Managerial Accounting
15th Edition
ISBN: 9780078025631
Author: Ray H Garrison, Eric Noreen, Peter C. Brewer Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 3, Problem 2AE
To determine
Selling price: The cost incurred by selling the product in the market is known as the selling price.
Determine the missing figures in the sheet. After finding the missing figures determine the selling price of Job 408 by replacing the current data with the data given in the question.
Expert Solution & Answer
Answer to Problem 2AE
Solution: The selling price of Job 408 using current data is $4348.75 and the selling price of Job 408 after replacing the current data with the given data is $2800.
Explanation of Solution
This calculation is done in the workbook and it is explained below,
Part -1- The missing figures in the sheet is determined here.
| Chapter 2: Applying Excel | |||
| Data | |||
| Mark-up on |
75% | ||
| Department | |||
| Milling | Assembly | ||
| 1 | Machine hours | 60000 | 3000 |
| 2 | Direct Labour Hours | 8000 | 80000 |
| 3 | Total fixed |
$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 407 | Department | ||
| Milling | Assembly | ||
| 6 | Machine hours | 90 | 4 |
| 7 | Direct Labour Hours | 5 | 20 |
| 8 | Direct Materials | $800.00 | $370.00 |
| 9 | Direct Labour cost | $70.00 | $280.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,90,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 | 80000 |
| 13 | Total Variable manufacturing overhead (11 x 12) | $1,20,000.00 | $3,00,000.00 |
| 14 | Total manufacturing overhead (10 + 13) | $5,10,000.00 | $8,00,000.00 |
| Step 2: Calculate the pre-determined overhead rate in each department | |||
| Milling | Assembly | ||
| 15 | Total manufacturing overhead (14) | $5,10,000.00 | $8,00,000.00 |
| 16 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
| 17 | Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16) | $8.50 | $10.00 |
| Step 3: Calculate the amount of overhead applied to both departments to Job 407 | |||
| Milling | Assembly | ||
| 18 | Pre-determined overhead rate per machine hour or direct labour hour (17) | $8.50 | $10.00 |
| 19 | Machine hours or direct labour hours for the job (given) | 90 | 20 |
| 20 | Manufacturing overhead applied (18 x 19) | $765.00 | $200.00 |
| Step 4: Calculate the total job cost for Job 407 | |||
| Milling | Assembly | ||
| 21 | Direct Materials (given) | $800.00 | $370.00 |
| 22 | Direct Labour cost (given) | $70.00 | $280.00 |
| 23 | Manufacturing overhead applied (20) | $765.00 | $200.00 |
| 24 | Total cost of Job 407 (21 + 22 + 23) | $1,635.00 | $850.00 |
| Total cost of Job 407 (Milling + Assembly) | $2,485.00 | ||
| Step 5: Calculate the selling price for Job 407 | |||
| Milling | Assembly | ||
| 25 | Total cost of Job 407 ( 24) | $1,635.00 | $850.00 |
| 26 | Mark-up (24 x 75%) | $1,226.25 | $637.50 |
| 27 | Selling price of Job 407 (25 + 26) | $2,861.25 | $1,487.50 |
| Total Selling Price (Milling + Assembly) | $4,348.75 | ||
Part 2 - The selling price of Job 408 by replacing the current data with data given
| Chapter 2: Applying Excel | |||
| Data | |||
| Mark-up on job cost | 75% | ||
| Department | |||
| Milling | Assembly | ||
| 1 | Machine hours | 60000 | 3000 |
| 2 | Direct Labour Hours | 8000 | 80000 |
| 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 | 80000 |
| 13 | Total Variable manufacturing overhead (11 x 12) | $1,20,000.00 | $3,00,000.00 |
| 14 | Total manufacturing overhead (10 + 13) | $4,20,000.00 | $8,00,000.00 |
| Step 2: Calculate the pre-determined overhead rate in each department | |||
| Milling | Assembly | ||
| 15 | Total manufacturing overhead (14) | $4,20,000.00 | $8,00,000.00 |
| 16 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
| 17 | Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16) | $7.00 | $10.00 |
| 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 | $10.00 |
| 19 | Machine hours or direct labour hours for the job (given) | 40 | 6 |
| 20 | Manufacturing overhead applied (18 x 19) | $280.00 | $60.00 |
| 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 | $60.00 |
| 24 | Total cost of Job 407 (21 + 22 + 23) | $1,030.00 | $570.00 |
| Total cost of Job 407 (Milling + Assembly) | $1,600.00 | ||
| Step 5: Calculate the selling price for Job 408 | |||
| Milling | Assembly | ||
| 25 | Total cost of Job 407 ( 24) | $1,030.00 | $570.00 |
| 26 | Mark-up (24 x 75%) | $772.50 | $427.50 |
| 27 | Selling price of Job 407 (25 + 26 ) | $1,802.50 | $997.50 |
| 28 | Total Selling Price of Job 408 (Milling + Assembly) | $2,800.00 | |
Conclusion
Thus, the selling price of Job 408 after replacing the current data with the given data is $2800.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Buffalo Inc. issued $4,200,000 of convertible 5-year bonds on July 1, 2025. The bonds provide for 6% interest payable semiannually on January 1 and July 1. The discount in connection with the issue was $102,000, which is being amortized monthly on a straight-line basis.
The bonds are convertible after one year into 15 shares of Buffalo Inc's $1 par value common stock for each $1,000 of bonds.
On October 1, 2026, $504,000 of bonds were turned in for conversion into common stock. Interest has been accrued monthly and paid as due. At the time of conversion, any accrued interest on bonds being converted is paid in cash.
Prepare the journal entries to record the conversion, amortization, and interest in connection with the bonds as of the following dates.
Buffalo Inc. issued $4,200,000 of convertible 5-year bonds on July 1, 2025. The bonds provide for 6% interest payable semiannually on January 1 and July 1. The discount in connection with the issue was $102,000, which is being amortized monthly on a straight-line basis.
The bonds are convertible after one year into 15 shares of Buffalo Inc's $1 par value common stock for each $1,000 of bonds.
On October 1, 2026, $504,000 of bonds were turned in for conversion into common stock. Interest has been accrued monthly and paid as due. At the time of conversion, any accrued interest on bonds being converted is paid in cash.
Prepare the journal entries to record the conversion, amortization, and interest in connection with the bonds as of the following dates. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List all debit entries before credit entries.
https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Flectures.mhhe.com%2Fconnect%2Frichardson_iba_1e_1265454345%2Fdata_files%2Fch2%2FIBA_Lab2-4_Alt_Data.xlsx&wdOrigin=BROWSELINK
make a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year.
make a slicer to interactively filter the pivot chart by state from which the products were ordered.
Adjust the pivot chart to show horizontal bar
Chapter 3 Solutions
Managerial Accounting
Ch. 3.A - Prob. 1ECh. 3.A - Prob. 2ECh. 3.A - Prob. 3ECh. 3.A - PROBLEM 3A-4 Activity-Based Absorption Costing as...Ch. 3.A - Prob. 5PCh. 3.A - CASE 3A-6 Activity-Based Absorption Costing and...Ch. 3.B - Prob. 1ECh. 3.B - Prob. 2ECh. 3.B - Prob. 3PCh. 3.B - Prob. 4C
Ch. 3 - Prob. 1QCh. 3 - Prob. 2QCh. 3 - Prob. 3QCh. 3 - Prob. 4QCh. 3 - Prob. 5QCh. 3 - Prob. 6QCh. 3 - Prob. 7QCh. 3 - Prob. 8QCh. 3 - 3-9 What is underapplied overhead? Overapplied...Ch. 3 - Prob. 10QCh. 3 - Prob. 11QCh. 3 - Prob. 12QCh. 3 - Prob. 13QCh. 3 - This Excel worksheet relates to the Dickson...Ch. 3 - This Excel worksheet relates to the Dickson...Ch. 3 - Prob. 3AECh. 3 - This Excel worksheet relates to the Dickson...Ch. 3 - Prob. 1F15Ch. 3 - Prob. 2F15Ch. 3 - Prob. 3F15Ch. 3 - Prob. 4F15Ch. 3 - Prob. 5F15Ch. 3 - Prob. 6F15Ch. 3 - Prob. 7F15Ch. 3 - Prob. 8F15Ch. 3 - Prob. 9F15Ch. 3 - Prob. 10F15Ch. 3 - Prob. 11F15Ch. 3 - Prob. 12F15Ch. 3 - Prob. 13F15Ch. 3 - Prob. 14F15Ch. 3 - Prob. 15F15Ch. 3 - Prob. 1ECh. 3 - Prob. 2ECh. 3 - Prob. 3ECh. 3 - EXERCISE 24 Computing Total Job Costs and Unit...Ch. 3 - EXERCISE 2-5 Computing Total Job Costs and Unit...Ch. 3 - Prob. 6ECh. 3 - EXERCISE 2-7 Job-Order Costing; Working Backwards...Ch. 3 - Prob. 8ECh. 3 - EXERCISE 3-9 Journal Entries and T-accounts...Ch. 3 - Prob. 10ECh. 3 - Prob. 11ECh. 3 - Prob. 12ECh. 3 - Prob. 13ECh. 3 - Prob. 14ECh. 3 - Prob. 15ECh. 3 - Prob. 16ECh. 3 - Prob. 17ECh. 3 - Prob. 18ECh. 3 - Prob. 19ECh. 3 - EXERCISE 2—13 Departmental Predetermined Overhead...Ch. 3 - EXERCISE 214 Job-Orders Costing for a Service...Ch. 3 - Prob. 22PCh. 3 - PROBLEM 2—16 Plantwide Predetermined Overhead...Ch. 3 - Prob. 24PCh. 3 - Prob. 25PCh. 3 - Prob. 26PCh. 3 - Prob. 27PCh. 3 - PROBLEM 2-21 Plant wide Versus Multiple...Ch. 3 - CASE 2-22 Plantwide versus Departmental Overhead...Ch. 3 - Prob. 30C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Give true answer the financial accounting questionarrow_forwardNeed help with this financial accounting questionarrow_forwardGary Watson, a graduating business student at a small college, is currently interviewing for a job. Gary was invited by both Tilly Manufacturing Company and Watson Supply Company to travel to a nearby city for an interview. Both companies have offered to pay Gary's expenses. His total expenses for the trip were $96 for mileage on his car and $45 for meals. As he prepares the letters requesting reimbursement, he is considering asking for the total amount of the expenses from both employers. His rationale is that if he had taken separate trips, each employer would have had to pay that amount. Who are the parties that are directly affected by this ethical dilemma? multiple choice 1 Tilly Manufacturing Company Watson Supply Company Both the employers Are the other students at the college potentially affected by Gary's decision? multiple choice 2 Yes No Are the professors at the college potentially affected by Gary's decision? multiple choice 3 Yes No…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License