Performance lawn equipment case study in business analytics

Assignment Help Operation Management
Reference no: EM131121406

Performance Lawn Equipment case study in Business Analytics text by James R. Evans. The problem statement is: "An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers in NA, Eur and Pacific regions as well as industry mower sales to assess future changes in market share. She also wants to forecast future increases in market share. She also wants to forecast future increases in production costs. Develop forecasting models for these data and prepare a formal report of your result with appropriate charts and outputs. Can you assist me with how to go about figuring 1st what model to use and the initial steps needed to solve these problem. I just need a starting point please. This is the model: Month NA SA Europe Pacific China World Jan-10 6000 200 720 100 0 7020 Feb-10 7950 220 990 120 0 9280 Mar-10 8100 250 1320 110 0 9780 Apr-10 9050 280 1650 120 0 11100 May-10 9900 310 1590 130 0 11930 Jun-10 10200 300 1620 120 0 12240 Jul-10 8730 280 1590 140 0 10740 Aug-10 8140 250 1560 130 0 10080 Sep-10 6480 230 1590 130 0 8430 Oct-10 5990 220 1320 120 0 7650 Nov-10 5320 210 990 130 0 6650 Dec-10 4640 180 660 140 0 5620 Jan-11 5980 210 690 140 0 7020 Feb-11 7620 240 1020 150 0 9030 Mar-11 8370 250 1290 140 0 10050 Apr-11 8830 290 1620 150 0 10890 May-11 9310 330 1650 130 0 11420 Jun-11 10230 310 1590 140 0 12270 Jul-11 8720 290 1560 150 0 10720 Aug-11 7710 270 1530 140 0 9650 Sep-11 6320 250 1590 150 0 8310 Oct-11 5840 250 1260 160 0 7510 Nov-11 4960 240 900 150 0 6250 Dec-11 4350 210 660 150 0 5370 Jan-12 6020 220 570 160 0 6970 Feb-12 7920 250 840 150 0 9160 Mar-12 8430 270 1110 160 0 9970 Apr-12 9040 310 1500 170 0 11020 May-12 9820 360 1440 160 0 11780 Jun-12 10370 330 1410 170 0 12280 Jul-12 9050 310 1440 160 0 10960 Aug-12 7620 300 1410 170 0 9500 Sep-12 6420 280 1350 180 0 8230 Oct-12 5890 270 1080 180 0 7420 Nov-12 5340 260 840 190 0 6630 Dec-12 4430 230 510 180 0 5350 Jan-13 6100 250 480 200 0 7030 Feb-13 8010 270 750 190 0 9220 Mar-13 8430 280 1140 200 0 10050 Apr-13 9110 320 1410 210 0 11050 May-13 9730 380 1340 190 0 11640 Jun-13 10120 360 1360 200 0 12040 Jul-13 9080 320 1410 200 0 11010 Aug-13 7820 310 1490 210 0 9830 Sep-13 6540 300 1310 220 0 8370 Oct-13 6010 290 980 210 0 7490 Nov-13 5270 270 770 220 0 6530 Dec-13 5380 260 430 230 0 6300 Jan-14 6210 270 400 200 0 7080 Feb-14 8030 280 750 190 0 9250 Mar-14 8540 300 970 210 0 10020 Apr-14 9120 340 1310 220 5 10995 May-14 9570 390 1260 200 16 11436 Jun-14 10230 380 1240 210 22 12082 Jul-14 9580 350 1300 230 26 11486 Aug-14 7680 340 1250 220 14 9504 Sep-14 6870 320 1210 220 15 8635 Oct-14 5930 310 970 230 11 7451 Nov-14 5260 300 650 240 3 6453 Dec-14 4830 290 300 230 1 5651

Reference no: EM131121406

Questions Cloud

