Question
  1. Compute a predetermined overhead rate.
  2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement.
  3. Compute underapplied or overapplied overhead cost and prepare the journal entry to close the balance in Manufacturing Overhead to the appropriate accounts.

Says 'all answers must be entered as a formula'

1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an inCost of Goods Manufactured and Cost of Goods Sold - Excel Sign In A FILE PAGE LAYOUT НOME INSERT FORMULAS DATA REVIEW VIEW CaCost of Goods Manufactured and Cost of Goods Sold - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cali49 Stanford Enterprises Schedule of Cost of Goods Sold 50 51 52 Finished goods inventory, beginning 53 Add: Cost of goods man

1 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Ans.

1. Predetermined Overhead rate = Estimated Manufacturing Overhead / Estimated Direct Labor Hours = $275,000 / 25000 = $11 per direct labor hour

Computation of applied overhead and determination of underapplied or overapplied overhead

Actual Manufacturing Overhead Cost (a) $ 302,750.00
Predetermined Overhead Rate (b) $          11.00
Actual Direct Labor Hours ©      27,760.00
Manufacturing Overhead applied (d = b * c) $ 305,360.00
Underapplied (Overapplied) manufacturing Overhead (e = a-d) $    (2,610.00)

2. Prepare schedules of cost of goods manufactured

Stanford Enterprises
Schedule of Cost of Goods Manufactured
Direct materials
Beginning raw materials inventory (a) $    15,000.00
Add: Purchases of raw materials (b) $ 375,000.00
Total raw materials available (c= a+b) $ 390,000.00
Deduct: Ending raw materials inventory( d) $    11,375.00
Raw materials used in production (e = c-d) $      378,625.00
Direct labor (f) $      536,300.00
Manufacturing overhead applied to work in process (g) $      305,360.00
Total manufacturing costs (h = e + f + g) $ 1,220,285.00
Add: Beginning work in process inventory (i) $        27,875.00
Total Cost of work in proces (j= h+i) $ 1,248,160.00
Deduct: Ending work in process inventory (k) $        22,350.00
Cost of goods manufactured (l = j-k) $ 1,225,810.00

2. Prepare schedules of cost of goods sold

Stanford Enterprises
Schedule of Cost of Goods Sold
Finished goods inventory,Beginning (a) $        34,600.00
Add: Cost of goods manufactured (b) $ 1,225,810.00
Cost of goods available for sale (c= a+b) $ 1,260,410.00
Deduct: Finished goods inventory,Ending ( d) $        26,450.00
Unadjusted cost of goods sold (e= c-d) $ 1,233,960.00
Underapplied (Overapplied) overhead (f) $        (2,610.00)
Adjusted cost of goods sold (g = e+f) $ 1,231,350.00

2. Income Statement

Stanford Enterprises
Income Statement
Sales (a) NA
Less: Cost of goods sold (b) $ 1,231,350.00
Gross margin (c = a-b) NA
Less: Selling and administrative expenses Selling expenses (d) NA
Net Operating Income (e = c -d) NA

As the information is not available in question i write NA.

3.

Computation of applied overhead and determination of underapplied or overapplied overhead

Actual Manufacturing Overhead Cost (a) $ 302,750.00
Predetermined Overhead Rate (b) $          11.00
Actual Direct Labor Hours (c)      27,760.00
Manufacturing Overhead applied (d = b * c) $ 305,360.00
Underapplied (Overapplied) manufacturing Overhead (e = a-d) $    (2,610.00)

Prepare the journal entry to close the balance in Manufacturing Overhead to the appropriate accounts

Date Particulars Debit Credit
Manufacturing Overhead $          2,610.00
Cost of Goods Sold $          2,610.00
Add a comment
Know the answer?
Add Answer to:
Compute a predetermined overhead rate. Prepare schedules of cost of goods manufactured and cost of goods...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods...

    1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 5 ? X . HOME - Sign In FILE INSERT Cost of Goods Manufactured and Cost of Goods Sold - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW AA = % D D A. Alignment Number Conditional Format as Cell - Formatting Table Styles - Calibri B I - Paste...

  • 1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods...

    1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 1 DB5 Cost of Goods Manufactured and Cost of Goods Sold - Excel Ch2 Excel Simulations F22 H F E D 1 1 А B с 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to...

  • G B с D E 1 Stanford Enterprises uses job-order costing. 2 The allocation base for...

    G B с D E 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275.000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375.000 11 Direct labor cost $536,300 12 Manufacturing overhead costs $302.750 13 14 Inventories: Beginning...

  • Next to each answer, may you please include the equation that was used to find the...

    Next to each answer, may you please include the equation that was used to find the solution. 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. 3. Compute underapplied or overapplied overhead cost and prepare the journal entry to dlose the balance in Manufacturing Overhead to the appropriate accounts. Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE REVIEW HOME INSERT PAGE LAYOUT...

  • Please give answers in the yellow boxes as an excel function and using cell references when...

    Please give answers in the yellow boxes as an excel function and using cell references when needed. B F G H D i Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27,760 9 Actual costs for the year: 10 Purchase of raw materials (all direct)...

  • ANSWERS MUST BE FOUND BY USING FORMULAS !!!! с E G H A B D F...

    ANSWERS MUST BE FOUND BY USING FORMULAS !!!! с E G H A B D F 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275,000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375,000 11 Direct labor...

  • a. Prepare a schedule of cost of goods manufactured. b. Was the overhead underapplied or overapplied?...

    a. Prepare a schedule of cost of goods manufactured. b. Was the overhead underapplied or overapplied? By how much? c. Prepare an income statement for the year. The company closes any underapplied or overapplied overhead to Cost of Goods Sold. Baab Corporation is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year: Raw materials Work in process Finished Goods Beginning Ending Balance Balance $ 14,150 $22,150 $...

  • Each answer must made in the form of a formula where the yellow boxes lie, thankyou!...

    Each answer must made in the form of a formula where the yellow boxes lie, thankyou! 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27,760 8 $375,000 $536,300 $302,750 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11...

  • Please give answers in the yellow boxes as an excel function and using cell references when...

    Please give answers in the yellow boxes as an excel function and using cell references when needed. Н 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27,760 9 Actual costs for the year: $375,000 Purchase of raw materials (all direct) 10 $536,300 $302,750...

  • Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller...

    Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below. If in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT