Concept explainers
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 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:
Mary runs regressions on each of the possible cost drivers and estimates these cost functions:
- 1. Explain why rooms inspected and inspection labor-hours are plausible cost drivers of inspection costs.
Required
- 2. Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain.
- 3. Mary expects inspectors to inspect 300 rooms and work for 105 hours next week. Using the cost driver you chose in requirement 2, what amount of inspection costs should Mary budget? Explain any implications of Mary choosing the cost driver you did not choose in requirement 2 to budget inspection costs.
Learn your wayIncludes step-by-step video
Chapter 10 Solutions
COST ACCOUNTING TTU >IC<
Additional Business Textbook Solutions
Financial Accounting
Financial Accounting, Student Value Edition (5th Edition)
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Horngren's Accounting (12th Edition)
Financial Accounting (11th Edition)
Financial Accounting, Student Value Edition (4th Edition)
- Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forwardProduct costing and decision analysis for a service company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its products. The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Total patient days are determined by multiplying the number of patients by the average length of stay in the hospital. A weighted care unit (wcu) is a measure of nursing effort used to care for patients. There were 192,000 weighted care units estimated for the year. In addition, Pleasant Stay estimated 6,000 patients and 27,000 patient days for the year. (The average patient is expected to have a a little more than a four-day stay in the hospital.) During a portion of the year, Pleasant Stay collected patient information for three selected procedures, as follows: Private insurance reimburses the hospital for these activities at a fixed daily rate of 406 per patient day for all three procedures. Instructions Determine the activity rates. Determine the activity cost for each procedure. Determine the excess or deficiency of reimbursements to activity cost. Interpret your results.arrow_forwardScattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:arrow_forward
- A local picnic table manufacturer has budgeted these overhead costs: They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown: Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities:arrow_forwardDeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fragility of the items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Required: 1. Using the method of least squares, run a regression using the number of orders as the independent variable. 2. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? 3. Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items.arrow_forwardAssign the customer-related activity costs to each customer type using activity rates. Now calculate the profitability of each customer category. As a manager, how would you use this information? Emery Company sells small machine parts to heavy equipment manufacturers for an average price of 1.05 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plants manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customers specifications have been met Inspection takes essentially the same time regardless of the type of part being produced. Emerys Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Calculate the profitability of each customer type. Discuss the problems with this measure of customer profitability.arrow_forward
- Using variable costing, service company Henry’s Helpers provides locksmith services. One type of service call is to evaluate private residences for security concerns and make recommendations for Safety plan. Use the data below to determine the company’s total contribution margin, contribution margin per service call, and contribution margin ratio when 220 service calls are made in the month of June.arrow_forwardCost Classification Match each cost to the appropriate cost behavior pattern shown in graphs (a) through (l). Any graph can fit two or more patterns. The cost of lumber used to manufacture wooden kitchen tables. The cost of order fillers in a warehouse. When demand increases significantly, the number of order fillers is increased, and when demand falls off significantly, the number is decreased. The salary of the plant’s quality control inspector, who inspects each batch of products. The cost of water and sewer service to the manufacturing plant. The local municipality charges a fixed rate per gallon for usage up to 10,000 gallons and a higher charge per gallon for usage above that point. The cost of an internet connection of $23 per month. The cost of an internet connection of $10 per month plus $2 per hour of usage above 10 hours. The cost to make copies of a given document at a printing shop, where the per-copy charge is reduced for customers who make more than…arrow_forwardCalculating and Interpreting Activity-Based Costing Data Hiram’s Lakeside is a popular restaurant located on Lake Washington in Seattle. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. The intern, in consultation with the owner, identified three major activities and then completed the first-stage allocations of costs to the activity cost pools. The results appear below. The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries. Some costs, such as the cost of cleaning the linens that cover the restaurant’s tables, vary with the number of parties served. Other costs, such as washing plates and glasses, depend on the number of diners served or the number of drinks served. Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant.…arrow_forward
- Activity-Based Costing; Customer Group Cost Analysis Franklin Furniture Inc. (FFI) manufactures bedroom furniture in sets (a set includes a dresser, two queen-size beds, and one bedsidetable) for use in motels and hotels. FFI has three customer groups, which it calls the value, quality,and luxury groups. The value products are targeted to low-price motels that are looking for simplefurniture, while the luxury furniture is targeted to the very best hotels. The value line is attractive toa variety of hotels and motels that appreciate the combination of quality and value. Currently therehas been a small increase in the quality and value lines, and an appreciable increase in demand in theluxury line, reflecting cyclical changes in the marketplace. Luxury hotels are now in more demandfor business travel, while a few years ago, the value segment was the most popular for business travelers. FFI wants to be able to respond to the increased demand with increased production but worriesabout the…arrow_forwardJane’s Cookhouse is a popular restaurant located in a scenic setting. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an ABC study. The intern, in consultation with the owner, identified three major activities. The intern then completed the first-stage allocations of costs to the activity cost pools, using data from last month’s operations. The results appear below: Activity Cost Pool Activity Measure Total Cost Total Activity Serving a party of diners Number of parties served $ 16,585 5,350 parties Serving a diner Number of diners served $ 107,010 13,050 diners Serving a drink Number of drinks ordered $ 35,310 10,700 drinks The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries. A group of diners who ask to sit at the same table are counted as a party. Some costs, such as the…arrow_forwardAs a new graduate employee in a hospitality company, you are being introduced to the staff. The company owns several businesses. You have been informed that your initial job will require you to analyse the costing system of a restaurant (Café Deluxe) which is situated on a beach side tourist area. Your supervisor has recently attended a business conference where he was introduced with an improved costing system, Activity Based Costing. Café Deluxe presently uses traditional costing method and they want your help to explore the adoption of Activity based costing systems. In your first visit you have noticed that it is a sit-down restaurant and offers menu dining. The corporate marketing manager is considering introducing a buffet menu at Café. Required: a) Explain the types of decisions Café Deluxe faces under normal business circumstances and the associated management accounting information required by the Café management. b) Do you think the profitability of restaurant services…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College