Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A chilled orange juice warehousing operation is experiencing too many out-of-stock situations with its 96 ounces containers. To better understand the current and future demand

  1. A chilled orange juice warehousing operation is experiencing too many out-of-stock situations with its 96 ounces containers. To better understand the current and future demand for this product, the company examined the last 36 days of sales, shown in the table below.

  1. Construct a scatter plot of these data, find the equation that can be used to predict demand, and used this equation to predict sales in the 37th period.
  2. Use a 5-period moving average to forecast sales for the 37th period.
  3. Which in your opinion is the better forecast? (10 Points)

Bank

Demand for 96 oz. Container

1

4578

2

4239

3

2754

4

4501

5

4016

6

4680

7

4950

8

3303

9

2367

10

3055

11

4248

12

5067

13

4201

14

5133

15

4211

16

3195

17

5760

18

5661

19

6102

20

6099

21

5902

22

2295

23

2682

24

5787

25

3339

26

3798

27

2007

28

6282

29

3267

30

4779

31

9000

32

9531

33

3823

34

8964

35

6984

36

6660

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_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Finance questions

Question

6. From a value standpoint, what is the efficiency of a process?

Answered: 1 week ago