Panchtantra - Decision Variables Objective Constraints: 1...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Decision Variables X-Meters of lungi Y-meters of Shirt Objective Maximize--Z = 0.9X+0.6Y Constraints: 1 Production capacity X/5+Y/12 <= 3000 2 Yarn Availability 40s 60X+100Y<=240000 3 Yarn Availability 60s 40X<=480000 4 Sales constraint Lungi X<=11000 5 Sales constraint Shirt Y<=22000 Constraints for subsequent plans 6 Maximize Lungi Production X= 11000 7 Avg pay of weavers should be 20.5 (4.5X+1.5Y)/3000 >= 20.5 8 Production expenses 10X+6Y<= 150000 Product Mix to Maximize the Profit Decision variable Lungi shirt meters 6666.6667 20000 Maximize The Profit Objective Profit 0.9 0.6 18000 Constraints 1 Production Capacity (No of loom days) 5 12 3000 3000 2 Yarn Availability 40s 60 100 2400000 2400000 3 Yarn Availability 60s 40 0 266667 480000 4 Sales constraint Lungi 1 0 6667 11000 5 Sales constraint Shirt 0 1 20000 22000 Product Mix that Mr. Ganesh Would have arrived if he had used previous production planning technique Decision variable Lungi shirt meters 11000 9600.000024 Objective Profit 0.9 0.6 15660 Constraints 1 Maximize Lungi Production 1 0 11000 11000 2 Production Capacity (No of loom days) 5 12 3000 3000 3 Yarn Availability 40s 60 100 1620000 2400000 4 Yarn Availability 60s 40 0 440000 480000 5 Sales constraint Lungi( irrelevant) 1 0 11000 11000 6 Sales constraint Shirt 0 1 9600 22000 Product Mix as per Weavers wage condition Decision variable Lungi shirt meters 8333.3333 16000 Objective Profit 0.9 0.6 17100 Constraints 1 Avg pay of weavers should be 20.5 4.5 1.5 21 20.5 2 Production Capacity (No of loom days) 5 12 3000 3000 3 Yarn Availability 40s 60 100 2100000 2400000 4 Yarn Availability 60s 40 0 333333 480000 5 Sales constraint Lungi 1 0 8333 11000 6 Sales constraint Shirt 0 1 16000 22000 Product Mix as per Production expenses condition Decision variable Lungi shirt meters 1800 22000 Objective Profit 0.9 0.6 14820 Constraints 1 Production expenses 10 6 150000 150000 2 Production Capacity (No of loom days) 5 12 2193 3000 3 Yarn Availability 40s 60 100 2308000 2400000 4 Yarn Availability 60s 40 0 72000 480000 5 Sales constraint Lungi 1 0 1800 11000 6 Sales constraint Shirt 0 1 22000 22000 Mr. Ganesh Strategy in this case was to Maximize Lungi production to sales requirement and then produce shirts in remaining loom hours Adequate earning of Weavers:- Average pay to weavers per loom day should be at least Rs:20.5 Production expenses should not exceed 1.5 lac
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Panchtantra.xlsx]Sheet1
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

Panchtantra - Decision Variables Objective Constraints: 1...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online