Question: Please answer the question without Excel Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over

Please answer the question without Excel

Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:

MONTH DEMAND (UNITS)
January 4,250
February 4,350
March 4,050
April 4,450
May 5,050
June 4,750
July 5,350
August 4,950
September 5,450
October 5,740
November 6,345
December 6,045

Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7.

Note: Do not round intermediate calculations. Round your answers to 2 decimal places.

To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence?

Note: Do not round intermediate calculations. Round your answer to the nearest whole number.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!