Choose calculations, interpret budgets and use spreadsheet models for practical decisions.
Example 1
In the budget spreadsheet, D2 uses =B2∗C2 and D3 uses =B3∗C3. What is D2+D3, in dollars?
Show worked answer
Answer: 181
- D2=11×13=143.
- D3=19×2=38.
- Add the two line totals: $181.
Example 2
A club has $74. It buys 8 kits at $4 each and pays a $15 delivery fee. How many dollars remain?
Show worked answer
Answer: 27
- Kit cost =8× $4= $32.
- Total cost = $32+ $15= $47.
- Balance = $74− $47= $27.
Example 3
A fundraiser receives $199. It pays for 11 supply packs at $10 each and a $12 hire fee. What is the profit in dollars?
Show worked answer
Answer: 77
- Expenses =11× $10+ $12= $122.
- Profit = revenue − expenses = $199− $122= $77.