manhon 1 1. You are required to read the case completely as described in the PLE.pdf document. 2. Download the excel sheet, HW3PLE.xlsx. 3. Complete the columns C and E on the same excel sheet. 4. Column C is where you mention if this data item was collected from an Internal source or External source or Special Study. 5. Column E is where you categorize the data item mentioned in each row into Interval, Ratio, Ordinal and Categorical. 6. After you complete the columns C and E, save it and upload it on Canvas , in the same format, for grading. Bluebells ... will Com . Worksheer Datasheet Dealer Satisfaction Source External Classification of Data Categorical Interval Ordinal Ratio HINT Ratio 2 End-User Satisfaction 3 2012 Customer Survey 4 Complaints Mower Unit Sales Metric in the datasheet Region Years Survey Scale Dealer Satisfaction Results Number of Dealers Sample Size Region Yoars Survey Scale Dealer Satisfaction Results: Number of End-Users Sample Se Region Quality Ease of Use Price Service Month World NA SA Eur Pac China Month NA SA Europe Pacific China World Month NA SA Eur Pac China World Month NA SA Eur Pac World Month NA SA Eur Pas China World Month Tractor Mower Month Administrative Depreciation interest 6 Tractor Unit Sales 7 Industry Mower Total Sales Industry Tractor Total Sales Unit Production Costs 10 Operating and Interest Expenses 11 On-Time Delivery 12 Defects After Delivery 13 Time To Pay Suppliers 14 Response Time 15 Employee Satisfaction Month Number of deliveries Number On Time Percent Month 2000 2009 2010 2011 2012 Month Working Days 01 2011 Q2 2011 Q3 2011 04 2011 Q1 2012 Q2 2012 Q3 2012 04 2012 Quarter Design & Production Sample size Manager Sample size Sales & Administration Sample size Total Sample size Production Time min Current Process A Process Weigh Observations YearPLE YsEducation College GPA Age Gender College Grad Local Engines Transmission Costs 17 18 19 20 Blade Weight Mower Test Employee Retention 21 Shipping Cost 22 Fixed Cost 23 Purchasing Survey Customer Mowers Tractors Current Plants Additional Capacity Cost Proposed Locations Maximum capacity Cost Delivery speed Price level Price fesibility Maracturing image Overal service Salesforce image Product quality Usage Level Satisfaction Level Size of fimm Purchasing Structure Industry Buying Type manhon 1 1. You are required to read the case completely as described in the PLE.pdf document. 2. Download the excel sheet, HW3PLE.xlsx. 3. Complete the columns C and E on the same excel sheet. 4. Column C is where you mention if this data item was collected from an Internal source or External source or Special Study. 5. Column E is where you categorize the data item mentioned in each row into Interval, Ratio, Ordinal and Categorical. 6. After you complete the columns C and E, save it and upload it on Canvas , in the same format, for grading. Bluebells ... will Com . Worksheer Datasheet Dealer Satisfaction Source External Classification of Data Categorical Interval Ordinal Ratio HINT Ratio 2 End-User Satisfaction 3 2012 Customer Survey 4 Complaints Mower Unit Sales Metric in the datasheet Region Years Survey Scale Dealer Satisfaction Results Number of Dealers Sample Size Region Yoars Survey Scale Dealer Satisfaction Results: Number of End-Users Sample Se Region Quality Ease of Use Price Service Month World NA SA Eur Pac China Month NA SA Europe Pacific China World Month NA SA Eur Pac China World Month NA SA Eur Pac World Month NA SA Eur Pas China World Month Tractor Mower Month Administrative Depreciation interest 6 Tractor Unit Sales 7 Industry Mower Total Sales Industry Tractor Total Sales Unit Production Costs 10 Operating and Interest Expenses 11 On-Time Delivery 12 Defects After Delivery 13 Time To Pay Suppliers 14 Response Time 15 Employee Satisfaction Month Number of deliveries Number On Time Percent Month 2000 2009 2010 2011 2012 Month Working Days 01 2011 Q2 2011 Q3 2011 04 2011 Q1 2012 Q2 2012 Q3 2012 04 2012 Quarter Design & Production Sample size Manager Sample size Sales & Administration Sample size Total Sample size Production Time min Current Process A Process Weigh Observations YearPLE YsEducation College GPA Age Gender College Grad Local Engines Transmission Costs 17 18 19 20 Blade Weight Mower Test Employee Retention 21 Shipping Cost 22 Fixed Cost 23 Purchasing Survey Customer Mowers Tractors Current Plants Additional Capacity Cost Proposed Locations Maximum capacity Cost Delivery speed Price level Price fesibility Maracturing image Overal service Salesforce image Product quality Usage Level Satisfaction Level Size of fimm Purchasing Structure Industry Buying Type
