LP Project 2 Instructions: Use the information given below to set up and solve a LP and provide the manager with the relevant information needed to make the optimal decision about how to move forward. Hopefully your sense of humor will kick in and you will also realize that you can now do LP with an abstract problem! Use your solution 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 new optimal solutions. A producer has three products, LARRY, MOE, and CURLY, which are composed from many of the same raw materials and subassemblies; they are assembled 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, four 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. If you produce the optimal production quantity of Larry, Curly and Moe, what is the optimal profit? For example, if your answer was $439,151.72, round to the nearest dollar and do not enter the dollar sign ($). Therefore, the correct answer would be entered as 439152 A/ How many hours were used in the assembly department? For example, if your answer was 51.72, the correct answer would be entered as 52 How many slap sticks were used in the optimal solution? For example, if your answer was 39,151.72, the correct answer would be entered as 39152 A What is the new optimal profit if you update the model to assume there was only 300 slapstick comedies, 50 shells, and 70 B movies? For example, if your answer was $439.151.72, round to the nearest dollar and do not enter the dollar sign ($). Therefore, the correct answer would be entered as 439152 A
