Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The management team for the company in question 2 is concerned about seasonal sales trends for the business and would like to compare its regular

The management team for the company in question 2 is concerned about seasonal sales trends for the business and would like to compare its regular regression forecast to a seasonally adjusted forecast. At the end of 2020, it has recorded the following actual sales: January 99,000 May 151,000 September 155,000 February 111,000 June 177,000 October 145,000 March 140,000 July 194,000 November 136,000 April 122,000 August 179,000 December 132,000 a. Based on the sales data for 2019 and 2020, develop a new linear regression equation for predicting long-term sales. Write the regression equation in the appropriate form. b. Using the regression equation, generate the regression sales forecast figures for each month of 2019 and 2020. c. Generate the regression sales forecast figures for each month of the following year (2021). d. Calculate the seasonal ratio for each month of 2019 and 2020 (round to 4 decimal places). e. Calculate the seasonal ratio for each month of 2021 by averaging the same respective months from the previous two years (round to 4 decimal places). f. Calculate the seasonal forecast for all 36 months.

Please help I will thumbs up!!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Content Audits And Inventories A Handbook

Authors: Paula Ladenburg Land

1st Edition

1937434389, 978-1937434380

More Books

Students also viewed these Accounting questions

Question

Verify that the Ep expression (17.58) holds for 1, 3-butadiene.

Answered: 1 week ago

Question

Compare the rewards with the pitfalls of starting a new business.

Answered: 1 week ago