Reference no: EM132287167
LP Project 2 Instructions: Use the information given below to set up and solve an LP, graph in Excel, and provide the manager with the relevant information needed to make the optimal decision about how to move forward. You should be prepared to answer a few quiz questions about the initial optimal decision and results. You should also be prepared to change certain assumptions and then solve the problem for a new optimal decision. You will get credit for answering questions via an online quiz. A producer has three products, LARRY, MOE, and CURLY, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product LARRY uses 10 units of comedy, a single B movie, a shell, 3 two reel comedies, 3.5 labor hours in the assembly department, and one labor hour in the finishing department. Each unit of product MOE uses 7 units of comedy, three units of Slapstick, three B movies, a shell, a two reel comedy, three labor hours in the assembly department, and 75 minutes in the finishing department. Each unit of product CURLY uses five units of comedy, 14 units of Slapstick, two B movies, a shell, 3 two reel comedies, five labor hours in the assembly department, and 90 minutes in the finishing department. Labor between the assembly and finishing departments is not transferable, but workers within each department can work on any of the three products. There are four full-time (40 hours/week) workers in the assembly department and one full-time and one half-time (20 hours/week) worker in the finishing department. At the start of this week, the company has 382 units of comedy, 400 units of Slapstick, 74 B movies, 58 shells, and 113 two reel comedy in inventory. No additional deliveries of raw materials are expected this week. There is a $90 profit on product LARRY, a $98 profit on product MOE, and a $125 profit on product CURLY. The operations manager doesn’t have any firm orders, but would like to make at least six of each product so he can have the products on the shelf in case a customer wanders in off the street.