Reference no: EM132351735
CASE: MOTOMART Sr. Capstone.
Digital Study Guide & the Excel spreadsheet provided for this case.
You are to reproduce Table 5 from the instructions for Step 4. To complete the information in the table, as a help to you, you were given an Excel file with the Salaries already completed for you as an example for what needs to be done.
In the Excel workbook, you are to create new worksheets for each of the other expenses and do the appropriate work to arrive at the figures that you will include in the table for each of the expenses.
Therefore, the completed Excel file should have an additional 7 worksheets added to it with the numbers you come up with put into the table.
When submitting the project, you are to submit the Word document with the 5 steps in it and the Excel file as supporting documentation.
If the Excel file is not submitted or is not completed, you will not receive credit for Step 4 which will cause you to fail the project.
Attachment:- Motomart Excel Spreadsheet.zip