Question

In: Accounting

Activity rate = Estimated overhead costs/Expected activity Machine Setup: $20000/50 = $400 per setup Special Processing:...

Activity rate = Estimated overhead costs/Expected activity

Machine Setup: $20000/50 = $400 per setup

Special Processing: $200000/8000 = $25 per machine hour

General Factory: $250000/12500 = $20 per direct labor hour

2.

Product A Product B Product C
Direct labor costs 40000 190000 50000
Direct materials 100000 120000 60000
Overheads:
Machine setup 12000 4000 6000
Special processing 125000 70000 75000
General factory 50000 237500 40000
Total overheads 187000 311500 121000
Total costs 327000 621500 231000

3.

Actual manufacturing overhead 625500
Manufacturing overhead applied ($187000 + $311500 + $121000) 619500
Under-applied overhead $ 6000

At the end of the month Product A and Product B production runs were fully completed. Product C was not fully completed and remains in work in process. All other work in process at the beginning of the month was completed by the end of the month. ABC Corporation has provided the following additional information about its inventories and sales activities:

Purchased of raw materials(Both indirect and direct) $ 300,000.00
indirect materials included in manufacturing overhead $    40,000.00
direct labor ?
manufacturing overhead applied to work in process ?
over/under applied overhead ?
Inventory account Beginning balance Ending Balance
raw materials $ 200,000.00 ?
work in process $    40,000.00 ?
finished goods $ 500,000.00 $       600,000.00
Sales $ 2,000,000.00
selling price per unit $          5,000.00
variable selling expense per unit $              120.00
variable admin expense per unit $              230.00
total fixed selling expense $      240,000.00
total fixed admin expense $      320,000.00

Using the information provided above, please prepare a schedule of cost of goods manufactured, schedule of cost of goods sold, and contribution format income statement for ABC Corporation for the month ended March 31, 2020.

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Cost of goods manufactureed
Direct Material used:
Beginning inventory - Raw Material $       200,000
Add: Purchase of Raw Material $       300,000
Total Direct Material available $       500,000
Less: Ending Inventory - Raw material $     (180,000)
Total Material used $       320,000
Less: Indirect Material used $       (40,000)
Direct Material used $       280,000
Direct Labor $       280,000
Applied Overheads $       619,500
Manufacturing cost for the period $   1,179,500
Add: Beginning Inventory - Work in process $         40,000
$   1,219,500
Less: Ending inventory - Work in process Cost of Product C $     (231,000)
Cost of Goods manufactured $       988,500
Cost of Goods Sold
Beginning Finished Goods Inventory $       500,000
Add: Cost of goods manufactured $       988,500
Cost of goods available for sale $   1,488,500
Less: Ending finished goods inventory $     (600,000)
Unadjusted cost of goods sold $       888,500
Add: Underapplied overheads $            6,000
Adjusted Cost of goods sold $       894,500
Income Statement:
Sales $   2,000,000
Less: Cost of goods sold $     -894,500
Gross Margin $   1,105,500
Less: Selling and Admin Expense
Variable Selling Expense 400*$120 $        -48,000
Variable Admin Expense 400*$230 $        -92,000
Fixed Selling Expense $     -240,000
Fixed Admin Expense $     -320,000
Net Income $       405,500

Related Solutions

