Question: Sales data for two years are as follows. Data are aggregated with two months of sales in each period. a. Plot the data. b. Fit

Sales data for two years are as follows. Data are aggregated with two months of sales in each “period.”

MONTHS MONTHS SALES SALES January-February March-April 109 104 150 170 120 100 115 112 January-February March-April 159

a. Plot the data.

b. Fit a simple linear regression model to the sales data.

c. In addition to the regression model, determine multiplicative seasonal index factors. A full cycle is assumed to be a full year. d. Using the results from parts (b) and (c), prepare a forecast for the next year.

MONTHS MONTHS SALES SALES January-February March-April 109 104 150 170 120 100 115 112 January-February March-April 159 182 May-June May-June July-August July-August 126 September-October November-December September-October November-December 106

Step by Step Solution

★★★★★

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b c t y Average from same bimonthly period Seasonal factor Deseasonalized demand t 2 t y t desea... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

287-B-M-L-S-C-M (1617).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

Fit an overdispersed Poisson log- linear regression model to the Galpagos island species count data, using the total species count as the response. Use all five covariates (with area and elevation on...

In the simple linear regression model y = (0 + (1x + u. Suppose that E(u) ( 0. Letting a0 = E(u), show that the model can always be rewritten with the same slope, but a new intercept and error, where...

Refer to Exercise 16.132, where a simple linear regression model was used to analyze the relationship between welding machine breakdowns and the age of the machine. The analysis proved to be so...

Sales data for two years are as follows. Data are aggregated with two months of sales in each "period." a. Plot the data. Instructions: 1. Use the line tool (Sales) to draw the sales for each period....

please try to explain throughly thank you Sales data for two years are as follows. Data are aggregated with two months of sales in each "period." a. Plot the data. Instructions: 1. Use the line tool...

The sales data for two years are as follows. Data are aggregated with two months of sales in each "period." \ table [ [ MoNTHS , SALES,,MoNTHS,SALES ] , [ January to February, 1 0 8 , January to...

Sales data for two years are as follows. Data are aggregated with two months of sales, in each "period." Months January-February March-April May-June July-August September-October November-December...

Please put in Excel The sales data for two years are as follows. Data are aggregated with two months of sales in each "period." a. Plot the data. b. Fit a simple linear regression model to the sales...

Sales data for two years are as follows. Data are aggregated with two months of sales in each period. a. Plot the data b. Fit a simple linear regression model to the sales data. c. In addition to the...

A step up transformer convert 120V AC to 800 V AC and it has 500 turns on its primary side (a) What is the number of turns on the secondary side? (b) If the transformer passes through 4000 Watts of...

Using Coincidence Point Theorem, find explicit form of following function. (v(t 1) + t,w? (t? - 1) + t, u (t - 1) + t) = (0,0,0)

When evaluating the future liabilities of defined benefit pension plans, the discount rate matters because multiple choice lower rates of discount mean that liabilities nearer to the present will...

Visit two local small businesses, one in the service sector (e.g., dry cleaner, auto repair shop, veterinarian, or bookstore) and one that manufactures tangible goods. Interview employees from these...

Braggs Bakery is building a new automated bakery in downtown Sandusky. Here are the activities that need to be completed to get the new bakery built and the equipment installed. a. Draw the project...

Assume the network and data that follow: a. Construct the network diagram. b. Indicate the critical path when normal activity times are used. c. Compute the minimum total direct cost for each project...

Your project to obtain charitable donations is now 30 days into a planned 40- day project. The project is divided into 3 activities. The first activity is designed to solicit individual donations. It...

Your company has earnings per share of $4. It has 1 million shares outstanding, each of which has a price of $42. You are thinking of buying TargetCo, which has earnings of $3 per share, 1 million...

Aluminum Building Products Company (ABPC) is considering investing in either of the two mutually exclusive projects described as follows: Project 1. Buying a new set of roll-forming tools for its...

Here's the Taylor series of expansion about where the terms of order 2 and higher have been discarded to create a linear approximation to . This operation is easy for basic functions such as . When...