Purchase Solution

Linear trend estimation

Not what you're looking for?

Ask Custom Question

Please help to build a spreadsheet to figure out the following:

Freight car loadings over an 18-week period at a busy port are:

Week Number
1 220
2 245
3 293
4 275
5 332
6 310
7 350
8 360
9 427
10 380
11 432
12 450
13 477
14 475
15 538
16 510
17 532
18 541

a) Compute a linear trend line for freight car loadings:

b) Use the trend equation to predict loadings for weeks 25 and 26:
The forecasted demand for week 25 and 26 is ____ and ____ respectively.

c) The manager intends to install new equipment when the volume reaches 829 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately what week?
It would take approximately _15_ more weeks.

Purchase this Solution

Solution Summary

This posting carries a linear trend estimation problem and the solution outlines the two methods of estimating a linear trend (see attachment).

Purchase this Solution

Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.