Question: How do i use excel to figure out the question marks. thanks!! 1 Chapter 2: Applying Excel Dath Markup on job cost begin{tabular}{l|l} 5 &

How do i use excel to figure out the question marks. thanks!! How do i use excel to figure out the question marks. thanks!!

1 Chapter 2: Applying Excel Dath Markup on job cost \begin{tabular}{l|l} 5 & \\ 6 & \\ 7 & \\ 8 & Machine-hours \\ 9 & Direct laborhours \\ \hline \end{tabular} 10 Total foxed manufacturing overhead cost 1 Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour Cost summary for Job 407 Machine-hours Direct laborthours Direct materials Direct labor cost 75% Department \begin{tabular}{|r|r|} \hline \multicolumn{1}{|c|}{ Miling } & Assembly \\ \hline 60,000 & 3,000 \\ \hline 8,000 & 80,000 \\ \hline$390,000 & $500,000 \\ \hline 52,00 & \\ \hline & $3.75 \\ \hline \end{tabular} Department Assembly Enter a fomula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department Total foxed manufacturing overhead cost Variable manufacturing ovethead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overtead Total manufacturing overtead Step 2: Calculate the predetermined overhead rate in each department Total manufacturing overhead Total machine hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour \begin{tabular}{|r|r|} \hline 90 & 4 \\ \hline 5 & 20 \\ \hline$800 & $370 \\ \hline$70 & $280 \\ \hline \end{tabular} Step 3: Caleulate the amount of overhead applied from both departments to Job 407 Predetemined ovemead rate per machine-hour or direct laborhour Machine-hours or direct labor-hours for the job Manufacturing overhead applied \begin{tabular}{r|r|} \hline Miling & Assembly \\ \hline? & ? \\ \hline? & ? \\ \hline? & ? \\ \hline? & ? \\ \hline? & ? \\ \hline \hline \end{tabular} Step 4: Calculate the total job cost for Job 407 Direct materials 46 Drect labor cost 47 Manufacturing ovetiead applied Total cost of Job 407 Step 5: Calculato the solling price for Job 407 Total cost of Job 407 Markup. Seling price of Job 407

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!