loader  Loading... Please wait...

Question(s) / Instruction(s):

1. The Bingo Hamburger Company has a chain of 12 stores in a large city.Sales figures and profits for the stores are given in the following table.Obtain a regression line for the data and predict profit for a store assuming sales of $10 million. X Y SalesProfits $7 $.15 2.10 6.13 4.15 14.25 15.27 16.24 12.20 14.27 20.44 15.34 7 .17 2.A manufacturer has experienced the following monthly demand for one of their products. MonthActual demand (in cases) February1500 March2860 April 2950 May 3490 June3000 a.Using a three month moving average, what would the forecast and MAD have been for July? b.What would the three-month weighted moving average (using .4, .4, .2) and MAD have been for July?What would the MAD be using a regression? c.Which forecasting method would you recommend?Why? 3. The ‚Å“K‚ Company has a chain of 12 stores in a Southeast.Sales figures and profits for the stores are given in the following table.Obtain a regression line for the data and predict profit for a store assuming sales of $20 million. X Y SalesProfits $9 $.20 8 .19 7.15 8.17 15.20 14.18 17.21 20.25 22.28 23.31 19.23 15.20 4.A manufacturer of mole and gopher poison has experienced the following monthly demand for an environmentally sound pesticide poison. MonthActual demand (in cases) February640 March840 April 770 May 950 June875 a.Using a Average method, what would the forecast have been for July? b.What would the unweighted three-month simple moving average have been for July? c.Which forecasting method would you recommend?Why?

Find Similar Answers by Subject


Student Reviews

Rate and review your solution! (Please rate on a Scale of 1 - 5. Top Rating is 5.)


Expert's Answer
Download Solution:
$1.79

This solution includes:

  • Plain text
  • Cited sources when necessary
  • Attached file(s)
  • Solution Document(s)



Reach Us

408-538-8534

20-3582-4059

39-008-4233

+1-408-904-6494