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 at the beginning of the process. Overhead is applied using the following drivers and activity rates: During the first quarter, the Plate Cutting Department used 26,300 hours (direct, indirect, and machine hours) to produce the quarter's output. Other quarterly data for the Plate Cutting Department are as follows: Required: 1. Prepare a physical flow schedule. If an answer is zero, enter " 0 ". 5. Suppose the plant manager asked the following questions: a. What is the actual cycle time for the conversion cost output for the plate subassembly (round to four decimal places)? X hours per unit b. What is the conversion cost rate for the first quarter, using total conversion costs and total time (round to the nearest cent)? per hour c. 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? (round to the nearest cent)? Identify the data analytic types (descriptive, diagnostic, predictive, or prescriptive) that apply to parts a. through d. (see Exhibit 2.5 and Exhibit 2.6 for a review of data analytic metrics). Note: More than one data analytic type might apply. 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 at the beginning of the process. Overhead is applied using the following drivers and activity rates: During the first quarter, the Plate Cutting Department used 26,300 hours (direct, indirect, and machine hours) to produce the quarter's output. Other quarterly data for the Plate Cutting Department are as follows: Required: 1. Prepare a physical flow schedule. If an answer is zero, enter " 0 ". 5. Suppose the plant manager asked the following questions: a. What is the actual cycle time for the conversion cost output for the plate subassembly (round to four decimal places)? X hours per unit b. What is the conversion cost rate for the first quarter, using total conversion costs and total time (round to the nearest cent)? per hour c. 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? (round to the nearest cent)? Identify the data analytic types (descriptive, diagnostic, predictive, or prescriptive) that apply to parts a. through d. (see Exhibit 2.5 and Exhibit 2.6 for a review of data analytic metrics). Note: More than one data analytic type might apply