Question

In: Accounting

The following data pertain to the Vesuvius Tile Company for July. Work in process, July 1...

The following data pertain to the Vesuvius Tile Company for July.

Work in process, July 1 (in units) .......................................................................................................................20,000

Units started during July ...................................................................................................................................?

Total units to account for ..................................................................................................................................65,000

Units completed and transferred out during July ................................................................................................?

Work in process, July 31 (in units) .....................................................................................................................15,000

Total equivalent units: direct material .................................................................................................................65,000

Total equivalent units: conversion ......................................................................................................................?

Work in process, July 1: direct material .............................................................................................................$164,400

Work in process, July 1: conversion ...................................................................................................................?

Costs incurred during July: direct material .........................................................................................................?

Costs incurred during July: conversion ..............................................................................................................659,400

Work in process, July 1: total cost .....................................................................................................................244,200

Total costs incurred during July .........................................................................................................................1,031,250

Total costs to account for ..................................................................................................................................1,275,450

Cost per equivalent unit: direct material .............................................................................................................8.25

Cost per equivalent unit: conversion ..................................................................................................................?

Total cost per equivalent unit ............................................................................................................................21.45

Cost of goods completed and transfered out during July ......................................................................................?

Cost remaining in ending work-in-process inventory: direct material ...................................................................?

Cost remaining in ending work-in-process inventory: conversion .........................................................................79,200

Total cost of July 31 work in process .................................................................................................................202,950

Additional Information:

a. Direct material is added at the beginning of the production process, and conversion activity occurs uniformly throughout the process.

b. The company uses weighted-average process costing.

c. The July 1 work in process was 30 percent complete as to conversion.

d. The July 31 work in process was 40 percent complete as to conversion.

Problem 4–27 Missing Data; Production Report; Weighted-Average (LO 4, 5, 6)

Cost remaining in ending work-in-process inventory, direct material: $123,750

Total cost of July 31 work in process: $202,950

Chapter 4 Process Costing and Hybrid Product-Costing Systems 159

Required: Compute the missing amounts, and prepare the firm’s July production report

Solutions

Expert Solution

Solution:

Unit started in July = Total units to be accounted for - Units in beinning WIP = 65000 - 20000 = 45000

Units completed and transferred out = Total units to be accounte for - Units in ending WIP = 65000 - 15000 = 50000 units

Cost per equivalent unit of direct material = $8.25

Total equivalent unit of direct material = 65000

Total cost of direct material = 65000 * $8.25 = $536,250

Cost of direct material in beginning WIP = $164,400

Direct material cost incurred in july = $536,250 - $164,400 = $371,850

Total cost per equivalent unit = $21.45

Cost per equivalent unit for conversion = $21.45 - $8.25 = $13.20

Total cost to be accounted for = $1,275,450

Conversion cost to be accounted for = $1,275,450 - $536,250 = $739,200

Equivalent units of conversion = $739,200 / $13.20 = 56000 units

Conversion cost included in beginning WIP = $244,200 - $164,400 = $79,800

Computation of Equivalent unit of Production - Weighted Average
Particulars Physical Units Material Conversion
Unit completed & Transferred out 50000 50000 50000
Closing WIP: 15000
Material (100%) 15000
Conversion (40%) 6000
Equivalent units of production 65000 65000 56000
Computation of Cost per equivalent unit of Production - Weighted Average
Particulars Material Conversion
Opening WIP $164,400.00 $79,800.00
Cost Added during July $371,850.00 $659,400.00
Total cost to be accounted for $536,250.00 $739,200.00
Equivalent units of production 65000 56000
Cost per Equivalent unit $8.25 $13.20
Computation of Cost of ending WIP and units completed & transferred out - Weighted Average
Particulars Material Conversion Total
Equivalent unit of Ending WIP 15000 6000
Cost per equivalent unit $8.25 $13.20
Cost of Ending WIP (Equivalent unit * Cost per equivalent unit) $123,750 $79,200 $202,950
Units completed and transferred 50000 50000
Cost of units completed & Transferred (Unit completed * cost per equivalent unit) $412,500 $660,000 $1,072,500
Cost reconciliation - Weighted Average
Particulars Amount
Costs to be accounted for:
Cost of beginning WIP inventory $244,200.00
Cost added to production $1,031,250.00
Total Cost to be accounted for $1,275,450.00
Costs accounted for as follows:
Cost of unit transferred out $1,072,500
Ending WIP:
Material $123,750
Converison $79,200
Total cost accounted for $1,275,450

Related Solutions

