Concept explainers
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.
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 |
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?
Chapter 3 Solutions
ACC 202 Principles of Accounting 2 Ball State University
- What is the present value of these financial accounting question?arrow_forwardProvide correct answer the financial accounting questionarrow_forwardIncome statements for Vernon Company for Year 3 and Year 4 follow: VERNON COMPANY Income Statements Year 4 Year 3 Sales $201,100 $181,100 Cost of goods sold 143,000 121,000 Selling expenses 21,200 19,200 Administrative expenses 12,100 14,100 Interest expense 3,500 5,500 Total expenses 179,800 159,800 Income before taxes 21,300 21,300 Income taxes expense Net income 6,300 3,300 $ 15,000 $ 18,000 Required a. Perform a horizontal analysis, showing the percentage change in each Income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each Income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Note: Percentages may not add exactly due to rounding. Round your answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4). Sales VERNON COMPANY…arrow_forward
- 41 A company issues a $1,000 par value bond at 100. The bonds have one warrant attached to buy one share of common stock for $30 within the next five years. At the time, the stock is trading at $60, and the warrant can be traded separately from the bond. The bond alone trades at 99 without the warrant. Once issued, the market price for the warrant is $31. How much of the bond sale proceeds is allocated to the warrant if the proportional method is used? $29.13 $30.07 $29.41 $30.36arrow_forward35 A company had 100,000 shares of stock outstanding and repurchased 20,000 of those shares as treasury stock. What is a valid reason for this action? To increase dividends to improve market perception To increase shares available for stock compensation To increase shareholders' equity To increase assets to avoid a takeoverarrow_forward14 A company reported total assets of $300,000 as of December 31, 2018, and $500,000 as of December 31, 2019. Net sales revenue was $200,000 for the year ending December 31, 2019. Net income was $20,000 for the year ending December 31, 2019. What was the company's return on assets for the year ending December 31, 2019? 0000 4% 5% ○ 10% 50%arrow_forward
- 29 A company's income statement reveals the following amounts related to the company's operations for the most recent year: .Net sales revenue: $5,000,000 • Interest expense: $60,000 Income tax expense: $80,000 ⚫ Net income: $400,000 What was the company's times-interest-earned ratio for the year? 4.33 6.75 7.67 9.00arrow_forward20 A bank will only continue a credit line for one of its small business customers if the small business can keep an acid-test greater than 1. The company's reported current accounts are as follows: ⚫ Cash: $6,000 • Accounts receivable (net): $19,000 • Inventory: $8,000 • Short-term investment: $4,500 ⚫ Current liabilities: $17,000 Which decision should the bank make? Close the credit line because the acid-test ratio is 0.45. Close the credit line because the acid-test ratio is 0.58. Maintain the credit line because the acid-test ratio is 2.21. Maintain the credit line because the acid-test ratio is 1.74.arrow_forward00 16.67% 25.00% 400.00% 600.00% 13 A company reported net sales revenue of $6,000,000 for the year ending December 31, 2018, and $8,000,000 for the year ending December 31, 2019. Net income was $1,000,000 for the year ending December 31, 2018, and $2,000,000 for the year ending December 31, 2019. What was the company's profit margin on sales for the year ending December 31, 2019?arrow_forward
- 25 A municipality issues bonds to fund a new school capital improvement project. The municipality wants to manage its cash flow and therefore needs the bonds to mature over a period of many years. Which type of bonds should be issued? Coupon Term Serial Unsecured 0000arrow_forward12 A company reported the following financial information: As of December 31, 2018 total assets of $10,000,000 net sales revenue of $6,000,000 .Net income of $1,000,000 As of December 31, 2019 total assets of $14,000,000 net sales revenue of $8,000,000 .net income of $2,000,000 What was the company's return on assets for the year ending December 31, 2019? O 8.33% O 14.29% O 16.67% O 66.67%arrow_forward46 Which two circumstances lead to an impairment? Choose 2 answers. A significant change in legal factors that decreases an asset's value A future net cash flow that is significantly greater than anticipated The presence of significantly fewer competitors than anticipated A significant excess of cost expectations for constructing an asset A significant increase in the expected market value of an asset A significant reduction in the expected cost of acquiring an assetarrow_forward
- 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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education