The steps you will follow for this project are as follows:

Download the Excel data file.

Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step$-$by$-$step.

Perform the requirements on the data file.

Check your work in the Excel file with these check figures.

Use your Excel file to answer the six multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$)$ Information on how to update Excel and Office $365.$

B$)$ If you do not have Office $365,$ click here to learn how to get it for free.

C$)$ Troubleshooting FAQ.

This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answerin questions until you have asked for assistance from your instructor.

Using the Excel file you created for Madison, what was the total job cost for the floor lamp model?

A$.$ $$170,925\mathrm{.}00$

B$.$ $$71,053\mathrm{.}50$

C$.$ $$341,908\mathrm{.}50$

D$.$ $$99,930\mathrm{.}00$

Using the Excel file you created for Madison, what was the total job cost for the desk lamp model in Ohio?

A$.$ $$101,115\mathrm{.}50$

B$.$ $$40,427\mathrm{.}00$

C$.$ $$27,907\mathrm{.}00$

D$.$ $$32,781\mathrm{.}50$

Using the Excel file you created for Madison, what was the average cost per unit for the floor lamp model?

A$.18\mathrm{.}9852$

B$.21\mathrm{.}3648$

$.274557$