1. A bakeshop has recorded sales (in dozens) for three products, as shown belowboar en 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 AAT& AUO Cupcakes ATe OMA SAM MEMEED AOorron Clanamon 0 Buns AUDY 3DA8AM CMA OT YMA Blueberry LE MT STRMulfins AROW Day 1 3VA TOUE 30 45 34 STUO 17 TARD 26 32 19 27 4 19 23 5. 22 22 23 48 34 23 29 8. 25 20 29 24 14 10 31 26 18 11 35 27 47 12 31 28 26 13 14 34 31 24 a salhequs 33 31slum 2rfordelicet 30 ch lebisozd to sau sth no 15 alasero qolaveb o 2oidsi16V grome 2. Freight car loadings over a 12-year period at a busy port are as follows: sra obonÍ 19iqe aid ni bsdinzob 29uptadosi sviislifsup odT 21tolplyo E12bas Tegensot ban anoinigo ovitugexe Number Week Week Number Week Number Em ow pinda460icloozes 475 500 rfT 1 220 350 13 245 360 14 goibsrimx9 sit no 400 3 280 6. 15 4. 275 380 16 510 300 11 420 17 525 01 1qma18 2supinrbe541 vbsihozzA nodsups odn nolteicotoi rris atstoriooi 6 SE 2b 310 12 nsbi 450 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 &00 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 belowboar en 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 AAT& AUO Cupcakes ATe OMA SAM MEMEED AOorron Clanamon 0 Buns AUDY 3DA8AM CMA OT YMA Blueberry LE MT STRMulfins AROW Day 1 3VA TOUE 30 45 34 STUO 17 TARD 26 32 19 27 4 19 23 5. 22 22 23 48 34 23 29 8. 25 20 29 24 14 10 31 26 18 11 35 27 47 12 31 28 26 13 14 34 31 24 a salhequs 33 31slum 2rfordelicet 30 ch lebisozd to sau sth no 15 alasero qolaveb o 2oidsi16V grome 2. Freight car loadings over a 12-year period at a busy port are as follows: sra obonÍ 19iqe aid ni bsdinzob 29uptadosi sviislifsup odT 21tolplyo E12bas Tegensot ban anoinigo ovitugexe Number Week Week Number Week Number Em ow pinda460icloozes 475 500 rfT 1 220 350 13 245 360 14 goibsrimx9 sit no 400 3 280 6. 15 4. 275 380 16 510 300 11 420 17 525 01 1qma18 2supinrbe541 vbsihozzA nodsups odn nolteicotoi rris atstoriooi 6 SE 2b 310 12 nsbi 450 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 &00 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 2 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.
Step by step
Solved in 2 steps with 3 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.