Please answer and show Calculations

C 1 2 e show calculation outreat for each question that requesito refer to the cell that does. Final answers should be within the green colored cells. Any empty blank ce et can be used for your own calculation to demonstrate intermediate steps of calculations. You can also use the "Aditional Calculation if any worksheet for interm calculation 2 4 5 6 Assignment Questions for Module 4 10 IL 12 A bakery manager has to order staff members to make cakes during certain days of the month. On cake production days, number of cakes made in a day. Annual sales for cakes Daily sales: The cost of storing cake: Cost of ordering cakes (accounts for total costs of labor, raw materials, equipment, The working days in the year bakery is open: 13 SOOcakes per day 12000 cakes 40 cakes 2 per cake per day 30 per order of cake production day 300 days in a year 14 15 16 17 18 Answers 19 20 21 1 How many cakes should the manager ask the cake making team to produce (EOQI? 2 How many times will the cake making team be asked to make cakes by the manager? 3 What will be the maximum number of cakes in the bakery at any time? 4 How many days out of all the working days, is the bakery actually making cakes? what percentage of days is the bakery actually busy making cakes? (compared to total 5 working days) What are the ordering costs and holding costs for the bakery for a year? Ordering Costs Holding Costs 23 ANNARR 27 30 31 32 33 34