Term 6 Unit 5 Discussions
ceteiv
DeliScenario.xlsxScenario Summary
| Scenario Summary | |||||
| Current Conditions | Ideal Case | Increased Costs | Low Sales | ||
| Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | ||
| Changing Cells: | |||||
| Units Sold | $C$4 | 1278 | 1500 | 700 | 500 |
| Sales Price | $C$6 | $ 4.25 | $ 4.25 | $ 4.50 | $ 4.00 |
| Result Cells: | |||||
| Net Profit | $F$13 | $ 3,500.00 | $ 4,246.25 | $ 1,735.25 | $ 763.75 |
Budget
| Burton's Sandwich Shop | |||||||||||
| Forecasts | Fixed Costs | Variable Costs | Income | ||||||||
| Sandwichs sold (units sold) | 1278 | Lease | $ 525.00 | Costs of goods sold | $ 958.30 | Income from cash | $ 271.52 | ||||
| Unit price | $ 0.75 | Utilities | $ 250.00 | Credit Card Processing Fees | $ 182.08 | Income from credit | $ 5,158.86 | ||||
| Sales price | $ 4.25 | Credit Card Equipment Fee | $ 15.00 | Total | $ 1,140.38 | Total income | $ 5,430.38 | ||||
| Percentage of credit card sales per month | 95% | Total | $ 790.00 | ||||||||
| Percentage of cash sales per month | 5% | ||||||||||
| Credit Card Swipes per Month | 1,214 | Totals | |||||||||
| Credit Card Cost per Swipe | $ 0.15 | Total Fixed Costs | $ 790.00 | ||||||||
| Total Variable Costs | $ 1,140.38 | ||||||||||
| Total Income | $ 5,430.38 | ||||||||||
| Net Profit | $ 3,500.00 | ||||||||||
Student Name &A &F
