This is not that difficult spreadsheet the problem is saying:John tells you that
ID: 3138287 • Letter: T
Question
This is not that difficult spreadsheet the problem is saying:John tells you that he hates math. He meticulously entered the Miscellaneous expenses so he’s absolutely sure those figures are correct. He copies the other expenses from one month to the next, and he’s sure all expenses were correct for January. He tells you that the only change to his expenses is that his rent was increased to $982.00 in April. He also tells you that he has $63 in his bank account, not $1,080.00. Let’s go through the troubleshooting steps to debug the spreadsheet. I can not figure out how they get 63 as the total I keep getting 31
January February March Year-to-Date 5 Income $ 2,475.00 $ 2,475.00 2,475.00 $ 2,475.00 $ 9,900.00 7 Expenses 8 Rent 9 Car (gas) 10 Car (insurance) 11 Car (loan) 12 Car (repairs) 13 Food/household 14 Miscellaneous 15 16 Total Expenses 17 18 Net Surplus/Deficit $ 511.00 19 20 21 950.00 120.00 950.00 950.00 120.00 294.00 600.00 120.00 294.00 600.00 982.00 3,832.00 480.00 336.00 294.001,176.00 628.00 600.00 2,400.00 294.00017.00 120.00 336.00 294.00 628.00 600.00 170.00 325.00 228.00 1,964.00 2,592.00 1,964.00 2,332.00 9,869.00 117.00 $ 511.00 143.00 31.00 23 24Explanation / Answer
All data looks fine here except rent detail
as the rent is increasing from 950 to 982 - the rent would be applied from May - which will result in additional $ 32 savings - which will ultimately result in overall $ 63 savings.
January February March April Year-to-date Income 2475 2475 2475 2475 9900 Expenses Rent 950 950 950 950 3800 Car(Gas) 120 120 120 120 480 Car(Insurance) 336 336 Car(Loan) 294 294 294 294 1176 Car(Repairs) 628 628 Food/Household 600 600 600 600 2400 Miscellaneous 325 170 228 294 1017 Total Expenses 1964 2592 1964 2300 9837 Net Surplus/Deficit 511 -117 511 175 63Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.