90.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer