BUS300 Operations Management : Historical Data

$20 Bonus + 25% OFF

Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!

Students Who Viewed This Also Studied

BUS300 Operations Management

Task :

Human Resources Inc. (HR Inc.) is a small company that conducts seminars on productivity issues for corporate executives. HR Inc. focuses on improving the quality of work and the attitude of workers in service organizations. The company tries to provide seminar participants with the tools essential for dealing with hard-to-measure issues.

Originally, its seminars were geared toward hospital administration —specifically, topics included how to motivate nursing staffs and how to provide quality care for patients. Over the years, the demand for seminars has grown, as has the company’s client base. Clients now include insurance executives who want to improve the quality and productivity of their claim recorders, travel agency directors who want to improve the service of their agencies, and managers of secretarial pools who wish to improve the attitudes in their offices.

HR Inc. has offered one seminar each season since 1990. Each seminar lasts for one week and is typically held at a resort or spa. The location has varied over the years, but the winter seminars have tended to be in Florida, the spring seminars in Chicago, the summer seminars in the Carolinas, and the fall seminars in the northeast corridor (between Washington and Boston).

The table shows the number of persons attending seminars since Hr Inc. began.

Table. The number of Participants

Participants

Year

2000

2001

2002

2003

2004

2005

2006

2007

2008

Quarter

Winter

624

588

608

607

690

832

703

776

950

Spring

30

205

218

305

214

263

423

450

339

Summer

323

191

249

431

405

389

509

540

660

Fall

420

477

470

447

452

479

575

603

619

Assignments:  use Ms. Excel Spreadsheet to do the following.

You may copy and paste the data to your Excel Spreadsheet. I would also suggestion that you re-arrange data into a 2-dimension table (Quarters, # of Participants). To do so will make your job easier.

A spreadsheet template has be posted in the same Canvas folder you may use to help you complete the project in a structure and organized way.

Forecast

Use a 4-Quarter Moving AverageMethod to forecast the # of the participants from Winter 2001 to Winter 2009.

Use a Linear Projection Forecast Methodto forecast the # of the emergency visit from Winter 2000 to Winter 2009.

Use an Exponential Smoothing Forecast Method,with a = 0.4, to forecast the # of the emergency visit from Winter 2001 to Winter 2009. Assume that initial forecast for Fall 2000 is 450.

Discussion

Plot One(nice) Chart the following 4 Data Series over time (Winter 2001 to Fall 2008):

the historical data series,

the data series of forecasts obtained in 1a), 1b) and 1c).

What data pattern you may conclude from the chart of historical data series

Intuitively, which of the three forecasts you made in question 1 seems the best.

Use one of forecast Error Measurements, either MAD,or MSE, or MAPE (you choose) to determine which of the forecasts from 1a), 1b) or 1c) provides the best (smallest) forecasting error summary from the given historical data set. Is your conclusion same as the one you reached in 2)-b)-ii)?

Remark.  It is important to point out that error comparison of different forecast methods should be done on a Consistent Base. That is, the forecast error comparison for different forecast methods is meaningful only when we compare errors from the Same Range of forecasts.

Use the same Forecast Error Measurementyou used in question 3), find the best smoothing parameter a (i.e. the a that leads to the smallest forecast error) of Exponential Smoothing Forecast Method.

For the Exponential Smoothing forecastobtained in 1c), use Tracking Signal to monitor the forecast results and draw a conclusion on whether or not the forecasts are Biased, assume C = 3, and -C = -3 to be the control limits of the tracking signal method.

For the given historical data set,

Based on the data patternof the three-year data set, one can argue that the forecast methods used in 1a)-c), or, in general, we may conclude that Moving average, Linear Trend Project, and Exponential Smoothing Method should not be good Forecasting methods for the given data set since the seasonal data pattern exists.  Can you elaborate?

Propose Your Own Forecast Method(Other than the Moving Average, Linear Trend Project, and Exponential Smoothing Method we did in question 1)) that might be better than the forecast methods 1a) – 1c). Use the Forecast Method proposed to do forecasts from Winter 2000 to Winter 2009.

Use the SameForecast Error Measurement as you used in part 3) to calculate forecasting error for your method, and then check to see if your method is better.?

BUS300 Operations Management

Answer in Detail


Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

33 More Pages to Come in This Document. Get access to the complete answer.

Missing of deadlines is a myth with MyAssignmenthelp.com. Our super-fast writers take minimum time to complete your assignment orders without compromising the quality. We welcome unlimited revisions. We boost the presence of 3000+ subject matter experts excellent in crafting customized essays, assignments and dissertations. Team MyAssignment.com not only rule in Australia, UK and US but has also spread its wings to Canada, Singapore and UAE. We operate 24 hours a day considering the hectic academic schedule of scholars. MyAssignmenthelp.com is a reliable source where the written assignments are processed through series of quality check to guarantee 100 percent original papers. Get your custom essay help, dissertation writing services and online assignment help at the unbeatable price in the industry.

More BUS300 BUS300 Operations Management: Questions & Answers

Management

Instructions: 1) Make sure you have carefully read Chapters 11 & 12 in your text. 2) Begin by reading the following scenario: You work for a large, private health care organization that has server, mainframe, and RSA user access. Sean, your manager, has been asked to provide the latest version o …

View Answer

Management

Task A: Lean Six Sigma in Industries (a Full Report format

View Answer

Business Management

On completion of this unit, students will be able to: a) understand and apply the concepts of substance use and abuse to case studies b) explain the interactions between individual drug use and the social context c) develop specific assessment and referral skills for working effectively with  c …

View Answer

HOS302A Resort and Spa Management

Task:
Learning Outcomes
(a) Examine the history and development of the resorts and spa sector and its impact on the general economy of the host location. (b) Investigate the effect of the internal and external environments on resort and spa operations. (c) Discuss the influence of customer expec …

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.

Choose Our Best Expert to Help You

Davian Downs

I have acquired my academic degrees from the University of Cambridge.

350 – Completed Orders

Hire Me

Jax Mahoney

PhD degree on Management fromm Ohio State University

600 – Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

Management

Essay: 3 Pages, Deadline:
1 day

I am glad about the service. they answer all your questions well, and the team is respectful. they are excellent at writing essays with fast delivery.

User ID: 7***54 Canada

Project Management

Assignment: 8 Pages, Deadline:
20 days

I am pleased with the marks I received on this particular assignment. Thank you!

User ID: 6***97 United Kingdom, Great Britain

Accounting

Home Work: 14 Pages, Deadline:
10 days

Got a good grade. Nice work. Had support until the delivery of assignment and delivered work a few days before than promised.

User ID: 7***68 United Kingdom, Great Britain

Electronics

Home Work: 5 Pages, Deadline:
7 days

I am so satisfied. Great job. Recommended. Fast delivery and smart experts……

User ID: 8***52 United Kingdom, Norway

Nursing

Assignment: 4.8 Pages, Deadline:
8 days

It was very well structured and all the instructions were followed.. The order was also completed on time. minimal grammatical mistakes.

User ID: 7***50 United Kingdom, Australia

Psychology

Home Work: 2 Pages, Deadline:
1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85

User ID: 4***21 Charlotte, United States

Psychology

Assignment: 1 Page, Deadline:
1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85

User ID: 4***21 Charlotte, United States

Maths

Assignment: 2 Pages, Deadline:
4 days

helped me so much when I was at a time crunch, and they really pulled through for me

User ID: 5***12 Charlotte, United States

Statistics

Assignment: 5 Pages, Deadline:
12 days

Great service and perfect work and fast feedbacks as well i have no doubt in the work

User ID: 2***25 Khobar, Saudi Arabia

Marketing

Assignment: 1 Page, Deadline:
6 days

Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.

User ID: 5***56 San Francisco, United States

Property Law

Assignment: 12 Pages, Deadline:
12 days

Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty …

User ID: 6***34 San Francisco, Singapore

Project Management

Assignment: 6 Pages, Deadline:
1 day

I got my assignment delivered before the deadline, and it was an excellent job done.

User ID: 8***21 San Francisco, Nigeria

Healthcare

Assignment: 0 Pages, Deadline:
22 hours

great work and need more concise and explanation, provide feedback as soon as possible

User ID: 8***48 San Francisco, Saudi Arabia

Management

Essay: 4 Pages, Deadline:
2 days

I was impressed with the adjustment made to the report to suit the APA 7 edition style with citations for all answers.

User ID: 8***17 San Francisco, United States

Marketing

Assignment: 8 Pages, Deadline:
21 days

