Problem
Determine what statistical analysis formulas you need. Perform these tasks on the 17 Cash flow worksheet. For example, calculate the monthly averages and monthly percentages of the line totals. Use this information to create the scenarios you need to use the goal-seek tools. For example, JAN's total income was 6.26% of the 2017 Cash flow. So, if the goal for 2018 is to have 6.26% of the year's budget total of $624,000 then JAN 2018 income categories (Sales, Service and Other) need to total $39,041. What combination of category numbers will achieve that? Use Excel's Scenario Manager and goal seek tools to project how to attain these objectives for the 2018 Budget worksheet. You have to show your work on the Cash flow worksheet or on a new worksheet named Scenario Manager that is produced with the tools you use.