Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare the Cooling Department production cost report using Weighted Average method and following this Excell form. Thank you so muchhh X Factory manufactures a single

image text in transcribed

image text in transcribed

Prepare the Cooling Department production cost report using Weighted Average method and following this Excell form. Thank you so muchhh

X Factory manufactures a single product, which passes through the Mixing Department and Cooling Department Manufacturing begins in the Mixing Department. All units are then transferred to Cooling Department In the Cooling Department, further materials are added and processed until completion, and transferred to the finished goods inventory. Qverhead is allocated on the basis of 100% of direct labour cest Work in process in the Cooling Department on 1 Mar was 10,000 units ( Material : 60% complete, Conversion: 50% complete). The costs included in these units were as follow During the month, the Cooling Department completed and transferred 30,000 units to finished goods inventory. The ending work in process for Cooling Department was 6,000 units (Material : 70\%, Conversion: 80\%) Units transferred in from Mixing Department in Mar were charged at $3.50 per unit. Cooling Department's cost in Mar were: Required: Prepare the Cooling Department production cost report for the month of Mar 2023 using (round up to 2 decimal place) i) Weighted Average method ii) FIFO method Note: You may prepare the production cost report using EXCEL \begin{tabular}{l|l|l|l|l|} & \multicolumn{1}{|c|}{ Physical Units } & \multicolumn{1}{c|}{ Euivalent units } & TOTAL \\ \cline { 2 - 4 } QUANTITIES & Step 1 & Step 2 & & \\ \hline Units to be accounted for & & & & \\ \hline Work in process, OB & & & & \\ \hline Started into production/ Transferred in & & & & \\ \hline Total units & & & & \\ \hline Units accounted for & & & & \\ \hline Transferred out & & & & \\ \hline Work in process, CB & & & & \\ \hline Total units & & & & \\ \hline CoSTS & & & & \\ \hline Total cost & & & & \\ \hline Equivalent units & & & & \\ \hline Unit costs & & & & \\ \hline Costs to be accounted for & & & & \\ \hline Work in process, OB & & & & \\ \hline Started into production/ Transferred in & & & & \\ \hline Total costs & & & & \\ \hline Cost Reconciliation schedule & & & & \\ \hline Costs accounted for & & & & \\ \hline Transferred out & & & & \\ \hline Work in process, CB & & & & \\ \hline Conversion costs & & & & \\ \hline Total costs & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of External Auditing

Authors: Brenda Porter, Jon Simon, David Hatherly

1st Edition

0471962120, 978-0471962120

More Books

Students also viewed these Accounting questions

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago