This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. Download the workbook containing this form from Connect, where you will also find instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
4. Restore the total number of machine-hours in the Assembly Department to 3000 machine-hours. What happens to the selling price forJob 408 if the total number of direct labor-hours in the Assembly Department decreases from 80,000 direct labor-hours to 50,000direct labor-hours? Does it increase, decrease, or stay the same as in pail 2 above? Why?
Selling price: The cost incurred by selling the product in the market is known as the selling price.
Determine the selling price for Job 408 when the machine hours in Assembly department are restored to 3000 hours and the Direct Labor hours in the said department are reduced from 80000 hours to 50000 hours.
Answer to Problem 4AE
Solution:
The pre-determined rate per direct labor hour increases from $10 to 13.75. As a result of which the total cost increases leading to an ultimate increase in the selling price for Job 408.Explanation of Solution
The calculation is done in the workbook and it is explained below,
Chapter 2: Applying Excel | |||
Data | |||
Mark-up on job cost | 75% | ||
Department | |||
Milling | Assembly | ||
1 | Machine hours | 60000 | 6000 |
2 | Direct Labour Hours | 8000 | 50000 |
3 | Total fixed manufacturing overhead cost | $3,90,000.00 | $5,00,000.00 |
4 | Variable manufacturing overhead per machine hour | $2.00 | $ - |
5 | Variable manufacturing overhead per direct labour hour | $ - | $3.75 |
Cost Summary for job 408 | Department | ||
Milling | Assembly | ||
6 | Machine hours | 40 | 10 |
7 | Direct Labour Hours | 2 | 6 |
8 | Direct Materials | $700.00 | $360.00 |
9 | Direct Labour cost | $50.00 | $150.00 |
Enter a formula into each of the cells marked with ? below | |||
Step 1: Calculate the estimated total manufacturing overhead cost for each department | |||
Milling | Assembly | ||
10 | Total fixed manufacturing overhead (given) | $3,00,000.00 | $5,00,000.00 |
11 | Variable manufacturing overhead per machine hour or direct labour hour (given) | $2.00 | $3.75 |
12 | Total machine hours or direct labour hours (given) | 60000 | 50000 |
13 | Total Variable manufacturing overhead (11 x 12) | $1,20,000.00 | $1,87,500.00 |
14 | Total manufacturing overhead (10 + 13) | $4,20,000.00 | $6,87,500.00 |
Step 2: Calculate the pre-determined overhead rate in each department | |||
Milling | Assembly | ||
15 | Total manufacturing overhead (14) | $4,20,000.00 | $6,87,500.00 |
16 | Total machine hours or direct labour hours (given) | 60000 | 50000 |
17 | Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16) | $7.00 | $13.75 |
Step 3: Calculate the amount of overhead applied to both departments to Job 408 | |||
Milling | Assembly | ||
18 | Pre-determined overhead rate per machine hour or direct labour hour (17) | $7.00 | $13.75 |
19 | Machine hours or direct labour hours for the job (given) | 40 | 6 |
20 | Manufacturing overhead applied (18 x 19) | $280.00 | $82.50 |
Step 4: Calculate the total job cost for Job 408 | |||
Milling | Assembly | ||
21 | Direct Materials (given) | $700.00 | $360.00 |
22 | Direct Labour cost (given) | $50.00 | $150.00 |
23 | Manufacturing overhead applied (20) | $280.00 | $82.50 |
24 | Total cost of Job 407 (21 + 22 + 23) | $1,030.00 | $592.50 |
Total cost of Job 407 (Milling + Assembly) | $1,622.50 | ||
Step 5: Calculate the selling price for Job 408 | |||
Milling | Assembly | ||
25 | Total cost of Job 407 ( 24) | $1,030.00 | $592.50 |
26 | Mark-up (24 x 75%) | $772.50 | $444.38 |
27 | Selling price of Job 407 (25 + 26 ) | $1,802.50 | $1,036.88 |
28 | Total Selling Price of Job 408 (Milling + Assembly) | $2,839.38 |
When the direct labor hours are reduced from 80000 hours to 50000 hours, the cost increases since the pre-determined rate per direct labor hour increases from $10 to $13.75. As a result of which the total cost increases leading to an ultimate increase in the selling price.
Since selling price is calculated as per the Cost plus Markup method it is directly related to an increase or a decrease in the cost.
Want to see more full solutions like this?
Chapter 2 Solutions
Introduction To Managerial Accounting
- Floyd Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct labor hours used for each toy during the current year is provided in the table below. Estimation for Number of Units Produced, Machine Hours Used, and Direct Labor Hours Number of units Machine hours (MH) Direct labor hours (DLH) Bear 2,000 8,000 MH 700 DLH Puppy 3,000 5,000 MH 1,000 DLH Bunny 5,000 4,000 MH 2,300 DLH The total machine running costs incurred during the year is $204,000. The allocation of machine running costs to these three items is based on machine hours. How much machine running costs are expected to be allocated to each unit of Bunny? (Round your answer to two decimal points) Group of answer choices $48.00 per unit $12.00 per unit $20.00 per unit $9.60 per unitarrow_forwardFloyd Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct labor hours used for each toy during the current year is provided in the table below. Estimation for Number of Units Produced, Machine Hours Used, and Direct Labor Hours Toy Number of units Machine hours (MH) Direct labor hours (DLH) Bear 2,000 8,000 MH 700 DLH Puppy 3,000 5,000 MH 1,000 DLH Bunny 5,000 4,000 MH 2,300 DLH The total machine running costs incurred during the year is $204,000. The allocation of machine running costs to these three items is based on machine hours. How much machine running costs are expected to be allocated to each unit of Bear? (Round your answer to two decimal points) Group of answer choices $20.00 per unit $9.60 per unit $12.00 per unit $48.00 per unitarrow_forwardFloyd Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct labor hours used for each toy during the current year is provided in the table below. Estimation for Number of Units Produced, Machine Hours Used, and Direct Labor Hours Toy Number of units Machine hours (MH) Direct labor hours (DLH) Bear 2,000 8,000 MH 700 DLH Puppy 3,000 5,000 MH 1,000 DLH Bunny 5,000 4,000 MH 2,300 DLH The total machine running costs incurred during the year is $204,000. The allocation of machine running costs to these three items is based on machine hours. How much machine running costs are expected to be allocated to Bear during the year? Group of answer choices $96,000 $60,000 $48,000 $8,400arrow_forward
- Floyd Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct labor hours used for each toy during the current year is provided in the table below. Estimation for Number of Units Produced, Machine Hours Used, and Direct Labor Hours Toy Number of units Machine hours (MH) Direct labor hours (DLH) Bear 2,000 8,000 MH 700 DLH Puppy 3,000 5,000 MH 1,000 DLH Bunny 5,000 4,000 MH 2,300 DLH The total machine running costs incurred during the year is $204,000. The allocation of machine running costs to these three items is based on machine hours. How much machine running costs are expected to be allocated to Puppy during the year? Group of answer choices $8,400 $60,000 $96,000 $48,000arrow_forwardPlease help with the question number 4,5, and 6. Thank you Gigabyte, Inc. manufactures three products for the computer industry: Gismos (product G): annual sales, 8,000 units Thingamajigs (product T): annual sales, 15,000 units Whatchamacallits (product W): annual sales, 4,000 units The company uses a traditional, volume-based product-costing system with manufacturing over-head applied on the basis of direct-labor dollars. The product costs have been computed as follows: Product G Product T Product W Raw material ..........................$ 35.00 $52.50 $17.50 Direct labor 16(.8 hr.at $20) 12(.6 hr at $20) 8(.4 hr at $20) Manufacturing overhead* ......140.00 105.00 70.00 Total product cost ..................$191.00 $169.50 $95.50 *Calculation of predetermined overhead rate: Manufacturing overhead budget: Machine…arrow_forwardDirections Below is information for Blue Company. Using this information, answer the following questions on the "Calculation" tab in the file. Show your work (how you got your answer) and format appropriately. Blue company has prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 to 1,500 units): Sales $ 20,000 Variable expenses 12,000 Contribution margin 8,000 NOTE: Use the amounts in the original fact pattern to the left as your basis for the questions below. Fixed expenses 6,000 Net operating income $ 2,000 Questions:…arrow_forward
- Macy Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct labor hours used for each toy during the current year is as follows: Number of units Machine hours (MH) Direct labor hours (DLH) Bear 2,000 5,000 MH 700 DLH Puppy 4,000 3,000 MH 1,000 DLH Bunny 6,000 2,000 MH 2,300 DLH The total machine running costs incurred during the year is $150,000. The allocation of machine running costs to these three items is based on machine hours. How much machine running costs are expected to be allocated to Bunny during the year? Group of answer choices $30,000 $75,000 $45,000 $48,000arrow_forwardRight Size Corporation manufactures faucets. Several weeks ago, the company received a special-order inquiry from Bates Inc. Bates desires to market a faucet similar to Right Size's model no. 85 and has offered to purchase 3,000 units. The following data are available: • Cost data for Right Size's model no. 85 faucet: direct materials - $45; direct labour - $30 (2 hours at $15 per hour); and manufacturing overhead - $70 (2 hours at $35 per hour). • The normal selling price of model no. 85 is $180; however, Bates has offered Right Size only $115 because of the large quantity it is willing to purchase. • Bates requires a design modification that will allow a $4 reduction in direct-material cost. • Right Size's production supervisor notes that the company will incur $8,700 in additional set-up costs and will have to purchase a $3,300 special device to manufacture these units. This device will be discarded once the special order is completed. • Total manufacturing overhead costs are…arrow_forwardRight Size Corporation manufactures faucets. Several weeks ago, the company received a special-order inquiry from Bates Inc. Bates desires to market a faucet similar to Right Size's model no. 85 and has offered to purchase 3,000 units. The following data are available: • Cost data for Right Size's model no. 85 faucet: direct materials - $45; direct labour - $30 (2 hours at $15 per hour); and manufacturing overhead - $70 (2 hours at $35 per hour).• The normal selling price of model no. 85 is $180; however, Bates has offered Right Size only $115 because of the large quantity it is willing to purchase.• Bates requires a design modification that will allow a $4 reduction in direct-material cost.• Right Size's production supervisor notes that the company will incur $8,700 in additional set-up costs and will have to purchase a $3,300 special device to manufacture these units. This device will be discarded once the special order is completed.• Total manufacturing overhead costs are applied to…arrow_forward
- Right Size Corporation manufactures faucets. Several weeks ago, the company received a special-order inquiry from Bates Inc. Bates desires to market a faucet similar to Right Size's model no. 85 and has offered to purchase 3,000 units. The following data are available: • Cost data for Right Size's model no. 85 faucet: direct materials - $45; direct labour - $30 (2 hours at $15 per hour); and manufacturing overhead - $70 (2 hours at $35 per hour).• The normal selling price of model no. 85 is $180; however, Bates has offered Right Size only $115 because of the large quantity it is willing to purchase. • Bates requires a design modification that will allow a $4 reduction in direct-material cost.• Right Size's production supervisor notes that the company will incur $8,700 in additional set-up costs and will have to purchase a $3,300 special device to manufacture these units. This device will be discarded once the special order is completed.• Total manufacturing overhead costs are applied…arrow_forwardSamson Designers produces a lady’s handbag that normally sells for $120. The company produces 800 units annually but has the capacity to produce 1,100 units. An order from a customer has been received for 200 handbags at $85 each that would not disrupt current operations. Current costs for the handbag are as follows: Direct materials $23.00 Direct labor 45.00 Variable overhead 7.00 Fixed overhead 12.00 Total $87.00 In addition, the customer would like to add a monogram to each bag which would require an additional $4 per bag in additional labor costs. Samson would also have to purchase a piece of equipment to create the monogram which would cost $800. This equipment would not have any other uses. Which statement is true with regard to this situation? Incremental…arrow_forwardPlease don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first. ALSO PLEASE INCLUDE THE EXCEL FORMULAS!! Thanks!! If someone can help I will give a thumbs up. Thanks for the help! :)arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning