ZuoTi.Pro
Question

to tively appears to be happening? Can you intu the demand in November? Given the following data, use a trend line predict de
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Seasonal Average Seasonal factorForecast for the year 2018 Intercep 141.25 Year 2014 ual Trend Forecastin Period 201.521 0.87

Formula

1 B C D E F G H I J K L M N
2 Year 2014 2015 2016 2017 Seasonal Average Seasonal factor Forecast for the year 2018 Intercept =INTERCEPT(M4:M19,J4:J19) Slope =SLOPE(M4:M19,J4:J19)
3 Season Period Year Season Actual Trend Forecasting
4 Winter 123 155 151 178 =AVERAGE(C4:F4) =G4/$C$12 =H4*N20 1 2014 Winter 123
5 Spring 133 189 186 225 =AVERAGE(C5:F5) =G5/$C$12 =H5*N21 2 Spring 133
6 Summer 172 186 288 272 =AVERAGE(C6:F6) =G6/$C$12 =H6*N22 3 Summer 172
7 Fall 281 225 303 296 =AVERAGE(C7:F7) =G7/$C$12 =H7*N23 4 Fall 281
8 5 2015 Winter 155
9 Average =AVERAGE(C4:C7) =AVERAGE(D4:D7) =AVERAGE(E4:E7) =AVERAGE(F4:F7) 6 Spring 189
10 Total =SUM(C4:C7) =SUM(D4:D7) =SUM(E4:E7) =SUM(F4:F7) 7 Summer 186
11 Grand Total =SUM(C4:F7) 8 Fall 225
12 Overall Average =AVERAGE(C4:F7) 9 2016 Winter 151
13 10 Spring 186
14 11 Summer 288
15 12 Fall 303
16 13 2017 Winter 178
17 14 Spring 225
18 15 Summer 272
19 16 Fall 296
20 17 2018 Winter =$K$2+(J20*$M$2)
21 18 Spring =$K$2+(J21*$M$2)
22 19 Summer =$K$2+(J22*$M$2)
23 20 Fall =$K$2+(J23*$M$2)
0 0
Add a comment
Know the answer?
Add Answer to:
To tively appears to be happening? Can you intu the demand in November? Given the following data,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 5.6 Given the following data, use a trend line and seasonals to predict demand for 20X8. Year 20X...

    5.6 Given the following data, use a trend line and seasonals to predict demand for 20X8. Year 20X4 20X5 20X6 WinterSpring Summer 133 189 186 225 Fall 281 286 303 296 123 155 151 178 172 205 288 272 20X7 ease espn step G4ex Pl 5.6 Given the following data, use a trend line and seasonals to predict demand for 20X8. Year 20X4 20X5 20X6 WinterSpring Summer 133 189 186 225 Fall 281 286 303 296 123 155 151 178...

  • 33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...

    33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...

  • Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with ...

    Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with alphabetically both rows and columns I was successful with these steps but I am stuck with next step below is my code and screenshot import numpy as np import pandas as pd data=pd.read_csv("/Users/superman/Downloads/words_file2.txt",header=None) df_input=pd.DataFrame(data) df_output=pd.DataFrame(np.arange(676).reshape((26,26)), index = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'], columns = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z']) df_output.index.name="Start" df_output.columns.name="End" df_output This below screen shot is what I have to find I have to find each word...

  • Please determine the IDENTITY of the unknown compound and explain how each peak / data point...

    Please determine the IDENTITY of the unknown compound and explain how each peak / data point from the following instruments led to that identification. What does the gcms indicate. Thank you very much! (The GCMS data is just a long set of numbers which is why the question appears so long). IR of unknown: NMR unknown Proton Graphs (first is overall graph, others that follow are zoomed in sections): NMR unknown Carbon Graphs (first is overall graph, others that follow...

  • If the two signal handling functions in 3000pc were replaced by one function, would there be...

    If the two signal handling functions in 3000pc were replaced by one function, would there be any significant loss of functionality? Briefly explain /* 3000pc.c */ 2 3 4 5 6 7 8 #include <stdio.h> 9 #include <stdlib.h> 10 #include <unistd.h> 11 #include <sys/mman.h> 12 #include <errno.h> 13 #include <string.h> 14 #include <sys/types.h> 15 #include <sys/wait.h> 16 #include <semaphore.h> 17 #include <string.h> 18 #include <time.h> 19 20 #define QUEUESIZE 32 21 #define WORDSIZE 16 22 23 const int wordlist_size =...

  • HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data...

    HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data link fir this data it’s all in photos.... thank you i have already posted the question We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...

  • Code is in C# Your instructor would like to thank to Marty Stepp and Hélène Martin...

    Code is in C# Your instructor would like to thank to Marty Stepp and Hélène Martin at the University of Washington, Seattle, who originally wrote this assignment (for their CSE 142, in Java) This program focuses on classes and objects. Turn in two files named Birthday.cs and Date.cs. You will also need the support file Date.dll; it is contained in the starter project for this assignment. The assignment has two parts: a client program that uses Date objects, and a...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT