week 2 sign
gysgtclarke
FRENCHIESSTART1.xlsxAssumptions
| Case Data | |||||||||
| Sales Information: | |||||||||
| Estimated % drop: | 20% | Estimated Growth: | 5% | Estimated Additional Holiday Increase: | 15% | ||||
| Sales: | Muffins | Cookies | Bread | ||||||
| Last Year | |||||||||
| Q4 | 45,000 | 65,000 | 85,000 | ||||||
| Current Year | |||||||||
| Q1 | |||||||||
| Q2 | |||||||||
| Q3 | |||||||||
| Q4 | |||||||||
| Next Year | |||||||||
| Q1 | |||||||||
| Q2 | |||||||||
| Sales Price/Item: | |||||||||
| Collection Information: | |||||||||
| Manufacturing Information: | |||||||||
&"Arial,Bold"&12Buns Bakery Basic Information For Year Ended December 31, Year 2
Sales Budget
| Sales Budget | |||||||
| Quarter | Total | ||||||
| Q1 | Q2 | Q3 | Q4 | 2017 | |||
| Muffins | |||||||
| Budgeted Sales | |||||||
| Selling price per dozen | |||||||
| Total Sales Revenue from Muffins | |||||||
| Cookies | |||||||
| Budgeted Sales | |||||||
| Selling price per dozen | |||||||
| Total Sales Revenue for Cookies | |||||||
| Bread | |||||||
| Budgeted Sales | |||||||
| Selling price per loaf | |||||||
| Total Sales Revenue for Bread | |||||||
| Total Sales Revenue | |||||||
| Schedule of Cash Collections | |||||||
| Collections in Quarter | Total | ||||||
| Q1 | Q2 | Q3 | Q4 | 2017 | |||
| Collections from last year | |||||||
| Q1 | Sales | ||||||
| Q2 | Sales | ||||||
| Q3 | Sales | ||||||
| Q4 | Sales | ||||||
| Total Cash Collections | $0 | $0 | $0 | $0 | $0 | ||
&"Arial,Bold"&12
Production Budget
| Production Budget |
