My Submissions

Part 1

Title Start Date Due Date Post Date Marks Available

Research/Case Study - Part 1 6 Jan 2020 - 03:00 23 Feb 2020 - 02:59 20 Feb 2020 - 02:00 100

Summary:

Instructions and Submission

Due no later than 11:00 p.m. on Sunday of Unit 6 or as directed by your professor

Worth 14% of final grade

Late Submission Policy

This assignment is subject to the Late Submission penalty policy, namely 5% per day for three days.

This page will close and will not allow further submissions after this Late Submission period has expired.

In the event of an emergency preventing you from submitting within this time frame, special permission must be obtained from your instructor. Documentation substantiating emergency is required. In such a circumstance, if the extension is granted, the professor will reopen the submission function for you on an individual basis.

Please do not email your submissions to your professor, either before or after the due date; all coursework should be submitted through the online course (Moodle).

Objectives

Utilize the necessary and truthful information for analysis.

Formulate the problem with a correct POM model or techniques.

Explore all possible alternatives and investigate each one of them.

Make decisions given all the information.

Background

With the growth of the Hard Rock Caf franchisefrom one pub in London in 1971 to more than 129 restaurants in more than 40 countries todaycame a corporate-wide demand for better forecasting. Hard Rock Caf uses long-range forecasting in setting a capacity plan and intermediate-term forecasting for locking in contracts for leather goods (used in jackets) and for such food items as beef, chicken, and pork. Its short-term sales forecasts are conducted each month, by cafe, and then aggregated for a headquarters view.

The heart of the sales forecasting system is the point-of-sale system (POS), which, in effect, captures transaction data on nearly every person who walks through a cafes door. The sale of each entre represents one customer; the entre sales data are transmitted daily to the Orlando corporate headquarters database. There, the financial team, headed by Todd Lindsey, begins the forecast process. Lindsey forecasts monthly guest counts, retail sales, banquet sales, and concert sales (if applicable) at each cafe. The general managers of individual cafes tap into the same database to prepare a daily forecast for their sites. A cafe manager pulls up prior years sales for that day, adding information from the local Chamber of Commerce or Tourist Board on upcoming events such as a major convention, sporting event, or concert in the city where the cafe is located. The daily forecast is further broken into hourly sales, which drives employee scheduling. An hourly forecast of $5500 in sales, for example, translates into 19 workstations, which are further broken down into a specific number of wait staff, hosts, bartenders, and kitchen staff. Computerized scheduling software plugs in people based on their availability. Variances between forecast and actual sales are then examined to see why errors occurred.

Hard Rock Caf doesnt limit its use of forecasting tools to sales. To evaluate managers and set bonuses, a three-year weighted moving average is applied to cafe sales. If cafe general managers exceed their targets, a bonus is computed. Todd Lindsey, at corporate headquarters, applies weights of 40% to the most recent years sales, 40% to the year before, and 20% to sales two years ago in reaching his moving average.

An even more sophisticated application of statistics is found in Hard Rock Cafs menu planning. Using multiple regression, managers can compute the impact on demand of other menu items if the price of one item is changed. For example, if the price of a cheeseburger increases from $7.99 to $8.99, they can predict the effect this will have on sales of chicken sandwiches, pork sandwiches, and salads. Managers do the same analysis on menu placement, with the centre section driving higher sales volumes. When an item such as a hamburger is moved off the centre to one of the side flaps, the corresponding effect on related items, say French fries, is determined.

Hard Rock's Moscow Cafe

Requirement

Using the information about Hard Rock Caf provided, write a report that addresses the following areas:

Describe three different forecasting applications at Hard Rock Cafe, and why you think they are used the way they are. Name three other areas in which you think Hard Rock could use forecasting models.

The role of the POS system in forecasting at Hard Rock Cafe.

Justify the use of the weighting system used for evaluating managers for annual bonuses.

Name several variables besides those mentioned in the case that could be used as good predictors of daily sales in each cafe.

At Hard Rock Cafes Moscow location, the manager is trying to evaluate how a new advertising campaign affects guest counts. Using data for the past 10 months (see the table), develop a least squares regression relationship and then forecast the expected guest count when advertising is $65 000.