PLEASE HELP DO THE APPENDIX 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 Nut Shipment Amount (lbs) Cost per Shipment

Almond 6000 7500

Brazil 7500 7350

Filbert 7500 6750

Pecan 6000 7260

Walnut 7500 7875

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 are $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 satisfied. 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

Appendix

you would need to 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. Similarly, you need to calculate the net profit per pound of Deluxe and per pound of the Holiday mix. For each of the LP models you use EXCEL Solver to get the answer, you need to submit the Model Formulation, the Answer, and the Sensitivity report. Your answer for the three questions to the President would come from the Solver output. Include all calculations in the Appendix.