Excel
Shavone05
three_dog_bakery_analysis.xlsxSheet1
| Three Dog Bakery | |||||
| Sales and Expenses for 2009 | |||||
| Expenses | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
| Rent | 2,500.00 | 2,500.00 | 2,500.00 | 2,500.00 | $ 10,000.00 |
| Utilities | 325.12 | 309.05 | 287.98 | 352.64 | $ 1,274.79 |
| Payroll | 9,832.97 | 11,299.87 | 8,264.81 | 13,226.47 | $ 42,624.12 |
| Insurance | 237.81 | 237.81 | 237.81 | 237.81 | $ 951.24 |
| Supplies | 1,468.92 | 1,790.84 | 1,206.77 | 1,628.13 | $ 6,094.66 |
| Total | $ 14,364.82 | $ 16,137.57 | $ 12,497.37 | $ 17,945.05 | |
| Sales | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
| Catering | 12,462.87 | 15,947.72 | 10,884.65 | 18,995.60 | $ 58,290.84 |
| Treats | 423.90 | 506.18 | 480.01 | 789.66 | $ 2,199.75 |
| Accessories | 1,228.09 | 1,287.16 | 1,494.67 | 1,982.64 | $ 5,992.56 |
| Total | $ 14,114.86 | $ 17,741.06 | $ 12,859.33 | $ 21,767.90 | |
| Net | $ (249.96) | $ 1,603.49 | $ 361.96 | $ 3,822.85 | $ 5,538.34 |
