Week 2 Excel Problems
brianc19861
RestaurantSales.xlsxDine In Daily Log
| Dine-In Customer Daily Log | |||||||||||||
| Small | Large | ||||||||||||
| Date | Time | Size | Customer | Waiting time | Server | Amount of Check | Salads/appetizers | Regular Pizza | Regular Pizza | Deep Dish Pizza | Desserts | Send back | Reason |
| 31-Mar | Lunch | 2 | New | 0 | Jackie | $ 22.50 | 2 | 0 | 1 | 0 | 0 | no | |
| 31-Mar | Lunch | 4 | Returning | 0 | Tom | $ 28.35 | 0 | 1 | 0 | 1 | 0 | no | |
| 31-Mar | Lunch | 2 | Returning | 0 | Tom | $ 12.15 | 0 | 2 | 0 | 0 | 0 | yes | wrong topping |
| 31-Mar | Lunch | 2 | Returning | 0 | Jackie | $ 18.70 | 2 | 1 | 0 | 0 | 0 | no | |
Delivery Daily Log
| Delivery Customer Daily Log | ||||||||||
| Small | Large | |||||||||
| Date | Time | Customer | Delivery Time | Driver | Amount of Check | Regular Pizza | Regular Pizza | Deep Dish Pizza | Send back | Reason |
| 31-Mar | 5:05 | Returning | 35 | Paul | $ 14.35 | 1 | ||||
| 31-Mar | 5:15 | Returning | 40 | Paul | $ 17.50 | 1 | ||||
| 31-Mar | 5:20 | Returning | 25 | Rick | $ 23.30 | 1 | 1 | |||
| 31-Mar | 5:21 | Returning | 33 | Paul | $ 28.25 | 2 | ||||
| 31-Mar | 5:45 | New | 48 | Paul | $ 16.85 | 1 |
Cust Sat Results
| Customer Satisfaction Results | ||||||||||||||||||||
| Month | Restaurant | Frequency | Wait | Perception | Courtesy | Clean | Attention | Knowledge | Ability | Friendly | Pace | Accuracy | Menu | Taste | Temp | Size | Value | Overall | Return | Recommend |
Data
| Restaurant Sales | ||||
| Date | Day | Lunch Sales $ | Dinner Sales $ | Delivery Sales $ |
| 31-Mar | Saturday | $542.00 | $1,468.00 | $884.00 |
| 1-Apr | Sunday | $873.00 | $1,345.00 | $489.00 |
| 3-Apr | Tuesday | $289.00 | $646.00 | $321.00 |
| 4-Apr | Wednesday | $354.00 | $782.00 | $289.00 |
| 5-Apr | Thursday | $403.00 | $805.00 | $276.00 |
| 6-Apr | Friday | $442.00 | $1,289.00 | $1,242.00 |
| 7-Apr | Saturday | $449.00 | $1,652.00 | $782.00 |
| 8-Apr | Sunday | $697.00 | $1,209.00 | $341.00 |
| 10-Apr | Tuesday | $307.00 | $579.00 | $328.00 |
| 11-Apr | Wednesday | $387.00 | $664.00 | $301.00 |
| 12-Apr | Thursday | $412.00 | $891.00 | $243.00 |
| 13-Apr | Friday | $508.00 | $1,178.00 | $1,068.00 |
| 14-Apr | Saturday | $503.00 | $1,581.00 | $714.00 |
| 15-Apr | Sunday | $741.00 | $1,137.00 | $326.00 |
| 17-Apr | Tuesday | $298.00 | $572.00 | $365.00 |
| 18-Apr | Wednesday | $419.00 | $621.00 | $278.00 |
| 19-Apr | Thursday | $345.00 | $913.00 | $294.00 |
| 20-Apr | Friday | $467.00 | $1,332.00 | $1,254.00 |
| 21-Apr | Saturday | $622.00 | $1,732.00 | $636.00 |
| 22-Apr | Sunday | $846.00 | $1,324.00 | $319.00 |
| 24-Apr | Tuesday | $233.00 | $523.00 | $411.00 |
| 25-Apr | Wednesday | $341.00 | $731.00 | $243.00 |
| 26-Apr | Thursday | $426.00 | $940.00 | $350.00 |
| 27-Apr | Friday | $379.00 | $1,409.00 | $1,143.00 |
| 28-Apr | Saturday | $592.00 | $1,856.00 | $601.00 |
| 29-Apr | Sunday | $779.00 | $1,229.00 | $398.00 |
