Sales forecasts and one page description
Kiera27
sales_forecast.xlsx
data
| | January | February | March | April | May | June | July | August | September | October | November | December |
| Volume |
| Service A | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 200 | 180 | 160 | 140 | 120 |
| Service B | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 105 |
| Service C | 75 | 73 | 71 | 69 | 67 | 65 | 63 | 61 | 59 | 57 | 55 | 53 |
| Price |
| Service A | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Service B | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Service C | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 |
| Margin |
| Service A | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% |
| Service B | 32% | 32% | 32% | 32% | 32% | 32% | 32% | 32% | 32% | 32% | 32% | 32% |
| Service C | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% |
| Profit | $55,750 | $61,150 | $66,550 | $71,950 | $77,350 | $82,750 | $88,150 | $88,550 | $88,950 | $89,350 | $89,750 | $90,150 |
