(Note for tutor please answer this comprehensively and give excel workings ) Thank you

Nutty Nuts Company produces three nut mixers: Regular, Deluxe and Holiday.Currently Nutty Nuts has purchased the following shipments of nuts at the prices shown

Type of NutShipment Amount (lbs)Cost per Shipment

Almond60007500

Brazil75007350

Filbert75006750

Pecan60007260

Walnut75007875

The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts.The Deluxe Mix consists of 20% of each type of nuts, the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts.Nutty Nuts' accountant analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contributions per pound is $1.65 for the Regular Mix, $2.00 for the Deluxe Mix, and $2.25 for the Holiday Mix.These figures do not include the cost of specific types of nuts in the different mixes because that cost can vary greatly in the commodity markets.Nutty Nuts already received orders of 10,000 pounds of Regular Mix, 5000 pounds of Deluxe Mix and 3000 pounds of Holiday Mix.

Because demand is running high, Nutty Nut expects to receive many more orders than can be satisfies.Nutty Nuts is committed to using the available nuts to maximize profit over the fall season; nuts not used will be given to the Free Store.Even if it is not profitable to do so, Nutty Nut president indicated that the orders already received must be satisfied.

Managerial Report

-What is this memo about?

-What is the optimal product mix, and what is the maximum profit?

-Should Nutty Nuts purchase an additional 1000 pounds of almonds for $1000 from a supplier who overbought?

-The change in profit if Nutty Nuts does not satisfied the orders already received.

Appendix

• Calculate the cost per pound of the five types of nuts included in the Regular, Deluxe and Holiday mixes.
• The net profit per pound of Regular is $1.65 - the nut cost to make one pound of Regular.
• Calculate the net profit per pound of Deluxe and per pound of Holiday mix.
• For each of the LP model use EXCEL Solver to get the answer, give Model Formulation, the Answer and the Sensitivity report.You answer for the three question to the President would come from the Solver output.Include all calculations in the Appendix.