$2$ Excel Project

Help

$2.$ Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $$390,000,$ keeping all of the other data the same as in the original example. Consider a new job, Job $408,$ with the following characteristics:

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $2$: Applying Excel,,$],[2,,,],[3,$Cost summary for Job $408,$Depar,ent$],[4,,$Milling,Assembly$],[5,$Machine$-$hours,$50,3],[6,$Direct labor$-$hours,$6,20],[7,$Direct materials cost,$ $540,$$ $320],[8,$Direct labor cost,$ $108,$$ $360]]$

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 $4,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.

Prev

$1$ of $1$

Next