----------------------------------------------------------------------------------------------------------------------
Data |
||
Markup on job cost |
75% |
|
Department |
||
Milling |
Assembly |
|
Machine-hours |
60,000 |
3,000 |
Direct labor-hours |
8,000 |
80,000 |
Total fixed manufacturing overhead cost |
$390,000 |
$500,000 |
Variable manufacturing overhead per machine-hour |
$2.00 |
|
Variable manufacturing overhead per direct labor-hour |
$3.75 |
|
Cost summary for Job 408 |
Department |
|
Milling |
Assembly |
|
Machine-hours |
60 |
4 |
Direct labor-hours |
8 |
40 |
Direct materials |
$900 |
$470 |
Direct labor cost |
$152 |
$800 |
----------------------------------------------------------------------------------------------------------------------
a) What is the selling price for Job 408? (Round your final answer to 2 decimal places.)
b) What is the selling price for Job 408, if the total number of machine-hours in the Assembly Department increases from 3,000 machine hours to 6,000 machine hours? (Round your final answer to 2 decimal places.)
c) 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? (Round your final answer to 2 decimal places.)
Markup on job cost | 75% | |
Department | ||
Milling | Assembly | |
Machine-hours | 60,000 | 3,000 |
Direct labor-hours | 8,000 | 80,000 |
Total fixed manufacturing overhead cost | $390,000 | $500,000 |
Fixed overhead rate | $6.50 | $6.25 |
Variable manufacturing overhead per machine-hour | $2.00 | |
Variable manufacturing overhead per direct labor-hour | $3.75 | |
Total predetermined overhead rate | $8.50 | $10.00 |
Cost summary for Job 408 | Department | |
Milling | Assembly | |
Machine-hours | 60 | 4 |
Direct labor-hours | 8 | 40 |
Direct materials | $900 | $470 |
Direct labor cost | $152 | $800 |
Calculation of Selling price | ||
Direct materials | $1,370 | |
Direct labor cost | $952 | |
Overheads | $910.00 | |
Total cost | $3,232.00 | |
Mark up | $2,424.00 | |
Selling price | $5,656.00 | |
The price will remain the same as $5656 as overheads in Assembly department are not absorbed on the basis of machine hours |
C)
Markup on job cost | 75% | |
Department | ||
Milling | Assembly | |
Machine-hours | 60,000 | 3,000 |
Direct labor-hours | 8,000 | 50,000 |
Total fixed manufacturing overhead cost | $390,000 | $500,000 |
Fixed overhead rate | $6.50 | $10.00 |
Variable manufacturing overhead per machine-hour | $2.00 | |
Variable manufacturing overhead per direct labor-hour | $3.75 | |
Total predetermined overhead rate | $8.50 | $13.75 |
Cost summary for Job 408 | Department | |
Milling | Assembly | |
Machine-hours | 60 | 4 |
Direct labor-hours | 8 | 40 |
Direct materials | $900 | $470 |
Direct labor cost | $152 | $800 |
Calculation of Selling price | ||
Direct materials | $1,370 | |
Direct labor cost | $952 | |
Overheads | $1,060.00 | |
Total cost | $3,382.00 | |
Mark up | $2,536.50 | |
Selling price | $5,918.50 |
Selling price will be $5918.50
Given the following data, answer the questions below the table: ---------------------------------------------------------------------------------------------------------------------- Data Markup on job cost...
1. 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: A B с 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 4 5 Department Milling Assembly 50 2 8 20 820 $ 270 144 $ 320 Machine-hours Direct labor-hours Direct materials cost Direct labor cost...
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: А B с 1 Chapter 2: Applying Excel Cost summary for Job 408 2 3 4 5 Machine-hours Direct labor hours Direct materials cost Direct labor cost Department Milling Assembly 70 2 5 40 880$ 440 95 $ 640...
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: A B C 1 2 3 4 5 6 7 8 Chapter 2: Applying Excel Cost summary for Job 408 Department Milling Assembly Machine-hours 60 2 Direct labor-hours 5 20 Direct materials cost $510 $400 Direct labor cost $90 $380...
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: A B с 1 2 Chapter 2: Applying Excel 3 Cost summary for Job 408 4 5 6 Machine-hours Direct labor hours Direct materials cost Direct labor cost Department Milling Assembly 90 2 9 20 760 $ 330 162...
In your worksheet, enter this new data in the cells for Job 407. Cost summary for Job 408 Department Milling Assembly Machine Hours 70 2 Direct labor hours 6 20 Direct material cost 640 380 Direct labor cost 114 380 What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total...
Help figuring out this problem show work if you can EXHIBIT 2-5 Dickson Company: An Example Using Multiple Predetermined Overhead Rates Step 1: Calculate the estimated total manufacturing overhead cost for each department. Miling Department Overhead Cost (Y): Assembly Department Overhead Cost (Y): = $390,000 + ($2.00 per MH X 60.000 MHS) = $500,000 + ($3.75 per DLH X 80,000 DLHs) = $390,000+ $120,000 = $500,000 + $300,000 = $510,000 = $800,000 Step 2: Calculate the predetermined overhead rate in...
EXHIBIT 2-5 Dickson Company: An Example Using Multiple Predetermined Overhead Rates Step 1 Calculate the estimated total manufacturing overhead cost for each department. Milling Department Overhead Cost(Y): Assembly Department Overhead Cost (Y): = $390,000 + ($2.00 per MH 60,000 MHs) = $500,000 + ($3.75 per DLH 80,000 DLHs) = $390,000+ $120,000 = $500,000 + $300,000 = $510,000 = $800,000 Step 2 Calculate the predetermined overhead rate in each department Milling Department Overhead Rate: Assembly Department Overhead Rate: $510,000 $800,000 60,000...
Data Markup on job cost 75% Milling Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour Department Assembly 60,000 3,000 8,000 80,000 $390,000 $500,000 $2.00 $3.75 Cost summary for Job 407 Department Milling Assembly 90 Machine-hours Direct labor-hours Direct materials Direct labor cost $800 $70 20 $370 $280 Enter a formula into each of the cells marked with a ? below Assembly Step 1: Calculate the estimated total manufacturing overhead...
Chapter 2 Applying Excel (B) Help Saved 1 Required information This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5 10 points 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: eBook Print A B C References 1 Chapter 2: Applying Excel 3...
Here are the instructions, my apologies Chapter 2: Applying Excel: Exercise 1. 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: А B С Book 1 Chapter 2: Applying Excel 2 Files 3 Cost summary for Job 408 4 5 Department Muling Assembly 70 4 0 20 840 $...