A B 50 50 75 75 2 50 74 Demand 41 50 40 0 0 olo 0 33 1. Many business models assume that they will sell everything they produce. Although unrealistic, this simplifies the model and allows them to solve the given problem. Simulation allows us to remove this assumption and deal with more realistic business scenarios. This requires creating formulas in Excel to calculate the number of unsold items (oversupply) and the amount of unfilled demand (undersupply). Open a new Excel document and create the template on the left. You don't need to include the shaded cells or the test values. Save your file in your computer, and keep it. You don't need to submit it in Canvas. Test Values 1 Supply 108 3 4 Unsold items 9 35 5 Unfilled demand 24 Your goal is to create formulas in cells B4 and B5 that calculate the number of unsold items and unfilled demand for any combination of supply and demand values. Think about how you would do this. When supply is greater than demand, supply - demand > 0. When demand is greater and supply, demand-supply > 0. Use that knowledge in combination with a MAX or MIN statement to create the required formulas. Note that the two formulas will be different but similar. Make sure to test that your formulas work by trying out the test values. Note that although is possible to use a nested IF statement to determine these values, I specifically want You to do this using the MAX and MIN functions. 2. Use the same Excel sheet as above. Enter the function=RANDO into cell A7. This generates a random number between 0 and 1 (with 15 decimal place accuracy). Create a nested IF statement in cell B7 that will output "Low" if the number is less than 0.4, "Mid" if the value is between 0.4 and 0.7, and "High" otherwise. Write your formula here