Ask Management Theories Expert

A group of minimum of two (2) and maximum of three (3) students must submit their assignment. Students must work in groups. No individual assignment is allowed unless approved by the professor.

Students are reminded that submitted assignments must be neat, readable, and well-organized. Assignment marks will be adjusted for sloppiness, poor grammar and spelling, as well as for technical errors. Plagiarism on assignments will not be accepted, each student must sign the statement of integrity.

E-mail questions related to the assignment should be sent to the Teaching Assistants;

Negar: [email protected] (Group X) and Alhassan: [email protected] (Group Y).

Problem # 1 National Mixer, Inc. sells can openers. Monthly sales can openers for seven-month periods were as follows:

a) Plot the monthly data.
b) Forecast September sales volume using each of the following:

1. A linear trend equation. (use regression analysis)

2. A Four-month moving average.

3. Exponential smoothing with a smoothing constant equal to 0.20, assuming a February forecast of 19(000).

4. The naïve approach

5. A weighted average using 0.6 for August, 0.3 for July, and 0.10 for June.

c) Which method seems least appropriate? Why?

Problem # 2
Management of the Jackson Manufacturing Corporation wishes to choose a statistical forecasting method for forecasting total sales for the corporation. Total sales (in million of dollars) for each month of last year are shown below.

a) Starting at period 3 and using the initial estimates of 131 for the exponentially smoothed forecast (i.e. the average of the 1st two periods) and 11 for the exponentially smoothed trend (i.e. A2 - A1 = 137 - 126), apply exponential smoothing with trend adjustment (double exponential smoothing) to the last year's sales. Where α = 0.1 or 0.5 and β = 0.1 or 0.5. Compare both MAD and MSE for these 4 combinations. Which value of α and β would you recommend?

b) Using the recommended value of α and β from part a), what is the forecast of total sales for January of the New Year?

c) When plotting the data. Note how the sales level is shifting significantly from month to month - first trending upward and then dipping downwards before resuming an upward trend. Assuming that similar patterns would continue in the future, evaluate how well you feel that exponential smoothing with trend adjustment method would perform in forecasting future sales.

Problem # 3
Given the date above use Excel to answer the following questions:

a) Plot the daily data of the number of customers served for the evening meal, which forecasting method would you recommend and why?

b) Use the multiplicative decomposition model discussed in class and NOT in the book, to calculate the seven seasonal indices (Hint: Use a seven-day centered moving average), and the intercept and slope of the trend component (Hint: deseasonalize the data, fit an appropriate model to the deseasonalzed data). Fill in the table below.

c) Using the multiplicative decomposition model, is the forecast of period 1 to 28 performing adequately? Justify your answer.

d) Using the multiplicative model, forecast the "Number Served" for the next two weeks (e.g. forecast the "Number Served" for period 29 to period 42). Show calculation.

Problem # 4

New Brunswick's Soda Pop, Inc. has a new fruit drink for which it has high hopes. Steve Allen, the production planner, has assembled the following data and demand forecast:

Steve's job (i.e. your job for this assignment) is to develop an aggregate plan and calculate its cost. The three initial options he wants to evaluate are:

a) Plan A: Chase strategy that hires and fires personnel as necessary to meet the forecast.
b) Plan B: Level strategy.
c) Plan C: Level strategy that produces 1,200 units per quarter and meets the forecasted demand with inventory and subcontracting.
d) If you are Steve's boss, the VP for operations, which plan do you implement and why?

Problem # 5
Forrester and Cohen is a small accounting firm, managed by Joseph Cohen since the retirement in December of his partner Brad Forrester. Cohen and his three CPAs can together bill 640 hours per month. When Cohen or another accountant bill more than 160 hours per month, he or she can gets an additional "overtime" pay of $62.50 for each extra hours: this is above and beyond the $5,000 salary each draws during the month. (Cohen draws the same base pay as his employees). Cohen strongly discourages any CPA from working (billing) more that 240 hours in any given month. The demand for the billable hours for the firm over the next 6 months is estimated below:

Cohen has an arrangement with Forrester, his former partner, to help out during the busy tax season, if needed, for an hourly fee of $125. Cohen will not even consider laying off one of his colleagues in the case of a slow economy. He could, however, hire another CPA at the same salary, as business dictates.

a) Develop an aggregate plan for the six-month period and compute its corresponding cost (i.e. the cost of Cohen's plan of using overtime and Forrester).

b) Should the firm remain as is, with a total of four CPAs?

Management Theories, Management Studies

  • Category:- Management Theories
  • Reference No.:- M91823144

Have any Question?


Related Questions in Management Theories

Assignment -for this assignment analyze and discuss your

Assignment - For this assignment, analyze and discuss your personal leadership style. Based on your experiences, current readings, work experience, education, and use of self-assessment instruments describe what you thin ...

Assignment -personal reflection 1 -instructions - watch

Assignment - Personal Reflection 1 - Instructions - Watch Milgram's obedience video: Milgram Experiment Proves We Blindly Obey Authority. Consider the following. Christ called his disciples to follow him (Mark 1:17). He ...

Assignment -instructions - please follow instructions for

Assignment - Instructions - Please follow instructions for all for Personal Learning Journal. And each personal learning journal should be of 300words. Each student will keep a personal journal to reflect and record thei ...

Healthcare information technology overview the current

Healthcare Information Technology Overview: The current healthcare industry utilizes a plethora of healthcare information technology (HIT) systems. HIT systems are designed to enhance quality outcomes, prevent adverse ev ...

Archetypes in actionsenge ross smith roberts amp kleiner

Archetypes in Action Senge, Ross, Smith, Roberts, & Kleiner (1994) noted: At its broadest level, systems thinking encompasses a large and fairly amorphous body of methods, tools, and principles, all oriented to looking a ...

Assessment descriptionyou are required to read the

Assessment Description You are required to read the following journal article article: 1. How Risky is Your Company? HBR. May-June 1999 You are also required to read a fictional case study based on a company that will be ...

Discussion - this discussion deals with the important topic

Discussion - This Discussion deals with the important topic of whether money is a motivator for increased job performance and satisfaction. Look at your own history of how you have been compensated, what problems you saw ...

Question - choose a product or technology interview five

Question - Choose a product or technology. Interview five consumers who buy that product and ask them what major problems they have with the product (or what major things they dislike about it). Then ask them to describe ...

Questions -1 choose an industry and then use the library or

Questions - 1. "Choose an industry and then use the library or the Internet to find data from secondary sources that will be highly useful in developing a marketing plan." Start thinking of the industry that relates to t ...

Developing leaders and organisations assessment - report on

Developing, Leaders and Organisations Assessment - Report on Promoting Individual Informal Workplace Learning Brief - You are the newly-appointed Human Resource Advisor in a medium-sized business that employs approximate ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As