1. A bakeshop has recorded sales (in dozens) for three products, as shown below: a. Predict orders for the following day for each of the products using an appropriate naive method. Hint: Plot each data set. b. What should the use of sales data instead of demand imply? CHAOA YDAATE AO Cupcakes ATe ONA SAM Blueberry Clanamon Buns BUDY 3D48AM CMA TARS AROW LE MT STRMuffins Day 13VA TOUT 30 45 34 STUO 17 26 32 19 27 19 22 6. 48 23 29 8. 25 20 29 24 14 10 31 26 18 11 35 27 47 12 31 28 26 13 ilaup 2 29 31 37 14 34 24 33 Ixa Jngbut no var 2ibor sviileu0 lebisoaid to sau srb no vis 31sium 15 alasero qolaveb o 2oidsi16V guome 2. Freight car loadings over a 12-year period at a busy port are as follows: 21nolpigo leizbas Tegensor baa anotnigo ovitusexe.a Number Week Number Week Week Number sm ow Upind460 sloozes 475 1 220 350 13 245 8. 360 14 3sb 400 500 sdT 4. 275 380 510 525 odziw 0f 1qm18 25upiarbe541 vbsboz2A 16 300 11 420 17 6 SE 2b 310 12 450 enodsups cin naltsiotoi Isrls atstoriont a. Determine a linear trend line for expected freight car loadings. b. Use the trend equation to predict expected loadings for weeks 20 and 21. C. The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately what week?
1. A bakeshop has recorded sales (in dozens) for three products, as shown below: a. Predict orders for the following day for each of the products using an appropriate naive method. Hint: Plot each data set. b. What should the use of sales data instead of demand imply? CHAOA YDAATE AO Cupcakes ATe ONA SAM Blueberry Clanamon Buns BUDY 3D48AM CMA TARS AROW LE MT STRMuffins Day 13VA TOUT 30 45 34 STUO 17 26 32 19 27 19 22 6. 48 23 29 8. 25 20 29 24 14 10 31 26 18 11 35 27 47 12 31 28 26 13 ilaup 2 29 31 37 14 34 24 33 Ixa Jngbut no var 2ibor sviileu0 lebisoaid to sau srb no vis 31sium 15 alasero qolaveb o 2oidsi16V guome 2. Freight car loadings over a 12-year period at a busy port are as follows: 21nolpigo leizbas Tegensor baa anotnigo ovitusexe.a Number Week Number Week Week Number sm ow Upind460 sloozes 475 1 220 350 13 245 8. 360 14 3sb 400 500 sdT 4. 275 380 510 525 odziw 0f 1qm18 25upiarbe541 vbsboz2A 16 300 11 420 17 6 SE 2b 310 12 450 enodsups cin naltsiotoi Isrls atstoriont a. Determine a linear trend line for expected freight car loadings. b. Use the trend equation to predict expected loadings for weeks 20 and 21. C. The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately what week?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Answer number 1 only. Full solution. Unique answers only.
Transcribed Image Text:1. A bakeshop has recorded sales (in dozens) for three products, as shown below:
a. Predict orders for the following day for each of the products using an appropriate
naive method. Hint: Plot each data set.
b. What should the use of sales data instead of demand imply?
CHAOA YD AATE AUO
Cupcakes ATe OMA SAM
ICY CO
Cianamon
Blueberry
Muffins
ARO
Co.20
AUDY 3518 AM CA
ARS
Day
13VA TOUE 30
45
34
17
26
27
19
4.
19
23
22
22
23
48
7.
23
29
8.
36
25
20
29
24
14
10
31
26
18
11
35
27
47
12
31
26
aasb ad u 2s 27.in/ost gai250910
31
13
14
34
24
31slumm
15
lebisolaid to sau arh no
alaserol qulavab o 2oidsi16V gnome
2. Freight car loadings over a 12-year period at a busy port are as follows:
21noinio le12 bas Tegenso ba anoinigo
Number
Week
Week
Number
Week
Number
Em ow
350
upind 460
475
1
220
7
13
245
360
14
pirotello goibsrims sdi to
400
280
6.
15
500
4
275
10
380
16
510
420
bisqicnoue wsqe ph
300
11
17
525
6 SE 2b 310
uftni 12 nsbi, vib 450 01 8 25pinrbe541 vdsinoz2A
a. Determine a linear trend line for expected freight car loadings.
b. Use the trend equation to predict expected loadings for weeks 20 and 21.VOSTUD
c. The manager intends to install new equipment when the volume exceeds 800
loadings per week. Assuming the current trend continues, the loading volume will
reach that level in approximately what week?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.