Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A motel has an average room rate of$58,an occupancy rate of75%and the motel has100rooms.The double occupancy rate is40%.The spread of$20is wanted between single and double

  1. A motel has an average room rate of$58,an occupancy rate of75%and the motel has100rooms.The double occupancy rate is40%.The spread of$20is wanted between single and double room rate.Calculate the following,round to the nearest dollar:

a)Single room rate is$__________,b)Double room rate is$__________

a) Single rate$54

b) Double rate$64

a) Single rate$55

b)Double rate$75

a) Single rate$54

b) Double rate$74

a) Single rate$50

b) Double rate$70

2. NetFood Sales for a month were$84,400.The cost of food purchasedduring the month was3times the beginning inventory.Beginning food inventory was$14,800and ending inventory is$12,200.The restaurant served300employee meals during the month.Employee meals cost the restaurant approximately75cents per meal.The kitchen sent2cases of oranges to the bar during the month.One case of oranges cost$25.The managers issued$250of complimentary food to guests.The bar sent2cases of wine to the kitchen for cooking,one case of red wine and one case of white wine.The red wine cost$78and the white wine cost$78.Based on this information for the month calculate the following:

Cost of Food Purchased:$______________,Cost Food Used:$_____________Cost of Food Sold:$___________and the Cost of Food as a Percentage of Food Sales:____________%(round to the nearest whole number)

Cost of Food Purchased: $44,400

Cost Food Used: $47,000

Cost of Food Sold: $46,631

Cost of Food as a Percentage of Food Sales: 55%

Cost of Food Purchased: $59,200

Cost Food Used: $47,000

Cost of Food Sold: $44,400

Cost of Food as a Percentage of Food Sales: 53%

Cost of Food Purchased: $36,000

Cost Food Used: $46,631

Cost of Food Sold: $47,000

Cost of Food as a Percentage of Food Sales: 54%

3. A motel operation has 120 rooms. The previous year of operations reported an occupancy rate of 70 percent and the average room rate was $40.00. The owner is forecasting the occupancy rate to increase by 7 percent and the average room rate is to be increased by $5.00. Variable cost per room occupied is forecasted to be $8.50 per room. Determine the forecasted total sales revenue and total variable cost for the coming year of operations.

Total Sales Revenue: $____________Total Variable Cost: $_____________

Total Sales Revenue: $1,458,540,Variable Cost per room: $275,502

Total Sales Revenue: $1,517,670, Variable Cost per room: $175,502

Total Sales Revenue: $1,517,670,Variable Cost per room: $286,671

Total Sales Revenue: $1,458,540,Variable Cost per room: $175,502

4. A 150-seat restaurant caters to members only, opening for lunch 5 days a week and 7 days a week for dinner. Lunch seat turnover is 1.2 and dinner turnover is 2.3. Average check for lunch is $14.50 and dinner average check is $22.00. Calculate by meal period and total sales revenue forecast for the month of March. Assume 23 weekdays in March.

Lunch = $75,038

Dinner = 200,750

March total sales forecast = $330,788

Lunch = $60,030

Dinner = 235,290

March total sales forecast = $295,320

Lunch = $75,038

Dinner = 290,750

March total sales forecast = $330,788

Lunch = $75,038

Dinner = 255,750

March total sales forecast = $330,788

5. Sales revenue in Period 1 is $100,000 and food cost as a percentage of sales is 40%. Sales revenue in Period 2 is $104,000 and food cost as a percentage of sales is 44%. Calculate the dollar change and percentage change in food cost.

Dollar change = $5,760, Percentage change = 13.4%

Dollar change = $4,000, Percentage change = 10.0%

Dollar change = $5,760, Percentage change = 14.4%

Dollar change = $4,400, Percentage change = 4.0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Advanced Accounting in Canada

Authors: Hilton Murray, Herauf Darrell

8th edition

1259087557, 1057317623, 978-1259087554

More Books

Students also viewed these Accounting questions

Question

If the job involves a client load or caseload, what is it?

Answered: 1 week ago

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago