Please show how to do in excel

If the question is too long complete what you can and I can post the second part in a different post.

update: I got a comment saying not readable, not sure which part its referring to but if you zoom in you should be able to read everything.

Update 2: I;ve uploaded bigger screen shots of the data.

Background

Eagle Industrial Supplies (EIS) produces and markets lawn mowers and tractors in North America, South America, Europe, Pacific Rim, and starting in 2016, China. EIS originally focused on lawn mowers and gradually branched out into the growing tractor market in recent years. EIS has always emphasized quality and customer satisfaction as two main pillars of its business model.

EIS markets its products to both retail consumers as well as industrial customersresellers or retailers and businesses in the related industries such as landscaping. The company considers industrial customers an important segment of the market for sustaining the sales growth in many regions. Accordingly, the executive team has sanctioned a third-party vendor to conduct a survey to better understand EISs relationship with its industrial customers. The team is interested in identifying the factors that positively or negatively affect the level of business conducted between EIS and its industrial customers. Another concern is the variations in annual profit due to the uncertainties in demands for mowers and tractors which will ultimately impact the planned expansions in each region. They are interested in understanding how the variations in demand will affect the companys annual profit which can significantly impact its strategic plans.

Problems

The attached Microsoft Excel file contains the following data: the third-party survey of the companys business customers. Use appropriate functions, tools, and techniques covered in the relevant chapters, class exercises, and assignments to analyze the data and write a summary of findings for each of the following in the context of the case:

1. Regression analysis of the results from the survey of industrial customers (Identify the characteristics of firms that positively or negatively affect usage and satisfaction levels. Identify the attributes of the company that positively or negatively affect usage and satisfaction levels. Discuss the implications of the findings on the companys strategy and competitive advantage. Recommend possible course of actions based on the findings.)
2. Simulation of total annual profit of the company (Set up a Monte Carlo Simulation of 500 trials in a spreadsheet based on the following model and generate summary statistics and 95% confidence interval as well as a histogram or frequency distribution. Comment on major findings from the simulation of the companys total profit. Discuss the simulation results in the context of the companys strategic plans. Explain the limitations of the simulation, if any.):
   • Demand for mowers: normal distribution with = 100,000 and = 3,500
   • Demand for tractors: normal distribution with = 40,000 and = 2,500
   • Variable unit costs for mowers: uniform distribution with a= $150 and b = $175
   • Variable unit costs for tractors: uniform distribution with a= $1,500 and b = $2,000
   • Fixed costs for both mower and tractor productions together: triangular distribution with a= $7,500,000, b = $11,000,000, and c = $9,750,000
   • Production capacity: 150,000 mowers and 50,000 tractors
   • Unit prices: $500 per mower and $2,500 per tractor

