The service company. Excellent Maids, cleans hotel rooms at resorts on Hilton Head Island. Excellent hasidentified three activities involved in cleaning. Information on those activities for the month of May follow:Cost PoolsEstimated OverheadExpectedUse of Cost DriversCost DriversCostCleaning bed linensNumber of beds$72,00048,000 bedsCleaning bathroomsNumber of bathrooms64,00032,000 bathroomsOther cleaningNumber of hotel roomsand public spaces45,00018,000 spaces

Name: The service company. Excellent Maids, cleans hotel rooms at resorts o
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: The service company. Excellent Maids, cleans hotel rooms at resorts on Hilton Head Island. Excellent hasidentified three activities involved in cleaning. Information on those activities for the month of May follow:Cost PoolsEstimated OverheadExpecte

Financial management consists of directing ,planning, organizing and controlling of financial…

Business

Accounting

The service company. Excellent Maids, cleans hotel rooms at resorts on Hilton Head Island. Excellent has identified three activities involved in cleaning. Information on those activities for the month of May follow: Estimated Overhead Cost Cost Pools Cost Drivers Expected Use of Cost Drivers Cleaning bed linens Number of beds $72,000 48,000 beds Cleaning bathrooms Number of bathrooms 64,000 32,000 bathrooms Other cleaning Number of hotel rooms and public spaces 45,000 18.000 spaces

The service company. Excellent Maids, cleans hotel rooms at resorts on Hilton Head Island. Excellent has identified three activities involved in cleaning. Information on those activities for the month of May follow: Estimated Overhead Cost Cost Pools Cost Drivers Expected Use of Cost Drivers Cleaning bed linens Number of beds $72,000 48,000 beds Cleaning bathrooms Number of bathrooms 64,000 32,000 bathrooms Other cleaning Number of hotel rooms and public spaces 45,000 18.000 spaces

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 5BE: Activity-based costing for a service business Sterling Hotel uses activity-based costing to...

See similar textbooks

Similar questions

Exercise 7-3 (Algo) Compute Activity Rates [LO7-3] Green Thumb Gardening is a small gardening service using activity-based costing to estimate costs for pricing and other purposes. The owner of the company believes 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 depend on whether the beds are low-maintenance beds (mainly ordinary trees and shrubs) or high-maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below: Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service Square feet of lawn Square feet of…
ctivity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are $8 per guest check-in, $25 per room cleaning, and $4 per served meal (not including food). Ginny Campbell visited the hotel for a three-night stay. Campbell had three meals in the hotel during her visit. Determine the total activity-based cost for Campbell's visit.
A manufacturer uses activity-based costing to assign overhead costs to products. Budgeted cost information for selected activities for next year follows. Activity Purchasing Cleaning factory Providing utilities Activity cost pool Purchasing Factory Expected Cost $127,600 31,500 63,070 Expected Costs Compute activity rates for each of the cost pools. (Round your answers to 2 decimal places.) Expected Amount of Cost Driver Cost Driver Purchase orders Square feet Square feet 4,400 4,900 Activity Overhead Rate Expected Usage of Cost Driver 4,488 purchase orders 4,900 square feet 4,900 square feet per purchase order per square foot
Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are $8.10 per guest check-in, $24.00 per room cleaning, and $4.00 per served meal (not including food). Tara Stone visited the hotel for a 4-night stay. Tara had 5 meals in the hotel during the visit. Determine the total activity-based cost for Stone's visit during the month. Round your answer to the nearest cent.$fill in the blank 1
Woodstock Binding has two service departments, IT (Information Technology) and HR (Human Resources), and two operating departments, Publishing.and Binding. Management has decided to allocate IT costs on the basis of IT Tickets (issued with each IT request) in each department and HR costs on the basis of employees in each department. The following data appear in the company records for the current period: IT tickets Employees Department direct costs From: Service department costs IT HR Total $ IT IT 0 20 $ 156,800 Required: Allocate the service department costs using the reciprocal method. (Matrix algebra is not required because there are only two service departments.) Note: Amounts to be deducted should be indicated by a minus sign. Do not round intermediate calculations. 39,200 39,200 0x HR 1,585 0 $ 249,030 Answer is not complete. $ Cost Allocation To: HR Publishing 2,536 30 $ 433,400 0 0X 0 Publishing $ 0x 74,709 x 74,709 Binding 2,219 50 $ 398,500 $ Binding 0 x 124,515 124,515
Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Q.Explain why rooms inspected and inspection labor-hours are plausible cost drivers of inspection costs.
Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Q.Mary expects inspectors to inspect 300 rooms and work for 105 hours next week. Using the cost driver , what amount of inspection costs should Mary budget?
The following is an extract of a cost report for Best Car Wash for the six months from Jun to Nov. Management considers the activities in these six months as within the relevant range for the purpose of cost Month Number of cars washed Carwashing labour Costs ($) Jun 500 7,000 Jul 520 7,200 Aug 480 6,800 Sep 510 7,100 Oct 400 6,000 Nov 600 8,000 Based on the above data, determine the cost behaviour of the car washing labour cost. Justify your answer. 2. Quality Press Ltd produces a number of products, including a weekly newspaper called The Quality Times, customised business cards and printed stationery. In preparing next year’s budget, the accountant is analysing the behaviour of the company’s major costs, listed below, and considering possible cost The cost of paper used in the Quality Times. Each edition comprises 40 pages The cost of the card used for business The cost of the lease on the company The…
Transformations Hair Salon uses an activity-based costing system to determine the cost of services. The salon has determined the costs of services by activity as follows: Activity Activity Rate Hair washing $1.50 Conditioning 2.00 Chemical treatment 20.00 Styling 10.00 a. Using the information provided, determine the cost of services for each of the following services provided by the salon: HairWashing Conditioning Chemical Treatment Styling Haircut 1 1 0 0 Complete style 1 1 0 1 Perm 2 3 1 1 Highlights 3 4 2 1 Round your answers to two decimal places, if necessary. Haircut $ per unit Complete style $ per unit Perm $ per unit Highlights $ per unit b. If the company budgets 10,000 haircuts, 4,000 complete styles, 3,500 perms, and 5,500 highlights, determine the budget for cost of services. Services Total Costs Haircut $ Complete style Perm Highlights Total $
Woodstock Binding has two service departments, IT (Information Technology) and HR (Human Resources), and two operating departments, Publishing and Binding. Management has decided to allocate IT costs on the basis of IT Tickets (issued with each IT request) in each department and HR costs on the basis of employees in each department. The following data appear in the company records for the current period: IT tickets Employees Department direct costs From: Service department costs IT HR Total IT $ 0 16 $ 152,000 Required: Allocate the service department costs using the reciprocal method. (Matrix algebra is not required because there are only two service departments.) Note: Amounts to be deducted should be indicated by a minus sign. Do not round intermediate calculations. HR 1,525 0 $ 247,950 152,000 Answer is not complete. Cost Allocation To: IT HR 152,000 $ 247,950 Publishing 2,440 24 $ 431,000 $ 247,950 Publishing $ Binding 2,135 40 $ 392,500 0 Binding 0
Regression, activity-based costing, choosing cost drivers. Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A signicant component of inspection costs is the cost of the supplies used in each inspection.
The Grand Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are $9 per guest check-in, $15 per room cleaning, and $5 per served meal (not including food). Nikita Johnson visited the hotel for a three-night stay. Nikita had three meals in the hotel during her visit. Determine the total activity-based cost for Nikita’s visit.