The marketing manager of a company that manufactures and distributes farmingequipment (such as combined harvesters, ploughs and tractors) recorded thenumber of farming units sold quarterly for the period 2007 to 2010.Table 5Quarter2007200820092010Summer57606564Autumn51566062Winter50535858Spring56616870a. Find the quarterly seasonal indexes for farming equipment sold.b. Do seasonal forces significantly influence the sale of farming equipment?Comment.c. Derive a least squares trend line for the sales of farming equipment usinga sequential numbering system starting with x = 1 in period 1.d. Prepare seasonally-adjusted trend estimates of the number of farmingunits that this company can expect to sell in each quarter of 2011.

Answered: Image /qna-images/answer/1c404d2c-f5a8-441e-80ff-f2cb3b8a339f.jpg

Answered: Table 5 Quarter 2007 2008 2009 2010…

Principles Of Marketing

17th Edition

ISBN:9780134492513

Author:Kotler, Philip, Armstrong, Gary (gary M.)

Publisher:Kotler, Philip, Armstrong, Gary (gary M.)

Chapter1: Marketing: Creating Customer Value And Engagement

Section: Chapter Questions

Problem 1.1DQ

See similar textbooks

Similar questions

i need the answer quickly
Quarter 1 2 31 11 14 172 20 23 263 29 32 354 38 41 44Compute seasonal relatives for this quarterly data.a. Use the SA method.
Please solve this question...
Prepare a Demand Forecast for “Year 5” using Excel. Quarterly Data for Cars Sales Yt Year Quarter Sales (1000s) Year 1 1 4.80 2 4.10 3 6.00 4 6.50 Year 2 1 5.80 2 5.20 3 6.80 4 7.40 Year 3 1 6.00 2 5.60 3 7.50 4 7.80 Year 4 1 6.30 2 5.90 3 8.00 4 8.40 Year 5 1 2 3 4
Month Jan Feb Mar Apr Answer: Demand Using a 3-month weighted moving average forecasting method with weights of 50% for the most recent demand, 30% for demand from 2 periods before, and 20% from 3 periods back, what is the forecast for May? Answer to 1 decimal place. Check 130 123 100 80
14. The demand for Krispee Crunchies is experiencing a decline. The company wants to monitor demand for this product closely as it nears the end of its life cycle. The following table shows the actual sales history for January to October. Generate forecasts for November to December, using the trend projection with regression method. Looking at the accuracy of its forecasts in the Trend Projection Worksheet, as well as the other statistics provided, how confident are you in these forecasts for November to December? Month January February March April May June Sales 890,000 800,000 825,000 840,000 730,000 780,000 Month July August September October November December Sales 710,000 730,000 680,000 670,000
March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same
Please help with this. Thank you for your assistance.
Sales in hunderds) of XYX Cc for the previous 7 months are 80, 82. 88, 95, 103, 105 and 122 respectively. Forecast the sales by 4 point moving average method for the forthcoming penod Oa 10260 units Ob 10625 units Oc 11000 units d. 113500 units
Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates? (Hint, you might want to use excel for this) period 1 2 3 4 5 6 7 8 9 10 13673 6640 2737 3486 141 13186) 5448 3485 7728 16591 8236 3316 855358 11 12 13 15 16 17 18 19 Demand Deseasonalized D₁ Demand D 3200 7658 4420 2384 3654 8680 5795 1953 4742 20 4472 4657 4956 5074 5157 5917 6646 6850 6791 6573 6363 6308 6932 7887 8662 8989 O Level-4696 Trend-343 O Level-3612. Trend-264 O Level 3629; Trend-263 O Level-2528: Trend-185
1
please answer in 30 mins. answer if 100% sure.

Recommended textbooks for you

Principles Of Marketing

Marketing

ISBN:

9780134492513

Author:

Kotler, Philip, Armstrong, Gary (gary M.)

Publisher:

Pearson Higher Education,

Marketing

ISBN:

9781259924040

Author:

Roger A. Kerin, Steven W. Hartley

Publisher:

McGraw-Hill Education

Foundations of Business (MindTap Course List)

Marketing

ISBN:

9781337386920

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Principles Of Marketing

Marketing

ISBN:

9780134492513

Author:

Kotler, Philip, Armstrong, Gary (gary M.)

Publisher:

Pearson Higher Education,

Marketing

ISBN:

9781259924040

Author:

Roger A. Kerin, Steven W. Hartley

Publisher:

McGraw-Hill Education

Foundations of Business (MindTap Course List)

Marketing

ISBN:

9781337386920

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Marketing: An Introduction (13th Edition)

Marketing

ISBN:

9780134149530

Author:

Gary Armstrong, Philip Kotler

Publisher:

PEARSON

MKTG 12:STUDENT ED.-TEXT

Marketing

ISBN:

9781337407595

Author:

Lamb

Publisher:

Cengage

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

Table 5 Quarter 2007 2008 2009 2010 Summer 57 60 65 64 Autumn 51 56 60 62 Winter 50 53 58 58 Spring 56 61 68 70 a. Find the quarterly seasonal indexes for farming equipment sold.