Required information

Part $2$ of $2$

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $2$: Applying Excel,,,,$],[2,,,,,],[3,$Cost summary for Job $408,$Department$],[4,,,$Milling,,$],[5,$Machine$-$hours,,$90,,2],[6,$Direct labor$-$hours,,$6,,40],[7,$Direct materials cost,$$,790,$$$,260],[8,$Direct labor cost,$$,120,$$$,760]]$

References

In your worksheet, enter this new data in the cells for Job $407.$

What is the new selling price for Job $408?$

$3.$ Without changing the data for the job from requirement $2$ above, what is the selling price for Job $408$ if the total number of machinehours in the Assembly Department increases from $3,000$ machine$-$hours to $5,000$ machine$-$hours?

$4.$ Restore the total number of machine$-$hours in the Assembly Department to $3,000$ machine$-$hours. And keep the job data the same as it was in Requirement $2.$ What is the selling price for Job $408$ if the total number of direct labor$-$hours in the Assembly Department decreases from $80,000$ direct labor$-$hours to $50,000$ direct labor$-$hours?

Complete this question by entering your answers in the tabs below.

Reauired?

Reouired $3$

Reauired $4$