I need to know the equations for the below information, there is more information on the attached document
- Use a Monte Carlo simulation in MS Excel to simulate 1 month (26 days) of operation to calculate monthly profit. Replicate this simulation for 156 days, 312 days, 624 days, and 936 days to calculate average monthly profit.
- You are looking to expand production to see if you can increase profits by baking 55, 60, 65, and 70 batches per day. On a separate tab of the same spreadsheet, use Scenario Manager to create a scenario summary for each batch.