Marketing officer is typing to determine the primary causes of customers dissati
ID: 3229746 • Letter: M
Question
Marketing officer is typing to determine the primary causes of customers dissatisfaction with a new product recently launched. A telephone survey of customers who have recently bought the product provided the following data, high price (30 customers) difficult usability instructions (120 customers), per packaging (80 customers), narrow selection of colors (20 customers), too many batteries required to operate (50 customers), (40 customers). In the space below, hand a Pareto chart for this data and the 80/20 rule in your analysis A car dealer has had the following number of car sales for the past 12 Quarters. Q1(2012):200 Q1(2013): 240 Q1(2014): 288 Q2(2012): 150 Q2(2013): 180 Q2(2014): 216 Q3(2012): 300 Q3(2013): 360 Q3(2014): 432 Q4(2012): 400 Q4(2013): 480 Q4(2014): 576 Write the forecast for the next 4 quarters, using the above time series sales patterns to guide four analysis. Assume 2016 will have the same sales conditions was experienced in the prior 3 years. Q1(2015): Q2(2015): Q3(2015): Q4(2015):Explanation / Answer
Year Quarter Sales MA CMA Ratio Avg_Ratio SI DeS Time 2012 1 200 0.835951756 239.2482563 1 2012 2 150 0.590990483 253.8111937 2 2012 3 300 262.5 267.5 1.121495327 1.123066027 267.1258793 3 2012 4 400 272.5 276.25 1.447963801 1.449991734 275.8636417 4 2013 1 240 280 287.5 0.834782609 0.834782609 0.910914481 263.4714948 5 2013 2 180 295 305 0.590163934 0.590163934 0.970793578 185.415318 6 2013 3 360 315 321 1.121495327 1.121495327 0.99388473 362.2150428 7 2013 4 480 327 331.5 1.447963801 1.447963801 1.124407211 426.8916061 8 2014 1 288 336 345 0.834782609 0.910914481 316.1657938 9 2014 2 216 354 366 0.590163934 0.970793578 222.4983816 10 2014 3 432 378 0.99388473 434.6580513 11 2014 4 576 1.124407211 512.2699273 12 a) S.I Q1 0.835951756 Q2 0.590990483 Q3 1.123066027 Q4 1.449991734 b) Deseasonalized data is as mentioned above in the table. Trend line based on time as dependent variable is 195.415645+18.136498(Time) c) Q1 195.415645+18.136498(13) 431.190119 Q2 195.415645+18.136498(14) 449.326617 Q3 195.415645+18.136498(15) 467.463115 Q4 195.415645+18.136498(16) 485.599613 d) Final values Q1 360.4541371 Q2 265.5477545 Q3 524.9919435 Q4 704.1154247