help solve

Note: Please show calculation'output for each question that requires it or refer to the cell that does. Final answers should be within the green colored cells. Any empty/blank cells in this worksheet can be used for your own calculation to demonstrate intermediate steps of calculations. You can also use the "Aditional Calculation if amy" worksheet for intermediate calculations. Assignment Questions for Module 4 A bakery manager has te order staff members to make cakes during certain days of the month. On cake production days, number of cakes made ina day:| 500] cakes per day Annual sales for cakes: } 12000] cakes Daily sales: The cost of storing cake: per cake per year Cost of ordering cakes (accounts for total costs of labor, raw materials, equipment, etc.): 30) per order of cake production day The working days in the year bakery is open: days in a year Answers How many cakes should the manager ask the cake making team to 1 produce (EOQ)? How many times will the cake making team be asked to make cakes by the 2 Manager? 3 What will be the maximum number of cakes in the bakery at anytime? Po Out of one Run of Production-consumption cycle, how many days is the bakery 4 actually making cakes? [| What percentage of days is the bakery actually busy making cakes? (compared to total working days) [| 6 What are the ordering costs and holding costs for the bakery for a year? Ordering Costs Holding Costs