Question

The Lakeshore Hoters guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August Guest-Days of Supplies Expense S 13,100 s12,600 15,100 11,000 16,600 18,600 17,800 15,100 7,500 7,000 9,500 13,000 12,000 9,500 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. (Do not round your intermediate calculations and Round the Variable cost por quest-day to 2 decimal points) Quest-Days Supplies High activity level Low activity level Change Variable cost per guest-day Fixed cost per month per guest-day
formula you derived above, what amount of custodial supplies expense would you expect to be incurred at an occupanoy Intermedlate calculations.) level of 12,200 guest-days? (Do not round your Variable cost Flxed cost Total cost
3. Prepare a scattergraph using the data given above. (Place custodial supplies expense on the vertical axis and guest-days on the hortzoalaxis. Rtound your plotting points to the nearest hundredth value.) Instructions: 1.On the graph below, use the point tool (Mar) to plot custodial supplies expense on the vertical axis and guest-days on the horizontal axis. 2. Repeat the same process for the plotter tools (Apr, May, June, July, Aug, Sep). 3. To enter exact coordinates, click on the point and enter the values of x and y 4. To remove a point from the graph, click on the point and select delete option. May 00 10000 4000 18000 18000 Guest Days
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
The Lakeshore Hoter's guest-days of occupancy and custodial supplies expense over the last seven months were:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were:...

    The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August September Guest-Days of Occupancy 8,500 •8,000 10,500 12,000 14,000 13,000 10,500 Custodial Supplies Expense $ 14,100 $ 13,600 $ 16,100 $ 17,600 $ 19,600 $ 18,600 $ 16,100 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:...

  • The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:...

    The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Month March April May June July August September Occupancy Days 18,300 12,740 15,360 29,400 25,800 18,000 15,100 Custodial Supplies Expense $ 16,700 17,250 20,150 23,350 26,000 20,750 20,000 Occupancy-days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days. Required: 1. Using the high-low method, estimate...

  • The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:...

    The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Month March April May June July August September Occupancy-Days 6.900 7.900 13,600 20,500 25,500 17,800 15,000 Custodial Supplies Expense $ 14,430 15,150 19,420 23,950 27,450 20,710 19,450 Occupancy-days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days. Required: 1. Using the high-low method, estimate a...

  • The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:...

    The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Month March April May June July August September Occupancy-Days 6.900 7.900 13,600 20,500 25,500 17,800 15,000 Custodial Supplies Expense $ 14,430 15,150 19,420 23,950 27,450 20,710 19,450 Occupancy-days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days. Required: 1. Using the high-low method, estimate a...

  • Homework EXERCISE 2-14 High-Low Method; Predicting Cost The Lakeshore Hotel's guest-days of occupancy and custodial supplies...

    Homework EXERCISE 2-14 High-Low Method; Predicting Cost The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August September Guest Days of Occupancy 4,000 6.500 8,000 10,500 12,000 9,000 7,500 Custodial Supplies Expense $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....

  • NISE 3-5 High-Low Method; Predicting Cost [L01. L031 ashore Hotel's guest-days of occupancy and custodial supplies...

    NISE 3-5 High-Low Method; Predicting Cost [L01. L031 ashore Hotel's guest-days of occupancy and custodial supplies expense over the last seven The Lakeshore Hotel's months were: Month Guest-Days of Occupancy Custodial Supplies Expense March April May ..... June ... July August .. September ..... 4,000 6,500 8,000 10,500 12,000 9,000 $7,500 $8,250 $10,500 $12,000 $13,500 $10,750 $9,750 7,500 Guest-days is a measure of the overall activity at the hotel. For example, a guest who stays at the hotel for three...

  • Check my we 1 10 D The Lakeshore Hotel's occupancy days and custodial supplies expense over...

    Check my we 1 10 D The Lakeshore Hotel's occupancy days and custodial supplies expense over the last seven months were as follows: Custod Occupancy Supplies Expense March 18, April 16,020 July August September 16,200 Occupancy days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days Required: 1. Using the high-low method estimate a cost formula for custodial supplies expense. (Round...

  • 1. Refer to Exercise 2-14 on page 55. Part 1 of 2. Using the formula format...

    1. Refer to Exercise 2-14 on page 55. Part 1 of 2. Using the formula format as shown on page 34 of the text, and using the High/Low Method, estimate a cost formula for custodial supplies expense for the Lakeshore Hotel. 2. Refer to Exercise 2-14, Part 2 of 2 on page 55. Using the cost formula derived in part one , the total amount of custodial supplies expense you would expect Lakeshore Hotel to incur at an occupancy level...

  • Wedst seven months were as Occupancy Days 18,200 12,660 15.240 29,100 25,200 17,600 14,900 Month March...

    Wedst seven months were as Occupancy Days 18,200 12,660 15.240 29,100 25,200 17,600 14,900 Month March April May June July August September Custodial Supplies Expense 511,960 12,330 16,520 20,300 23,120 17,210 16,290 - Occupancy-days are a measure of the overall activity at the hotel For example, when a guest stays at the hotell counted as three occupancy-days Required: 1. Using the high-low method estimate a cost formula for custodial supplies expense. (Round the "Fixed cost tot amount and "Variable cost'...

  • Guest-days is a messure of the overall activity at the hotel For esample, a guest who...

    Guest-days is a messure of the overall activity at the hotel For esample, a guest who stays at the fotee days is counted as ree est days 2 Using the coat formula you derived above, what amount of cusliodial supplies expense would you expect to be incumed a an occupancy level of 11,700 es-ays? (Ds not round your intemmediats 2Using the cost formula you derived above, what amount of custodial supplies expense wouid you expect to be inourred at an...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT