Weighted Average Method, FIFO Method, Physical Flow, Equivalent Units

Middelton Company manufactures a product that passes through two processes: Fabrication and Assembly. The following information was obtained for the Fabrication Department for October:

1. All materials are added at the beginning of the process.
2. Beginning work in process had 125,000 units, 40 percent complete with respect to conversion costs.
3. Ending work in process had 25,000 units, 20 percent complete with respect to conversion costs.
4. Started in process, 175,000 units.

Required:

1. Prepare a physical flow schedule.

Middelton Company Physical Flow Schedule

Units to account for:
Started and completedUnits, beginning work in processUnits, ending work in process	- Select -
Units completedUnits, ending work in processUnits startedUnits transferred out	- Select -
Total units to account for	fill in the blank 97a4fb07205d020_5
Units accounted for:
Units completed and transferred out:
Started and completedUnits completedUnits startedUnits transferred out	- Select -
From beginning work in processUnits completedUnits startedUnits transferred out	- Select -
Units completedUnits, ending work in processUnits startedUnits transferred out	- Select -
Total units accounted for	fill in the blank 97a4fb07205d020_12

2. Compute equivalent units using the weighted average method.

Weighted average method:	Equivalent Units
Direct Materials	fill in the blank 285734fc1031f95_1
Conversion Costs	fill in the blank 285734fc1031f95_2

3. Compute equivalent units using the FIFO method.

FIFO method:	Equivalent Units
Direct Materials	fill in the blank 285734fc1031f95_3
Conversion Costs	fill in the blank 285734fc1031f95_4

4. Suppose that the cost of direct materials in beginning work in process is $560,000 and that the direct materials cost incurred for October is $700,000. With these changes, answer the following:

a. What is the unit materials cost for the units in BWIP? Round your answers to the nearest cent. $fill in the blank b4718400d050fe0_1

b. What is the unit materials cost for units produced in October? Round your answers to the nearest cent. $fill in the blank b4718400d050fe0_2

Which method should be used to answer this question?

Weighted AverageFIFO

Explain why the unit materials cost is not the same for weighted average and FIFO.

Of the two unit calculations,

Weighted AverageFIFO

uses only October costs and October output, so it

shouldshould not

be used to calculate the unit materials cost for October. When those costs are changing from one period to the next, then the unit costs for FIFO and WA

willwill not

differ.

As part of your explanation, show that the weighted average unit cost for materials is the blend of the September unit materials cost and the October unit materials cost.

Because the weights are the

distributionproportioncomparison

of total equivalent units for each unit cost.

c. Which data analytic types (descriptive, diagnostic, predictive, or prescriptive) apply for 4a and 4b? Note: More than one data analytic type might apply. (See Exhibit 2.5 and Exhibit 2.6 for a review of data analytic metrics.)

Calculating what the unit materials cost is for September is

descriptivediagnosticpredictiveprescriptive

. Identifying the method that should be used for calculating October's unit materials cost is

descriptivediagnosticpredictiveprescriptive

. Explaining why the two unit costs differ and showing how the Weighted Average method is a blend of BWIP and current cost is

descriptivediagnosticpredictiveprescriptive