Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to number of employees supervised and salary refer to annual salary in 1000$. Employees 28 31 38 38 43 47 48 49 53 56 Salary 99 102 136 127 157 121 173 197 200 176 a. Create the regression equation. b. Forecast the salary of a manager who supervises 90 employees by using the regression equation you created.

Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to number of employees supervised and salary refer to annual salary in 1000$. Employees 28 31 38 38 43 47 48 49 53 56 Salary 99 102 136 127 157 121 173 197 200 176 a. Create the regression equation. b. Forecast the salary of a manager who supervises 90 employees by using the regression equation you created.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to number of employees supervised and salary refer to annual salary in 1000$. Employees 28 31 38 38 43 47 48 49 53 56Salary 99 102 136 127 157 121 173 197 200 176 a. Create the regression equation.b. Forecast the salary of a manager who supervises 90 employees by using the regression equation you created.
How do organizations use linear regression. Also can you provide some examples.
Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs. Year 2013 2014 2015 2016 2017 2018 2019 2020 2021Membership (000s) 17 16 16 21 20 20 23 25 24 1. What are the issues associated with qualitative forecasting, and how are these overcome?
Explain what is the connection between forecasting and quality control?
What is the connection between forecasting and quality control?
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Sales (1,000s of gallons) Week 1 17 2 21 3 19 23 5 18 6 16 7 21 8 19 9 23 10 21 11 16 12 23 (a) Using a weight of - for the most recent observation, for the second most recent observation, and - for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Time Series Value Weighted Moving Average Forecast Week 1. 17 2 21 19 4 23 5 18 6 16 7 21
Use quantitative methods for the data shown below: Period 1 2 3 4 5 6 7 Observation 24 34 36 37 41 44 45 i) Naïve method: ii) Three period moving average iii) Three period Weighted moving average iiii)Four-period Moving Average iiiii)Four-period Weighted Moving Average b. Plot the original time series and comment on the appropriateness of a linear trend.
Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs. Year 2013 2014 2015 2016 2017 2018 2019 2020 2021Membership (000s) 17 16 16 21 20 20 23 25 24 1. Provide an example of qualitative forecasting and explain the shortcomings.
3- What are the different Forecasting Approaches? Explain each in detail
What are some of the common Business Statistics used in Excell for Hospitality Management?
Q1: Income at the architectural firm Spraggins and Yunes for the period February to July was as follows: Month February March April May June July 72.8 Income (in $ 70.0 thousand) 68.5 64.5 71.7 71.3 Use trend-adjusted exponential smoothing to forecast the firm's August income. Assume that the initial forecast average for February is $65,000 and the initial trend adjustment is 0. The smoothing constants selected are a = .1 and B =.2.