The Pat-A-Cake Pastry Shop makes chocolate cake in three sizes –Small, Medium, and Large. For each size, the number of cakes madeis an integer (i.e. the shop does not bake only half of a cake).The shop has the following amounts of the three main ingredients onhand – 400 ounces of cake flour, 550 ounces of caster sugar, and150 ounces of cocoa powder. The table below provides details on theamount of each ingredient required for each cake size as well asthe profit contributions. The shop wants to make the appropriateamount of each cake size in order to maximize profit. Cake SmallMedium Large Available Plain flour (Ounce) 8 16 21 400 Caster sugar(Ounce) 18 22 25 550 Cocoa powder (Ounce) 3 5 11 150 Profit/Unit$18 $25 $32

Develop a spreadsheet model and find the optimal solution usingExcel Solver. What is the optimal total profit? Enter your answerwithout a dollar sign.

Question 2 Based on your answer to Question 1, what quantity oflarge cakes should be produced to maximize profit contribution?Remember that the number of cakes made should be an integer.

Question 3 Based on your answer to Question 1, what quantity ofmedium cakes should be produced to maximize profit contribution?Remember that the number of cakes should be an integer.

Question 4 Based on your answer to Question 1, what quantity ofsmall cakes should be produced to maximize profit contribution?Remember that the number of cakes should be an integer.