S38 fx B C D K M N O P O R S T U V - E F G H Third-Party Survey of Industrial Customers 1 2 Delivery speed 4.1 Manufacturi ng image 4.7 Overall service 2.4 Purchasing structure Size of firm Each entry represents an industrial customer who provided a response to the survey, or a respondent Industry Product quality 5.2 8.4 0 Price level 0.6 3 5.2 4 5 6 0 Usage level 32 43 Satisfaction level 4.2 4.3 5.2 3.9 2.5 Salesforce image 2.3 4 2.7 2.3 4.6 1 1 1.8 3.4 2.7 0 6.6 6 Buying type 1 1 2 1 3 4.3 48 1 1 1 1 1.8 1 Price flexibility 6.90 6.30 5.70 7.10 9.60 7.90 9.50 6.20 9.40 6.50 1 1 6.0 3.4 0 0 1 1.9 0.9 3.3 2.4 32 58 45 46 1.9 1 8 9 10 11 1 1 8.2 7.8 4.5 9.7 7.6 6.9 7.6 8.7 2.6 3.5 2.8 2 1 0 4.6 1.3 1 4.5 2.2 0 1 Company's attributes rated by each respondent on a scale of 0 (poor) to 10 (excellent): Delivery speedthe amount of time it takes to deliver the product once an order is confirmed Price level-the perceived level of price charged by the company Price flexibility-the perceived willingness of the company's representatives to negotiate price on all types of purchases Manufacturing image-the overall image of the manufacturer Overall service-the overall level of service necessary for maintaining a satisfactory relationship between the company and the purchaser Sales force imagethe overall image of the company's sales force Product quality-perceived level of quality 1 0 2 5.5 3.5 3 0 0 1 4.2 1.6 3.5 1.6 1 1 0 4.0 2.4 3.9 8.80 3.7 2 3 0 0 0 1 6.8 4.4 5.8 4.3 5.4 5.4 4.3 5 4.4 5 5.9 4.7 4.4 3 2 1 2 1 0 0 2.2 1.4 2.8 1 0 2.1 2.7 44 63 54 32 47 39 38 54 49 38 40 3.2 2.8 2.5 1.4 3.7 2.6 1.7 2.9 9.10 8.10 8.60 9.90 9.70 1 0 0 1 3.7 4.7 1 1.5 1.3 3 12 13 14 15 16 17 18 19 20 21 22 23 24 25 0 0 0 3 5.8 8.3 6.6 6.7 6.8 4.8 6.2 5.9 6.8 6.8 2 0 0 5.9 7.8 4.8 6.6 5.1 4.7 6 4.8 4.6 3.8 5.7 6.7 4.7 5.1 4.3 6.1 6.7 4 2.5 7.1 4.8 4.8 5.8 4.8 6.1 3.5 5.5 0 3.4 3.2 4.9 3 2 4.1 Measures of the outcomes of the respondent's purchase relationships with the company: Usage level-how much of the firm's total product is purchased from the company, measured on a 100-point scale, ranging from 0% to 100% Satisfaction level-how satisfied the purchaser is with past purchases from the company, measured on the same graphic rating scale as perceptions 1 through 7 2.7 3.6 3.4 5.70 1 1 0 0 1.8 1.5 0 0 7.70 9.70 9.90 2 3 3.3 54 0 0 5.3 4.7 1 3.9 2.6 0 5.6 5.9 6 4.5 3.3 0 0 1.4 1.3 0.9 0.4 3 3 2.1 8.60 0 0 3.3 3.4 6.3 5.2 2 1 1.2 0 0 0 26 3.0 4 8.30 9.10 6.70 3.5 0 1 0 3 2.4 1.9 1 Characteristics of the responding firm: Size of firm-size relative to others in this market [0 = small; 1 = large] Purchasing structure-the purchasing method used in a particular company [1 = centralized procurement, 0 = decentralized procurement] Industrythe industry classification of the purchaser (1 = retail (resale such as Home Depot), 0 = private (non-resale, such as a landscaper)] Buying type-a variable that has three categories (1 = new purchase, 2 = modified rebuy, 3 = straight rebuy] 1 0 1 27 28 29 8.70 0 0 5.1 4.6 2 55 41 35 55 36 49 49 36 54 49 46 3.3 3.4 1.8 1.7 3.4 2.5 2.6 2.8 2.5 3.9 1.7 3 8.4 7.2 3.8 4.7 7.2 6.7 0 0 0 1 1.5 1.4 2.1 1.5 1.3 2.8 3.7 3 5.2 3.7 4.9 5.9 3.7 5.8 5.4 5.1 30 2.4 7.90 6.60 9.70 1.9 1 1 0 1 31 0 1 5.2 3.5 4.1 OO 32 3.2 3.1 3.9 3 3 9.90 0 5.4 8.4 1 0 33 5.90 1 1 2 A B D E F H | J K L M 33 5.5 3 46 1 0 2 4.1 3.0 2.8 3.7 3.2 5.90 6.00 8.90 3.9 3.1 8.4 8 5.1 3.3 34 1 1 3 43 1 0 1 3.8 5.3 6.9 5.9 8.2 53 5 0 1 0 35 36 3 3.3 3.7 3.2 2.4 5.2 2 9.30 4.6 60 6.1 0 0 0 3 3.7 3.5 3.4 47 3.8 1 1 0 1 37 38 3.4 2.4 6.40 7.70 5.7 3.4 8.4 6.2 1 1.1 35 1 1 0 1 1.7 2.5 1.8 3.3 7.50 4.5 39 1 1 4.1 3.6 4.8 1 39 40 1 2.4 2.5 4 5.80 5.8 3.7 7.6 9.3 7.3 44 1 1 1 3.6 4.0 2 41 0.9 5.4 2.4 2.6 46 0 0 1 3 9.10 6.90 42 2.1 5.4 1.1 2.6 8.9 29 5.1 3.9 3.3 1 1 1 1 0.0 2.4 1.9 28 1 1 1 43 44 1 2 3.4 6.40 7.60 4.5 4.6 7.8 2.1 2.6 2.2 2.5 8.8 7.7 40 3.7 1 1 1 1 5.9 9.60 4.6 4.5 58 0 0 1 3 45 46 0.9 2.3 3.4 3.6 4.5 1.3 6.2 53 0 0 0 3 6.7 5.9 4.8 3.2 4.9 5.0 2.0 47 3.1 0 0 0 2 4.7 3.7 2.5 1.7 3.7 8.5 48 38 48 1 1 1 9.30 8.60 6.50 9.40 10.00 5.60 1.3 2.6 2.5 1.9 3.9 2.4 3.7 1 0 1.4 6.3 54 6 0 0 49 50 51 3 5.0 3.1 4.6 4.5 5.6 3.8 55 0 0 1 3 2.6 3.6 3.2 2.3 9.1 43 4.9 4.7 4.9 1 1 1 3.4 5.8 2 0.2 8.80 4.5 3 2.4 6.7 57 0 0 1 3 52 53 8.00 3 3.8 1.4 53 3.8 0 0 1 3 2.1 0.7 5.2 5.2 6 41 5 0 0 0 2 54 55 56 5.4 3.7 2.6 4.5 2.8 2.1 3.6 4.8 5.2 1 1 1 2 8.20 8.20 6.30 6.70 8.70 2.5 2.5 3.4 2.6 5 5.9 4.9 53 50 1 1 0 4.1 2.4 0.8 2 9 8.8 9.2 5.6 5.5 3.7 32 1 1 57 58 1 4.3 2.5 1.6 2.8 1 0 2.9 2.1 39 0 0 1 3.8 2.9 3.7 4.2 59 2.6 7.70 7 3.6 7.7 47 0 1 1 2 60 4.9 4.4 740 69 46 96 62 62 1 1 0 2 B C D E F G H - J K L N A 4.9 60 4.6 4 9.6 62 6.2 1 1 0 EN mm 61 5.4 4 65 6 0 0 0 3 2.5 62 4.3 46 5.6 0 0 1 63 2.3 7.40 9.60 7.60 8.00 9.90 9.20 9.30 7.7 4.4 8.7 3.8 6.9 5.5 5.4 4.7 4.5 5.8 5.5 50 1 4.4 2.5 1.8 4.5 1.9 1.9 1.1 3.8 1 1 2 5 4.8 64 3.1 54 0 0 1 3 65 5.1 4.5 60 6.1 0 0 0 3 2.2 3.1 2.3 2.7 2.6 3.2 66 3.1 3.3 2.6 3.6 2.5 3.4 1.6 2.6 3.3 4.1 7.4 47 5.3 0 0 1 3 67 3.0 5.50 6 36 4.2 0 1 1 2 68 2 7.20 10 40 1 1 1 1 1.1 3.7 4.2 3.4 4.9 69 6.8 45 0 0 0 2 2.3 3.9 70 59 6 0 0 0 3 7.3 7.1 71 1.6 3 46 4.5 1 1 0 2 1.4 2.5 4.5 1.7 3.7 5.4 72 4.8 58 0 0 0 3 5.3 2.3 3.6 73 2.5 1.9 2.3 2.9 3.5 3 4.5 49 4.3 4.8 5.4 1 1 1 2 74 50 1 1 1 2 75 4 55 3.9 0 0 1 3 5.6 3.6 76 2.2 2.2 1.3 4.9 4.7 4.5 6.2 5.3 3.7 5.2 6.2 3.1 4.8 4.5 6.6 4.9 6.1 3.3 4.5 4.6 3.8 8.2 2.9 51 0 0 0 3 9.00 9.20 6.40 8.50 8.30 5.90 8.20 9.90 9.10 6.60 9.40 8.30 9.70 7.10 8.70 8.70 5.50 4.9 5.1 77 5.2 60 0 0 1 3 1 1 0 0 0 1 0 9.1 8.4 5.3 4.9 7.3 8.2 8.5 5.3 5.2 9.9 6.8 4.9 6.3 1.6 1.9 2.7 2.7 2.7 2.6 1.5 3.1 2.1 2.1 4.4 1 2 2 3 0 0 3.3 2.4 3.2 2.2 2.9 1.5 3.1 3.6 4 78 79 80 81 82 83 84 85 0 3.0 4.2 3.8 3.3 1.0 4.5 5.5 3.4 0 2 2.4 0.8 2.6 1.9 1.6 1.8 4.6 1 41 49 42 47 39 56 59 47 4.1 5.2 5.1 5.1 3.3 5.1 4.5 5.6 1 1 1 3 0 0 0 0 0 3 o 1 0 1 2 Price level 4.6 Purchasing stry 1 Industry 1 Buying type 2 2.8 1 0 1 Delivery speed 85 3.4 86 1.6 87 2.3 88 2.6 89 2.5 3.7 1 0 1 3 1 0 2 3.1 1 1 1 90 2.4 2.9 1 0 2 91 3.5 1 0 1 1.2 1 1 1 92 93 2.1 2.9 4.3 3.0 4.8 2.5 0 0 3 Price flexibility Manufacturing Overall service Salesforce ima Product quality Usage level Satisfaction lev Size of firm 5.50 8.2 4 4.4 6.3 47 5.6 0 6.10 6.4 2.3 3.8 8.2 41 4.1 1 7.60 5 3 2.5 7.4 37 4.4 0 8.50 6 2.8 2.8 6.8 53 5.6 1 7.00 4.2 2.8 2.2 9 43 3.7 1 8.40 5.9 2.7 2.7 6.7 51 5.5 1 7.40 4.8 2.8 2.3 7.2 36 4.3 0 7.30 6.1 2 2.5 8 34 4 1 9.30 6.3 3.4 4 7.4 60 6.1 0 7.80 7.1 3 3.8 7.9 49 4.4 0 7.60 4.2 3.3 1.4 5.8 39 5.5 0 5.10 7.8 3.6 4 5.9 43 5.2 0 5.00 4.9 2.2 2.5 8.2 36 3.6 1 6.70 4.5 2.2 2.1 5 31 4 0 6.40 5 0.7 2.1 8.4 25 3.4 1 9.20 4.8 3.3 2.8 7.1 60 5.2 0 5.20 5 2.4 2.7 8.4 38 3.7 1 6.70 6.8 2.6 2.9 8.4 42 4.3 1 9.00 5 2.2 3 6 33 4.4 0 94 2.8 1 1 2. 95 0 0 2 1.7 4.2 96 3.1 1 1 2 97 2.7 1 0 1 1.9 4.0 98 0.5 0 1 1 1.6 1 1 1 0.5 0 1 3 0.6 6.1 2.0 3.1 2.5 2.8 1 0 99 100 101 102 103 104 1 2.2 1 0 1 1.8 0 0 1 S38 fx B C D K M N O P O R S T U V - E F G H Third-Party Survey of Industrial Customers 1 2 Delivery speed 4.1 Manufacturi ng image 4.7 Overall service 2.4 Purchasing structure Size of firm Each entry represents an industrial customer who provided a response to the survey, or a respondent Industry Product quality 5.2 8.4 0 Price level 0.6 3 5.2 4 5 6 0 Usage level 32 43 Satisfaction level 4.2 4.3 5.2 3.9 2.5 Salesforce image 2.3 4 2.7 2.3 4.6 1 1 1.8 3.4 2.7 0 6.6 6 Buying type 1 1 2 1 3 4.3 48 1 1 1 1 1.8 1 Price flexibility 6.90 6.30 5.70 7.10 9.60 7.90 9.50 6.20 9.40 6.50 1 1 6.0 3.4 0 0 1 1.9 0.9 3.3 2.4 32 58 45 46 1.9 1 8 9 10 11 1 1 8.2 7.8 4.5 9.7 7.6 6.9 7.6 8.7 2.6 3.5 2.8 2 1 0 4.6 1.3 1 4.5 2.2 0 1 Company's attributes rated by each respondent on a scale of 0 (poor) to 10 (excellent): Delivery speedthe amount of time it takes to deliver the product once an order is confirmed Price level-the perceived level of price charged by the company Price flexibility-the perceived willingness of the company's representatives to negotiate price on all types of purchases Manufacturing image-the overall image of the manufacturer Overall service-the overall level of service necessary for maintaining a satisfactory relationship between the company and the purchaser Sales force imagethe overall image of the company's sales force Product quality-perceived level of quality 1 0 2 5.5 3.5 3 0 0 1 4.2 1.6 3.5 1.6 1 1 0 4.0 2.4 3.9 8.80 3.7 2 3 0 0 0 1 6.8 4.4 5.8 4.3 5.4 5.4 4.3 5 4.4 5 5.9 4.7 4.4 3 2 1 2 1 0 0 2.2 1.4 2.8 1 0 2.1 2.7 44 63 54 32 47 39 38 54 49 38 40 3.2 2.8 2.5 1.4 3.7 2.6 1.7 2.9 9.10 8.10 8.60 9.90 9.70 1 0 0 1 3.7 4.7 1 1.5 1.3 3 12 13 14 15 16 17 18 19 20 21 22 23 24 25 0 0 0 3 5.8 8.3 6.6 6.7 6.8 4.8 6.2 5.9 6.8 6.8 2 0 0 5.9 7.8 4.8 6.6 5.1 4.7 6 4.8 4.6 3.8 5.7 6.7 4.7 5.1 4.3 6.1 6.7 4 2.5 7.1 4.8 4.8 5.8 4.8 6.1 3.5 5.5 0 3.4 3.2 4.9 3 2 4.1 Measures of the outcomes of the respondent's purchase relationships with the company: Usage level-how much of the firm's total product is purchased from the company, measured on a 100-point scale, ranging from 0% to 100% Satisfaction level-how satisfied the purchaser is with past purchases from the company, measured on the same graphic rating scale as perceptions 1 through 7 2.7 3.6 3.4 5.70 1 1 0 0 1.8 1.5 0 0 7.70 9.70 9.90 2 3 3.3 54 0 0 5.3 4.7 1 3.9 2.6 0 5.6 5.9 6 4.5 3.3 0 0 1.4 1.3 0.9 0.4 3 3 2.1 8.60 0 0 3.3 3.4 6.3 5.2 2 1 1.2 0 0 0 26 3.0 4 8.30 9.10 6.70 3.5 0 1 0 3 2.4 1.9 1 Characteristics of the responding firm: Size of firm-size relative to others in this market [0 = small; 1 = large] Purchasing structure-the purchasing method used in a particular company [1 = centralized procurement, 0 = decentralized procurement] Industrythe industry classification of the purchaser (1 = retail (resale such as Home Depot), 0 = private (non-resale, such as a landscaper)] Buying type-a variable that has three categories (1 = new purchase, 2 = modified rebuy, 3 = straight rebuy] 1 0 1 27 28 29 8.70 0 0 5.1 4.6 2 55 41 35 55 36 49 49 36 54 49 46 3.3 3.4 1.8 1.7 3.4 2.5 2.6 2.8 2.5 3.9 1.7 3 8.4 7.2 3.8 4.7 7.2 6.7 0 0 0 1 1.5 1.4 2.1 1.5 1.3 2.8 3.7 3 5.2 3.7 4.9 5.9 3.7 5.8 5.4 5.1 30 2.4 7.90 6.60 9.70 1.9 1 1 0 1 31 0 1 5.2 3.5 4.1 OO 32 3.2 3.1 3.9 3 3 9.90 0 5.4 8.4 1 0 33 5.90 1 1 2 A B D E F H | J K L M 33 5.5 3 46 1 0 2 4.1 3.0 2.8 3.7 3.2 5.90 6.00 8.90 3.9 3.1 8.4 8 5.1 3.3 34 1 1 3 43 1 0 1 3.8 5.3 6.9 5.9 8.2 53 5 0 1 0 35 36 3 3.3 3.7 3.2 2.4 5.2 2 9.30 4.6 60 6.1 0 0 0 3 3.7 3.5 3.4 47 3.8 1 1 0 1 37 38 3.4 2.4 6.40 7.70 5.7 3.4 8.4 6.2 1 1.1 35 1 1 0 1 1.7 2.5 1.8 3.3 7.50 4.5 39 1 1 4.1 3.6 4.8 1 39 40 1 2.4 2.5 4 5.80 5.8 3.7 7.6 9.3 7.3 44 1 1 1 3.6 4.0 2 41 0.9 5.4 2.4 2.6 46 0 0 1 3 9.10 6.90 42 2.1 5.4 1.1 2.6 8.9 29 5.1 3.9 3.3 1 1 1 1 0.0 2.4 1.9 28 1 1 1 43 44 1 2 3.4 6.40 7.60 4.5 4.6 7.8 2.1 2.6 2.2 2.5 8.8 7.7 40 3.7 1 1 1 1 5.9 9.60 4.6 4.5 58 0 0 1 3 45 46 0.9 2.3 3.4 3.6 4.5 1.3 6.2 53 0 0 0 3 6.7 5.9 4.8 3.2 4.9 5.0 2.0 47 3.1 0 0 0 2 4.7 3.7 2.5 1.7 3.7 8.5 48 38 48 1 1 1 9.30 8.60 6.50 9.40 10.00 5.60 1.3 2.6 2.5 1.9 3.9 2.4 3.7 1 0 1.4 6.3 54 6 0 0 49 50 51 3 5.0 3.1 4.6 4.5 5.6 3.8 55 0 0 1 3 2.6 3.6 3.2 2.3 9.1 43 4.9 4.7 4.9 1 1 1 3.4 5.8 2 0.2 8.80 4.5 3 2.4 6.7 57 0 0 1 3 52 53 8.00 3 3.8 1.4 53 3.8 0 0 1 3 2.1 0.7 5.2 5.2 6 41 5 0 0 0 2 54 55 56 5.4 3.7 2.6 4.5 2.8 2.1 3.6 4.8 5.2 1 1 1 2 8.20 8.20 6.30 6.70 8.70 2.5 2.5 3.4 2.6 5 5.9 4.9 53 50 1 1 0 4.1 2.4 0.8 2 9 8.8 9.2 5.6 5.5 3.7 32 1 1 57 58 1 4.3 2.5 1.6 2.8 1 0 2.9 2.1 39 0 0 1 3.8 2.9 3.7 4.2 59 2.6 7.70 7 3.6 7.7 47 0 1 1 2 60 4.9 4.4 740 69 46 96 62 62 1 1 0 2 B C D E F G H - J K L N A 4.9 60 4.6 4 9.6 62 6.2 1 1 0 EN mm 61 5.4 4 65 6 0 0 0 3 2.5 62 4.3 46 5.6 0 0 1 63 2.3 7.40 9.60 7.60 8.00 9.90 9.20 9.30 7.7 4.4 8.7 3.8 6.9 5.5 5.4 4.7 4.5 5.8 5.5 50 1 4.4 2.5 1.8 4.5 1.9 1.9 1.1 3.8 1 1 2 5 4.8 64 3.1 54 0 0 1 3 65 5.1 4.5 60 6.1 0 0 0 3 2.2 3.1 2.3 2.7 2.6 3.2 66 3.1 3.3 2.6 3.6 2.5 3.4 1.6 2.6 3.3 4.1 7.4 47 5.3 0 0 1 3 67 3.0 5.50 6 36 4.2 0 1 1 2 68 2 7.20 10 40 1 1 1 1 1.1 3.7 4.2 3.4 4.9 69 6.8 45 0 0 0 2 2.3 3.9 70 59 6 0 0 0 3 7.3 7.1 71 1.6 3 46 4.5 1 1 0 2 1.4 2.5 4.5 1.7 3.7 5.4 72 4.8 58 0 0 0 3 5.3 2.3 3.6 73 2.5 1.9 2.3 2.9 3.5 3 4.5 49 4.3 4.8 5.4 1 1 1 2 74 50 1 1 1 2 75 4 55 3.9 0 0 1 3 5.6 3.6 76 2.2 2.2 1.3 4.9 4.7 4.5 6.2 5.3 3.7 5.2 6.2 3.1 4.8 4.5 6.6 4.9 6.1 3.3 4.5 4.6 3.8 8.2 2.9 51 0 0 0 3 9.00 9.20 6.40 8.50 8.30 5.90 8.20 9.90 9.10 6.60 9.40 8.30 9.70 7.10 8.70 8.70 5.50 4.9 5.1 77 5.2 60 0 0 1 3 1 1 0 0 0 1 0 9.1 8.4 5.3 4.9 7.3 8.2 8.5 5.3 5.2 9.9 6.8 4.9 6.3 1.6 1.9 2.7 2.7 2.7 2.6 1.5 3.1 2.1 2.1 4.4 1 2 2 3 0 0 3.3 2.4 3.2 2.2 2.9 1.5 3.1 3.6 4 78 79 80 81 82 83 84 85 0 3.0 4.2 3.8 3.3 1.0 4.5 5.5 3.4 0 2 2.4 0.8 2.6 1.9 1.6 1.8 4.6 1 41 49 42 47 39 56 59 47 4.1 5.2 5.1 5.1 3.3 5.1 4.5 5.6 1 1 1 3 0 0 0 0 0 3 o 1 0 1 2 Price level 4.6 Purchasing stry 1 Industry 1 Buying type 2 2.8 1 0 1 Delivery speed 85 3.4 86 1.6 87 2.3 88 2.6 89 2.5 3.7 1 0 1 3 1 0 2 3.1 1 1 1 90 2.4 2.9 1 0 2 91 3.5 1 0 1 1.2 1 1 1 92 93 2.1 2.9 4.3 3.0 4.8 2.5 0 0 3 Price flexibility Manufacturing Overall service Salesforce ima Product quality Usage level Satisfaction lev Size of firm 5.50 8.2 4 4.4 6.3 47 5.6 0 6.10 6.4 2.3 3.8 8.2 41 4.1 1 7.60 5 3 2.5 7.4 37 4.4 0 8.50 6 2.8 2.8 6.8 53 5.6 1 7.00 4.2 2.8 2.2 9 43 3.7 1 8.40 5.9 2.7 2.7 6.7 51 5.5 1 7.40 4.8 2.8 2.3 7.2 36 4.3 0 7.30 6.1 2 2.5 8 34 4 1 9.30 6.3 3.4 4 7.4 60 6.1 0 7.80 7.1 3 3.8 7.9 49 4.4 0 7.60 4.2 3.3 1.4 5.8 39 5.5 0 5.10 7.8 3.6 4 5.9 43 5.2 0 5.00 4.9 2.2 2.5 8.2 36 3.6 1 6.70 4.5 2.2 2.1 5 31 4 0 6.40 5 0.7 2.1 8.4 25 3.4 1 9.20 4.8 3.3 2.8 7.1 60 5.2 0 5.20 5 2.4 2.7 8.4 38 3.7 1 6.70 6.8 2.6 2.9 8.4 42 4.3 1 9.00 5 2.2 3 6 33 4.4 0 94 2.8 1 1 2. 95 0 0 2 1.7 4.2 96 3.1 1 1 2 97 2.7 1 0 1 1.9 4.0 98 0.5 0 1 1 1.6 1 1 1 0.5 0 1 3 0.6 6.1 2.0 3.1 2.5 2.8 1 0 99 100 101 102 103 104 1 2.2 1 0 1 1.8 0 0 1