Thank you once again excellent paper, will use service again, extremely efficient understood the requirements.

User ID: 7***88 Melbourne, Australia

Economics

Course Work: 4 Pages, Deadline:
6 days

Thank you for the constant support and understanding and work towards my project

User ID: 8***56 Melbourne, Canada

English

Essay: 8 Pages, Deadline:
10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G …

User ID: 3***04 Melbourne, Bahrain

Finance

Programming: 2 Pages, Deadline:
23 hours

Good not bad. But if the solution with more analysis and explanation will be great

User ID: 8***49 Melbourne, Saudi Arabia

Management

Assignment: 6 Pages, Deadline:
5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel …

User ID: 8***14 Mississauga, Canada

Chemistry

Assignment: 1 Page, Deadline:
5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

User ID: 2***50 Kitchener, Canada

Management

Essay: 3 Pages, Deadline:
1 day

I am glad about the service. they answer all your questions well, and the team is respectful. they are excellent at writing essays with fast delivery.

User ID: 7***54 Canada

Project Management

Assignment: 8 Pages, Deadline:
20 days

I am pleased with the marks I received on this particular assignment. Thank you!

User ID: 6***97 United Kingdom, Great Britain

Accounting

Home Work: 14 Pages, Deadline:
10 days

Got a good grade. Nice work. Had support until the delivery of assignment and delivered work a few days before than promised.

User ID: 7***68 United Kingdom, Great Britain

Electronics

Home Work: 5 Pages, Deadline:
7 days

I am so satisfied. Great job. Recommended. Fast delivery and smart experts……

User ID: 8***52 United Kingdom, Norway

Nursing

Assignment: 4.8 Pages, Deadline:
8 days

It was very well structured and all the instructions were followed.. The order was also completed on time. minimal grammatical mistakes.

User ID: 7***50 United Kingdom, Australia

Psychology

Home Work: 2 Pages, Deadline:
1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85

User ID: 4***21 Charlotte, United States

Psychology

Assignment: 1 Page, Deadline:
1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85

User ID: 4***21 Charlotte, United States

Maths

Assignment: 2 Pages, Deadline:
4 days

helped me so much when I was at a time crunch, and they really pulled through for me

User ID: 5***12 Charlotte, United States

Statistics

Assignment: 5 Pages, Deadline:
12 days

Great service and perfect work and fast feedbacks as well i have no doubt in the work

User ID: 2***25 Khobar, Saudi Arabia

Marketing

Assignment: 1 Page, Deadline:
6 days

Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.

User ID: 5***56 San Francisco, United States

Property Law

Assignment: 12 Pages, Deadline:
12 days

Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty …

User ID: 6***34 San Francisco, Singapore

Project Management

Assignment: 6 Pages, Deadline:
1 day

I got my assignment delivered before the deadline, and it was an excellent job done.

User ID: 8***21 San Francisco, Nigeria

Healthcare

Assignment: 0 Pages, Deadline:
22 hours

great work and need more concise and explanation, provide feedback as soon as possible

User ID: 8***48 San Francisco, Saudi Arabia

Management

Essay: 4 Pages, Deadline:
2 days

I was impressed with the adjustment made to the report to suit the APA 7 edition style with citations for all answers.

User ID: 8***17 San Francisco, United States

Marketing

Assignment: 8 Pages, Deadline:
21 days

Thank you once again excellent paper, will use service again, extremely efficient understood the requirements.

User ID: 7***88 Melbourne, Australia

Economics

Course Work: 4 Pages, Deadline:
6 days

Thank you for the constant support and understanding and work towards my project

User ID: 8***56 Melbourne, Canada

English

Essay: 8 Pages, Deadline:
10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G …

User ID: 3***04 Melbourne, Bahrain

Finance

Programming: 2 Pages, Deadline:
23 hours

Good not bad. But if the solution with more analysis and explanation will be great

User ID: 8***49 Melbourne, Saudi Arabia

Management

Assignment: 6 Pages, Deadline:
5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel …

User ID: 8***14 Mississauga, Canada

Chemistry

Assignment: 1 Page, Deadline:
5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

User ID: 2***50 Kitchener, Canada

Have any Query?
Reference no: EM132069492

WhatsApp
Hello! Need help with your assignments? We are here

GRAB 25% OFF YOUR ORDERS TODAY

X