INSTRUCTIONS -

1. Use formulas to calculate Gross profit, Total operating expenses, Operating Income, and Variances in columns E & H.

2. Apply conditional formatting to columns E & H (ask yourself: why only those columns?). Don't forget to include a legend or key code for your conditional formatting.

3. Use those results to project what Austin's actual 2017 year-end results will be for Rev, CGS, R&D, S&M, Gen & Admin (column I). Include a brief rationale for each in column O.

4. Now apply conditional formatting to columns K, L & N.

And must also create a "HEAT MAP" From the results.

Attachment:- Assignment File.rar