Messages
Proposals
Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.
Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support
Assignment
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
a. Using Excel, create a linear regression equation to model the number of repairs per month.
b. How many repair calls does the regression equation predict for June of year 2?
c. 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?
Submit your findings in a Word document and include the Excel spread sheet.
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
ONLINE |
Instant Homework Helper |
$36 |
She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
Instant Assignment WriterI will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points. |
$18 | Chat With Writer |
ONLINE |
Top Class EngineersI am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message. |
$37 | Chat With Writer |
ONLINE |
Supreme Essay WriterI am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You |
$50 | Chat With Writer |
ONLINE |
Engineering SolutionsI have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project. |
$25 | Chat With Writer |
ONLINE |
Coursework Assignment HelpBeing a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading. |
$31 | Chat With Writer |
ONLINE |
Top Class ResultsI am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message. |
$36 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.