Estimated variable manufacturing overhead $25 per machine hour Estimated fixed manufacturing overhead $67,100 Estimated machine-hours 6,100...
Estimated variable manufacturing overhead $25 per machine hour Estimated fixed manufacturing overhead $67,100 Estimated machine-hours 6,100 Actual manufacturing overhead $231,500 Actual machine-hours 6,250 The estimates of the manufacturing overhead and of machine-hours were made at the beginning of the year for the purpose of computing the company's predetermined overhead rate for the year. The applied manufacturing overhead for the year is:
1. The predetermined manufacturing overhead rate is $18 per machine hour based on an estimated manufacturing...
1. The predetermined manufacturing overhead rate is $18 per machine hour based on an estimated manufacturing overhead of 180,000 and 10,000 machine hours. For the year the actual overhead was 200,000 and machine hours were 11,000. How much manufacturing overhead was applied during the year? a. 198,000 b. 200,000 c. none of the above 2. Overapplied manufacturing overhead that is not material is adjusted by which entry? a. debit manufacturing overhead and credit misc exp b. debit cash and credit...
III. Manufacturing Overhead Costs estimated $       500,000 Direct Labor Hours estimated             50,000 Machine Hours estimated...
III. Manufacturing Overhead Costs estimated $       500,000 Direct Labor Hours estimated             50,000 Machine Hours estimated           250,000 Direct Labor Costs estimated $    1,000,000 Determine the Pre-determined Overhead rate based on the following: a Direct Labor Hours b Machine Hours c Direct Labor Cost
Nova Company’s total overhead costs at various levels of activity follow: Month Machine-Hours Total Overhead Costs...
Nova Company’s total overhead costs at various levels of activity follow: Month Machine-Hours Total Overhead Costs April 78,000 $ 214,000 May 115,500 286,000 June 96,000 238,000 July 106,000 246,640 Assume that the total overhead costs consist of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 78,000 machine-hour level of activity is as follows: Utilities (V) $ 48,640 Supervisory salaries (F) 22,600 Maintenance (M) 142,760 Total overhead costs $ 214,000 V = variable; F = fixed; M...
If overhead is applied on the basis of machine hours, what will be the overhead rate per hour?
Simplex Company has the following estimated costs for next year: Simplex estimates that 10,000 direct labour and 16,000 machine hours will be worked during the year. If overhead is applied on the basis of machine hours, what will be the overhead rate per hour?
Direct Mateirals- $10,000 on this job Direct Labor- 400 hours at $10.00 Manufacturing Overhead- Estimated Rate-...
Direct Mateirals- $10,000 on this job Direct Labor- 400 hours at $10.00 Manufacturing Overhead- Estimated Rate- $15.00 per Direct Labor Hour Requirement 1: Students will create a Job Order Costing spreadsheet in Excel (with formulas) using the data presented in the video. Requirement 2: Using the Excel spreadsheet, complete a Job Order Costing spreadsheet for the following two customers: John Smith ordered five tree houses Jane Doe ordered three tree houses Requirement 3: Questions to be answered: 1. What is...
The predetermined overhead allocation rate for Lemke, Inc., is based on estimated direct labor costs of...
The predetermined overhead allocation rate for Lemke, Inc., is based on estimated direct labor costs of $250,000 and estimated factory overhead of $550,000. Actual costs incurred were: Direct materials…………………………….. $250,000 Direct labor………………………………….. 300,000 Indirect materials……………………………             155,000 Indirect labor……………………………….. 225,000 Sales commissions…………………………. 50,000 Factory depreciation………………………… 170,000 Property taxes, factory……………………...    115,000 Advertising………………………………..... 62,500 (a)    Calculate the predetermined overhead rate and calculate the overhead applied during the year. (b)   Determine the amount of over- or underapplied overhead and state whether it was under or...
BuBu Gump has a cost function for overhead costs of $60,000 per month plus $50 per...
BuBu Gump has a cost function for overhead costs of $60,000 per month plus $50 per client hour. In March its overhead allocation rate was calculated assuming 3,000 client hours. Actual overhead costs for July were $220,000, and client hours amounted to 2,800. A.  Determine the total cost for Job 526 if direct costs were $52,000 and 850 hours were worked for the client. B.  Provide examples of possible overhead costs for BuBu Gump that are (1) fixed and (2) variable. C.  Determine...
I need to calculate the variable costs, DLH, Fixed costs and the manufacturing overhead rate per...
I need to calculate the variable costs, DLH, Fixed costs and the manufacturing overhead rate per direct labor hour for each quarter and year-end. I've done some calculation but I believe I am missing something in the variable costs calculations with the indirect materials, indirect labor hours and maintenance. I have been multiplying the indirect costs by DLH, but some of my instructions indicate I am supposed to divide it. Not sure if I am misinterpreting or just missing a...
Happy Clicks Inc. uses a predetermined overhead allocation rate of $4.75 per machine hour. Actual overhead...
Happy Clicks Inc. uses a predetermined overhead allocation rate of $4.75 per machine hour. Actual overhead costs incurred during the year are as follows: Indirect materials $5,200 Indirect labor $3,750 Plant depreciation $4,800 Plant utilities and insurance $9,530 Other plant overhead costs $12,700 Total machine hours used during the year 7,520 hours What is the amount of manufacturing overhead cost allocated to Work-in-Process Inventory during the year? Is the manufacturing overhead account under or over allocated and if so by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT