1. 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 86,300 units, 40 percent complete with respect to conversion costs.
   3. Ending work in process had 14,500 units, 30 percent complete with respect to conversion costs.
   4. Started in process, 105,400 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 38fff004c055fd0_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 38fff004c055fd0_12

   2. Compute equivalent units using the weighted average method.

   Weighted average method:	Equivalent Units
   Direct Materials	fill in the blank 6f944af30008fb9_1
   Conversion Costs	fill in the blank 6f944af30008fb9_2

   3. Compute equivalent units using the FIFO method.

   FIFO method:	Equivalent Units
   Direct Materials	fill in the blank 6f944af30008fb9_3
   Conversion Costs	fill in the blank 6f944af30008fb9_4

   4. Suppose that the cost of direct materials in beginning work in process is $636,400 and that the direct materials cost incurred for October is $759,200. 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 e9b4fbf8a02ffec_1

   b. What is the unit materials cost for units produced in October? Round your answers to the nearest cent. $fill in the blank e9b4fbf8a02ffec_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

   .