Main Problems Page | Main Answers Page | Trip Summary | Home Page
Answer #1: Percentages
 |
Sub-Total each column. Add all subtotals for Total. To calculate percentage per category, divide the subtotal for that category by the total expenses. Example for Food: $330 / $1560 = 21.15% See chart below for answers. |
| Food | Lodging | Gasoline | Tickets | Other | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mon | $50.00 | $45.00 | $95.00 | $10.00 | ||||||||
| Tues | $40.00 | $45.00 | $83.00 | $55.00 | $20.00 | |||||||
| Wed | $29.00 | $55.00 | $37.00 | $65.00 | $10.00 | |||||||
| Thurs | $80.00 | $55.00 | $45.00 | $70.00 | ||||||||
| Fri | $31.00 | $85.00 | $40.00 | |||||||||
| Sat | $44.00 | $81.00 | $89.00 | $40.00 | ||||||||
| Sun | $56.00 | $75.00 | $100.00 | $30.00 | ||||||||
| Sub-Totals | $330.00 | $360.00 | $441.00 | $319.00 | $110.00 | $1560 | ||||||
| % by category | 21.15% | 23.08% | 28.27% | 20.45% | 7.05% | 100% |
Return to Problem #1
Return to Main Problems Page