Cost of Goods Manufactured; Cost of Goods Sold. Valleydale Company incurred the following costs during the month: direct labor, $120,000; factory overhead, $108,000; and direct materials purchases, $160,000. Inventories were costed as follows:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
NOTE: Please solve in excel and provide the formula in excel thank you!
E4-3 Cost of Goods Manufactured; Cost of Goods Sold. Valleydale Company incurred the
following costs during the month: direct labor, $120,000; factory overhead, $108,000; and
direct materials purchases, $160,000. Inventories were costed as follows:
Finished Goods.
Work in Process.
Direct Materials.
Required:
(1) Calculate the cost of goods manufactured
(2) Calculate the cost of goods sold.
(a) Account balances:
Finished Goods.
Work in Process
Direct Material.
Indirect Material.
E4-4 Manufacturing Costs; Cost of Goods Manufactured; Inventories. Cost data on the
activities of Columbia Manufacturing for May are as follows:
April 30
(b) Transactions in May:
Supplies purchased.
Cost of goods sold.
Raw materials purchased.
Indirect labor....
Factory heat, light, and power.
Factory rent.
Factory insurance
Sales commissions...
Beginning
$27,000
61,500
37,500
Administrative expenses....
Production supervisor's salary
$45,602
60,420
10,250
5,600
Ending
$26,000
57,500
43,500
$
Required:
(1) Calculate the factory overhead incurred in May.
(2) Determine the cost of goods manufactured in May.
(3) Determine the ending balance in finished goods at May 31.
May 31
?
52,800
12,700
5,180
$ 16,500
280,000
105,000
22,000
11,220
18,500
2,000
48,000
25,000
5,000
(c) 4,250 direct labor hours were worked in May. Laborers work a 40-hour week and are
paid $22 per hour for the regular shift and time-and-a-half for each hour of overtime.
Of the 4,250 hours, 250 hours were worked in overtime in May. The company treats
the overtime premium as a part of overhead.
Transcribed Image Text:E4-3 Cost of Goods Manufactured; Cost of Goods Sold. Valleydale Company incurred the following costs during the month: direct labor, $120,000; factory overhead, $108,000; and direct materials purchases, $160,000. Inventories were costed as follows: Finished Goods. Work in Process. Direct Materials. Required: (1) Calculate the cost of goods manufactured (2) Calculate the cost of goods sold. (a) Account balances: Finished Goods. Work in Process Direct Material. Indirect Material. E4-4 Manufacturing Costs; Cost of Goods Manufactured; Inventories. Cost data on the activities of Columbia Manufacturing for May are as follows: April 30 (b) Transactions in May: Supplies purchased. Cost of goods sold. Raw materials purchased. Indirect labor.... Factory heat, light, and power. Factory rent. Factory insurance Sales commissions... Beginning $27,000 61,500 37,500 Administrative expenses.... Production supervisor's salary $45,602 60,420 10,250 5,600 Ending $26,000 57,500 43,500 $ Required: (1) Calculate the factory overhead incurred in May. (2) Determine the cost of goods manufactured in May. (3) Determine the ending balance in finished goods at May 31. May 31 ? 52,800 12,700 5,180 $ 16,500 280,000 105,000 22,000 11,220 18,500 2,000 48,000 25,000 5,000 (c) 4,250 direct labor hours were worked in May. Laborers work a 40-hour week and are paid $22 per hour for the regular shift and time-and-a-half for each hour of overtime. Of the 4,250 hours, 250 hours were worked in overtime in May. The company treats the overtime premium as a part of overhead.
Expert Solution
steps

Step by step

Solved in 3 steps with 4 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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education