BIS 155 WEEK 5 LAB 5
tedhuge11
wk5_chap7_cap_summary.xlsxDocumentation
| Bruno's Dining Analysis | |||||
| Creator | Lenisha Henderson | ||||
| Date of Creation | 9/29/14 | ||||
| Date of Last Modification | |||||
| Purpose | Analyse the sales data over past 3 months. | ||||
| The dining analysis shows sales for each of | |||||
| the dining locations by quarter and | |||||
| the dining locations by quarter and | |||||
| summarizes the data on one sheet. | |||||
Summary
| Bruno's Dining Analysis | |||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
| Dine-In | $97,000 | $85,000 | $75,000 | $61,000 | $318,000 |
| Pick-up | $108,000 | $110,000 | $108,000 | $109,000 | $435,000 |
| Delivery | $72,000 | $95,000 | $126,000 | $157,000 | $450,000 |
| Total | $277,000 | $290,000 | $309,000 | $327,000 | $1,203,000 |
Eastside
| Eastside Location | |||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
| Dine-In | $45,000 | $41,000 | $38,000 | $33,000 | $ 157,000 |
| Pick-up | $19,000 | $21,000 | $20,000 | $20,000 | $ 80,000 |
| Delivery | $25,000 | $35,000 | $45,000 | $55,000 | $ 160,000 |
| Total | $89,000 | $97,000 | $103,000 | $108,000 | $ 397,000 |
Westside
| Westside Location | |||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
| Dine-In | $12,000 | $10,000 | $8,000 | $6,000 | $ 36,000 |
| Pick-up | $27,000 | $26,000 | $26,000 | $26,000 | $ 105,000 |
| Delivery | $25,000 | $34,000 | $46,000 | $60,000 | $ 165,000 |
| Total | $64,000 | $70,000 | $80,000 | $92,000 | $ 306,000 |
Downtown
| Downtown Location | |||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
| Dine-In | $40,000 | $34,000 | $29,000 | $22,000 | $ 125,000 |
| Pick-up | $62,000 | $63,000 | $62,000 | $63,000 | $ 250,000 |
| Delivery | $22,000 | $26,000 | $35,000 | $42,000 | $ 125,000 |
| Total | $124,000 | $123,000 | $126,000 | $127,000 | $ 500,000 |
