Question

The textile mill model -

• Produces 3 types of fabric (F1, F2, F3) on 2 types of machines (Regular, Special). Or Buy.
• Time to delivery is 13 weeks.
• 15 regular machines (F2, F3) + 3 special machines (F1, F2, F3) + Buy (F1, F2, F3)
• Demand for F1, F2, F3 is 45000, 76500, 10000 yards.
• Special loom capacity in yards/hour – 4.7, 5.2, 4.4
• Regular loom capacity in yards/hour – 0, 5.2, 4.4
• Manufacture cost in $/yard – 0.65, 0.61, 0.50
• Outsource cost in $/yard – 0.85, 0.75, 0.65

1.1. Minimise total cost to meet demand when mill closes during weekends and special loom capacity reduces by 50%. Clearly mention the change in total cost.

Answer 1

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE TTHERE TO HELP YOU..ALL THE BEST

ANSWER:

EXCEL SHEET:

Product \ Source	Special	Regular	Purchase	Total	Demand
F1	30794.4	0	14205.6	45000	45000
F2	0	76500	0	76500	76500
F3	0	10000	0	10000	10000
Costs per yard	Special	Regular	Purchase
F1	0.65	0.65	0.85
F2	0.61	0.61	0.75
F3	0.5	0.5	0.65
	Special (hours/ yard)	Regular (hours/ yard)
	0.213
	0.192	0.192
	0.227	0.227
Required hrs.	6552	16984.27
Available hrs.	6552	32760
Total cost	$83,756.12

I HOPE YOU UNDERSTAND..

PLS RATE THUMBS UP..ITS HELPS ME ALOT..

THANK YOU...!!