MBA 576 Operations Management Homework- Park University
You just finished your MBA degree and your boss wants "to show you off" in an upcoming staff meeting because she feels you have a lot of potential. Needless to say, you feel some pressure.
She says the company's machines have required "high number of repairs" over the past year and feels the repair service staff needs to be "beefed up", but she is not sure how many new staff are needed. The repair department was stood up one year ago, and she tasks you to come up with staffing estimates to make sure there are enough repair staff to meet the demand. Below is the data she gives you for the past 16 months, and then she asks, "How many repair staff positions would you forecast we need in the next 6 months?"
Year 1 - # of repair calls received. The repair staff is open from 7am to 7pm, seven days a week, and repair staff work the entire 12-hour shift. You can assume a single repair takes an average of 30 minutes for each repair.
|
Month
|
Average # of repair calls received per day for each month the repair office was open in year 1
|
|
Jan
|
25
|
|
Feb
|
19
|
|
Mar
|
28
|
|
Apr
|
32
|
|
May
|
42
|
|
Jun
|
47
|
|
Jul
|
50
|
|
Aug
|
49
|
|
Sep
|
52
|
|
Oct
|
54
|
|
Nov
|
53
|
|
Dec
|
59
|
|
Jan
|
49
|
|
Feb
|
40
|
|
Mar
|
42
|
|
Apr
|
47
|
• Using Excel, create a linear regression equation to model the number of repairs per month.
• How many repair calls does the regression equation predict for June of year 2?
• Given your prediction for June of year 2, how many repair staff members do you forecast will be needed per 12-hour shift to handle the load?
Format your homework according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.