FINAL CAPSTONE PROJECT (HEALTH SPA)
MP861026
SalesBudgetForcastingSpreadsheet.xlsx
Sales Budget
| | SALES FORCAST | | | | Enter Company Name Here | | | | | | | FISCAL YEAR START DATE |
| | | | | | | | | | | | | Jul-16 |
| | PRODUCT NAME | | Jul-16 | Aug-16 | Sep-16 | Oct-16 | Nov-16 | Dec-16 | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | TOTAL | | 2015 | 2014 | 2013 | 2012 | 2011 |
| | ITEM 1 | PRICE PER UNIT | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | | | ITEM 1 |
| | | UNITS SOLD | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 5400 | | 3750 | 4200 | 4000 | 3750 | 3890 |
| | | TOTAL | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $540,000.00 | | $375,000.00 | $420,000.00 | $400,000.00 | $375,000.00 | $389,000.00 |
| | ITEM 2 | PRICE PER UNIT | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | | | ITEM 2 |
| | | UNITS SOLD | 1000 | 800 | 1000 | 800 | 1000 | 800 | 1000 | 800 | 1000 | 800 | 1000 | 800 | 10800 | | 3750 | 4200 | 4000 | 3750 | 3890 |
| | | TOTAL | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $540,000.00 | | $375,000.00 | $420,000.00 | $400,000.00 | $375,000.00 | $389,000.00 |
| | ITEM 3 | PRICE PER UNIT | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | | | ITEM 3 |
| | | UNITS SOLD | 2000 | 1600 | 2000 | 1600 | 2000 | 1600 | 2000 | 1600 | 2000 | 1600 | 2000 | 1600 | 21600 | | 3750 | 4200 | 4000 | 3750 | 3890 |
| | | TOTAL | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $50,000.00 | $40,000.00 | $540,000.00 | | $375,000.00 | $420,000.00 | $400,000.00 | $375,000.00 | $389,000.00 |
| | ITEM 4 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 4 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 5 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 5 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 6 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 6 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 7 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 7 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 8 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 8 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 9 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 9 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | ITEM 10 | PRICE PER UNIT | | | | | | | | | | | | | | | ITEM 10 |
| | | UNITS SOLD | | | | | | | | | | | | | 0 |
| | | TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| | | | MONTHLY TOTALS | | | | | | | | | | | | | | YEARLY TOTALS |
| | | UNITS SOLD | 3500 | 2800 | 3500 | 2800 | 3500 | 2800 | 3500 | 2800 | 3500 | 2800 | 3500 | 2800 | 37800 | | 11250 | 12600 | 12000 | 11250 | 11670 |
| | | TOTAL | $150,000.00 | $120,000.00 | $150,000.00 | $120,000.00 | $150,000.00 | $120,000.00 | $150,000.00 | $120,000.00 | $150,000.00 | $120,000.00 | $150,000.00 | $120,000.00 | $1,620,000.00 | | $1,125,000.00 | $1,260,000.00 | $1,200,000.00 | $1,125,000.00 | $1,167,000.00 |
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
https://www.smartsheet.com/try-it?trp=8597&utm_source=integrated+content&utm_campaign=/free-sales-plan-templates-excel-and-word&utm_medium=sales-forecast-template
