Scribd
Upload
21 views2 pages

Scenario Summary: Changing Cells

The document presents a family budget scenario analysis comparing current values with two alternative scenarios for various expenses. It highlights changes in fuel bills, credit cards, food, clothes, and phone bills, resulting in different income left amounts. Current total outgoings are 1154, with an income of 1200, leaving 46 in income left under the current scenario.

Uploaded by

anzar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views2 pages

Scenario Summary: Changing Cells

The document presents a family budget scenario analysis comparing current values with two alternative scenarios for various expenses. It highlights changes in fuel bills, credit cards, food, clothes, and phone bills, resulting in different income left amounts. Current total outgoings are 1154, with an income of 1200, leaving 46 in income left under the current scenario.

Uploaded by

anzar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Scenario Summary

Current Values: Scenario 1 Scenario 2


Changing Cells:
Fuel_Bills 85 80 75
Credit_Cards 29 24 26
Food 280 250 260
Clothes 150 125 110
Phone_Bill 45 35 32
Result Cells:
Income_Left 46 121 132
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
THE FAMILY BUDGET
OUTGOINGS INCOME
Mortgage 440 1200
Fuel Bills 85
Council Tax 45
Credit Cards 29
Food 280
Clothes 150
Phone Bill 45
Direct Debits 80

Total Outgoings 1154

Income Left 46

You might also like