Hi CourseHero, can you help me with my assignment, thank you.

Exercise 1:Process costing

Selzik Company makes super-premium cake mixes that go through two processing departments, Blending and Packaging. The following activity was recorded in the Blending Department during July:

Production data:

---------------------------------------------------------------------------------------------------------------------------------------------------

I I Total I

---------------------------------------------------------------------------------------------------------------------------------------------------

Units in process, July 1

(materials 100% complete; conversion 30% complete) I I 10,000 I

--------------------------------------------------------------------------------------------------------------------------------------------------

Units started into Production I I 170,000 I

--------------------------------------------------------------------------------------------------------------------------------------------------

Units complete, and transferred to Packaging I I ? I

-------------------------------------------------------------------------------------------------------------------------------------------------

Unitsin process, July 31

(materials 100% complete; conversion 40% complete) I I 20,000 I

-----------------------------------------------------------------------------------------------------------------------------------------------

Cost data: I I I

----------------------------------------------------------------------------------------------------------------------------------------------

Work in process inventory, July 1: I I I

----------------------------------------------------------------------------------------------------------------------------------------------

Materials cost I $ 8,500 I I

-----------------------------------------------------------------------------------------------------------------------------------------------

Conversion cost I 4,900 I $13,400 I

-----------------------------------------------------------------------------------------------------------------------------------------------

Cost added during the month: I I I

---------------------------------------------------------------------------------------------------------------------------------------------

Materials cost I $139,400 I I

-----------------------------------------------------------------------------------------------------------------------------------------------

Conversion cost I 244,200 I 383,600 I

----------------------------------------------------------------------------------------------------------------------------------------------

Total Cost I I $397,000 I

----------------------------------------------------------------------------------------------------------------------------------------------

All materials are added at the beginning of work in the Blending Department.

Required:

Prepare, a production report in weighted average method and FIFO method for the Blending Department for July. Use the following 3 steps as a guide in preparing your report:

1.Prepare, a quantity schedule and compute the equivalentsunits

2.Compute the costs per equivalent unit for the month

3.Using the data from (1) and (2) above, prepare, a cost reconciliation

Note:

I have just created a sample table above as I cannot make cells same as the excel sheets. I have also tried to upload a screenshot but I immediately received a message saying that I needed to revised my question.

Here is the original copy-paste from MS Word which is all in Italic:

Exercise 1:Process costing

Selzik Company makes super-premium cake mixes that go through two processing departments, Blending and Packaging. The following activity was recorded in the Blending Department during July:

Production data:

Total

Units in process, July 1

(materials 100% complete; conversion 30% complete)

10,000

Units started into Production

170,000

Units complete, and transferred to Packaging

?

Unitsin process, July 31

(materials 100% complete; conversion 40% complete)

20,000

Cost data:

Work in process inventory, July 1:

Materials cost

$ 8,500

Conversion cost

4,900

$13,400

Cost added during the month:

Materials cost

$139,400

Conversion cost

244,200

383,600

Total Cost

$397,000

All materials are added at the beginning of work in the Blending Department.

Required:

Prepare, a production report in weighted average method and FIFO method for the Blending Department for July. Use the following 3 steps as a guide in preparing your report:

1.Prepare, a quantity schedule and compute the equivalentsunits

2.Compute the costs per equivalent unit for the month

3.Using the data from (1) and (2) above, prepare, a cost reconciliation

Thank you very much and I look forward on your team's response.