Purchase Solution

Project Management - Forecasting ManagerImprov, Inc.

Not what you're looking for?

Ask Custom Question

See the attached file.

Forecasting ManagerImprov, Inc.
ManagerImprov Inc. (MI Inc.) is a small company that conducts seminars on productivity issues for corporate executives. MI 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 claims 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. MI Inc. has offered one seminar each season for the past nine years. 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 following table shows the number of persons attending seminars since MI Inc. began.

Participants per Year/Quarter

Year -Qtr 1 2 3 4 5 6 7 8 9
Winter 35 68 70 64 73 89 96 93 95
Spring 44 61 62 72 62 66 78 80 82
Summer 54 61 70 76 85 82 95 88 89
Fall 49 75 74 72 72 92 94 101 87

DISCUSSION QUESTION
MI Inc. is considering a major expansion program. Before committing to it, however, the company would like to be able to forecast the size of its seminars. MI Inc. is wondering if it should expand in all four seasons or if it should concentrate on one. The company would like to know if the growth has been even in all four regions or not. Find a forecasting model that best answers MI Inc.'s questions. What is the forecast for each quarter in the next two years?

Attachments
Purchase this Solution
Solution Summary

The solution examines product management for forecasting ManagerImprov, Inc.

Solution Preview

Please see the attached Excel sheet for results and calculations.

Although there are many other methods for forecasting, regression analysis has been considered to be the most widely used. In my solution, I use such method to find the equation that will best fit the operational data up to date. After that, I simply plug the value for the next two periods (10 and 11 respectively) into the regression equation to obtain the forecasting.

Once you open up the Excel sheet, you should notice that I separated the data according to different season into four different worksheet, labeled "Winter", "Spring" etc. After I input the data into different sheet, I graphed the series using a 2-D line graph. Here is there the regression comes in. Once you are done, right click on the plotted line and select "Add ...

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Introduction to Finance

This quiz test introductory finance topics.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • Inventory Management and Control for Apple Inc.

    587425 Inventory Management and Control for Apple Inc.

  • Schedule and Cost Control Techniques

    Project management a systems approach to planning, scheduling, and controlling (8th ed.). Hoboken, NJ: John Wiley & Sons, Inc. Leach, L. (2003).

  • Automotive Builders, Inc.: The Stanhope Project.

    181748 Project Management Project Management: A Managerial Approach by Wiley (6th Edition) Chapter 7 Case AUTOMOTIVE BUILDERS, INC.: THE STANHOPE PROJECT QUESTIONS 1. How did ABI handle forecast risk? 2.

  • Software Pluses and Minuses

    Pearson Education, Inc. Upper Saddle River, N.J. The expert identifies three areas where project management software is especially beneficial and how it is beneficial.

  • NPV Project Investments

    Financial Management. Pearson Education, Inc. Upper Saddle River, New Jersey. NPV project investments are examined. What kinds of investments would terminal value accounts for a substantial fractions of the total project NPV is determined.

  • Conflict resolution techniques

    82344 Project management Reporting Explain how the project manager will communicate performance evaluation results to both management and the customer.

  • Forecasting technology, implementation, Porter's five forces

    One choice for the organization would be to use current technology or delay the project in order to adopt a superior technology. Forecasting provides management with tools to make decisions related to technology.

  • Forecasting Methodologies

    In project management forecasting refers to the forecasting of discrete events, forecasting of a large group of activities, or the technology used for forecasting. The methodologies include qualitative and quantitative.

  • IRR and Cash Multiples

    Financial Management. Pearson Education, Inc. IRR and cash multiples as alternative valuations are examined.

View More Related Solutions