Question: Solve the following Linear programming problems using graphical solution. Confirm your solution using Excel Solver or TORA Problem #1 The Burroughs Garment Company manufactures



Solve the following Linear programming problems using graphical solution. Confirm your solution using Excel Solver or TORA Problem #1 The Burroughs Garment Company manufactures men's shirts and women's blouses for Walmark Discount Stores. Walmark will accept all the production supplied by Burroughs. The production process includes cutting, sewing, and packaging. Burroughs employs 25 workers in the cutting department, 35 in the sewing department, and 5 in the packaging department. The factory works one 8-hour shift, 5 days a week. The following table gives the time requirements and profits per unit for the two garments: Minutes per unit Garment Cutting Sewing Packaging Unit profit ($) Shirts 20 70 12 8 Blouses 60 60 4 12 Determine the optimal weekly production schedule for Burroughs. Problem # 2 A furniture company manufactures desks and chairs. The sawing department cuts the lumber for both products, which is then sent to separate assembly departments. Assembled items are sent for finishing to the painting department. The daily capacity of the sawing department is 200 chairs or 80 desks. The chair assembly department can produce 120 chairs daily and the desk assembly department 60 desks daily. The paint department has a daily capacity of either 150 chairs or 110 desks. Given that the profit per chair is $50 and that of a desk is $100, determine the optimal production mix for the company. Problem # 3 John must work at least 20 hours a week to supplement his income while attending school. He has the opportunity to work in two retail stores. In store 1, he can work between 4.5 and 12 hours a week, and in store 2, he is allowed between 5.5 and 10 hours. Both stores pay the same hourly wage. In deciding how many hours to work in each store, John wants to base his decision on work stress. Based on interviews with present employees, John estimates that, on an ascending scale of 1 to 10, the stress factors are 8 and 6 at stores 1 and 2, respectively. Because stress mounts by the hour, he assumes that the total stress for each store at the end of the week is proportional to the number of hours he works in the store. How many hours should John work in each store? Problem # 4 OilCo is building a refinery to produce four products diesel, gasoline, lubricants, and jet fuel. The minimum demand (in bbl/day) for each of these products is 14,000,30,000, 10,000, and 8000, respectively. Iraq and Dubai are under contract to ship crude to OilCo. Because of the production quotas specified by OPEC (Organization of Petroleum Exporting Countries), the new refinery can receive at least 40% of its crude from Iraq and the remaining amount from Dubai. OilCo predicts that the demand and crude oil quotas will remain steady over the next 10 years. The specifications of the two crude oils lead to different product mixes: One barrel of Iraq crude yields 2 bbl of diesel, 25 bbl of gasoline, .1 bbl of lubricant, and .15 bbl of jet fuel. The corresponding yields from Dubai crude are .1, .6, .15, and .1, respectively. Oil Co needs to determine the minimum capacity of the refinery (in bbl/day).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
