(See Solution) Forecasting managerial needs. Managers are an important part of any organization's resource base. Accordingly, the organization should be
Question: Forecasting managerial needs. Managers are an important part of any organization's resource base. Accordingly, the organization should be just as concerned about forecasting its future managerial needs as it is with forecasting its needs for, say, the natural resources used in its production process (Northcraft and Neale, Organizational Behavior: A Management Challenge, 2001). A common forecasting procedure is to model the relationship between sales and the number of managers needed because the demand for managers is the result of the increases and decreases in the demand for products and services that a firm offers its customers. To develop this relationship, the data shown in the table below (saved in the MANAGERS2 file) are collected from a firm's records.
| Units Sold, X | Managers,Y |
| 5 | 10 |
| 4 | 11 |
| 8 | 10 |
| 7 | 10 |
| 9 | 9 |
| 15 | 10 |
| 20 | 11 |
| 21 | 17 |
| 25 | 19 |
| 24 | 21 |
| 30 | 22 |
| 31 | 25 |
| 36 | 30 |
| 38 | 30 |
| 40 | 31 |
| 41 | 31 |
| 51 | 32 |
| 40 | 30 |
| 48 | 32 |
| 47 | 32 |
- Test the usefulness of the model. Use \(\alpha=.05\). State your conclusion in the context of the problem.
- The company projects that it will sell 39 units next month. Use the least squares model to construct a 90% prediction interval for the number of managers needed next month.
- Interpret the interval in part b. Use the interval to determine the reliability of the firm's projection.
Deliverable: Word Document 