Please solve as an excel sheet

Times New.. ~ 16 - A A Aa A ST A - E Untitled Paste BIUvaexx ADA . Styles Styles Dictate Sensitivity Editor Pan 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, HI, N1, and FLU1, which are composed from many of the same raw materials and subassemblies; they are assembled by the same skilled workforce. Each unit of product HI uses 12 units of dihidroxine, a single purge system subassembly, a shell, 2 solar chargers, 4 labor hours in the assembly department, and one labor hour in the finishing department. Each unit of product N1 uses 9 units of dihidroxine, three units of Naphthalene, two purge system subassemblies, a shell, a solar charger, three labor hours in the assembly department, and 75 minutes in the finishing department. Each unit of product FLUI uses six units of dihidroxine, 15 units of Naphthalene, two purge system subassemblies, a shell, two solar chargers, five labor hours in the assembly department, and two labor hours 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 398 units of dihidroxine, 400 units of Naphthalene, 82 purge system subassemblies, 52 shells, and 103 solar chargers in inventory. No additional deliveries of raw materials are expected this week. There is an $80 profit on product H1, a $100 profit on product N1, and a $135 profit on product FLU1. The operations manager doesn't have any firm orders, but would like to make at least five of each product so he can have the products on the shelf in case a customer wanders in off the street. Focus E 112%