The following data pertain to the Vesuvius Tile Company for July.Work in process, July 1 (in...
The following data pertain to the Vesuvius Tile Company for July.Work in process, July 1 (in units) .......................................................................................................................20,000Units started during July ...................................................................................................................................?Total units to account for ..................................................................................................................................65,000Units completed and transferred out during July ................................................................................................?Work in process, July 31 (in units) .....................................................................................................................15,000Total equivalent units: direct material .................................................................................................................65,000Total equivalent units: conversion ......................................................................................................................?Work in process, July 1: direct material .............................................................................................................$164,400Work in process, July 1: conversion ...................................................................................................................?Costs incurred during July: direct material .........................................................................................................?Costs incurred during July: conversion ..............................................................................................................659,400Work in process, July 1: total cost...
1. The following data pertain to April operations for Schnitzels Company:                   Unit sold           &nbsp
1. The following data pertain to April operations for Schnitzels Company:                   Unit sold                                                90.000          Unit produced                                        100.000          Sales price per unit                                $ 12                                    Fixed                            Variable Materials                     -                               $2    per unit produced Direct Labor                -                                 1.5 per unit produced Factory Overhead $200.000                      $0.5 per unit produced Marketing and Administrative       0.2 per unit sold $140.000        Required:        Prepare an operating income statement for 20A using direct costing    
The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit...
The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit sold……………………………9,000          Unit Produced………………………8,000          Sales price per unit…………………$30          Direct Manufacturing cost per unit…$10          Fixed factory overhead-total……….$40,000          Fixed factory overhead-per unit……$5          Commercial expenses (all fixed)…..$50,000          Required: Prepare an income statement using absorption costing Prepare an income statement using direct costing Provide computation explaining the difference in        operating income between the two methods.
1. The following cost data for the year just ended pertain to Devere company, a greeting...
1. The following cost data for the year just ended pertain to Devere company, a greeting card manager: USD Direct Material 2,100,000 Advertising expense 98,000 Depreciation on factory building 115,000 Direct Labour: wages 505,000 cost of finished goods inventory at year-end 115,000 indirect labour: wages 140,000 production supervisor's salary 47,000 service department cost 100,000 Direct Labour: Fringe benefits 87,000 Indirect labour: fringe benefits 31,000 Benefits for a production supervisor 10,000 total overtime premiums paid 55,000 Cost of idle time: production...
Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1...
Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1 Revenue $39,474 $35,137 Net income 5,658 5,642 Accounts receivable 4,389 3,725 Inventory 2,290 1,926 Total current assets 10,151 9,130 Total assets 34,628 29,930 Total current liabilities 7,753 6,860 Total long-term liabilities 9,641 7,702 Total stockholder equity 20,000 18,000 Common-Size Income Statements - Company A reported the following income statements: COMPANY A INCOME STATEMENT FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1 (in...
Sanchez & Company produces paints. On July 1, it had no work-in-process inventory. It starts production...
Sanchez & Company produces paints. On July 1, it had no work-in-process inventory. It starts production of 105,000 gallons of paint in July and completes 82,000 gallons. The costs of the resources used by Sanchez in July consist of the following:    Materials $ 286,444 Conversion costs (labor and overhead) 286,100 Required: The production supervisor estimates that the ending work-in-process is 88 percent complete. Compute the cost of paint transferred to finished goods and the amount in work-in-process ending inventory...
Sanchez & Company produces paints. On July 1, it had no work-in-process inventory. It starts production...
Sanchez & Company produces paints. On July 1, it had no work-in-process inventory. It starts production of 107,000 gallons of paint in July and completes 87,000 gallons. The costs of the resources used by Sanchez in July consist of the following: Materials $296,100 Conversion costs (labor and overhead) $274,800 Required: The production supervisor estimates that the ending work-in-process is 84 percent complete. Compute the cost of paint transferred to finished goods and the snount in work-in-process ending inventory as of...
Test Company reported the following inventory balances. Raw materials inventory, July 31 $3,000 Work-in-process inventory, July...
Test Company reported the following inventory balances. Raw materials inventory, July 31 $3,000 Work-in-process inventory, July 1 $8,000 Work-in-process inventory, July 31 $6,000 Finished goods inventory, July 1 $4,000 In addition, the company reported the following information for the month of July. Materials purchases $14,000 Direct labor $15,000 Administrative costs $13,000 Direct materials used $16,000 Selling costs $14,000 Cost of goods manufactured $45,000 Cost of goods sold $46,000 Sales $80,000 Determine the raw materials inventory for July 1 (the beginning...
The ledger of American Company has the following work in process account. Work in Process—Painting 5/1...
The ledger of American Company has the following work in process account. Work in Process—Painting 5/1 Balance 3,690 5/31 Transferred out ? 5/31 Materials 6,840 5/31 Labor 4,230 5/31 Overhead 1,280 5/31 Balance ? Production records show that there were 480 units in the beginning inventory, 30% complete, 1,760 units started, and 1,410 units transferred out. The beginning work in process had materials cost of $2,840 and conversion costs of $850. The units in ending inventory were 40% complete. Materials...
The ledger of American Company has the following work in process account. Work in Process—Painting 5/1...
The ledger of American Company has the following work in process account. Work in Process—Painting 5/1 Balance 3,590 5/31 Transferred out ? 5/31 Materials 5,160 5/31 Labor 2,530 5/31 Overhead 1,380 5/31 Balance ? Production records show that there were 400 units in the beginning inventory, 30% complete, 1,600 units started, and 1,700 units transferred out. The beginning work in process had materials cost of $2,040 and conversion costs of $1,550. The units in ending inventory were 40% complete. Materials...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT