Forecasting at Hard Rock Cafe Essay

Pam and Susan’s department stores are in the process of opening a new business unit. There are two locations that are being considered for the new store and decision is based upon estimates of sales for both of them. My job is to use data gathered from each store as well census data in store’s trading zones to predict sales at both of the sites that are being consider for their newest store.

The case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential, and for this purpose, you will need to develop a multiple regression model to predict sales. Specific case questions are given in the textbook, and the necessary data is in the file named pamsue.xls.

The Regional Food Manager for Ye Olde FoodKing Company has retained Mark Craig of Blue Steel Consulting to perform a regression analysis to forecast demand of your product. The four characteristics readily available included price, competitors’ price, average income, and market population. The results of each regression analysis are presented at the end of this memo. The remainder of this memo describes the regression analysis used and limitations to the data available. Running a regression provides a statistical procedure to estimate the liner dependency of one or more

* Forecasting is an impartial strategic ingredient that will ensure apt base for reputable planning. Our forecast is always the first step in developing plans in running the business along with our future plans of growth strategies. With this tool, we are able to anticipate our sales within reason that then can allow for us to control our costs in conjunction with inventory which will then help us to enhance our customer service. Sales forecasting is a vital strategic tactic in our company’s methodology.

Using MINITAB run the multiple regression analysis using the variables CALLS, TIME, and YEARS to predict SALES. State the equation for this multiple regression model.

For our Gemba project, we decided to analyze the order fulfillment procedure for Cup of Joe, a coffee shop located in the Lennox Town Center. In order to capture the establishment’s peak hours of business, we primarily visited during the hours of 9:00am-12:00pm. We focused our attention on orders for baked goods, coffee, and espresso drinks, as these products are the shop’s main source of revenue and reputation. On several separate mornings we were able to observe an average of 125 orders over three hours (a takt time of 1.44 minutes). In the evening, there were often less than a dozen orders every hour. Since every order is slightly different, we have described the average order and the steps in the process that are consistent in almost every situation. We have identified multiple areas for improvement, which are referenced in the sections entitled analysis and recommendations.

After analyzing past customer preferences, in 2010 store 88 initiated a promotion to increase mid-week sales to even out demand. In the past approximately 80% of services were incurred on Friday, Saturday and Monday, compared to 20% incurred on Tuesday, Wednesday and Thursday. To even out the demand for services, the store initiated a program to decrease the service price to $18 on Tuesdays, Wednesdays, and Thursdays and increase the price to $30 on Fridays, Saturdays, and Mondays. Through careful scheduling of staff, budgeted labor time was also decreased from 2,500 hours to 2,250 hours per employee.

1. Identify the key problem in the case and explaining why it is the key problem.

Forecasting is the methodology utilized in the translation of past experiences in an estimation of the future. The German market presents challenges for forecasting techniques especially for its retail segment. Commercially oriented organizations are used to help during forecasting as general works done by academic scientists are not easy to come across (Bonner, 2009).

The model analyses quarter by quarter. As off now the budget and expected revenue is as follows:

Ferguson, M. E., Crystal, C. R., Higbie, J., & Kapoor, R. (2007). A Comparison of Unconstraining Methods to Improve Revenue Management Systems (ed. 3).

Using the regression results and the other computations from Assignment 1, determine the market structure in which the low-calorie frozen, microwavable food company operates.

1. Tutti’s Sandwich Shop has the following information regarding costs at various levels of monthly sales. Help Tutti separate her costs into fixed costs and variable costs so that she can predict and evaluate costs at varying levels of guests served.

The procedure for this model is to collect several periods of history relating to the independent and dependent variables themselves, establish the relationship that minimizes mean squared error of forecast vs actual using linear or non-linear and singular or multiple regression analysis.

There are quite a number of financial statements that are associated with the the food and beverage production and services system. These financial statements includes sales records, standard amount and the actual amount of foods and beverages that the establishment sells. The variance analysis is a good tool for planning and enables an establishment to have a grasp of the current costs of food items. Every food service manager must be concerned with the cost of foods including the cost related to the