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 solution
Chapter 2 Solutions
MANAGERIAL ACCT W/CONNECT >IC<
- Kindly help me with this General accounting questions not use chart gpt please fast given solutionarrow_forwardPlease explain the solution to this financial accounting problem with accurate principles.arrow_forwardHello tutor please given General accounting question answer do fast and properly explain all answerarrow_forward
- I need help solving this general accounting question with the proper methodology.arrow_forwardBased on the results of the Accounts Receivable Aging as of December 31, 2022 visualization, what conclusion can be made regarding the outstanding accounts receivables? a. The count of unpaid invoices was the highest for invoices within the 90+ days aging group and the lowest for invoices in the 31-60 days aging group. b. The count of unpaid invoices was the highest for invoices within the 31-60 days aging group and the lowest for invoices in the 90+ days aging group. c. The outstanding accounts receivable value for the 90+ days aging group is approximately the value of the other aging groups combined. d. The outstanding accounts receivable value for the 90+ days aging group is approximately twice the value of the other aging groups combined.arrow_forwardPlease given correct answer for General accounting question I need step by step explanationarrow_forward
- Based on the results of the Sales Total vs Sales Order Counts by Channel in 2022 visualization, how do the sales channels compare with each other? a. Website sales had the lowest number of sales orders, and the average value of the sales orders was lower compared to the other sales channels. b. B2B sales had the highest number of sales orders, and the average value of the sales orders was lower compared to the other sales channels. c. Storefront sales had the highest number of sales orders, and the average value of the sales orders was lower compared to the other sales channels. d. Storefront sales had the highest number of sales orders, and the average value of the sales orders was higher compared to the other sales channels.arrow_forwardPlease explain this financial accounting problem by applying valid financial principles.arrow_forwardI want to this question answer for Financial accounting question not need ai solutionarrow_forward
- I need help with this financial accounting question using accurate methods and procedures.arrow_forwardUsing the Sales Total vs Sales Order Counts by Channel in 2022 visualization, what trends are shown for the B2B sales channel? What recommendations do you have for management for the B2B strategy? What are some considerations when pursuing a B2B strategy?arrow_forwardCan you provide a detailed solution to this financial accounting problem using proper principles?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


