3 BE9.12-Using Excel with Time-Driven Actgivity-Based Costing 345678HELAG PROBLEM 5 Martha Motors was evaluating its costs related to customers checking cars in and 6 out for maintenance. Previously, it calculated an activity-based rate for each 7 customer for this process that included both check-in and check-out. A new time- 8 driven study recognized that the practical employee capacity was lower than the 9 theoretical capacity; it further determined estimated times for check-in separate 10 from check-out. Information on the rates and times of the activities is presented 11 here. 12 13 14 15 16 17 18 Previous activity-based rate per customer Estimated time for check-in in minutes Estimated time for check-out in minutes New estimated cost of capacity per hour $ $ 5.00 5 10 18.00 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. How much would the time-driven method recognize for one customer checking in and out? Check-in cost Check-out cost Cost for one customer

DC9.12 - Unlne Excel with Time-Drlwen Actrylty-Based Costing PROBLEM Martha Motors was evaluating its costs related to customers checking cars in and out for maintenance. Previoush, it calculated an activity-based rate for each customer for this process that included both check-in and check-out. A new time. diven study recognired that the practical employee capacity was lower than the theoretical capacity, it further determined estimated times for check-in separate from check-out. information on the rates and times of the activities is presented here