Harmon Foods Inc Case Solution

Case ID: 171248
Solution ID: 9172

Author: Frank Moore

Words: 1493

Price: $75

Harmon Foods Inc Case Analysis Overview

Speculation and dispatching have been a planning and resource allocation challenge. Multiple regressions are encouraged to be the appropriate response to overcome this challenge. Evaluation of regression coefficients permits a point by point appreciation of examples, regularity, and promoting impact.

Harmon Foods Inc Case Excel Calculations

Baseline regression

Case with Lag

Lag regression

Lag Residuals

80% interval

Sales prediction

Harmon Foods Inc Case Questions Answers

1. Build the regression model, starting with the independent variables in the file “harmon.xls”. Please include the regression output for your model in your report.

2. Argue that your model is good.

a. How does it compare with other possible models (if you include/remove some independent variables, etc.)?

b. Check whether the regression assumptions are satisfied (briefly summarize your conclusions from residual analysis).

3. For the next month, January 1988, the planned amount of Consumer Packs is 100 000 cases and Dealer Allowances are set at 500 000$. Use your model to predict sales in January 1988. Please report a point estimate and a 95% prediction interval.

4. Give a short interpretation for each of the regression coefficients in your model. Construct 80% confidence intervals for each coefficient.

5. If some extra budget becomes available, would you allocate it to Consumer Packs or to Dealer Allowances

Have different requirements for this essay?
Order custom essay
Total Price
$ 0.00