What-if Analysis
Wanderlust
CH13_WhatIfAnalysis.xlsxSix-Month Financial Projection
| Kioscafé | |||||||
| Six-Month Financial Projection | |||||||
| January | February | March | April | May | June | Total | |
| Revenue | $ 62,000 | $ 58,750 | $ 67,500 | $ 68,200 | $ 59,800 | $ 60,100 | |
| Cost of Goods Sold | |||||||
| Gross Margin | |||||||
| Expenses | |||||||
| Bonus | |||||||
| Commission | |||||||
| Newsstand Rental | |||||||
| Advertising | |||||||
| Equipment Maintenance | |||||||
| Total Expenses | |||||||
| Operating Income | |||||||
| What-If Assumptions | |||||||
| Margin | 75.50% | ||||||
| Bonus | $ 4,000 | ||||||
| Sales Revenue for Bonus | $ 60,500 | ||||||
| Commission | 28.00% | ||||||
| Newsstand Rental | 11.00% | ||||||
| Advertising | 6.00% | ||||||
| Equipment Maintenance | 4.00% |
