Question

Find the seasonalized forecast for Q2 of 2017.The sales trend has been modeled as: Sales =...

Find the seasonalized forecast for Q2 of 2017.The sales trend has been modeled as: Sales = 2 * t + 200, where t= time in quarters, beginning in Q1 2014. Seasonality for the four quarterly periods is given in the table below.

Quarter

Seasonal Factor

Quarter #1

1.2000

Quarter #2

1.41

Quarter #3

0.5000

Quarter #4
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1


0 0
Know the answer?
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
Similar Questions
2. The table below shows (1) sales forecasts for the respective quarters before adjusting for seasonality,...
2. The table below shows (1) sales forecasts for the respective quarters before adjusting for seasonality, and (2) the seasonal indices for each of the four quarters. Adjust these sales forecasts for seasonality and put the final (adjusted) forecasts in the table. Quarter 1 2 3 4 Sales forecast 400 400 400 400 Seasonal Index 1.2 0.8 0.7 1.3 Adjusted Forecast
Year Quarter Sales 1 Q1 7 Q2 2 Q3 4 Q4 10 2 Q1 6 Q2...
Year Quarter Sales 1 Q1 7 Q2 2 Q3 4 Q4 10 2 Q1 6 Q2 3 Q3 8 Q4 14 3 Q1 10 Q2 3 Q3 5 Q4 16 4 Q1 12 Q2 4 Q3 7 Q4 22 1.Develop a model for trend and seasonality. Please clearly define your variables. How many independent variables do you have in your regression? 2.What is the intercept in your estimated regression model? Rounded to two decimal places. 3.Use the model to forecast...
The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle....
The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Ft = 52 − 4.2t + 3.2t 2    where Ft = Unit sales t = 0 at the first quarter of last year Quarter Relative 1 1.00 2 1.00 3 .50 4 1.50 Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of the year...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $5,600,000.00 $4,900,000 $4,200,000 $6,400,000 Accounts receivable at the beginning of the year are $2,100,000. The company has a 30-day collection period. Calculate cash collections in each of the four quarters by completing the following: Q1 Q2 Q3 Q4 Beginning Receivables Sales Cash collections Ending receivables Note: Must show work
1) When operating a business, a manager should only use one forecasting technique at a time....
1) When operating a business, a manager should only use one forecasting technique at a time. Yes or No? 2) Quarterly demand for a product includes both a trend and seasonality. The trend portion of deseasonalized demand is forecast based on a linear trend, yt = 50 + 4t, while the quarterly seasonal relatives are Q1 = 1.2, Q2 = 1.1, Q3 = 0.95 and Q4 = 0.75. What is the forecast demand for t = 11 and t =...
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a...
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Ft = 62 − 5.2t + 4.2t 2    where Ft = Unit sales t = 0 at the first quarter of last year Quarter Relative 1 1.15 2 1.00 3 .65 4 1.30 Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The MacFarlane Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $7,800 $9,600 $9,000 $7,500 a. Accounts receivable at the beginning of the year are $3,600. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Q1 Q2 Q3 Q4 Beginning receivables $ $ $ $...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in 2017, 2018 and 2019. Data on revenue in recent years is presented below. Year Q1 Q2 Q3 Q4 TOTAL 2012          695          788          809       1,302 $3,594 2013          896          941       1,018       1,677 $4,532 2014       1,037          929       1,353       2,090 $5,409 2015       1,067       1,081       1,574       2,143 $5,865 2016       1,147       1,161...
The Gruber Company has projected the following quarterly sales amounts for the coming year:   Q1   Q2...
The Gruber Company has projected the following quarterly sales amounts for the coming year:   Q1   Q2   Q3   Q4   Sales $ 770 $ 800 $ 880 $ 960 a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
I use 40 quarterly observations on a time series beginning with the first quarter of 2007...
I use 40 quarterly observations on a time series beginning with the first quarter of 2007 to estimate the following model: Y = 5 + 0.25 Trend + 1 Q2 – 2 Q3 + 0.5 Q4 Where Trend is a time index equal to 1 for the first observation and increases by 1 each quarter; Q2 is a dummy variable equal to 1 for all observations on the second quarter of a year and equal to 0 for all other...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT