The Performance level.xlsx file contains performance information for a sample of 100 companies. Unused capacity is costly and an eager MBA student is trying to explain why some companies use more of their available capacity than others. She has gathered some info as shown in the data file. Delivery speed is a measure of how long customers must wait after placing an order. Price level is a measure of how fast the company's prices have risen relative to their competition. Price flexibility is a measure of how fast the company is able to respond to cost changes in the market place. Manufacturing image and Salesforce image are based on subjective assessments by the companies' customers (a separate questionnaire using a simple Lickert scale was used to get this information). Overall service and Product quality have been taken from independent industry analyses published in trade journals. Firm size is a categorical variable that takes on a value of 1 if the firm's market capitalization is over $500 million.

Using capacity utilization as the dependent variable, estimate an appropriate model. Be sure to explain why you have included or excluded certain variables. Explain your thought processes thoroughly.

Capacity utilization Delivery speed Price level Price flexibility Manufacturing image Overall service Salesforce image Product quality Size of firm 32 4.1 0.6 6. 4.7 2.4 5.2 43 1.8 6.3 5.6 2.5 4 8.4 48 3.4 5.2 5.7 6 4.3 2.7 8.2 32 2.7 1 7.1 5.9 1.8 2.3 7.8 58 6 0.9 9.6 7.8 3.4 4.6 4.5 45 1.9 3.3 7.9 4.8 2.6 1.9 9.7 46 4.6 2.4 9.5 6.6 3.5 4.5 7.6 44 1.3 4.2 6.2 5.1 2.8 2.2 6.9 63 5.5 1.6 9.4 4.7 3.5 3 7.6 54 4 3.5 6.5 6 3.7 3.2 8.7 32 2.4 1.6 8.8 4.8 2 2.8 5.8 47 3.9 2.2 9.1 4.6 3 2.5 8.3 39 2.8 1.4 8.1 3 .8 2.1 1.4 6.6 38 3.7 1.5 8.6 5.7 2.7 3.7 6.7 54 4.7 1.3 9.9 6.7 3 2.6 6.8 49 3.4 2 9.7 4.7 2.7 1.7 4.8 38 3.2 4.1 5.7 5.1 3.6 2.9 6.2 40 4.9 1.8 7.7 4.3 3.4 1.5 5.9 5.3 1.4 9.7 6.1 3.3 3.9 6.8 - o o - o o o o o o o O O O - O 4.7 1.3 9.9 6.7 3 2.6 6.8 3.3 0.9 8.6 2.1 1.8 6.3 3.4 0.4 8.3 2.5 1.2 1.7 5.2 55 4 9.1 7.1 3.5 3.4 8.4 2.4 1.5 6.7 4.8 1.9 2.5 7.2 5 .1 1.4 8.7 4.8 3.3 2.6 3.8 4.6 2.1 7.9 5.8 3.4 2.8 4.7 36 2.4 1.5 6.6 4.8 1.9 2.5 7.2 54 5.2 1.3 9.7 6.1 3.2 3.9 6.7 3.5 2.8 9.9 3.5 3.1 1.7 5.4 4.1 3.7 5.9 5.5 3.9 3 8.4 3 w woo 3 3.2 6 5.3 3.1 3 8 2.8 3.8 8.9 6.9 3.3 3.2 8.2 o o - 5.2 INC 9.3 5.9 3.7 2.4 4.6 3.4 3.7 6.4 5.7 3.5 3.4 8.4 2.4 7.7 3.4 1.7 1.1 6.2 1.8 3.3 7.5 4.5 2.5 2.4 7.6 3.6 4 5.8 5.8 3.7 2.5 9.3 0.9 9.1 5.4 2.4 2.6 7.3 0 2.1 6.9 5.4 1.1 2.6 8.9 2.4 IN 6.4 4.5 2.1 2.2 8.8 1.9 3.4 7.6 4.6 2.6 2.5 7.7 5.9 0.9 9.6 7.8 3.4 4.6 4.5 ooo- 4.9 2.3 9.3 4.5 3.6 1.3 6.2 48 1.3 8.6 4.7 3.1 2.5 3.7 2.6 6.5 3.7 2.4 1.7 8.5 2.5 9.4 4.6 3.7 1.4 6.3 o o- 3.1 1.9 10 4.5 2.6 3.2 3.8 3.4 3.9 5.6 5.6 3.6 2.3 9 .1 5.8 0.2 8.8 4.5 3 2.4 6.7 poo- 5.4 2.1 8 3 3.8 1.4 5.2 3.7 0.7 8.2 6 2.1 2.5 5.2 2.6 4.8 8.2 5 3.6 2.5 9 4.5 4.1 6.3 5.9 4.3 3.4 8.8 2.8 2.4 6.7 4.9 2.5 2.6 9.2 0.8 8.7 2.9 1.6 2.1 5.6 2 .6 7.7 7 2.8 3.6 7.7 - OC 4.9 4.4 7.4 6.9 4.6 9.6 5.4 2.5 9.6 5.5 3 7.7 4.3 1.8 7.6 5.4 3.1 2.5 4.4 2.3 4.5 8 4.7 3.3 2.2 8.7 3.1 1.9 9.9 4.5 2.6 3 .1 3.8 5 .1 1.9 9.2 5.8 3.6 2.3 4.5 4.1 1.1 9.3 5.5 2.5 2.7 7.4 3 3.8 5.5 4.9 3.4 2.6 6 40 1.1 2 7.2 4.7 1.6 3.2 10 3.7 1.4 9 4.5 2.6 2 .3 6.8 4.2 2.5 9.2 6.2 3 .3 3.9 7 .3 1.6 4.5 6.4 5.3 3 2.5 7.1 5.3 1.7 8.5 3.7 3.5 1.9 4.8 2.3 3.7 8.3 5.2 3 2.3 9.1 3 .6 5.4 5.9 6.2 4.5 2.9 8.4 5.6 2.2 8.2 3.1 4 1.6 5.3 o o- 2.2 9.9 4.8 2.9 1.9 4.9 1.3 9.1 4.5 3.3 2.7 7.3 41 NC 6.6 6.6 2.4 2.7 8.2 49 4.2 2.4 9.4 4.9 3.2 2.7 8.5 3.8 0.8 8.3 6.1 2.2 2.6 5.3 ooo- 3.3 2.6 9.7 3.3 2.9 5.2 1.9 7 .1 1.5 4.5 1.5 3.1 9.9 4.5 1.6 8.7 16 3.1 2.1 6.8\f