Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year. Room Revenue $8,713,000 Transient Rooms Sold 83,730 Group Rooms Sold 16,270 Total Rooms Sold 100,000 Operating Expenses Linen $31,100 Cleaning Supplies $24,000 Guest Supplies $104,800 Outside Services $24,000 Laundry $80,500 Concierge Expense $60,000 Office Supplies $19,200 Reservation Expenses Reservation Department $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Cost at $6 per transient res. $251,200 Total Reservation Expense $581,200 All other Expense $120,000 Total Operating Expenses $1,044,800 Total Operating Expense Percentage 12.0% Use the table above to answer Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room to whole cents, and round the percentage of sales to two decimals (i.e 0.33%). Use the laundry and reservation information as supplied. Office Supplies – What is the office supplies expense as a percentage of total room sales, for the first 6 months? 0.03% 0.22% 0.85% 1.23%
Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year. Room Revenue $8,713,000 Transient Rooms Sold 83,730 Group Rooms Sold 16,270 Total Rooms Sold 100,000 Operating Expenses Linen $31,100 Cleaning Supplies $24,000 Guest Supplies $104,800 Outside Services $24,000 Laundry $80,500 Concierge Expense $60,000 Office Supplies $19,200 Reservation Expenses Reservation Department $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Cost at $6 per transient res. $251,200 Total Reservation Expense $581,200 All other Expense $120,000 Total Operating Expenses $1,044,800 Total Operating Expense Percentage 12.0% Use the table above to answer Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room to whole cents, and round the percentage of sales to two decimals (i.e 0.33%). Use the laundry and reservation information as supplied. Office Supplies – What is the office supplies expense as a percentage of total room sales, for the first 6 months? 0.03% 0.22% 0.85% 1.23%
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter1: Introduction To Managerial Accounting
Section: Chapter Questions
Problem 6BE: Jakes Cabins is a small motel chain with locations near the national parks of Utah, Wyoming, and...
Related questions
Question
Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year.
Room Revenue $8,713,000
Transient Rooms Sold 83,730
Group Rooms Sold 16,270
Total Rooms Sold 100,000
Operating Expenses
Linen $31,100
Cleaning Supplies $24,000
Guest Supplies $104,800
Outside Services $24,000
Laundry $80,500
Concierge Expense $60,000
Office Supplies $19,200
Reservation Expenses
Reservation Department $150,000
Fixed Res Center Cost $180,000
Variable Reser. Center Cost at $6 per transient res. $251,200
Total Reservation Expense $581,200
All other Expense $120,000
Total Operating Expenses $1,044,800
Total Operating Expense Percentage 12.0%
Use the table above to answer
Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room to whole cents, and round the percentage of sales to two decimals (i.e 0.33%). Use the laundry and reservation information as supplied.
Office Supplies – What is the office supplies expense as a percentage of total room sales, for the first 6 months?
0.03%
0.22%
0.85%
1.23%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning