What is the shadow price of the mixing available time?

What is the optimal number of Strawberry cakes to bake daily?

What are the maximum daily profits that can be achieved in dollars?

What is the shadow price of the maximum demand for mango cake?

Consider the bakery example we solved in class for the best capacity allocation. Suppose now that the bakery has become very successful and has expanded. Now they offer five cakes: Mango with profit margin $32 per cake, Chocolate with profit margin $20 per cake, Strawberry with profit margin $15 per cake, Raspberry with profit margin $11 per cake, and Pineapple with profit margin \$18 per cake. The minimum and maximum demand for each type of cake (per day) is provided in [MIN, MAX] format: Mango: [20,40]; Chocolate: [55,80]; Strawberry: [50,120]; Raspberry: [20,70]; Pineapple: [25,60]. They have also expanded their capacity in their four main steps. Please see the following table for both available capacity and how much capacity each cake consumes at a given step. Your goal is to determine how many of each cake to produce per day to maximize profits. Mango Chocolate Strawberry Raspberry Pineapple Solve the problem of maximizing daily profits for the bakery as a Linear Programming problem in Excel. Report the optimal solution with sensitivity report. Upload your Excel file here