Aggregate Production Planning: Please see the attached Excel file for the question in the first 2...

Question

Aggregate Production Planning: Please see the attached Excel file for the question in the first 2 spreadsheets (last spreadsheet for MPS question). You will basically fill out with the answers you have. I expect you to see using Excel formulas to make your production planning strategy fully automatic, which means that when I change the numbers within the input area, the answer should change automatically.
Master Production Scheduling: Please fill out the yellow highlighted rows in the last spreadsheet in the attached Excel file. Again, try to make fully automated Excel file.

assignment-aggregate-production-planning-mps-1-wt4ldt1r.xlsx

Lalit · Accepted Answer

Constant Production Exercise
	Fill the necessary cells according to the class exercises and examples													Limit of maximum overtime (%)	20
														Initial # of workers (People)	65
				MONTH	DEC	JAN	FEB	MAR	APR	MAY	JUN	TOTAL		Initial Inventory (pounds)	8500
				Monthly Production/Worker		90	90	90	90	90	90			Regular Production Time (Hours/Month)	160
				Beginning Inventory		8500	4350	2440	2610	1720	3460			Regular Production Rate (Pound/Month/Labor)	90
				Work Force Level	65	65	101	113	79	86	100			Overtime Production Rate (of regular time)	0.2
				Straight Production		5850	9090	10170	7110	7740	9000			Cost of regular time production ($/hour)	5
				Overtime Production		0	0	0	0	0	0			Cost of overtime production ($/hour)	7.5	1.5
				Subcontract Production		0	0	0	0	0	0			Cost of carry inventory ($/lb/month)	0.

Aggregate Production Planning: Please see the attached Excel file for the question in the first 2 spreadsheets (last spreadsheet for MPS question). You will basically fill out with the answers you...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment