It's a BUS 220 Question.

Please, solve in excel and show excel functions used.

1. Problem One: BMZZ Sound produces three lines of high fidelity headphones, Model J, Model T, and Model W. The profits for each model are, $350, $850 and $9000, respectively. The company expects the daily demand for each model to be at least 1,500, 1250 and 1760 units, respectively. Due to limitations in their manufacturing facility, the company cannot exceed 4750 units for Model J, 3380 units for Model T, and 2570 units for model W. Due to global demand, the company has a contractual obligation to send at least 1680 units every day to emerging market customers. In addition, the marketing department has requested to avoid brand dilution by limiting total output to 14,000 units per day. Given your knowledge of Linear Programming, (a) how many units of each model should BMZZ produce to maximize daily profits? (b) Create a Sensitivity Report and state, both the Reduced Cost, and the Shadow Price, (c) interpret the significance of both, Reduced Cost and the Shadow Price, (d) suppose that both, the company expects a new higher demand of at least 2,500 units for model T, how does that impact your optimal solution - in terms of output and profitability