Question

In: Accounting

A local cleaning service has identified 4 activities that drive its costs. The service uses activity-based...

A local cleaning service has identified 4 activities that drive its costs. The service uses activity-based costing to estimate the costs of jobs prior to pricing them. They clean both commercial and residential properties. They have the following budgets for the upcoming year:

Cost Type

Budgeted Cost for Both Commercial & Residential Properties

Driver

Expected Driver Activity for Commercial Properties

Expected Driver Activity for Residential Properties

Cleaning Personnel

$120,000

# of Properties to Clean

600 properties to clean

900 properties to clean

Travel to Jobs

$30,000

Miles Driven to/from Property

30,000 miles (round-trip)

10,000 miles

(round-trip)

Cleaning Equipment

$40,000

Hours to Clean a Property

24,000 hours

16,000 hours

Cleaning Supplies

$60,000

Square Feet of Property

360,000 square feet

240,000 square feet

A residential customer has called and would like price quote to have his property cleaned next week. The property is a 20 mile round-trip to/from the cleaning personnel. It should take about 4 hours to clean it and the house is 1,000 square feet.

What would you recommend the price quote be to this customer? Support your answer with clear calculations of your cost estimate and about your pricing strategy.

Solutions

Expert Solution

Calculation of activity based cost driver rates:

Particulars Cost Driver Budgeted cost Budgeted units of cost driver Rate per cost driver unit
Cleaning personnel Number of property clean $         1,20,000 1500 80
Travels to Job Miles driven to/from property $             30,000 40000 0.75
Cleaning Equipment Hours to clean a property $             40,000 40000 1
Cleaning Supplies Square feet of property $             60,000 600000 0.1

Calculation of price quoted to customer:-

Particulars Cost driver units Cost driver rate Cost Allocated
Cleaning personnel 1 80 $                                                    80
Travels to Job 20 0.75 $                                                    15
Cleaning Equipment 4 1 $                                                      4
Cleaning Supplies 1000 0.1 $                                                  100
Price to be charged $                                                  199

The cleaning service company has used activity based costing method to calculate teh cost. Also, it has used total costing method for calculation of price to be quoted.


Related Solutions

Wellington Chocolate Company uses activity-based costing (ABC). The controller identified two activities and their budgeted costs:...
Wellington Chocolate Company uses activity-based costing (ABC). The controller identified two activities and their budgeted costs: Setting up equipment $598,000 Other overheard $6,400,000 Setting up equipment is based on setup hours, and other overhead is based on oven hours. Wellington produces two products, Fudge and Cookies. Information on each product is as follows: Fudge Cookies Units produced 8,000 445,000 Setup hours 10,400 2,600 Oven hours 5,000 35,000 Required: Round your answers to the nearest whole dollar, unless otherwise directed. 1....
Production Inc. uses activity based costing. The following estimated activity costs are identified in the table...
Production Inc. uses activity based costing. The following estimated activity costs are identified in the table below. In addition, they have two product lines, A100 and B100. Activity Cost Cost Driver A100 B100 Cost allocation base Setup $85,600 # of setups 1,600 1,750 16,000 Handling $136,500 # of parts 1,480 360 65,000 Assembly $126,000 Direct Labor Hours 800 365 5,000 Total $348,100 Summary of prime costs: A100 B100 Direct materials $16,000 $9,500 Direct labor $13,400 $12,700 Calculate the unit cost...
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material...
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material handling, Product testing, Packaging - and their respective cost drivers - pounds of material, tests, packages. Budgeted activity costs in 2018 were as follows: Activity Budgeted Cost   Material handling $104,700       Product testing 58,700       Packaging 53,000       The following 2018 cost driver information is available for one of its products, Product A, and for all of its products (including Product A): Product A All Products pounds...
Fischer Company identified the following activities, costs, and activity drivers: Activity Expected Costs Expected Activity Handling...
Fischer Company identified the following activities, costs, and activity drivers: Activity Expected Costs Expected Activity Handling Parts 425,000 25,00 parts in stock Inspecting Parts 390,000 940 batches Processing Purchase Orders 220,000 440 orders Designing Packaging 230,000 5 models a. Compute a plantwide overhead rate assuming the company assigns overhead based on 70,000 budgeted direct labor hours (Round to two decimals). b. Compute separate rates for each of the four activities using the activity-based costing.
Company uses activity-based costing to determine product cost. The accounting department identified the following overhead activities,...
Company uses activity-based costing to determine product cost. The accounting department identified the following overhead activities, costs, and activity drivers for the coming year. Activity Estimated cost Activity driver Activity capacity Setting up equipment $120,000 Number of setups 300 Ordering materials 90,000 Number of orders 9,000 Maintaining machines 210,000 Machine hours 21,000 Total overhead $420,000 The following actual results were collected for the production of Model X and Model Y during the year. Model X Model Y Units produced 8,000...
4. Nationals Inc. uses activity-based costing to determine the costs of its three products: A, B,...
4. Nationals Inc. uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown below. (Check: Activity 1 activity rate should be a number between $7 and $10). (3 points) Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $140,000 7,500 4,000 6,000 Activity 2 $54,000 2,500 2,000 1,500 Activity 3 $38,000 15,000 25,000...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year:...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity                                Expected Cost          Activity Driver               Activity Capacity Material-handling costs.. £45,000             Number of moves.........        450 Machine costs................ £80,000             Machine hours.............. 20,000 Order costs.................... £15,000             Number of orders.........        750 Receiving costs.............. £30,000             Number of parts........... 50,000 Setup costs.................... £50,000             Number of setups.........        250 Assume that each activity corresponds to a process. DAB’s normal activity is 5,000 direct labor hours. The following two jobs...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for...
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT