# TECHNOLOGY AND INFORMATION MANAGEMENT

1. Demand Forecasting for Tahoe Salt. Use Excel to work through the static forecasting for the Tahoe Salt problem (4th Edition, Chapter 7) Your results should match the given solution

Since there are an even number of period, I will have to find the average of two averages corresponding with periods 1-4 and 2-5. Example De-seasonalized Data Period 3: Ð2.5/= (8000+13000+23000+34000)/4 = 19500, Ð3.5/= (13000+23000+34000+10000)/4= 80000

Ð3/= (80000+19500) = 49750. The formula for this methodology is the following: Ðt/= [Dt-(p/2)+Dt+(p/2)+2]/2P. In excel use the following formulas to calculate the de-seasonalized data = (((SUM (Dt-2: Dt+1)/4) +(SUM (Dt-1: Dt+2)/4))/2) For Example: for period 8 = (((SUM (D7:D10)/4) +(SUM (D8:D11)/4))/2)

Results Column 5:

Run the Regression provided by Excel Solver to come up with the following Data

T: Trend = 524: Level = 18348.99

Regressed Equation: Regressed Demand = 18348.99+524t. Plugging =18439+A2*524 into Excel and copying down the Regressed Data column to apply the regression equation to all actual demand points results in the following:

Results Column 6:

Determine the Seasonal Factors. Formula: St = Dt/Ðt/. Results:

Each seasonal factor is summed up with its corresponding factor in each season cycle. For example: Since their cycles are divided up into quarter the formula will result: Savg1 = (S1+S2+S3)/4, Savg3 = (S3+S7+S11)/4

Forecasting

References

Johnson, Tara (2018). How the Amazon Supply Chain Strategy Works? Tinuiti. https://tinuiti.com.

Krajewski, L., Ritzman, M., Malhotra, N (2006). Operations Management: Processes and Value Chains. (8th edition). Prentice Hall.

Liker, J.K. (2005). The Toyota Way and Supply Chain Management”, Presentation for OESA Lean to Survive Program, The University of Michigan

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

## Benefits of our college essay writing service

• ### 80+ disciplines

Buy an essay in any subject you find difficult—we’ll have a specialist in it ready

• ### Custom formatting

APA, MLA, Chicago—we can use any formatting style you need.

• ### Plagiarism check

Get a paper that’s fully original and checked for plagiarism

### What the numbers say?

• 527
writers active
• 9.5 out of 10
current average quality score
• 98.40%
of orders delivered on time
error: