The purpose of this assignment is trifold. I want to ensure that you: (1) Understand how to compute simple forecasts that will help you to get a handle on how the simulation works; (2) Understand know how to use Excel formulas properly, and that you can organize your work in a logical and straight-forward manner that is easy for your audience to follow; and (3) Have the ability to apply your forecasts using a written format to sell your ideas to others. For this assignment, please complete the following forecasts for the simulation using Excel. Specically, I want you to use information available on the Round 0 Courier, the Industry Conditions Report, and the Capstone Manager Guide to forecast the following: 1. 2. 99:55\" Forecast demand for all 5 product segments, for each of the 8 yearly rounds. Forecast the \"ideal spot" locations (or \"sweet spot" locations) for each product segment, for each of the 8 rounds. Please estimate the cost to double capacity for each of your current products. Please estimate the cost to raise automation for each of your current products. Please calculate the gross margin for each of your current products. Please calculate the margin potential for each of your current products