Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

cant quite figure these out. super urgent! 1. The lunch covers at SIU Student Center dining Room are forecasted based on moving average. The number

cant quite figure these out. super urgent! image text in transcribed
image text in transcribed
1. The lunch covers at SIU Student Center dining Room are forecasted based on moving average. The number of covers served by day for the first five weeks of the year are as follows (15 marks) Week 6 Day Week Week Week Week Week Week 6 3 week moving 5 week moving average method average method Monday 640 635 644 654 650 Tuesday 644 632 647 652 653 Wednesday 61 635 646 650 657 Thursday646 636 644651 651 Friday645 633 640 652 654 Required: Forecast the number of meals for each day of the week six using the three week and five week moving averages method method 2. The XYZ Hotel consists of 100 guestrooms and 100-seat coffee shop. 20 Marks) The average room rate is as follows. $ 100 $ 120 $ 150 Single Room Double Room King Suites The monthly occupancy is forecasted at 75 percent. The single, double room and king occupancies for the month of April are forecasted to be 30 percent, 40 percent and 30 percent respectively. The coffee shop is open for three meals each day and the average seat turmover and average check by meal period is as follows Average Check $7.50 12.50 $15.00 Seat Tumoxer Breakfast 1.4 1.6 1.2 Dinner Calculate the forecasted room revenues and the food revenues for the month of April Forecasted Room Revenues Type of Roorn Total Rooms Sold Month) apan y % Average Daily Forecasted Sales Total Sale Forecasted Food Revenues Meal No. of seats Seat Period No of days Average Meal Forecasted Sales Tunover in month United States) Focus F3 FS F6 F7 F8 F9

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

Step: 3

blur-text-image

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

Horngren S Financial And Managerial Accounting The Managerial Chapters RENTAL EDITION

Authors: Miller-Nobles

1st Edition

0136503748, 978-0136503743

More Books

Students also viewed these Accounting questions

Question

What are the characteristics of a virtual path?

Answered: 1 week ago

Question

3. How has e-commerce transformed marketing?

Answered: 1 week ago