Question

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 2017 Return 2018 Return Quarter Expenses Quarter Expenses Quarter Expenses 14,100 1 $ 14,500 13,400 13,200 15,900 2016 Return 1 $ 13,750 2 12,400 2 12,700 3 15,800 13,200 2 12,800 3 15, 300 4 4 4 The result of a simple regression analysis using all 12 data points yielded an intercept of $13,025.76 and a coefficient for the independent variable of $127.45. (R-squared 0.41, SE $1,066.52.) 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 3. 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.

i need answer to number 3,
fill in the answers in the format shown below please

Regression One Predicted Expenses 2019 Quarter Regression Two Predicted Expenses 2019 Quarter

i keep getting completely wrong snd unrelated answers
please only answer if you understand what needs to be done

0 1
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
i need answer to number 3, fill in the answers in the format shown below please...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • got number 2 solved now need solution to number 3 fill in the above chart (similar...

    got number 2 solved now need solution to number 3 fill in the above chart (similar question and solution below , that's what I need ) 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...

  • Required information [The following information applies to the questions displayed below.] Lexon Inc. is a large...

    Required information [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 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...

  • 2019 Quarter Return expenses 1 .. 2 3 4 Calculate the quarterly forecasts for 2019 using...

    2019 Quarter Return expenses 1 .. 2 3 4 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. (Round your answers to 2 decimal places for Regression One.) Regression One 2019 Quarter Predicted expenses 1 2 3 4 Regression Two 2019 Quarter Predicted Expenses 1 2 3 4 Required informatio [The following information applies to the questions displayed below.] Lexon Inc....

  • 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 2017 Quarter 2018 Quarter Return Expenses $ 12,750 11,500 11,800 13,900 Return Expenses $ 13,100 12,300...

  • PLEASE ANSWER ALL THANKS :) I. Fill in the blanks. Cash P 30,000 P 120,000 Accounts...

    PLEASE ANSWER ALL THANKS :) I. Fill in the blanks. Cash P 30,000 P 120,000 Accounts Payable Notes Payable Marketable Securities 25,000 Accrued Wages 20,000 Accounts Receivable Total Current Liabilities Inventories Long-Term Debt Total Current Assets Total Liabilities Net Fixed Assets 600,000 TOTAL ASSETS Stockholder's Equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY The following financial data for 2016 are also available: 1. Sales totaled P1,800,000.00 2. The gross profit margin was 25% 3. Inventory turnover was 6.0 (use COGS/Ave. inventory formula)...

  • I need certified help with the question below. I need the question answered "CORRECTLY" ASAP! Please...

    I need certified help with the question below. I need the question answered "CORRECTLY" ASAP! Please show work.. Thanks! During the fourth quarter of 2019, there were seven biweekly paydays on Friday (October 4, 18; November 1, 15, 29; December 13, 27) for Quality Repairs. Using the forms supplied below, complete the following forms for the fourth quarter. If an amount or input box does not require an entry, leave it blank or enter "0". Quarterly Payroll Data Total Earnings...

  • Question 1 Which of the following choices best describes the scatterplot shown below? Group of answer...

    Question 1 Which of the following choices best describes the scatterplot shown below? Group of answer choices Linear, negative, strong No form, weak Linear, positive, strong Curved, weak Question 2 Which of the following choices is most likely to be the correlation of the data in the scatterplot shown below? Group of answer choices -0.14 1.04 0.86 -0.92 Question 3 Most roller coasters get their speed by dropping down a steep initial incline, so it makes sense that we can...

  • (I did this homework in completion but professor was not happy with answers whatsoever, need additional...

    (I did this homework in completion but professor was not happy with answers whatsoever, need additional answers and especially improvement to 1.b help!! photos not attaching? mean by severai steps. inis is a View Feedback homework and will need you to work, in one two View Feedback or various steps. Unfortunately, I cannot read your screen shot of what you did on excel. As I have said in numerous messages announcements etc, I cannot аcсept pictures. You need to write...

  • I need help with research critique summary of this below article in APA format and in...

    I need help with research critique summary of this below article in APA format and in text citation and the reference en/poni%20perception%20article.pdf EATING DISORDERS 2018, VOL. 26, NO. 2, 107-126 https://doi.org/10.1080/10640266,2017.1318624 Routledge Taylor & Francis Group PREVENTION SERIES Check to Perceptions of disordered eating and associated help seeking in young women Annamaria J. McAndrew and Rosanne Menna Department of Psychology, University of Windsor, Windsor, Ontario, Canada ABSTRACT Disordered eating is common among young women, but rates of help-seeking are remarkably...

  • I need answers of question 3 and 4. 1. 151 The graphic below shows actual inflation...

    I need answers of question 3 and 4. 1. 151 The graphic below shows actual inflation (this is labeled headline inflation" in the chart) and inflation targets for a number of countries in 2014 September 2014 or ltest Seeden South Korea Japan India Using only information in the chart and frameworks developed in this class (i.e., not subsequent events), please answer the following questions a. [5 points] At the time of the chart, which monetary policy would you have recommended...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT