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

$1)$ Download the Excel data fileopens in a new tab.

$2)$ 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.

$3)$ Perform the requirementsLOADING... on the data file.

$4)$ Check your work in the Excel file with these check figuresLOADING....

$5)$ 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$LOADING....

$$B$)$ If you do not have Office$365,$ click here to learn how to get it for freeopens in a new tab.

$$C$)$ Troubleshooting FAQLOADING....

Question content area bottom

Part $1$

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 answering the questions until you have asked for assistance from your instructor.

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

A$.$$ $341$ comma $413\mathrm{.}00$

$ $341$ comma $413\mathrm{.}00$

B$.$$ $98$ comma $385\mathrm{.}00$

$ $98$ comma $385\mathrm{.}00$

C$.$$ $70$ comma $982\mathrm{.}00$

$ $70$ comma $982\mathrm{.}00$

D$.$$ $172$ comma $046\mathrm{.}00$

$ $172$ comma $046\mathrm{.}00$

Using the Excel file you created for Lancaster$,$ what was the total job cost for the desk lamp model in Iowa$?$

A$.$$ $27$ comma $583\mathrm{.}00$

$ $27$ comma $583\mathrm{.}00$

B$.$$ $30$ comma $763\mathrm{.}00$

$ $30$ comma $763\mathrm{.}00$

C$.$$ $98$ comma $961\mathrm{.}00$

$ $98$ comma $961\mathrm{.}00$

D$.$$ $40$ comma $615\mathrm{.}00$

$ $40$ comma $615\mathrm{.}00$

Using the Excel file you created for Lancaster$,$ what was the average cost per unit for the table lamp$$ model?

A$\mathrm{.}22\mathrm{.}0555$

$22\mathrm{.}0555$

B$\mathrm{.}19\mathrm{.}3873$

$19\mathrm{.}3873$

C$\mathrm{.}22\mathrm{.}7560$

$22\mathrm{.}7560$

D$\mathrm{.}21\mathrm{.}6045$

$21\mathrm{.}6045$

Using the Excel file you created for Lancaster$,$ what was the average cost for the floor lamp model in Vermont$?$

A$\mathrm{.}22\mathrm{.}0919$

$22\mathrm{.}0919$

B$\mathrm{.}22\mathrm{.}7500$

$22\mathrm{.}7500$

C$\mathrm{.}21\mathrm{.}5259$

$21\mathrm{.}5259$

D$\mathrm{.}19\mathrm{.}1325$

$19\mathrm{.}1325$

Using the Excel file you created for Lancaster$,$ what is the total direct material$($DM$)$ used in Arizona$?$

A$.$$ $48$ comma $135\mathrm{.}50$

$ $48$ comma $135\mathrm{.}50$

B$.$$ $29$ comma $723\mathrm{.}50$

$ $29$ comma $723\mathrm{.}50$

C$.$$ $65$ comma $503\mathrm{.}00$

$ $65$ comma $503\mathrm{.}00$

D$.$$ $166$ comma $130\mathrm{.}00$

$ $166$ comma $130\mathrm{.}00$

Using the Excel file you created for Lancaster$,$ what is the total direct labor$($DL$)$ used in Vermont$?$