(Get Answer)
Expert Answer
Expert Answer
This solution was written by a subject matter expert. It's designed to help students like you learn core concepts. Demands Of Sea Food Essay Discussion Paper
ORDER YOUR PAPER NOW
- Explanation for step 1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 |
|
Year 2018
|
Year 2019
|
Year 2020
|
Seasonal Average
|
Seasonal Index
|
| 2 |
Spring
|
8
|
10
|
12
|
10
|
0.622
|
| 3 |
Summer
|
13
|
16
|
13
|
14
|
0.870
|
| 4 |
Fall
|
23
|
23
|
22
|
22.67
|
1.409
|
| 5 |
Winter
|
14
|
18
|
21
|
17.67
|
1.098
|
| 6 |
Global Average
|
16.083
|
|
|
|
|
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 |
|
Year 2018
|
Year 2019
|
Year 2020
|
Seasonal Average
|
Seasonal Index
|
| 2 |
Spring
|
8
|
10
|
12
|
=AVERAGE(B2:D2)
|
=E2/$B$6
|
| 3 |
Summer
|
13
|
16
|
13
|
=AVERAGE(B3:D3)
|
=E3/$B$6
|
| 4 |
Fall
|
23
|
23
|
22
|
=AVERAGE(B4:D4)
|
=E4/$B$6
|
| 5 |
Winter
|
14
|
18
|
21
|
=AVERAGE(B5:D5)
|
=E5/$B$6
|
| 6 |
Global Average
|
=AVERAGE(B2:D5)
|
|
|
|
|
| A | B | C | D | |
|---|---|---|---|---|
| 1 |
Period
|
Demand
|
Regression forecast
|
Intercept
|
| 2 |
1
|
8
|
12.72
|
12.11
|
| 3 |
2
|
13
|
13.33
|
Slope
|
| 4 |
3
|
23
|
13.94
|
0.61
|
| 5 |
4
|
14
|
14.55
|
|
| 6 |
5
|
10
|
15.17
|
|
| 7 |
6
|
16
|
15.78
|
|
| 8 |
7
|
23
|
16.39
|
|
| 9 |
8
|
18
|
17.00
|
|
| 10 |
9
|
12
|
17.61
|
|
| 11 |
10
|
13
|
18.22
|
|
| 12 |
11
|
22
|
18.84
|
|
| 13 |
12
|
21
|
19.45
|
|
| 14 |
13
|
|
20.06
|
|
| 15 |
14
|
|
20.67
|
|
| 16 |
15
|
|
21.28
|
|
| 17 |
16
|
|
21.90
|
|
| A | B | C | D | |
|---|---|---|---|---|
| 1 |
Period
|
Demand
|
Regression forecast
|
Intercept
|
| 2 |
1
|
8
|
=$D$2+($D$4*A2)
|
=INTERCEPT(B2:B13,A2:A13)
|
| 3 |
2
|
13
|
=$D$2+($D$4*A3)
|
Slope
|
| 4 |
3
|
23
|
=$D$2+($D$4*A4)
|
=SLOPE(B2:B13,A2:A13)
|
| 5 |
4
|
14
|
=$D$2+($D$4*A5)
|
|
| 6 |
5
|
10
|
=$D$2+($D$4*A6)
|
|
| 7 |
6
|
16
|
=$D$2+($D$4*A7)
|
|
| 8 |
7
|
23
|
=$D$2+($D$4*A8)
|
|
| 9 |
8
|
18
|
=$D$2+($D$4*A9)
|
|
| 10 |
9
|
12
|
=$D$2+($D$4*A10)
|
|
| 11 |
10
|
13
|
=$D$2+($D$4*A11)
|
|
| 12 |
11
|
22
|
=$D$2+($D$4*A12)
|
|
| 13 |
12
|
21
|
=$D$2+($D$4*A13)
|
|
| 14 |
13
|
|
=$D$2+($D$4*A14)
|
|
| 15 |
14
|
|
=$D$2+($D$4*A15)
|
|
| 16 |
15
|
|
=$D$2+($D$4*A16)
|
|
| 17 |
16
|
|
=$D$2+($D$4*A17)
|
|
| A | B | C | D | |
|---|---|---|---|---|
| 1 |
|
Forecast data for 2021
|
Seasonal Index
|
Final forecast for 2021
|
| 2 |
Spring
|
20.06
|
0.622
|
12.47
|
| 3 |
Summer
|
20.67
|
0.870
|
17.99
|
| 4 |
Fall
|
21.28
|
1.409
|
30.00
|
| 5 |
Winter
|
21.90
|
1.098
|
24.05
|
| A | B | C | D | |
|---|---|---|---|---|
| 1 |
|
Forecast data for 2021
|
Seasonal Index
|
Final forecast for 2021
|
| 2 |
Spring
|
20.0606060606061
|
0.621761658031088
|
=B2*C2
|
| 3 |
Summer
|
20.6724941724942
|
0.870466321243523
|
=B3*C3
|
| 4 |
Fall
|
21.2843822843823
|
1.40932642487047
|
=B4*C4
|
| 5 |
Winter
|
21.8962703962704
|
1.09844559585492
|
=B5*C5
|
- Explanation for step 2
| A | B | |
|---|---|---|
| 1 |
|
Seasonal Index
|
| 2 |
Spring
|
0.622
|
| 3 |
Summer
|
0.870
|
| 4 |
Fall
|
1.409
|
| 5 |
Winter
|
1.098
|
|
|
Final forecast for 2021
|
|
Spring
|
12.47
|
|
Summer
|
17.99
|
|
Fall
|
30.00
|
|
Winter
|
24.05
|
This question has already been tackled by one of our writers and a good grade recorded. You can equally get high grades by simply making your order for this or any other school assignment that you may have.
Every Student Buys Essays from us, here is why!
Pressed for time to complete assignments or when you feel like you cannot write, you can purchase an essay on our website. Some students also want model papers to use as samples when revising or writing. There are also students who approach our essay writing service to beat deadlines. We handle every type of homework, assignment, and academic writing tasks. You can buy college essays and other assignments here. At a glance, here are some reasons students prefer our website.
100% Original Essays and Papers
You can be sure that you are getting a paper that is custom written based on your instructions. We do not sell papers that are pre-written. Instead, we write every essay from scratch. When you say “write my essay,” we respond by giving you a paper that is 100% original and free of any plagiarism. The essays you purchase from us have never been sold anywhere.
Flexible & Affordable Prices
It does not cost a fortune to get academic writing help on our website. If you have a question from class, place an order, get a discount, and get cheap essay writing services. What you see as the price is what you pay for. There are no any hidden charges. If you need urgent papers, they might cost a little more, but the price is worth the quality you get in the end. Hire a professional academic writer beginning from $13 a page.
Anonymity, Privacy, and Confidentiality
No one will ever know that you purchased an essay or assignment from our website. The essays you buy from us are written by experts. Your data is only used to coordinate the essay writing services you get. No one can access your personal information and data. Go ahead and order an essay from our website. It is safe, secure, and convenient.