Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Car Wash Costs $ 11,500 $ 13,400 $ 12,300 $ 15,000 $ 16,700 $ 24,300 $ 22,700 $ 23,400 $ 23,300 $ 22,600 $ 11,200 $ 16,000 Month Rental Returns 2,500 January February March 2,500 2,800 April May June July August September October 3,100 3,700 5,100 5,600 5,600 4,800 4,100 2,200 3,000 November December 2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.)

Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Car Wash Costs $ 11,500 $ 13,400 $ 12,300 $ 15,000 $ 16,700 $ 24,300 $ 22,700 $ 23,400 $ 23,300 $ 22,600 $ 11,200 $ 16,000 Month Rental Returns 2,500 January February March 2,500 2,800 April May June July August September October 3,100 3,700 5,100 5,600 5,600 4,800 4,100 2,200 3,000 November December 2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.)

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter18: Pricing And Profitability Analysis

Section: Chapter Questions

Problem 1CE: Ventana Window and Wall Treatments Company provides draperies, shades, and various window...

See similar textbooks

Similar questions

Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Rental Car Wash Month Returns Costs January 2,400 $ 10,500 February 2,500 $ 12,900 March 2,700 $ 11,300 April 2,900 $ 13,500 May 3,600 $ 15,700 June 4,900 $ 22,300 July 5,500 $ 21,700 August 5,400 $ 20,900 September 4,700 $ 22,300 October November December 3,800 $ 19,600 2,100 $ 10,200 2,600 $ 12,500 . Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. (Round Fixed cost to the…
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month Rental Returns Car Wash Costs January 2,500 $ 11,600 February 2,500 $ 13,400 March 2,800 $ 12,400 April 3,100 $ 15,200 May 3,700 $ 16,800 June 5,200 $ 24,500 July 5,600 $ 22,800 August 5,600 $ 23,700 September 4,800 $ 23,400 October 4,200 $ 22,900 November 2,300 $ 11,300 December 3,000 $ 16,300 2. Using least-squares regression, estimate the variable cost…
Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,500 2,500 2,800 3,100 3,700 5,200 5,600 5,700 4,800 4,900 Fixed cost per month Variable cost per rental return 2,300 3,100 Exercise 5A-2 Part 2 (Algo) Car Wash Costs $ 11,800 $ 13,500 $ 12,600 $ 15,500 $ 17,000 $ 24,900 $ 23,000 $ 24,200 $ 23,600 $ 23,500 $ 11,500 $ 17,000 2. Using least-squares regression; estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal…
Kara Meyer, owner of Flower Power, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Meyer wants to set the delivery fee based on the distance driven to deliver the flowers. Meyer wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months: (Click the icon to view the data.) Read the requirements. Requirement 1. Determine the company's cost equation (use the output from the Excel regression). (Ro y = x + Data table Month January.. February March April May June July Miles Driven 16,400 17,500 15,000 16,100 17,300 15,600 14,500 Print Van Operating Costs $5,480 $5,400 $4,950 $5,270 $5,740 $5,440 $4,680 Done - X
Solve the following: A company recently established a branch to sell its most popular fan. The company purchases these fans and stores them in a warehouse. The fans are then shipped from the warehouse to both the home office and the new branch, FOB destination. Home office management is responsible for setting the transfer price of the fans charged to the branch in a manner that will measure the long-run incremental cost of supplying the fans to the branch on a continuing basis. Per unit costs for the fans are P50.00 purchase price P2.50 shipping cost to warehouse P3.00 handling cost including P1.00 of allocated administrative overhead P3.50 shipping cost to branch paid by home office P1.25 shipping cost to home office The minimum transfer price that home office should charge the branch to meet its measurement objective is?
Classifying Costs as Product or Period Costs Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. 1. Depreciation on salespersons’ cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors’ salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9.…
Cost Estimation; High-Low Method; MAPE Horton Manufacturing Inc. produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm’s profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours 1 $2,625 1,499 2 2,670 1,590 3 2,720 1,605 4 2,822 1,655 5 2,855 1,775 6 3,005 1,880 7 2,865 1,785 8 2,905 1,805 9 2,780 1,695 10…
Identifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent situations: a. A computer service agreement in which a company pays 150 per month and 15 per hour of technical time b. Fuel cost of the companys fleet of motor vehicles c. The cost of beer for a bar d. The cost of computer printers and copiers at your college e. Rent for a dental office f. The salary of a receptionist in a law firm g. The wages of counter help in a fast-food restaurant h. The salaries of dental hygienists in a three-dentist office. One hygienist can take care of 120 cleanings per month. i. Electricity cost which includes a 15 per month billing charge and an additional amount depending on the number of kilowatt-hours used Required: 1. For each situation, describe the cost as one of the following: fixed cost, variable cost, mixed cost, or step cost. (Hint: First, consider what the driver or output measure is. If additional assumptions are necessary to support your cost type decision, be sure to write them down.) Example: Raw materials used in productionVariable cost 2. CONCEPTUAL CONNECTION Change your assumption(s) for each situation so that the cost type changes to a different cost type. List the new cost type and the changed assumption(s) that gave rise to it. Example: Raw materials used in production. Changed assumptionthe materials are difficult to obtain, and a years worth must be contracted for in advance. Now, this is a fixed cost. (This is the case with diamond sales by DeBeers Inc. to its sightholders. See the following website for information: www.keyguide.net/sightholders/.)
Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)
Salem Electronics currently produces two products: a programmable calculator and a tape recorder. A recent marketing study indicated that consumers would react favorably to a radio with the Salem brand name. Owner Kenneth Booth was interested in the possibility. Before any commitment was made, however, Kenneth wanted to know what the incremental fixed costs would be and how many radios must be sold to cover these costs. In response, Betty Johnson, the marketing manager, gathered data for the current products to help in projecting overhead costs for the new product. The overhead costs based on 30,000 direct labor hours follow. (The high-low method using direct labor hours as the independent variable was used to determine the fixed and variable costs.) All depreciation. The following activity data were also gathered: Betty was told that a plantwide overhead rate was used to assign overhead costs based on direct labor hours. She was also informed by engineering that if 20,000 radios were produced and sold (her projection based on her marketing study), they would have the same activity data as the recorders (use the same direct labor hours, machine hours, setups, and so on). Engineering also provided the following additional estimates for the proposed product line: Upon receiving these estimates, Betty did some quick calculations and became quite excited. With a selling price of 26 and just 18,000 of additional fixed costs, only 4,500 units had to be sold to break even. Since Betty was confident that 20,000 units could be sold, she was prepared to strongly recommend the new product line. Required: 1. Reproduce Bettys break-even calculation using conventional cost assignments. How much additional profit would be expected under this scenario, assuming that 20,000 radios are sold? 2. Use an activity-based costing approach, and calculate the break-even point and the incremental profit that would be earned on sales of 20,000 units. 3. Explain why the CVP analysis done in Requirement 2 is more accurate than the analysis done in Requirement 1. What recommendation would you make?
Air Americo is about to introduce a daily round-trip flight from New York to Los Angeles and is determining how to price its round-trip tickets. The market research group at Air Americo segments the market into business and pleasure travelers. It provides the following information on the effects of two different prices on the number of seats expected to be sold and the variable cost per ticket, including the commission paid to travel agents: Price Charged Variable Costs per Ticket # of Seats Expected to be Sold Business Pleasure 800 2,100 75 300 150 185 285 30 Pleasure travelers start their travel during one week, spend at least I weekend at their destination, and return the following week or thereafter. Business travelers usually start and complete their travel within the same workweek. They do not stay over weekends. Assume that round-trip fuel costs are fixed costs of $24,500 and that fixed costs allocated to the round-trip flight for airplane-lease costs, ground services, and…
Suppose that you have been given a summer job as an Intern at Issac Alrcams, a company that manufactures sophisticated spy cameras for remote-controlled millitary reconnalssance alrcraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financlal statements before approving the loan. Requlred: Classify each cost listed below as elther a product cost or a perlod cost for the purpose of preparing financial statements for the bank. Costs Product Cost or Period Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9. Advertising costs.…