Question

Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising...

Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2019. The relevant quarterly data for the previous three years follow:

2016 Quarter Return Expenses 2017 Quarter Return Expenses 2018 Quarter Return Expenses
1 $13,900 1 $14,300 1 $14,800
2 $12,600 2 $13,400 2 $13,700
3 $12,900 3 $13,000 3 $13,500
4 $15,200 4 $15,600 4 $16,300

The result of a simple regression analysis using all 12 data points yielded an intercept of $13,154.55 and a coefficient for the independent variable of $145.45. (R-squared = 0.45, SE = $1,084.18.)

Required (Part 1): Plot the data in the order of the dates (can just give coordinates for each point).

(Part 2)a: 2. Looking at the graph you prepared for requirement 1, select two representative data points and calculate the quarterly forecast for 2019 using the high-low method.

2019 Quarter Return Expenses
1 -
2 -
3 -
4 -

(Part 2)b: Calculate the quarterly forecasts for 2019 using the results of a regression analysis. Evaluate the results of the regression analysis and make appropriate changes to improve the model.

Regression One
2019 Quarter Predicted Expenses
1 -
2 -
3 -
4 -
Regression Two
2019 Quarter Predicted Expenses
1 -
2 -
3 -
4 -

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
home / study / business / accounting / accounting questions and answers / [the following information...
home / study / business / accounting / accounting questions and answers / [the following information applies to the questions displayed below.] lexon inc. is a large ... Question: [The following information applies to the questions displayed below.] Lexon Inc. is a large manuf... [The following information applies to the questions displayed below.] Lexon Inc. is a large manufacturer of affordable DVD players. Management recently became aware of rising expenses resulting from returns of malfunctioning products. As a starting point...
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in...
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2016: 4072 4521 4452 4418 2017: 4010 4392 4399 4334 2018: 4092 4484 4277     4360 Obtain the seasonal factors and enter them into the appropriate yellow cells below: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Seasonal Factor Using the columns Year and Total (Annual Sales) below, obtain the regression equation...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260 2016 1 740 2016 2 2,720 2016 3 4,900 2016 4 520 2017 1 1,500 2017 2 3,100 2017 3 6,520 2017 4 960 2018 1 1,840 2018 2 4,040 2018 3 7,680 2018 4 1,640 2019 1 3,520 2019 2 5,640 2019 3 8,900 2019 4 3,620 Problem 2 House Depot’s quarterly sales of a lawn, landscaping, and gardening items – like lawnmowers,...
Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three...
Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three years are:          Year Quarter Sales t Qtr2 Qtr3 Qtr4 1 1 1690 1 0 0 0 1 2 940 2 1 0 0 1 3 2625 3 0 1 0 1 4 2400 4 0 0 1 2 1 1760 5 0 0 0 2 2 990 6 1 0 0 2 3 2800 7 0 1 0 2 4 2510 8 0...
A statistical program is recommended. Consider the following time series. Quarter Year 1 Year 2 Year...
A statistical program is recommended. Consider the following time series. Quarter Year 1 Year 2 Year 3 1 72 69 63 2 49 41 51 3 58 60 53 4 77 80 71 (a) Construct a time series plot. A time series plot contains a series of 12 points connected by line segments. The horizontal axis is labeled: Year/Quarter. There are 12 tick marks on the horizontal axis which have been divided up into 3 groups of 4 tick marks....
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...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com- piled, and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one particular area of southeast Texas follow: QUARTER                  YEAR 1         ...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4 2.42 2010 1 2.72 2010 2 2.53 2010 3 2.61 2010 4 2.84 2011 1 2.95 2011 2 2.79 2011 3 2.93 2011 4 3.03 2012 1 3.44 2012 2 3.2 2012 3 3.3 2012 4 3.36 2013 1 3.79 2013 2 3.56 2013 3 3.74 2013 4 3.8 2014 1 4.24 2014 2 3.87 2014 3 4.15 2014 4 4.18 2015 1 4.8...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alpha α equals=0.4 with an initial forecast for week 1 of 586​) methods to forecast demand for week 13....
Question Simple Life Food Ltd is a manufacturer of ‘ready to eat meal’ and sells to...
Question Simple Life Food Ltd is a manufacturer of ‘ready to eat meal’ and sells to various food outlets for credit and cash basis. The management wants to prepare a master budget for the first ten months of the year ending 31 October 2019, and has compiled the following data: 1. The firm sells a single type of set menu at a price of $24 per set. The sales forecast (in sets) prepared by the marketing department for the ten...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT