Question
Need help making decisions on Capstone Round 3 Production Production Schedule Able Acre Adam Aft Agape Agave NA NA Total Unit Sales Forecast 770 3,115
Need help making decisions on Capstone Round 3 Production
Production
| Schedule | Able | Acre | Adam | Aft | Agape | Agave | NA | NA | Total |
|---|---|---|---|---|---|---|---|---|---|
| Unit Sales Forecast | 770 | 3,115 | 254 | 430 | 304 | 575 | 0 | 0 | 5,448 |
| Inventory On Hand | 0 | 0 | 873 | 192 | 673 | 0 | 0 | 0 | 1,738 |
| Production Schedule |
|
|
|
|
|
| 5,353 | ||
| Production After Adj. | 1,800 | 1,400 | 900 | 600 | 600 | 0 | 0 | 0 | 5,300 |
| Margins | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| 2nd Shift Production% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 0.0% | 0 | 0 | |
| Labor Cost/Unit | $8.95 | $7.67 | $10.23 | $10.23 | $10.23 | $0.00 | 0 | 0 | |
| Material Cost/Unit | $8.73 | $5.71 | $13.73 | $13.35 | $11.55 | $8.82 | 0 | 0 | |
| Total Unit Cost | $17.68 | $13.39 | $23.96 | $23.58 | $21.78 | $8.82 | 0 | 0 | |
| Contribution Margin | 33.3% | 31.3% | 34.4% | 25.1% | 30.9% | 72.0% | 0 | 0 |
| Physical Plant | Total | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| 1st Shift Capacity | 1,800 | 1,400 | 900 | 600 | 600 | 0 | 0 | 0 | 5,300 |
| Buy/Sell Capacity |
|
|
|
|
|
| 0 | ||
| Automation Rating | 4.0 | 5.0 | 3.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | |
| New Autom. Rating |
|
|
|
|
|
| |||
| Investment ($000) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
| Workforce | Last Year | Needed | This Year % | This Year | 1st Shift | 2nd Shift | Overtime | Max Invest | $ 25,128 |
| Complement | 924 | 892 | % | 892 | 915 | 9 | 0.0% | A/P Lag |
Production vs Capacity
'Able' Both Shifts : 3600 'Able' Base Capacity : 1800 'Able' Production : 1800 'Acre' Both Shifts : 2800 'Acre' Base Capacity : 1400 'Acre' Production : 1400 'Adam' Both Shifts : 1800 'Adam' Base Capacity : 900 'Adam' Production : 900 'Aft' Both Shifts : 1200 'Aft' Base Capacity : 600 'Aft' Production : 600 'Agape' Both Shifts : 1200 'Agape' Base Capacity : 600 'Agape' Production : 600 'Agave' Both Shifts : 0 'Agave' Base Capacity : 0 'Agave' Production : 0
Both ShiftsBase CapacityProductionAbleAcreAdamAftAgapeAgave0k2k4k
Price vs Unit Cost
'Able' Material : $8.73 'Able' Labor : $8.95 'Able' Margin : $8.82 'Able' Total: $27 'Acre' Material : $5.71 'Acre' Labor : $7.67 'Acre' Margin : $6.11 'Acre' Total: $19 'Adam' Material : $13.73 'Adam' Labor : $10.23 'Adam' Margin : $12.54 'Adam' Total: $37 'Aft' Material : $13.35 'Aft' Labor : $10.23 'Aft' Margin : $7.92 'Aft' Total: $32 'Agape' Material : $11.55 'Agape' Labor : $10.23 'Agape' Margin : $9.72 'Agape' Total: $32 'Agave' Material : $8.82 'Agave' Labor : $0.00 'Agave' Margin : $22.68 'Agave' Total: $32
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
