Capsim | Management homework help

 
1. What is the formula for calculating your sales forecast?
2.  Where do you get the information needed to fill in the formula?
 Below is a Capsim worksheet I created to help you make decisions based on data.
 
 Below is also a video on how to make decisions based on data.  Scroll ahead to the Sales forecasting portion of the video and answer these questions. 
 https://youtu.be/Awg4TguPZuw 
Please answer the following questions following the review of the video and worksheet.