Excel: with formulas
Sheet1
| Pamper Yourself Salon & Day Spa | ||||||||
| Operating Expenses for 2010 | ||||||||
| Expense | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | Average | Maximum | Minimum |
| Rent | 7750 | 7750 | 7750 | 7750 | ||||
| Utilities | 8624 | 7982 | 7229 | 8096 | ||||
| Payroll | 23456 | 26922 | 25876 | 29415 | ||||
| Insurance | 8355 | 8194 | 8225 | 8327 | ||||
| Education | 4749 | 3081 | 6552 | 4006 | ||||
| Inventory | 29986 | 27115 | 25641 | 32465 | ||||
| Total | ||||||||
| Average | ||||||||
| Maximum | ||||||||
| Minimum |