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: a. All materials are added at the beginning of the process. b. Beginning work in process had 94,000 units, 20 percent complete with respect to conversion costs. C. Ending work in process had 18,500 units, 35 percent complete with respect to conversion costs. d. Started in process, 98,900 units. Required: 1. Prepare a physical flow schedule. Middelton Company Physical Flow Schedule Units to account for: Units, beginning work in process 94,000 Units started 98,900 192,900 Total units to account for Units accounted for: Units completed and transferred out: Started and completed 80,400 From beginning work in process 94,000 Units, ending work in process 18,500 Total units accounted for 192,900 2. Compute equivalent units using the weighted average method. Weighted average method: Equivalent Units Direct Materials 192,900 Conversion Costs 180,875 3. Compute equivalent units using the FIFO method. FIFO method: Equivalent Units Direct Materials 98,900 Conversion Costs 162,075 4. Suppose that the cost of direct materials in beginning work in process is $653,100 and that the direct materials cost incurred for October is $761,900. 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. 6.95 b. What is the unit materials cost for units produced in October? Round your answers to the nearest cent. $ 30.14 x Which method should be used to answer this question? Weighted Average Explain why the unit materials cost is not the same for weighted average and FIFO. uses only October costs and October output, so it should 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 of the two unit calculations, FIFO FIFO and WA will 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 proportion 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.) Explaining why the two unit costs differ and showing how Calculating what the unit materials cost is for September is descriptive Identifying the method that should be used for calculating October's unit materials cost is prescriptive the weighted Average method is a blend of BWIP and current cost is diagnostic