MANAGERIAL ACCOUTING LL WITH ACCESS
16th Edition
ISBN: 9781307670585
Author: Garrison
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 2, 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
need help this questions
general accounting
Determine the following requirements of this financial accounting question
Chapter 2 Solutions
MANAGERIAL ACCOUTING LL WITH ACCESS
Ch. 2.A - EXERCISE 2A-1 Activity-Based Absorption Costing...Ch. 2.A - EXERCISE 2A-2 Activity-Based Absorption Costing as...Ch. 2.A - EXERCISE 2A-3 Activity-Based Absorption Costing as...Ch. 2.A - PROBLEM 2A-4 Activity-Based Absorption Costing as...Ch. 2.A - Prob. 5PCh. 2.A -
CASE 2A-6 Activity-Based Absorption Costing and...Ch. 2.B - EXERCISE 2B-1 Overhead Rate Based on Capacity...Ch. 2.B - EXERCISE 2B-2 Overhead Rates and Capacity Issues...Ch. 2.B - Prob. 3PCh. 2.B - Prob. 4C
Ch. 2 - Prob. 1QCh. 2 - What is absorption costing?Ch. 2 - What is normal costing?Ch. 2 - How is the unit product cost of a job calculated?
Ch. 2 - Explain the four-step process used to compute a...Ch. 2 - What is the purpose of the job cost sheet in a...Ch. 2 - Explain why some production costs must be assigned...Ch. 2 - Why do companies use predetermined overhead rates...Ch. 2 - What factors should be considered in selecting an...Ch. 2 - If a company fully allocates all of its overhead...Ch. 2 - Would you expect the amount of applied overhead...Ch. 2 - Prob. 12QCh. 2 - What is a plantwide overhead rate? Whyare multiple...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - Prob. 3AECh. 2 - This Excel worksheet relates to the Dickson...Ch. 2 - Prob. 1F15Ch. 2 - Prob. 2F15Ch. 2 - Prob. 3F15Ch. 2 - Prob. 4F15Ch. 2 - Prob. 5F15Ch. 2 - Prob. 6F15Ch. 2 - Prob. 7F15Ch. 2 - Prob. 8F15Ch. 2 - Prob. 9F15Ch. 2 - Prob. 10F15Ch. 2 - Prob. 11F15Ch. 2 - Sweeten Company had no jobs in progress at the...Ch. 2 - Prob. 13F15Ch. 2 - Prob. 14F15Ch. 2 - Prob. 15F15Ch. 2 - EXERCISE 2-1 Compute a Predetermined Overhead Rate...Ch. 2 - Prob. 2ECh. 2 - EXERCISE 2–3 Computing Total Job Costs and Unit...Ch. 2 - EXERCISE 24 Computing Total Job Costs and Unit...Ch. 2 - EXERCISE 2-5 Computing Total Job Costs and Unit...Ch. 2 - Prob. 6ECh. 2 - EXERCISE 2-7 Job-Order Costing; Working Backwards...Ch. 2 - EXERCISE 2-8 Applying Overhead Cost; Computing...Ch. 2 - EXERCISE 2–9 Job-Order Costing and Decision Making...Ch. 2 - Prob. 10ECh. 2 - Prob. 11ECh. 2 - Prob. 12ECh. 2 - EXERCISE 2—13 Departmental Predetermined Overhead...Ch. 2 - EXERCISE 214 Job-Orders Costing for a Service...Ch. 2 - Prob. 15ECh. 2 - PROBLEM 2—16 Plantwide Predetermined Overhead...Ch. 2 - PROBLEM 217 Plantwide and Departmental...Ch. 2 - Prob. 18PCh. 2 - Prob. 19PCh. 2 - Prob. 20PCh. 2 - PROBLEM 2-21 Plant wide Versus Multiple...Ch. 2 - CASE 2-22 Plantwide versus Departmental Overhead...
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
- Provide correct answer this financial accounting questionarrow_forwardChapter 15 Homework 13 Saved Help Save & Exit Submit Part 1 of 2 0.83 points eBook Ask Required information Use the following information to answer questions. (Algo) [The following information applies to the questions displayed below.] Information on Kwon Manufacturing's activities for its first month of operations follows: a. Purchased $100,800 of raw materials on credit. b. Materials requisitions show the following materials used for the month. Job 201 Job 202 Total direct materials Indirect materials Total materials used $ 49,000 24,400 73,400 9,420 $ 82,820 c. Time tickets show the following labor used for the month. Print References Job 201 $ 40,000 Job 202 13,400 Total direct labor 53,400 25,000 $ 78,400 Indirect labor Total labor used d. Applied overhead to Job 201 and to Job 202 using a predetermined overhead rate of 80% of direct materials cost. e. Transferred Job 201 to Finished Goods Inventory. f. Sold Job 201 for $166,160 on credit. g. Incurred the following actual other…arrow_forwardquesrion 2arrow_forward
- Anti-Pandemic Pharma Co. Ltd. reports the following information in its income statement: Sales = $5,250,000; Costs = $2, 173,000; Other expenses = $187,400; Depreciation expense = $79,000; Interest expense= $53,555; Taxes $76,000; Dividends $69,000. $136,700 worth of new shares were also issued during the year and long-term debt worth $65,300 was redeemed. a) Compute the cash flow from assets b) Compute the net change in working capital (325 marks)arrow_forwardQS 15-18 (Algo) Computing and recording over- or underapplied overhead LO P4 A company applies overhead at a rate of 170% of direct labor cost. Actual overhead cost for the current period is $1,081,900, and direct labor cost is $627,000. 1. Compute the under- or overapplied overhead. 2. Prepare the journal entry to close over- or underapplied overhead to Cost of Goods Sold. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the under- or overapplied overhead.arrow_forwardQuestion 6 During 2019, Bitsincoins Corporation had EBIT of $100,000, a change in net fixed assets of $400,000, an increase in net current assets of $100,000, an increase in spontaneous current liabilities of $400,000, a depreciation expense of $50,000, and a tax rate of 30%. Based on this information, what is Bitsincoin's free cash flow? (3 marks)arrow_forward
- Question 4 Waterfront Inc. wishes to borrow on a short-term basis without reducing its current ratio below 1.25. At present its current assets and current liabilities are $1,600 and $1,000 respectively. How much can Waterfront Inc. borrow? (5 marks)arrow_forwarddiscus extensivery source of bussines finances requaments not less than 4 pages font size 12 spacing 1.5 roman times references must be less thhan 5arrow_forwardCalculate stricklers cash conversion cycle?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