1 Function: SUM; Multiply; Divide; Cell Referencing 2 3 BE9.12-Using Excel with Time-Driven Actgivity-Based Costing 4...

Transcribed Image Text:

1 Function: SUM; Multiply; Divide; Cell Referencing 2 3 BE9.12-Using Excel with Time-Driven Actgivity-Based Costing 4 PROBLEM 5 Martha Motors was evaluating its costs related to customers checking cars in and out for maintenance. Previously, it calculated an activity-based rate for each 6 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. Previous activity-based rate per customer Estimated time for check-in in minutes 12 13 $ 5.00 14 5 15 Estimated time for check-out in minutes 10 16 New estimated cost of capacity per hour $ 18.00 17 18 19 20 21 22 23 24 25 26 27 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 1 Function: SUM; Multiply; Divide; Cell Referencing 2 3 BE9.12-Using Excel with Time-Driven Actgivity-Based Costing 4 PROBLEM 5 Martha Motors was evaluating its costs related to customers checking cars in and out for maintenance. Previously, it calculated an activity-based rate for each 6 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. Previous activity-based rate per customer Estimated time for check-in in minutes 12 13 $ 5.00 14 5 15 Estimated time for check-out in minutes 10 16 New estimated cost of capacity per hour $ 18.00 17 18 19 20 21 22 23 24 25 26 27 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