Stanford Enterprises uses job-order costing. Overhead is applied on the basis of direct labor hours. The following information relates to the year just ended. Data: Estimated total overhead costs Estimated total direct labor hours Actual total direct labor hours Actual costs for the year: Purchase of raw (direct) materials Direct labor cost Manufacturing overhead Inventories: Raw Materials (All Direct) Work in Process Finished Goods. $ 2,75,000 25,000 27,760 $ 3,75,000 $ 5,36,300 $ 3,02,750 Ending Beginning $ 15,000 $ 11,375 27,875 34.600 22,350 26.450

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter1: Introduction To Cost Accounting
Section: Chapter Questions
Problem 12E: Gerken Fabrication Inc. uses the job order cost system of accounting. The following information was...
icon
Related questions
Topic Video
Question
Integrated Excel: Calculating Cost of Goods Manufactured and Cost of Goods Sold
Stanford Enterprises uses job-order costing.
Overhead is applied on the basis of direct labor hours.
The following information relates to the year just ended.
Data:
Estimated total overhead costs
Estimated total direct labor hours
Actual total direct labor hours
Actual costs for the year:
Purchase of raw (direct) materials
Direct labor cost
Manufacturing overhead
Inventories:
Raw Materials (All Direct)
Work in Process
Finished Goods
Use the data to answer the following.
$ 2,75,000
25,000
27,760
$ 3,75,000
$ 5,36,300
$ 3,02,750
Beginning
Ending
$ 15,000 $ 11,375
22,350
26,450
27,875
34,600
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.
Navigation:
1. Use the Open Excel in New Tab button to launch this question.
2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Transcribed Image Text:Integrated Excel: Calculating Cost of Goods Manufactured and Cost of Goods Sold Stanford Enterprises uses job-order costing. Overhead is applied on the basis of direct labor hours. The following information relates to the year just ended. Data: Estimated total overhead costs Estimated total direct labor hours Actual total direct labor hours Actual costs for the year: Purchase of raw (direct) materials Direct labor cost Manufacturing overhead Inventories: Raw Materials (All Direct) Work in Process Finished Goods Use the data to answer the following. $ 2,75,000 25,000 27,760 $ 3,75,000 $ 5,36,300 $ 3,02,750 Beginning Ending $ 15,000 $ 11,375 22,350 26,450 27,875 34,600 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. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Knowledge Booster
Performance measurements
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning