This is the case

This is the case solution

I am asking for the excel formulas thats need to be inserted in each sell spicialy for sheet2. Thank you

T-Mobile ACT202L: Spring 2018: Graded Case#4: What-If-Analysis using both One and Two Variables Analyses What-If Analysis with One Variable: GIVEN: Green's Landscaping Company noted sales revenues for 2017 in the amount of $1 Management expects solid growth in the amount of 4.0% for 2018. REQUIRED: 1. What is the projected Sales for 2018 given the above expectation in growth? 2. What are the various projections for Sales in 2018 given various possible growt beginning with 2% up to and including 796 for every half point percent change? Sales Projection for 2018 Sales for 2017: Expected Growth Rate: Projected Sales for 2018: One Variable Two Variables 2 sheet I ACT202L: Spring 2018: Graded Case#4 2 What-If Analysis with Two Variables: GIVEN # Tom's Landscaping Company has noted sales revenues for 2017 to be $1.8 million. Management expects a growth rate in Sales to be 3.5% for 2018 but also expects 7 of Sales Revenues to be Operating Expenses. REQUIRED: 1. What are the Projected Sales for 2018 under this growth rate scenario? 2. What are the various Projected Operating Incomes should expected sales growth be anywhere from 2% up to and including 896 (for every half percent) 1 and expenses varying from 60% to 85% (for every 5% change)? 3 Ol Projected for 2018 4 Sales for 2017: 5 Growth for 2018 6 Projected Expenses for 2018: 7 Projected Sales for 2018: 8 Projected Ol for 2018