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 a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.
Best Solution Tutorial Excel 2010 Chapter 3a Project - Med Supply Online Warehouse
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 a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.
0 comments:
Post a Comment