Please provide answer in text (Without image), use weighted Average method The Bottling department of Soft Drink Company has the following production andmanufacturing cost data for June 2022. All materials are added at the beginning of theprocess.Manufacturing CostsBeginning work in processMaterialsConversion CostsTotal Cost of beginning work in processCost Incurred During Production in JuneMaterialsLaborOverheadTotal cost incurred during production in JuneProduction DataBeginning work in processUnits startedUnits transferred outEnding work in process17,500 units48,50053,0009,5001/5 complete$22,00016,250$38,250202,00071,12559875$333,000Prepare a production cost report for The Bottling department for the month of June?(You can use Microsoft Excel when solving the above problem.)

The weighted average method for a production cost report calculates the cost per equivalent unit by…

Answered: Prepare a production cost report for…

Business

Accounting

Prepare a production cost report for The Bottling department for the month of June?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 16M

See similar textbooks

Similar questions

Cost of production report The debits to Work in ProcessRoasting Department for Morning Brew Coffee Company for August, together with information concerning production, are as follows: All direct materials are placed in process at the beginning of production. A. Prepare a cost of production report, presenting the following computations: 1. Direct materials and conversion equivalent units of production for August 2. Direct materials and conversion costs per equivalent unit for August 3. Cost of goods finished during August 4. Cost of work in process at August 31 B. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (July).
Aero Aluminum Inc. uses a process cost system. The records for May show the following information: Required: Prepare a cost of production summary for each department. (Hint: When preparing the Converting production summary, refer to the Rolling production summary for the costs transferred in during the month.)
Production information shows these costs and units for the smoothing department in August. All materials are added at the beginning of the period. The ending work in process is 30% complete as to conversion. What is the value of the inventory transferred to finished goods and the value of the WIP inventory at the end of the month?
Tanaka Manufacturing Co. uses the process cost system. The following information for the month of December was obtained from the company’s books and from the production reports submitted by the department heads: Required: Prepare cost of production summaries for the Mixing, Blending, and Bottling (Hint: You must calculate the adjusted unit cost from Blending.) departments. Prepare a departmental cost work sheet. Draft the journal entries required to record the month’s operations. Prepare a statement of cost of goods manufactured for December. (Hint: Goods finished but not transferred to finished goods are considered part of work in process inventory.)
The Bottling department of Soft Drink Company has the following production and manufacturing cost data for June 2022. All materials are added at the beginning of the process. Manufacturing Costs Beginning work in process Materials Conversion Costs Total Cost of beginning work in process Cost Incurred During Production in June Materials Labor Overhead Total cost incurred during production in June Production Data Beginning work in process Units started Units transferred out Ending work in process 17,500 units 48,500 53,000 9,500 1/5 complete $22,000 16,250 $38,250 202,000 71,125 59875 $333,000 Prepare a production cost report for The Bottling department for the month of June? (You can use Microsoft Excel when solving the above problem.)
The Bottling department of Soft Drink Company has the following production and manufacturing cost data for June 2022. All materials are added at the beginning of the process. Manufacturing Costs Beginning work in process Materials Conversion Costs Total Cost of beginning work in process Cost Incurred During Production in June Materials Labor Overhead Total cost incurred during production in June Production Data Beginning work in process Units started Units transferred out Ending work in process 17,500 units 48,500 53,000 9,500 1/5 complete $22,000 16,250 $38,250 202,000 71,125 59875 $333,000 Prepare a production cost report for The Bottling department for the month of June?
Blossom Company manufactures basketballs. The first step is the production of internal rubber bladders. Materials are added at the beginning of the production process, and conversion costs are incurred uniformly. Production and cost data for the Bladder Department for July 2025 are as follows. Production Data-Basketballs. Work in process units, July 1 Units started into production Work in process units, July 31 Cost Data-Basketballs Work in process, July 1 Materials Conversion costs Costs added during July Direct materials Direct labor Manufacturing overhead (a1) $700 Equivalent Units 550 Units Materials 400 1,000 500 $1,250 1,960 1,200 1,000 Percent Complete 60 % Calculate the equivalent units of production for materials and conversion costs. 40 % Conversion Costs
Compute the equivalent units of production for (1) materials and (2) conversion costs for each month. Materials Conversion Costs January March May July Given: In Shady Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing Department in selected months during 2020 are as follows. BeginningWork in Process EndingWork in Process Month Units ConversionCost% UnitsTransferred Out Units ConversionCost% January 0 — 11,000 2,000 60 March 0 — 12,000 3,000 30 May 0 — 14,000 7,000 80 July 0 — 10,000 1,500 40
In Sandhill Company, materials are entered at the beginning of each process, and conversion costs are incurred uniformly throughout the process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing Department in selected months during 2022 are as follows. Beginning Work in Process Ending Work in Process Month Units Conversion Cost% Units Completed and Conversion Transferred Out Units Cost% January 0 13,200 2,400 60 March 0 14,400 3,600 30 May 0 16,800 8,400 80 July 0 12,000 1,600 40 (a) For January and May, compute the physical units to be accounted for and the physical units accounted for. January May Units to be accounted for Beginning work in process Started into production Total units Units accounted for Transferred out Ending work in process Total units
The assembly division of Quality Time Pieces, Inc. uses the weighted-average method of process costing. Consider the following data for May 2020: (Click the icon to view the data.) Requirement Compute equivalent units for direct materials and conversion costs. Show physical units in the first column of your schedule. Enter the physical units first, then calculate the equivalent units. Flow of Production Work in process beginning Started during current period To account for Completed and transferred out during current period Work in process, ending Accounted for Equivalent units of work done to date Physical Units Data table Beginning work in process (May 1)ª Started in May 2020 Completed during May 2020 Ending work in process (May 31) Total costs added during May 2020 Physical Units Direct (Watches) Materials 100 $459,888 Print 510 450 160 $3,237,000 aDegree of completion: direct materials, 80%; conversion costs, 35%. bDegree of completion: direct materials, 80%; conversion costs, 40%.…
. In Ramirez Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing Department in selected months during 2020 are as follows. Beginning Work in Process Month Beginning Work in Process Units Transferred Out Units % Complete as to Conversion Cost September 0 2,000 7,000 60 December 0 3,000 12,000 30 Compute the equivalent units of production for (1) materials and (2) conversion costs for each month.
The assembly division of Quality Time Pieces, Inc. uses the FIFO method of process costing. Consider the following data for May 2020: (Click the icon to view the data.) Requirement Compute equivalent units for direct materials and conversion costs. Show physical units in the first column of your schedule. Enter the physical units in first, then calculate the equivalent units. Flow of Production Work in process, beginning Started during current period To account for Completed and transferred out during current period: From beginning work in process Started and completed Work in process, ending Accounted for Equivalent unts of work done in current period Physical Units Data table Beginning work in process (May 1)ª Started in May 2020 Physical Units (Watches) 100 510 450 160 Print Completed during May 2020 Ending work in process (May 31)b Total costs added during May 2020 a Degree of completion: direct materials, 80%; conversion costs, 35%. Degree of completion: direct materials, 80%;…