# Linear regression | Operations Management homework help

Forecasting

Your boss comes in “with their hair on fire”, and says, “just came  from a staff meeting and the CEO announced the building next door is  coming available at a really good price per square foot.”  He needs you  to tell him if the forecasted demand for the next 36 months is high  enough that we may need some of the new space.  He follows up with, “If  we miss this opportunity, and later we figure out that we need more  space then the only option is to rent space in another building about 5  miles away at almost double the price per square foot”.

As the operations manager, the last thing you want to do is to split  your staff across two different buildings.

That is going to be a  staffing and scheduling headache, not to mention morale will take a  hit. Do you shoot from the hip and tell your boss, “no doubt, forecasted  demand indicates we can use the space”, or do you say, “let me run the  forecast and get back to you later today”?  Which response has the most  risk?  Are you willing to bet your job on your answer?

Forecasting is both an art and a science.  In the assignments for  Unit 2 you will get the opportunity to practice forecasting by solving  end of chapter problems and completing a linear trending assignment. In  order to determine if it makes sense to rent additional space, it will  be important to assess the level of operational efficiency of existing  processes associated with the delivery of products to consumers.  Improving process efficiencies could result in a reduction in labor  requirements. Maybe the company can support greater demand with a leaner  labor force. In this unit, in addition to applying forecasting models  to scenarios, you will also gain a more in-depth understanding of the  concept and practices used to create efficient organizations.

## Unit Learning Outcomes

1. Develop a plan for forecasting impacts to an organization’s bottom line. (CLO 1, 2, 4, and 7)
2. Demonstrate how to perform forecasting using data and statistics.  (CLO 4 and 5)
3. Identify trends and patterns in data as they apply to forecasting. (CLO 1, 3, 5, and 7)
4. Develop a data collection plan that will permit the creation of an accurate and reliable forecasting model. (CLO 3, 4, and 5)

## Directions

1. End of Chapter Problems (40 points):  Answer the following end of chapter problems from the textbook:

Chapter 3 – problems 2, 3, 4 and 8 (pages 125-126, 10 points each).

View the following example videos before working the problems:

C3 Example 03-03               Play media comment.              (mp4, 37MB)

C3 Example 03-04               Play media comment.              (mp4, 60MB)

C2 Example 03-08               Play media comment.              (mp4, 82MB)

2. Linear Regression Forecasting Assignment: Watch the video and  complete the assignment below (20 points). You must use the data  analysis tool pak method  in Excel (see second part of video) to perform  the linear regression, and include the regression table in your  spreadsheet.  Simply adding a trend line to the data graph does not meet  this requirement.

Download the file Unit 2 – Individual Assignment – Linear Regression, follow the directions, and submit when complete. Document is also located in Files on the Student View folder.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.