EXERCISE 2-14 High-Low Method: Predicting Cost [L02-4, L02-5]
The Lakeshore Hotel’s guest-days of occupancy and custodial supplies expense over the last seven months were:
Month | Guest-Daysof Occupancy | CustodialSupplies Expense |
March …. | 4,000 | $7,500 |
April …. | 6,500 | $8,250 |
May …. | 8.000 | $10500 |
June …. | 10,500 | $12,000 |
July …. | 12,000 | $13,500 |
August …. | 9,000 | $10,750 |
September …. | 7.500 | $9,750 |
Guest-days is a measure of the overall activity at the hotel. For example, a guest who stays at the hotel for three days is counted as three guest-days.
Required:
1. Using the high-low method, estimate a cost formula for custodial supplies expense.
2. Using the cost formula you derived above, what amount of custodial supplies expense would you expect to be incurred at an occupancy level of 11,000 guest-days?
3. Prepare a scattergraph using the data given above. Plot custodial supplies expense on the vertical axis and the number of guest-days occupied on the horizontal axis. Draw a straight line through the two data points that correspond to the high and low levels of activity. Make sure your line intersects the Y-axis.
4. Comment on the accuracy of your high-low estimates assuming a least-squares regression analysis estimated the total fixed costs to be $3,973.10 per month and the variable cost to be $0.77 per guest-day. How would the straight line that you drew in requirement 3 differ from a straight line that minimizes the sum of the squared errors?
5. Using the least-squares regression estimates given in requirement 4, what custodial supplies expense would you expect to be incurred at an occupancy level of 11,000 guest-days?
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Connect 1-Semester Access Card for Managerial Accounting
- The Coyle Shirt Company manufactures shirts in two departments: Cutting and Sewing. The company allocates manufacturing overhead using a single plantwide rate with direct labor hours as the allocation base. Estimated overhead costs for the year are $630,000, and estimated direct labor hours are 210,000. In June, the company incurred 18,200 direct labor hours. 1. 2. Compute the predetermined overhead allocation rate. Determine the amount of overhead allocated in June. The Coyle Shirt Company has refined its allocation system by separating manufacturing overhead costs into two cost pools-one for each department. (Click the icon to view the estimated costs and allocation data for each department.) 3. Compute the predetermined overhead allocation rates for each department. 4. Determine the total amount of overhead allocated in June. 1. Compute the predetermined overhead allocation rate. Begin by selecting the formula to calculate the predetermined overhead (OH) allocation rate. Then enter…arrow_forwardDecentralized businesses can have three responsibility centers that must be evaluated differently because of their functions. • Describe the three responsibility centers and give an example of each from your work. • Give an explanation about how each is evaluated. • Tell us why you would prefer to work in a centralized or decentralized organization. • Discuss which type of responsibility center you would prefer to manage and why.arrow_forwardDo fast this question answer general Accountingarrow_forward
- 12. Identify the following costs as preveron, appraisal, internal failure, or external failure: a. Inspection of final products b. Sales returns of defective products c. Employee training d. Reworking defective products e. Working with suppliers to ensure delivery of high-quality raw materials f. Costs of warranty repairs g. Product testing Type of cost Prevention Appraisal Internal failure External failurearrow_forwardYou invest $1,500 today to purchase a new machine that is expected to generate the following revenues over the next 4 years: Year 0 1 2 3 4 Cash flow -1500 300 475 680 490 Find the internal rate of return (IRR) from this investment. What would be the net present value (NPV) if the interest rate is 10%? An investment project provides cash inflows of $560 per year for 10 years. What is the project’s payback period if the initial cost is $2,500? What if the initial cost is $3,250? An investment project has annual cash inflows of $2,000, $2,500, $3,000, and $4,000, and a discount rate of 11%. What is the discounted payback period for these cash flows if the initial cost is $4,800? What if the initial cost is $5,600?arrow_forwardHow does the treatment of costs differ in ABC systems as opposed to traditional cost systems?arrow_forward
- Hii ticher please given correct answer general accountingarrow_forwardFinancial accountingarrow_forwardOn October 1, 2019, Ball Company issued 10% bonds dated October 1, 2019, with a face amount of $380,000. The bonds mature in 10 years. Interest is paid semiannually on March 31 and September 30. The proceeds from the bond issuance were $384,776.05 to yield 9.80%. Ball Company has a December 31 fiscal year-end and does not use reversing entries. Required: 1. Prepare journal entries to record the issuance of the bonds and the interest payments for 2019 and 2020 using the effective interest method. 2. Prepare journal entries to record the issuance of the bonds and the interest payments for 2019 and 2020 using the straight-line method.arrow_forward
- Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning