URGENT HOMEWORK DUE IN 6 HOURS
Ricardo2222
hw_5.xlsxSales Forecasting
| Sales Forecasting - Simple Trend Analysis | Note: Enter figures as positive numbers. | |||||||||||
| Segment | Total | |||||||||||
| Prior round demand vince_000: Titled Total Industry Unit Demand in Capstone Courier |
||||||||||||
| Growth Rate of Demand SCBA: Called Next Year's Segment Growth Rate in Capstone Courier |
||||||||||||
| Segment sales forecast | 0.00 | |||||||||||
| Sales forecasting by product Steve Letts: You can add more products if needed. | Product 1 | Product 2 | Product 3 | |||||||||
| Actual market share per product vince_000: Refer to Market Share report in Capstone Courier |
||||||||||||
| Actual Product Demand (based on actual market share) | 0.00 | 0.00 | 0.00 | |||||||||
| Potential Market share per product vince_000: Refer to Market Share report in Capstone Courier |
||||||||||||
| Potential Product Demand (based on potential market share) | 0.00 | 0.00 | 0.00 | |||||||||
| Lost Sales (Potential - Actual product demand) | 0.00 | 0.00 | 0.00 | |||||||||
| Forecasting per Product - Sensitivity Analysis (Worst Cast/Best Case) | ||||||||||||
| Parameters | ||||||||||||
| Price vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Labor Cost/Unit vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Material Cost/Unit vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Total Unit Cost vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Contribution Margin vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Per Product | Case 1 Stock Out | Case 2 Just In Time | Case 3 120 Days | |||||||||
| Units Demanded vince_000: Based on your portion of calculated total segment demand |
||||||||||||
| Units Sold (planned) vince_000: Based on your forecast |
||||||||||||
| Units Produced | 0 | 0 | 0 | |||||||||
| Units In Ending Inventory vince_000: Use Production Analysis report in Capstone Courier |
||||||||||||
| Units In Beginning Inventory vince_000: Use prior round Production Analysis report in Capstone Courier and take the ending inventory amount |
||||||||||||
| Missed Unit Sales | - | - | - | |||||||||
| Ending Inventory value | $0.00 | $0.00 | $0.00 | |||||||||
| Sales | $0.00 | $0.00 | $0.00 | |||||||||
| VARIABLE COSTS | ||||||||||||
| Direct Labor | $0.00 | $0.00 | $0.00 | |||||||||
| Direct Material | $0.00 | $0.00 | $0.00 | |||||||||
| Inventory Carry vince_000: (labor cost per unit + material cost per unit) * 12% * # of units held in inventory |
||||||||||||
|
Steve Letts: You can add more products if needed. |
vince_000: Refer to Market Share report in Capstone Courier |
vince_000: Refer to Market Share report in Capstone Courier | Total Variable Costs | $0.00 | $0.00 | $0.00 | ||||||
| Contribution Margin | $0.00 | $0.00 | $0.00 | |||||||||
| PERIOD COSTS | ||||||||||||
| Depreciation vince_000: From Pro-Forma income statement on Capsim.com |
||||||||||||
| SG&A: R&D vince_000: From Pro-Forma income statement on Capsim.com |
||||||||||||
| Promotion vince_000: From Pro-Forma income statement on Capsim.com |
||||||||||||
| Sales vince_000: From Pro-Forma income statement on Capsim.com |
||||||||||||
| Admin vince_000: From Pro-Forma income statement on Capsim.com |
||||||||||||
|
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Based on your portion of calculated total segment demand |
vince_000: Based on your forecast |
vince_000: Use Production Analysis report in Capstone Courier |
vince_000: Use prior round Production Analysis report in Capstone Courier and take the ending inventory amount | Total Period Costs | $0.00 | $0.00 | $0.00 |
| Net Margin | $0.00 | $0.00 | $0.00 |
Marketing
| Cost of Additional Promotions/Advertising to Additional Revenues Generated | Note: Enter figures as positive numbers. | |||||||
| Increase Spending | Actual | Decrease Spending | ||||||
| Marketing Costs: | ||||||||
| Promotion Costs |
vince_000: Your estimate of how much to increase promo costs | Payback Period (Months) Feng Wu: The length of time required to recover the cost |
||||||
| Sales Costs vince_000: direct labor + direct materials |
vince_000: amounts located in Capstone Courier/Capsim.com |
vince_000: Your estimate of how much to increase promo costs |
vince_000: your estimate on how much to decrease spending |
Feng Wu: The length of time required to recover the cost | Total Cost | |||
| Total Cost | $0.00 | $0.00 | $0.00 | Annual Benefits | ||||
| ERROR:#DIV/0! | ||||||||
| Cumulative Impacts | ||||||||
| Unit price |
vince_000: Price per unit | Accounting Rate of Return | ||||||
| Variable costs/unit vince_000: found in capstone courier | Average profit | |||||||
| Sales generated (forecast) vince_000: Your forecasted sales for each scenario. | Average investment | |||||||
| Gross Revenue | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||
| Variable costs | $0.00 | $0.00 | $0.00 | |||||
| Contribution margin | $0.00 | $0.00 | $0.00 | |||||
| Total benefit (less marketing costs) | $0.00 | $0.00 | $0.00 | |||||
Capacity
| Capacity Analysis per Segment | Note: Enter figures as positive numbers. | |||||
| Segment | Payback Feng Wu: The length of time required to recover the cost |
|||||
| Unit Demand in Segment | Period | Total Cost | $0.00 | |||
| Competitors' Capacity in Segment Steve Letts: Found in the Capstone Courier on production analysis page. | Annual Benefits | $0.00 | ||||
| Competitors Potential Production SCBA: This is your competitors' capacity X 2 to account for potential second shift production. | 0 | ERROR:#DIV/0! | ||||
| Guaranteed Unit Sales | 0 Nancy L. McClure: If this is negative, you can assume that there are no guaranteed sales. |
|||||
| Accounting | ||||||
| Beginning Inventory Steve Letts: Your leftover inventory from last year. | Rate of Return | Additional Profit | $0.00 | |||
| Ending Inventory Steve Letts: How much inventory you plan to have leftover at the end of the year. | Initial Investment | $0.00 | ||||
| Production | 0 | ERROR:#DIV/0! | ||||
| Contribution Margin per unit Steve Letts: Unit price - Labor and Material cost per unit (Production Tab) |
||||||
| Capacity Estimator | ||||||
| Unit Demand in Segment | 0 | |||||
| Growth Rate in Demand | ||||||
| Expected Market Share Steve Letts: The number you used for forecasting. |
||||||
| Expected unit sales volume | 0 | |||||
| Plant Capacity Steve Letts: For the particular segment. |
||||||
|
Steve Letts: Found in the Capstone Courier on production analysis page. |
Feng Wu: The length of time required to recover the cost |
SCBA: This is your competitors' capacity X 2 to account for potential second shift production. | Plant Utilization | ERROR:#DIV/0! | ||
| Expected production | 0 | |||||
| Max production | 0 | |||||
| Max market share (met by potential capacity) SCBA: This is the maximum market share allowed by the capacity available. |
Nancy L. McClure: If this is negative, you can assume that there are no guaranteed sales. |
Steve Letts: Your leftover inventory from last year. |
Steve Letts: How much inventory you plan to have leftover at the end of the year. |
Steve Letts: Unit price - Labor and Material cost per unit (Production Tab) | ERROR:#DIV/0! | |
| Planned market share | ERROR:#DIV/0! | |||||
| Cost-Benefit Analysis: | ||||||
| Total Benefit from Additional Capacity | $0 | |||||
| Total Cost of Additional Capacity | ||||||
|
Scott Collins: Test in CAPSIM how much it will cost to purchase. | Difference (positive = net benefit; negative = net cost) | $0 | ||||
