Draw the monthly sales data in a graph

Reference no: EM131195539

PROJECT - FORECASTING TECHNIQUES

The following data represent sales of toys for a Company based in Jeddah. Every period corresponds to 4 weeks.

Period	2013	2014	2015
1	155	576	1106
2	339	1064	2061
3	143	390	705
4	95	261	412
5	93	277	404
6	170	346	624
7	216	460	704
8	298	638	980
9	339	710	1233
10	213	505	684
11	234	458	671
12	302	679
13	431	646

a) Draw the monthly sales data in a graph and explain which forecasting method do you recommend.

b) Calculate the forecasting of the sales volume for the periods 12 and 13 when necessary using the following methods:

i. Linear equation. (using regression analysis)

ii. Five-month moving Average.

iii. Exponential Smoothing using the constant alpha as per the formula given in class and an initial forecast as the average of the total sales.

iv. Double Exponetial Smoothing using alpha in part iii, the contented beta as 10% more than alpha, the initial forecast as the average of all sales, and the initial trend as the trend equation at period zero.

c) Use the decomposition model and calculate the seasonal factors and forecast period 13, 14, 15, and 16.

d) Use the answer of part (b) and (c) to predict sales for the periods 12 and 13 for the year 2015. Show your work!

Reference no: EM131195539

Questions Cloud

Analyze the trends that you observed with each company : Analyze the trends that you observed with each company. To what could you attribute the increases or decreases in each company's trend(s)? What recommendations would you give to the brand managers of your favorite brand to increase the trend line f..

Comment when a company has strong internal control structure : When a company has a strong internal control structure, stockholders can expect the elimination of fraud.- Provide your comments.

What can be done to improve crm : Explain the way(s) an organization with which you are familiar measures quality and customer satisfaction. What can be done to improve CRM? Lastly, explain how you can personally have a positive impact on customer loyalty in your position.

Inverse demand curve for air travel is defined by equation : Assume that the airline industry is characterized as a duopoly in which two firms produce identical products. American Airlines’s marginal cost of is $90.00, while United’s marginal cost is $180.00. If the two firms compete by choosing quantities sim..

Draw the monthly sales data in a graph : OPIM433-1 PROJECT - FORECASTING TECHNIQUES. Draw the monthly sales data in a graph and explain which forecasting method do you recommend. Calculate the forecasting of the sales volume for the periods 12 and 13 when necessary using the following metho..

Identify three database requirements that must be addressed : Identify the three database requirements that must be addressed during database design. Analyze why these requirements often conflict with each other.

How implementation of marketing process benefit organization : Which step in the marketing process do you find the most interesting? Why? In your post and in responding to your peers, elaborate on the importance of following a process in marketing. How does the implementation of a marketing process benefit th..

How a composite key and a composite attribute are different : At least one website reference. Must have in-text citation for all the references used. Analyze how a composite key and a composite attribute are different. Explain how each would be indicated in an ERD.

Compute the taxpayers total deduction for exemptions : Compute the taxpayers' total deduction for exemptions for the year.- Evaluate Paul's suggestion.- What should they do?

User Account

All Pages