3 Exercise 6-14 Physical Flow, Equivalent Units, Unit Costs, No Beginning WIP Inventory, Activity-Based Costing, DBC McKay, Inc., produces a subassembly used in the production of hydraulic cylinders. The subassemblies are produced in three departments: Plate Cutting, Rod Cutting, and Welding. Materials are added a the beginning of the process. Overhead is applied using the following drivers and activity rates: CS Driver Direct labor cost Inspection hours Purchase orders Rate 120% of direct labor $40 per hour $100 per move Actual Usage (by Plate Cutting) $ 330,000 4,002 hours 1,680 moves s follows: ment areas machine hours) to produce the quarter's output. Other quarterly data for the Plate Cutting Depart- During the first quarter, the Plate Cutting Department used 20,000 hours (direct, indirect, and Beginning work in process, January 1 Units started 90,000 Direct materials cost $720,000 Units, ending work in process (100% materials: 64% 6,000 conversion), March 31 Required: 1. Prepare a physical flow schedule. 2 Calculate equivalent units of production for: a. Direct materials b. Conversion costs 3. Calculate unit costs for: a. Direct materials b. Conversion costs c. Total manufacturing 4. Provide the following information: a. The total cost of units transferred out b. The journal entry for transferring costs from Plate Cutting to Welding c. The cost assigned to units in ending inventory 5. Suppose the plant manager asked the following questions: 2. What is the actual cycle time for the conversion cost output for the plate subassembly (round to four decimal places)? b. What is the conversion cost rate for the first quarter, using total conversion costs and total time (round to the nearest cent)? What is the conversion cost per unit , using duration-based costing (round to the nearest cent)? d. According to production engineering, if efficiency were increased to an ideal level, then the cycle time should be 0.20 hours. If this were to occur, what would the cost per plate be? Identify the data analytic types (descriptive, diagnostic, predictive, or prescriptive) that apply to parts 2. through d. (sec Exhibits 2.5 and 2.6, pp. 37, 40, for a review of data analytic metrics). Note: More than one data analytic type might apply