Solutions Only with Excel and @Risk

You run a sushi stand in the underground walkways of Toronto. You are never sure exactly how many containers of salmon sashimi people are going to buy, but you have been tracking the last year or so and recorded the following pattern: (Data Attached)

The ingredients for each container of salmon sashimi costs you about $5 to make and a container sells for $8. You mark down any unsold containers by 50% after 3pm and you found they all sell out by the end of the day. You pride yourself on using fresh Salmon and so you order the fish the night before to be delivered in the morning. You can buy the salmon only in portions of 5 and are considering stocking between 40-60 containers, which means buying enough to make 40, 45, 50, 55, or 60 per day. How many containers should you order? In this question, if you are having technical difficulties with the "multiple runs" option of @risk, you can run the simulation manually instead of using the RISKSIMTABLE.