Question: I need help solving this linear programing HW using excel for my operations management class. Greatly appreciate it!! 62. Great Northwoods Outfitters is a retail

I need help solving this linear programing HW using excel for my operations management class. Greatly appreciate it!!
62. Great Northwoods Outfitters is a retail phone-catalog company that specializes in outdoor clothing and equipment. A phone station at the company will be staffed with either full-time operators or temporary operators 8 hours per day. Full-time operators, because of their experi- ence and training, process more orders and make fewer mistakes than temporary operators. However, temporary operators are cheaper because they receive a lower wage rate and are not paid benefits. A full-time operator can process about 360 orders per week, whereas a tempo- rary operator can process about 270 orders per week. A full-time operator averages 1.1 defec. tive orders per week, and a part-time operator incurs about 2.7 defective orders per week. The company wants to limit defective orders to 200 per week. The cost of staffing a station with full-time operators is $610 per week, and the cost of a station with part-time operators is $450 per week. Using historical data and forecasting techniques, the company has developed esti- mates of phone orders for an 8-week period, as follows: Week Orders Week Orders 1 2 3 4 19.500 21.000 25.600 27.200 5 6 7 8 33.400 29,800 27.000 31,000 The company does not want to hire or dismiss full-time employees after the first week (i.e., the company wants a constant group of full-time operators over the 8-week period). The company wants to determine how many full-time operators it needs and how many temporary operators to hire each week to meet weekly demand while minimizing labor costs. a. Formulate a linear programming model for this problem. b. Solve this model by using the computerStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
