Question

In: Operations Management

The following are the data regarding quarterly sales: Quarters Sales 1 500 2 350 3 250...

The following are the data regarding quarterly sales:

Quarters	Sales
1	500
2	350
3	250
4	400
5	450
6	350
7	200
8	300
9	350
10	200
11	150
12	400

Find the forecast value of the sales for each quarter starting with Quarter 6, by using a 4-quarter moving average.

Evaluate this forecasting method using MAD.

Evaluate this forecasting method using MSE.

Evaluate this forecasting method using MAPE.

Evaluate this forecasting method using MPE.

Use exponential smoothing with a smoothing constant of 0.2 and an initial value of 500 to forecast the sales for Quarter 1.

Expert Solution

a)

Below is the screenshot of the formula applied -

Below is the screenshot of the result -

b)

Below is the screenshot of the formula applied -

Below is the screenshot of the result -

keosha answered 1 year ago

Month May June July August September October November December January Sales 350 350 250 250 350...

Month May June July August September October November December January Sales 350 350 250 250 350 550 650 750 650 Collections month 0: 80%*95% month -1: 15% month -2: 5% Payments Purchase - 70% of next month sales Purchase payment - 50% of current month purchase Purchase payment - 50% of last month purchase Lease payment 10 10 10 10 10 10 construction 0 0 0 60 0 0 wages 30 30 40 50 70 80 other 5 5 5...

Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a...

Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a time series plot and develop linear trend equation using the original data (with seasonal components). 2.Calculate 4-quarter moving average values for this time series (column E). 3.Calculate centered moving average values and seasonal indexes (column F and G). 4.Calculate seasonal indexes (column J) for the four quarters. 5.Copy seasonal indexes (column J) to column O, and calculate deseasonalized number sold (column P). 6.Construct a...

Consider the following uneven cash flow stream 0 0 1 $250 2 $400 3 $500 4...

Consider the following uneven cash flow stream 0 0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10%? Add an outflow (or cost) of $1,000 at Year 0. What is the present value of the cash flow stream? Your oldest daughter is about to start kindergarten at a private school. Tuition is $10,000 per year payable at the beginning of the school year. You...

Consider the monthly sales data for the following questions. Month Sales 1 34400 2 29700 3...

Consider the monthly sales data for the following questions. Month Sales 1 34400 2 29700 3 29000 4 16600 5 20500 6 20300 7 22500 8 17400 9 19600 10 16400 11 17700 12 18100 13 15300 14 17600 15 14200 16 15800 17 14500 18 13300 Step 1 of 6: Fit a linear trend model to the data. What is the R2 value for the linear model? Enter 4 decimal places Step 2 of 6: How well does the...

The following production budget for the four quarters of 2019: Quarter 1 Quarter 2 Quarter 3...

The following production budget for the four quarters of 2019: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 3,000 4,000 5,000 8,000 Each units requires 4 kg of raw materials costing $6 per kilogram. On December 31, 2018, the ending inventory of raw materials was 3,000 kg. Management wants to have a raw materials inventory at the beginning of each quarter equal to 25% of the current quarter's production requirements in units. The production budget for the first quarter...

A sample of 5 months of sales data provided the following information: Month 1 2 3...

A sample of 5 months of sales data provided the following information: Month 1 2 3 4 5 Units Sold 96 110 85 96 93 Develop a point estimate of the population mean number of units sold per month (to 1 decimal). Develop a point estimate of the population standard deviation (to 2 decimals).

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales...

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 Selling price per unit $7 per unit 1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3)...

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3) 100,000; and 4) 50,000. Additionally, Chorus expects quarterly sales volume for 2018 as follows: 1) 70,000 units; 2) 80,000; 3) 75,000; and 4) 85,000. Chorus has an inventory policy which requires ending finished goods inventory to be 30% of budgeted sales for the next quarter. (T or F) The amount of production necessary to meet the expected sales for 2017 is 275,000 units.

sales 155 187 266 quarter 1 2 3 using the following data: A. what proportion of...

sales 155 187 266 quarter 1 2 3 using the following data: A. what proportion of the variability in sales can be explained by the model? B. predict the sales in the fourth quarter.

Research one of the following global health issues and write a 1-2 page essay (250-500 words)...

Research one of the following global health issues and write a 1-2 page essay (250-500 words) regarding the current state and future recommendations for dealing with the issue: Child Marriages: Child marriages are defined as the union between one or two individuals under the age of 18. One in five girls are married before the age of 18, and child marriages prevent children from becoming educated, can lead to severe health consequences and increased risk of violence. Legislation and programs...