Christmas party
fffinal
Costing.xlsxSheet1
| Expenses | Income | ||||||||||
| Quantity | Unit cost/Hourly Rate | Time | Total Cost | Quantity | Unit Cost | Income | |||||
| Venue | Tickets | 250 | 35 | 8750 | |||||||
| Rental | 1 | 1500 | 8 | 1500 | Bar | 6330 | |||||
| Bar Staff | 4 | 9.78 | 9 | 352.08 | Raffle | 500 | |||||
| Security | 4 | 9 | 8 | 288 | Total | 15580 | |||||
| Staff | 15 | Included | |||||||||
| 2140.08 | |||||||||||
| Entertainment | Bar Income | ||||||||||
| DJ | 300 | Pints | 620 | 3.5 | 2170 | ||||||
| Photo Booth | 369 | Bottles | 310 | 2.5 | 775 | ||||||
| Raffle | 1 | 150 | 150 | Spirits | 750 | 3.5 | 2625 | ||||
| Photographer | 1 | 10 | 8 | 80 | Wine | 190 | 4 | 760 | |||
| Decorations | 50 | Total | 6330 | ||||||||
| 949 | |||||||||||
| Catering | |||||||||||
| Meal | 250 | 25 | 6250 | ||||||||
| Beer (Draught) | 8 | 140 | 1120 | Expenses | 12175.08 | ||||||
| Beer (Bottles) | 18 | 11 | 198 | Income | 15580 | ||||||
| Spirits | 38 | 20 | 760 | Profit | 3404.92 | ||||||
| Wine | 43 | 6 | 258 | ||||||||
| Soft Drinks | 400 | ||||||||||
| 8986 | |||||||||||
| Advertisement | |||||||||||
| Poster Design | In House | ||||||||||
| Poster Printing | 100 | ||||||||||
| 100 | |||||||||||
| Total | 12175.08 |
&1#&"Arial"&11&K000000SW Public General
