In Part 1 you will create the worksheet. In Part 2 you will use Goal Seek and analyze three different sales scenarios.
Description Assignment Instructions & Requirements Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on the assumptions below. In Part 1 you will…