Production This a capstone problem and Where the Question marks are is where i...
90.2K
Verified Solution
Link Copied!
Question
Accounting
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
