You are required to develop a spreadsheet$-$based decision model that can be used to investigate and exploredecisions and risks related to daily bread production at a small bakery. The model should be designed to assistthe Bakery Manager in optimizing the daily production of their most popular bread type, aiming to meetcustomer demand while minimizing waste and maximizing daily profit.You should assume the following: The bakery has a limited production capacity. Daily demand for bread varies. There is a spoilage rate for unsold bread. Ingredients cost can fluctuate. The bakery offers occasional discounts on unsold bread towards the end of the day. Any other valid assumptions are left to your discretion.You are required to create a fictitious client $($i$.$e$.,$ the Bakery Manager$)$ and demonstrate the utility of thedecision model using real data where available $($such as the cost of ingredients and the selling price of bread$)$and create data where it is not. The decision model must be realistic and easy to use. The level of complexitymodelled, for example, the choice of deterministic vs$.$ stochastic inputs, input distributions, etc., is left to yourdiscretion. However, the model must enable the user to input business costs such as ingredient costs, spoilagerates, and discount rates, and revenue in order to maximize profit.Excel spreadsheet includes a sample of the decision model format for you to follow. The minimum requirements of the decision model are:$1.$ The ability to enter revenue and costs, so that decision options can be explored and to enable outputs,such as profit, to be calculated$\mathrm{.}2.$ Stochastic treatment of random inputs, in order to explore the resulting simulated output and tosummarise the risks$\mathrm{.}3.$ It must also enable the decision$-$maker to explore and understand the risks associated with the decision