Question
Production This a capstone problem and Where the Question marks are is where i can change the number in the space. Schedule Able Acre Adam
Production
This a capstone problem and Where the Question marks are is where i can change the number in the space.
| Schedule | Able | Acre | Adam | Aft | Agape | NA | NA | NA | Total |
|---|---|---|---|---|---|---|---|---|---|
| Unit Sales Forecast | 896 | 1,357 | 355 | 366 | 390 | 0 | 0 | 0 | 3,364 |
| Inventory On Hand | 189 | 39 | 40 | 78 | 62 | 0 | 0 | 0 | 408 |
| Production Schedule | 1200 ? | 1826 ? | 410 ? | 440 ? | 380 ? | 4,250 | |||
| Production After Adj. | 1,188 | 1,802 | 406 | 436 | 376 | 0 | 0 | 0 | 4,209 |
| Margins | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| 2nd Shift Production% | 0.0% | 30.0% | 0.0% | 0.0% | 0.0% | 0 | 0 | 0 | |
| Labor Cost/Unit | $7.85 | $7.46 | $8.97 | $8.97 | $8.97 | 0 | 0 | 0 | |
| Material Cost/Unit | $11.28 | $7.63 | $15.53 | $15.45 | $13.23 | 0 | 0 | 0 | |
| Total Unit Cost | $19.13 | $15.09 | $24.50 | $24.42 | $22.20 | 0 | 0 | 0 | |
| Contribution Margin | 31.7% | 28.1% | 35.5% | 26.0% | 32.7% | 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 ? | 0 ? | 0 ? | 0 ? | 0 ? | 0 | |||
| Automation Rating | 4.0 | 5.0 | 3.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | |
| New Autom. Rating | 4.0 ? | 5.0 ? | 3.0 ? | 3.0 ? | 3.0 ? | ||||
| 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 | $ 32,694 |
| Complement | 700 | 701 | 100 % | 701 | 640 | 61 | 0.0% | A/P Lag 30 ? |
Production vs Capacity
'Able' Both Shifts : 3600 'Able' Base Capacity : 1800 'Able' Production : 1188 'Acre' Both Shifts : 2800 'Acre' Base Capacity : 1400 'Acre' Production : 1802 'Adam' Both Shifts : 1800 'Adam' Base Capacity : 900 'Adam' Production : 406 'Aft' Both Shifts : 1200 'Aft' Base Capacity : 600 'Aft' Production : 436 'Agape' Both Shifts : 1200 'Agape' Base Capacity : 600 'Agape' Production : 376
Both Shifts Base Capacity Production AbleAcreAdamAftAgape0k2k4k
Price vs Unit Cost
'Able' Material : $11.28 'Able' Labor : $7.85 'Able' Margin : $8.87 'Able' Total: $28 'Acre' Material : $7.63 'Acre' Labor : $7.46 'Acre' Margin : $5.91 'Acre' Total: $21 'Adam' Material : $15.53 'Adam' Labor : $8.97 'Adam' Margin : $13.50 'Adam' Total: $38 'Aft' Material : $15.45 'Aft' Labor : $8.97 'Aft' Margin : $8.58 'Aft' Total: $33 'Agape' Material : $13.23 'Agape' Labor : $8.97 'Agape' Margin : $10.80 'Agape' Total: $33
Material Labor Margin AbleAcreAdamAftAgape$0$20$40
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Frank Woods Business Accounting An Introduction To Financial Accounting
Authors: Alan Sangster, Lewis Gordon, Frank Wood
15th Edition
1292365439, 9781292365435
