Moravia Company processes and packages cream cheese. The following data have been compiled for the month of April. Conversion activity occurs uniformly throughout the production process.
Work in process, April 1—13,000 units: | |||
Direct material: 100% complete, cost of | $ | 20,000 | |
Conversion: 25% complete, cost of | 3,500 | ||
Balance in work in process, April 1 | $ | 23,500 | |
Units started during April | 112,000 | ||
Units completed during April and transferred out to finished-goods inventory | 85,000 | ||
Work in process, April 30: | |||
Direct material: 100% complete | |||
Conversion: 35% complete | |||
Costs incurred during April: | |||
Direct material | $ | 230,000 | |
Conversion costs: | |||
Direct labor | $ | 46,200 | |
Applied manufacturing overhead | 84,940 | ||
Total conversion costs | $ | 131,140 | |
Prepare schedules to accomplish each of the following
process-costing steps for the month of April. Use the
weighted-average method of process costing.
Required:
1. Analysis of physical flow of units.
2. Calculation of equivalent units.
3. Computation of unit costs. (Round "Cost per Equivalent Unit" to 2 decimal places.)
Units in Ending WIP = Units in Beginning WIP +Units started -
Units completed and transferred
= 13000 + 112000 - 85000 = 40000 units
1.
Physical Flow Schedule | ||
Units to account for | ||
Beginning WIP | 13000 | |
Units started | 112000 | |
Total Units to account for | 125000 | |
Units accounted for | ||
Units completed and transferred out | ||
Beginning WIP | 13000 | |
Units started | 72000 | 85000 |
Ending WIP | 40000 | |
Total Units accounted for | 125000 |
2. Equivalent units of Production = Units completed and
transferred + Ending WIP x Completion
Material = 85000 + 40000 x 100% = 125000 units
Conversion = 85000 + 40000 x 35% = 99000 units
3. Cost per equivalent unit = (Beginning Cost + Cost added) /
Equivalent units
Material = ($20000 + $230000) / 125000 = $2 per unit
Conversion = ($23500 + $131140) / 99000 = $1.56 per unit
Total Cost per unit = $3.56 per unit
Moravia Company processes and packages cream cheese. The following data have been compiled for the month...
I need help (with #5, Build spreadsheet) the excel portion of my
homework, Moravia Company, Problem 4-29 from the Managerial
Accounting 11th ed. My homework is due tonight but would like to
see the excel by this afternoon at 5pm is possible.
Thank you
Moravia Company processes and packages cream cheese. The following data have been compiled for the month of April. Conversion activity occurs uniformly throughout the production process. $ 22.000 4500 $26.500 100.000 80.000 Work in process. Apr...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—50,000 units: Direct material: 100% complete, cost of $ 107,500 Conversion: 40% complete, cost of 115,200 Balance in work in process, June 1 $ 222,700 Units started during June 200,000 Units completed during June and transferred out to finished-goods inventory 200,000...
The following data pertain to the Hercules Tire and Rubber Company for the month of May. Work in process, May 1 (in units) ? Units started during May 60,000 Total units to account for 75,000 Units completed and transferred out during May ? Work in process, May 31 (in units) 10,000 Total equivalent units: direct material 75,000 Total equivalent units: conversion ? Work in process, May 1: direct material $ 135,000 Work in process, May 1: conversion ? Costs...
3.
4.
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. $183,500 128,600 $312,100 200,000 200,000 Work in process, June 1-60,000 units: Direct material: 100% complete, cost of Conversion: 40% complete, cost of Balance in work in process, June 1 Units started during June Units completed during June and transferred out to finished-goods inventory...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—50,000 units: Direct material: 100% complete, cost of $ 142,500 Conversion: 40% complete, cost of 83,200 Balance in work in process, June 1 $ 225,700 Units started during June 200,000 Units completed during June and transferred out to finished-goods inventory 210,000...
The Blending Department of Luongo Company has the following cost and production data for the month of April. Costs: Work in process, April 1 Direct materials: 100% complete Conversion costs: 20% complete Cost of work in process, April 1 Costs incurred during production in April Direct materials Conversion costs Costs incurred in April $111,000 77,700 $188,700 $888.000 405,150 $1.293,150 Units transferred out totaled 18,870. Ending work in process was 1,110 units that are 100% complete as to materials and 40%...
The Blending Department of Luongo Company has the following cost and production data for the month of April. $119,000 Costs: Work in process, April 1 Direct materials: 100% complete Conversion costs: 20% complete Cost of work in process, April 1 Costs incurred during production in April Direct materials Conversion costs Costs incurred in April 83,300 $202,300 $952,000 434,350 $1,386,350 Units transferred out totaled 20,230. Ending work in process was 1,190 units that are 100% complete as to materials and 40%...
The Blending Department of Luongo Company has the following cost and production data for the month of April. $111,000 77,700 Costs: Work in process, April 1 Direct materials: 100% complete Conversion costs: 20% complete Cost of work in process, April 1 Costs incurred during production in April Direct materials Conversion costs Costs incurred in April $188,700 $888,000 405,150 $1,293,150 Units transferred out totaled 18,870. Ending work in process was 1,110 units that are 100% complete as to materials and 40%...
The following data pertain to the Hercules Tire and Rubber Company for the month of May. 60,000 75,000 10,000 75,000 $ 135,000 Work in process, May 1 (in units) Units started during May Total units to account for Units completed and transferred out during May Work in process, May 31 (in units) Total equivalent units: direct material Total equivalent units: conversion Work in process, May 1: direct material Work in process, May 1: conversion Costs incurred during May: direct material...
The Mixing Department of Bravo Company has the following cost and production data for the month of April. Costs: Work in process, April 1 Direct materials: 100% complete $100,000 Conversion costs: 20% complete 70,000 Cost of work in process, April 1 $170,000 Costs incurred during production in April Direct materials $ 800,000 Conversion costs 365,000 Costs incurred in April $1,165,000 Units transferred out totaled 17,000. Ending work in process was 1,000 units that are 100% complete as to materials and...