2
answers
0
watching
2,019
views
3 Dec 2017

EXERCISE 2-14 High-Low Method; Predicting Cost [L02-4, LO2-5] The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Guest-Days of Occupancy Custodial Supplies Expense Month March ....... April May June ...... July ........ August September ...... 4,000 6,500 8,000 10,500 12,000 9,000 7,500 $7,500 $8,250 $10,500 $12,000 $13,500 $10,750 $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 ver- tical axis and the number of guest-days occupied on the horizontal axis. Draw a straight line 4. through the two data points that correspond to the high and low levels of activity. Make sure your line intersects the Y-axis. 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? 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? 5. Net operating income. $ 6,000 $ 18,000 $ 30,000 Required: 1. Identify each of the company's expenses (including cost of goods sold) as either variable, fixed, or mixed. 2. Using the high-low method, separate each mixed expense into variable and fixed elements. State the cost formula for each mixed expense. 3. Redo the company's income statement at the 5,000-unit level of activity using the contribution format.

For unlimited access to Homework Help, a Homework+ subscription is required.

Avatar image
Read by 1 person

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Tod Thiel
Tod ThielLv2
5 Dec 2017
Already have an account? Log in

Related questions

Related Documents

Weekly leaderboard

Start filling in the gaps now
Log in