Concept explainers
The Lakeshore Hotel guest days of occupancy and custodial supplies expense over the last seven months were:
Month Guest Days of Occupancy Custodial Supplies Expense
March 4,000 $7,500
April 6,500 $8,250
May 8,000 $10,500
June 12,000 $13,500
July 9,000 $10,750
August 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:
- Use the High-Low method, estimate a cost formula for custodial supplies expense
- 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?
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 1 images
- The Calling Company has three departments that occupy floor space in the 50,000 square feet building it rents for $500,000 annually. Department A occupies 25,000 sq ft; Department B occupies 10,000 sq ft; and Department C occupies 15,000 sq ft. How much annual rent expense should be allocated to Department B?arrow_forwardBodow is an entertainment complex located in Trinidad & Tobago. It offers various activitiessuch as music, rides, slides, and souvenir shopping, and customers pay a fixed fee to enter.The complex has been in operation for the past seven years and remains open throughout theyear. However, weather-related issues often lead to a significant decrease in customerattendance, usually by 50%, on approximately 30 days each year.Bodow has experienced substantial success, with customer numbers increasing byapproximately 15% annually. Sales at Bodow are categorized as cash sales and credit cardsales. All ticket sales are recorded on a computer, including the amount of each sale and thenumber of tickets issued. This information is electronically transferred to the accounts office.Cash collected from each ticket office is counted by two accounts clerks and two securityguards before being banked daily. The total cash from each ticket office is reconciled with thesales information transferred from…arrow_forwardWithout calculations, determine the contribution margin at the break-even point. Break-even point $arrow_forward
- The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the shifts are 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. An officer beginning a shift at one of these times works for the next 8 hours. During normal weekday operations, the number of officers needed varies depending on the time of day. The department staffing guidelines require the following minimum number of officers on duty: Time of Day 8:00 a.m.-noon Noon-4:00 p.m. 4:00 p.m.-8:00 p.m. 8:00 p.m.-midnight Midnight-4:00 a.m. 4:00 a.m.-8:00 a.m. Minimum No. of Officers on Duty 5 6 9 7 4 6 Determine the number of police officers that should be scheduled to begin the 8-hour shifts at each of the six times to minimize the total number of officers required. If your answer is zero, enter "0". Starting Time Officers Starting 8:00 a.m. Noon 4:00 p.m. 8:00 p.m. Midnight 4:00 a.m.arrow_forwardYou are reviewing all customer complaints received in any one of your stores in a 12 month period. You want to know if there is a certain time of the working week in which you receive more complaints. please RANK the weekdays from the HIGHEST complaints reported to the LOWEST complaints reported for the last 8 months of the year.arrow_forwardSugar Magnolia Company operates a cafeteria for its employees. The number of meals served each week over the last seven weeks, along with the total costs of operating the cafeteria are given below: Meals Served Cafeteria Costs Week 1 1,625 $5,080 Week 2 1,325 $3,980 Week 3 1,550 $4,940 Week 4 1,400 $4,700 Week 5 1,650 $5,100 Week 6 1,800 $5,380 Week 7 1,975 $5,540 Week 8 2,000 $5,640 Assume that the relevant range includes all of the activity levels mentioned in this problem. Using the high-low method: the variable cost per meal served in the cafeteria would be estimated to be: $_____________________________ b.) the estimated fixed cost per week is: $______________________________arrow_forward
- Restaurant A serves lunch and dinner. It is open 5 days a week all year long. The total revenue for the past year was $1,000,000. The manager of Matt's Deli estimates that 52% of its revenue is provided by lunch service and the remainder by dinner service. Matt's has 50 seats, with a seat turnover rate of 7.3 for lunch and 4.8 for dinner. Determine the average check per meal for lunch. Select one: a. $237 b. $653 c. None of the available choices d. $333arrow_forwardThe manager at the Overton Hotel in Lubbock believes that the success of the Texas Tech Red Raider Basketball team has an impact on the occupancy rate at the hotel during the first quarter of every year. Below are the number of victories for the Red Raiders in during the last three seasons and the hotel occupancy rate. This year, (year 4) the Red Raiders Basketball Team is expected to win 28 games and the manager at the Overton has asked you to determine their first quarter occupancy rate for the upcoming year (year 4) using associative forecasting. Year Wins First Quarter Occupancy Rate 1 25 2 3 27 31 88.32% 91.25% Ⓒ90.29% Ⓒ86.36% 92.21% 80% 90% 93%arrow_forwardTravel offers helicopter service from suburban towns to John F. Kennedy International Airport in New York City. Each of its 10 helicopters makes between 1,000 and 2,000 round-trips per year. The records indicate that a helicopter that has made 1,000 round-trips in the year incurs an average operating cost of $350 per round-trip, and one that has made 2,000 round-trips in the year incurs an average operating cost of $300 per round-trip. Read the requirements LOADING... . Requirement 1. Using the high-low method, estimate the linear relationship y=a+bX, where y is the total annual operating cost of a helicopter and X is the number of round-trips it makes to JFK airport during the year.arrow_forward
- A quality control activity analysis indicated the following four activity costs of a hotel. Verifying credit card information $40,000 Customer service training 20,000 Discounting room rates due to poor customer service 16,000 Correcting charges to customer invoices 8,000 Total $84,000 Sales are $750,000 for the year. Prepare a cost of quality report. Round your answers to one decimal place, if necessary. Due to rounding there may be difference of 0.1 Cost of Quality Report Quality CostClassification Quality Cost Percent of TotalQuality Cost Percent ofTotal Sales Prevention $fill in the blank 1 fill in the blank 2 % fill in the blank 3 % Appraisal fill in the blank 4 fill in the blank 5 fill in the blank 6 Internal failure fill in the blank 7 fill in the blank 8 fill in the blank 9 External failure fill in the blank 10 fill in the blank 11 fill in the blank 12 Totals $fill in the blank 13…arrow_forwardPresented below are data on three promissory notes. Determine the missing amounts. (Use 360 days for calculation. Do not round intermediate calculations.) Date of Note Terms Maturity Date Principal Annual Interest Rate 60 April 1 $810,000 6 % tA $ days 30 July 2 70,800 % days 6 March 7 128,000 10 % $ months Total Interest $590arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education