Mentioned corporate culture development : You mentioned corporate culture development as being a rewarding function. Of course, this can be true if HR can play a role in this - but do you think they really can? Isn't the culture of the organization set by the top managers of the company? Can..
Describe the intervention you have selected : Have you ever heard the expression: "If you're not measuring it, you're not managing it?" In this discussion, you will determine how you would measure the results of an intervention. Select an intervention with which you have some experience. Describ..
What factors related to financing-marketing and management : The base case and the locations selected for the first four stores, suggest some of the operational factors that WF took into account in deciding on the locations of the new 365 stores. What factors related to financing, marketing and management shou..
Source or underlying cause of the unethical behavior : What was the source or underlying cause of the unethical behavior? What was the hoped for outcome if there was one? Was an individual or a group involved? Did the accused seem sorry for what they did or defensive? Discuss what you would do as a manag..
Performance lawn equipment case study in business analytics : Performance Lawn Equipment case study in Business Analytics text by James R. Evans. The problem statement is: "An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales..
Explain knowledge management : Explain Knowledge Management. Examine how knowledge works (or doesn't) in an organization (or one you were previously associated with). Based on the reading for this week (or any outside materials), what recommendations would you make?
What are potential ethical challenges in the industry : What are potential ethical challenges in the industry in which you work? Describe a possible situation and how your firm deals with the potential of such a threat through policies and practice (for instance, employee handbook, training, progressive d..
Determine the critical path and interpret its meaning : The Ajax manufacturing Co. has received a contract from NASA for the final assembly of a space module for an upcoming mission. A team of engineers has determined the activities, precedence, constraints, and time estimates as in the accompanying table..
Determine the delivery schedule : SA supply serves the greater Houston area and has to determine the delivery schedule for tomorrow. Given the demand information in the graph and truck capacity of 30 units, Use the sweep heuristic starting from Depot going counter clock wise and find..

Reviews

Write a Review

Operation Management Questions & Answers

  Contents and sequence of risk management plan

The content that is required in a risk management plan is covered in the course. See the PMBOK guide for ideas on how to present your plan. Communicating metrics: When effective for communicating numbers, schedules, et cetera, use tables, bar char..

  Food is an integral part of understanding

Food is an integral part of understanding different countries, cultures, and lifestyles. In fact, your company is interested in importing Australian wine to the United States

  Implementing efforts to achieve effective interaction

In your organization (or one you have been a part of in the past), what efforts have been made to eliminate ineffective communication, while also implementing efforts to achieve effective interaction? Be specific in your response with both positive a..

  Create the mrp tables for all parts of the cd cabinet

Using the MRP Forms - create the MRP tables for all parts of the CD cabinet for a 12 week planning period. Note: You need to adjust the forms to work with this assignment by adding the required information

  Average aggregate inventory value for raw material

A firm had the following annual data: COGS = $1,265M; Raw material used = $500M. Based on this data, can we calculate the weeks of supply of raw material although the average aggregate inventory value for raw material is not given?

  Highly cellular consisting of superficial epithelial cells

This is an 18-month-old boy who was healthy until about 8 days ago when his mother noted reddened blotches on his neck and trunk particularly his upper back. The smear is highly cellular consisting of superficial epithelial cells. The patient should ..

  Identify which iso standards apply to riordan manufacturing

Identify three TQM tools that may be used for ongoing process improvement. Be sure to describe who will use the tool, when it will be used, and what interval and how it will lead to process improvement.

  Calculate total annual cost of ordering and holding flour

A large bakery buys flour in 25 kg bags. The bakery uses an average of' 4,860 bags a year. Preparing an order and receiving a shipment of flour bags involves a cost of $10 per order. Annual holding cost is $5 per flour bag. Determine the economic ord..

  Sensitivity ranges for the objective function coefficients

A company produces two products, A and B, which have profits of $9 and $7, respectively. What is the sensitivity ranges for the objective function coefficients? Determine the shadow prices for additional hours of production time on line 1 and line 2 ..

  State emvs of different alternatives are considered rational

The decisions made based on the EMVs of different alternatives are considered rational. Are there limitations or risks of using the EMV approach

  Calculate maximum change in money supply from transaction

Matthew and Kyle live and bank in Texas. The reserve requirement is 20%. If Matthew sells government bonds to Kyle for $1,000,000, will the money supply likely rise, fall, or not change?

  Case study on infoglide

David Wheeler got into business in order to ease his anger about his father's murder and in an attempt to see justice done. A computer database expert, he designed a program that would sift through crime reports in an effort to link and pinpoint c..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd