Q$5$B$-$ The cheesecake shop problem:

$-$ The seller buys cakes for $33$ SR each and sells for $50$ SR each.

$-$ The cakes not sold at the end of the day are sold as scrap for $5$ SR each.

$-$ Cheesecakes can be purchased in bundles of $10.$ Thus the merchant can buy $\backslash (40,50,60\backslash ),$ and so on$.$ You are required to simulate for a daily purchase of $70$ cakes ONLY.

$-$ There are three types of cake days, "good", "fair", and $"\text{'}$poor$"$ with probabilities of $\backslash (0\mathrm{.}35,0\mathrm{.}45\backslash )$ and $0\mathrm{.}20.$

$-$ The demand distribution for each type of days is listed in the table.

$-$ Profit is calculated as profit $=$ revenue $-$ cost $-$ lost profit from excess demand $+$ salvage

$-$ Make a simulation Table to calculate daily profit

$-$ Run the simulation by hand for $5$ days given the following random digits $\backslash ((4,50,62,38,5)\backslash )$ for Type of day and $\backslash ((88,99,28,90,43)\backslash )$ for Demand.

$-$ EXTRA POINTS

$-$ Run the simulation for a month using excel

$-$ Use data tables to make $100$ runs to calculate mean profit of the month and $95\backslash \%$ CI