Question

1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an in
Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE INSERT НOМE PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calb
Cost of Goods Manufactured and Cost of Goods Sold - Excel Sign In DATA REVIEW VIEW НOME FORMULAS INSERT PAGE LAYOUT FILE Calb

Next to each answer, may you please include the equation that was used to find the solution.
0 0
Add a comment Improve this question Transcribed image text
Answer #1
1.
Predetermined overhead Estimated manufacturing costs/Estimated direct labor hours
Predetermined overhead 275000/25000
Predetermined overhead $11.00 per hour
Actual manufacturing overhead rate $302,750
Predetermined overhead rate 11
Actual direct labor hours 27760 $305,360
Underapplied (overapplied) -$2,610 (302750-305360)
Schedule of cost of goods manufactured
Direct materials
Beginning raw material inventory $15,000
Add: Purchases of raw material $375,000
Total raw material available (15,000+375,000) $390,000
Less: Raw material inventory, ending $11,375
Raw material used in production $378,625 (390000-11375)
Direct labor $536,300
Manufacturing overhead applied to work in process $305,360
Total manufacturing costs $1,220,285 (378625+536300+305360)
Add: Beginning work in process inventory $27,875
Total cost of work in process inventory $1,248,160 (1220285+27875)
Less: Ending work in process inventory $22,350
Cost of goods manufactured $1,225,810 (1248160-22350)
Schedule of cost of goods sold
Finished goods inventory, Beginning $34,600
Add: Cost of goods manufactured $1,225,810
Cost of goods available for sale $1,260,410 (34600+1225810)
Less: Finished goods inventory, ending $26,450
Unadjusted cost of goods sold $1,233,960 (1260410-26450)
Underapplied (overapplied) overhead -$2,610
Adjusted cost of goods sold $1,231,350 (1233960-2610)
Add a comment
Know the answer?
Add Answer to:
Next to each answer, may you please include the equation that was used to find the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Compute a predetermined overhead rate. Prepare schedules of cost of goods manufactured and cost of goods...

    Compute a predetermined overhead rate. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. 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 income statement. 3. Compute underapplied or overapplied...

  • 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...

  • 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...

  • DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANS...

    DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO...

  • please WRITE THE FORMULA NEXT TO the answers, dont answer my question without the formula (...

    please WRITE THE FORMULA NEXT TO the answers, dont answer my question without the formula ( I did some of this so just do the ones i didnt do in yellow) PLEASE please write the formulas. thanks 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, Cost of Goods Manufactured and Cost of Goods Sold - Excel TAYOUT...

  • 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. 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)...

  • 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...

  • 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...

  • 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...

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