Please solve using excel and solver. Please use as much detail as possible with solver. Thanks!

Problem: Molokai Nut Company The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-coated nut crunch bars (Crunch), and plain roasted nuts Roasted). The company is barely able to keep up with the increasing demand for these products. However, increasing raw material prices and foreign competition are forcing MNC to watch its margins to ensure it is operating in the most efficient manner possible. To meet marketing demands for the coming week, MNC needs to produce at least 1,000 pounds of the whole product, between 400 and 500 pounds of the Cluster product, no more than 150 pounds of the Crunch product, and no more than 200 pounds of the Roasted product. Each pound of the whole, Cluster, Crunch, and Roasted product contains, respectively, 60%, 40%, 20%, and 100% macadamia nuts with the remaining weight made up of chocolate coating, The company has 1,100 pounds of nuts and 800 pounds of chocolate available for use in the next week. The various products are made using four different machines that hull the nuts, roast the nuts, coat the nuts in chocolate (if needed), and package the products. The following table summarizes the time required by each product on each machine. Each machine has 60 hours of time available in the coming week. Minutes Required Per Pound Machine Whole Cluster Crunch Hulling 1.00 1.00 1.00 Roasting 2.00 1,50 1.00 Coating 1.00 0.70 0.20 Packaging 2.50 1.60 1.25 Roasted 1.00 1.75 0.00 1.00 The selling price and variable cost associated with each pound of product is summarized in the following table: Per Pound Revenue and Costs Whole Cluster Crunch Roasted Selling Price $5.00 Variable Cost $3.15 $4.00 $2.60 $3.20 $2.16 $4.50 $3.10 The linear program (LP) to solve the Molokai Nut Company problem is as follows: Let: W - #pounds of Whole product produced CI - # pounds of Cluster product produced Cr- # pounds of Crunch product produced R - #pounds of Roasted product produced MAX 1.85W + 1.40CI + 1.04CP + 1.40R } Maximize Unit Profit Margin Subject to: 1.00W + 1.0001 + 1.00Cr+ 1.00R =0 } Non-negativity Constraint a) Formulate the layout of the solution in Excel (18 marks). b) Solve the problem using Solver (5 marks), c) Provide a brief written description of the optimal solution beside your spreadsheet (2 marks)