INSS220 MSU Datasets Graphs And Calculations Homework Help

Anonymous
timer Asked: Mar 4th, 2019
account_balance_wallet $9.99

Question Description

The information you will need is uploaded it is an excel chart and it is about datasets and we have to construct graphs and do calculations.

Unformatted Attachment Preview

Part 1 (based on chapters 1, 2 and 3) Due Sunday, March 3 Project grading criteria / Rubric: This is the first part of the project which requires to use descriptive statistics techniques covered in chapters 2 and 3. This part is worth 65 points and will be graded based on 2 categories: calculations and conclusions. You should submit an Excel file with your calculations and Word file with answers to the questions. Calculations category measures your ability to construct charts and graphs and calculate numerical measures. You can earn up to 30 points in the category. Conclusions category grades your ability to understand data, select appropriate charts and measures, interpret the results given in form of charts and numerical measures. This category is worth 35 points. You are expected to write at least 2-3 sentences per question. Dataset description: A company wants to analyze performance of one of its suppliers to understand should they continue to work with the supplier in the future. Information about several last orders received from the supplier was collected. The following measures of the supplier performance were used:       Percent defective shows what percent of items received from the supplier were defective; Delivery timeliness is measured as early, on-time, or late delivery; Price per unit of product; Order size Quantity received is the percentage of the ordered quantity which was actually received; Accuracy measures how the order was fulfilled. It can be one of the five options: “Very accurate” (5 points), “Accurate” (4 points), “Neutral” (3 points), “Inaccurate” (2 points), and “Very inaccurate” (1 points). Please, answer the questions below based on the information provided. If some of required information is not given to you, you can/should make an assumption. Question: The goal of this part of the project is to learn how to use descriptive statistics to summarize information and draw conclusions. Using the given dataset, answer the following questions: 1 1. Is it a sample or a population? Why? 2. Is it time series or cross-sectional data? Why? 3. What are elements, variables, and observations in the dataset? 4. Define a type of each variable in the dataset (ordinal, nominal, interval or ratio). 5. Choose one qualitative variable from your dataset and construct a chart (anyone appropriate) to summarize information about the variable. Describe what you see on the chart (2-3 sentences/points). 6. Choose one quantitative variable from your dataset and construct a chart (anyone appropriate) to summarize information about the variable. Describe what you see on the chart (2-3 sentences/points). 7. Choose another variable (variables used in questions 5 and 6 CANNOT be used) from your dataset and calculate 2 numerical measures to summarize information about the variable. Discuss the results and why this measures were used? (2-3 sentences/points). 8. Choose any 2 variables (can be previously used) from your dataset and analyze relationship between variables (use appropriate forms of descriptive statistics; charts, numerical measures, etc.). Are these variables related? Is the relationship linear? Is the relationship strong or weak? Explain your answers. 2 System quality User 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Cost of ownership Medium Medium Medium High High Medium Medium Medium Low Low Medium High Low Medium Medium High Low High Medium Low Low High Low Medium Low Low Medium High Medium Low Medium Medium Low Medium Low Medium Medium Low Low Ease of use Reliability 71 42 76 49 40 33 93 51 95 94 40 83 86 32 77 60 58 73 40 87 82 82 77 42 50 42 92 69 97 76 97 90 36 49 85 77 39 53 35 74 48 80 41 84 75 55 30 81 77 68 58 92 78 39 29 58 68 47 48 86 30 74 59 82 99 83 51 82 75 38 45 92 64 40 91 58 29 52 Information quality Speed Timeliness Acuracy Ralevance 93 71 95 69 92 69 41 74 98 63 61 53 60 94 76 86 98 88 63 78 42 78 65 45 85 61 45 57 71 44 83 55 80 79 81 90 35 91 68 51 74 40 59 45 34 90 77 77 53 66 92 83 53 64 53 59 35 78 64 99 39 59 97 71 96 44 54 87 83 95 46 58 45 63 78 52 54 62 44 56 44 45 99 48 58 60 66 90 84 64 44 58 54 99 43 87 34 67 81 96 46 40 50 72 34 70 47 70 43 54 89 49 72 61 73 85 79 82 48 64 33 89 67 99 70 80 99 89 63 51 97 94 72 42 73 95 36 64 97 67 52 55 94 93 76 66 87 76 86 80 61 57 90 51 95 96 Overall satisfaction 73 77 66 79 85 65 65 72 98 77 66 78 79 65 89 71 69 85 60 55 72 83 70 73 80 60 60 51 71 82 75 86 90 79 62 76 63 75 80 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Sales 94 85 100 101 95 106 99 103 108 119 112 111 125 118 130 123 126 120 121 132 121 128 121 133 Assets Liabilities Current Fixed Current Long-term Net profit Inventory 15.3 52 12.1 10 21.7 High 14 47 11.8 20 19.1 High 14.9 45 11.3 15 24.6 Medium 13.6 51 11.1 11 24.3 Medium 14.9 52 11.8 16 22 High 13.5 45 11.2 19 25.9 Medium 16.2 51 12.7 10 24.2 High 15.8 47 12.4 14 24.7 High 15.9 55 10.8 17 26 Medium 13.8 47 11.9 16 29.8 Medium 13.9 52 10.4 10 28.4 Low 15.7 47 11 17 27.7 Medium 13.2 51 10.9 15 32.7 Low 15.2 52 11.2 17 29.3 Medium 12.1 51 11 20 34.7 Medium 13.3 50 10.9 10 31.4 Low 13.7 47 10.8 17 32 Low 18.8 52 12.3 10 30.7 High 12.1 53 11.3 11 31.2 Medium 14.8 54 11 12 35 Medium 12.5 47 10.3 20 31.5 Low 13.1 54 11.6 16 34.5 Medium 13.8 49 10.3 13 30.8 Low 13.6 47 10.3 11 35 Low User 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Price per night Low Medium Low High Medium Medium Low High High High Medium High Low High Low High Medium Medium Medium Medium Medium High Medium High Low Medium Low Medium High Low Medium Medium Check-in 2 3 2 3 0 4 4 0 2 1 4 0 3 1 1 0 2 2 2 2 3 5 2 3 5 0 0 3 5 3 1 0 Service Room Dining 3 2 0 2 2 3 1 0 1 2 3 1 1 0 2 4 4 3 4 1 2 5 5 1 2 0 4 1 0 3 3 4 Exterior 4 1 2 3 0 1 1 3 1 3 2 0 2 4 2 2 5 2 5 2 2 5 0 2 2 0 5 5 5 2 4 4 3 1 2 2 0 4 1 0 4 1 2 2 5 4 2 3 0 2 0 2 1 2 2 2 3 4 2 2 0 5 2 3 Condition Lobby 5 5 0 1 3 5 3 4 4 1 5 4 2 0 1 5 5 1 1 4 5 1 0 0 2 1 4 5 0 3 5 0 Room 2 5 5 2 2 2 2 4 5 4 2 3 2 1 5 3 0 1 5 1 2 1 2 1 3 2 0 5 2 2 2 1 Overall satisfaction 41 46 34 26 4 47 35 17 40 40 28 24 41 19 40 40 25 20 30 21 30 45 27 13 39 10 33 40 26 52 33 18 Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Gender Female Male Female Female Male Male Female Male Male Male Male Male Male Male Male Female Female Female Male Male Male Male Male Male Female Male Female Male Female Male Female Male Male Female Age 59 40 30 42 23 27 55 46 29 39 52 40 39 23 55 48 35 36 39 52 50 39 63 30 32 58 38 50 45 44 53 57 48 38 Salary Medium Low Medium Medium Low Low High Medium Low Medium Medium Low Low Low High Medium Medium High High Low High Low Medium Medium Medium Low Medium Medium High Medium Low Low Low Low Question 1 Question 2 Question 3 5 1 2 2 1 3 2 2 1 2 2 3 2 1 3 3 2 5 4 3 1 5 4 2 5 2 1 1 2 2 3 2 2 1 4 4 5 2 1 5 1 1 1 1 1 2 2 1 3 1 4 3 2 1 5 2 1 3 1 5 1 2 2 4 1 3 2 1 2 5 1 5 4 1 5 4 1 2 5 3 1 2 1 1 1 2 1 3 4 1 1 1 2 2 3 4 1 2 1 2 1 5 Order number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Percent defective 8.892810801 2.496890103 7.434247995 5.77039136 4.091433141 4.205550467 9.973686656 0.050758632 1.598503661 5.768900583 3.620675677 8.079117111 3.95906706 8.180671557 1.322024213 8.978320579 5.202283966 7.386113857 9.094680622 4.450678857 5.352264206 9.527195775 6.929577638 4.2708307 1.070179493 2.941259782 0.61418564 3.083158534 2.71874074 5.779767167 Delivery timeliness On-time On-time On-time On-time Early On-time On-time On-time On-time Late Late On-time Early Late On-time On-time Early Late Late Early On-time Late On-time On-time On-time Early Late Late Late On-time Price, $ per unit 17 15 11 16 14 18 15 14 20 15 12 18 12 19 13 18 20 14 13 11 11 14 15 11 15 12 16 20 16 20 Order size Large Medium Medium Medium Small Medium Large Large Medium Medium Medium Medium Medium Medium Large Medium Medium Medium Medium Medium Small Medium Small Small Medium Large Large Medium Large Medium Quantity recieved Acuracy 2.904782 5 2.459966 2 2.013312 2 1.73175 1 8.013186 1 0.351703 5 5.854064 3 0.841119 3 4.204791 5 3.424232 5 4.370023 5 3.13458 1 5.453391 5 5.113631 5 6.376672 2 6.00417 5 1.403855 2 9.180562 5 2.968654 1 0.772257 4 5.61571 3 6.441035 3 5.646595 5 1.908344 2 9.275272 5 8.518055 1 5.156588 3 3.411785 5 1.73925 2 4.322342 5 Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Gender Female Male Female Male Female Female Male Female Female Male Female Female Male Male Male Male Female Female Female Female Female Male Male Male Male Male Male Male Age 48 49 52 50 61 23 35 54 38 53 47 48 36 39 32 33 48 23 59 41 52 57 55 52 44 59 65 59 Years at company Question 1 Question 2 Question 3 22 2 5 2 6 1 1 2 25 4 2 2 5 4 5 2 12 1 5 2 0 3 1 2 11 2 1 5 12 1 1 5 0 3 2 2 11 2 5 3 18 3 4 5 15 1 2 2 3 5 5 3 0 5 3 4 2 1 1 2 10 2 4 5 17 2 2 4 0 2 2 1 27 4 2 1 19 2 2 5 9 3 4 5 23 4 5 1 28 2 2 3 16 3 2 5 7 3 5 5 14 1 4 5 31 2 1 2 18 4 5 5 Employee Team size 1 7 2 11 3 25 4 17 5 8 6 20 7 8 8 21 9 11 10 27 11 22 12 20 13 22 14 12 15 28 16 22 17 10 18 11 19 26 20 16 21 9 22 18 23 20 24 21 25 21 26 10 27 14 28 22 29 18 30 11 31 12 32 12 33 22 Project length 21 45 36 21 13 35 42 20 60 44 57 19 60 22 57 30 43 31 41 47 45 15 45 54 58 7 22 49 39 13 14 56 40 Project budget Medium Medium Medium Medium Low Medium Low Low High Medium Medium Medium Medium Medium Low High Low Low Medium High Medium Medium Medium Medium Medium Medium High High High High High Low Medium Question 1 Question 2 Question 3 5 1 1 2 1 2 5 3 1 2 3 2 3 1 2 5 2 3 2 2 2 2 1 4 5 3 2 4 2 4 5 2 4 5 2 4 4 2 5 4 1 5 1 2 3 4 2 2 4 1 2 3 2 4 2 3 2 5 1 1 2 2 1 5 2 1 4 2 3 5 1 4 5 4 5 5 2 1 5 1 3 4 2 2 2 1 3 4 1 1 4 2 3 2 2 4 5 2 2 Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Gender Male Male Male Female Male Female Female Female Female Female Female Male Female Male Male Male Male Female Female Male Male Male Male Female Female Male Male Female Male Male Female Female Male Male Male Age 50 41 21 22 21 42 53 58 32 33 25 33 33 37 31 59 59 64 22 31 58 34 36 58 34 60 34 55 33 53 54 29 46 30 37 Salary Medium Medium Low Medium Medium High High Low Medium Low Low Low Low Medium High Low Medium Low Medium High High Medium Low Low Low Medium Low Low Low Medium Low Medium Medium Medium High Question 1 Question 2 Question 3 4 1 1 2 4 1 2 2 1 1 2 3 2 4 2 2 1 5 5 2 1 1 2 1 3 1 5 2 2 2 4 1 3 2 2 3 2 3 1 5 2 2 4 1 4 2 1 2 5 2 3 2 3 1 2 5 5 2 1 5 2 1 2 5 2 5 2 1 5 1 3 2 2 2 2 2 1 5 2 1 2 1 1 1 5 2 1 4 2 1 2 1 1 2 3 3 2 1 1 2 3 5 2 1 3 Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Gender Male Male Male Male Female Male Male Female Female Female Male Female Male Male Male Female Female Male Male Female Female Male Male Female Female Male Female Male Male Male Female Male Female Female Male Female Age 54 60 33 36 20 54 30 45 52 28 27 64 33 41 68 64 43 38 42 18 51 64 38 28 22 56 36 25 27 38 51 32 40 34 47 52 Marinal Status Married Divorsed Married Married Divorsed Divorsed Married Married Married Married Single Married Divorsed Single Single Divorsed Married Married Single Married Married Married Married Married Married Single Married Single Married Divorsed Married Divorsed Married Married Divorsed Married Family size 2 3 4 2 3 3 2 2 1 3 2 2 2 2 3 5 2 2 4 2 5 3 3 3 4 3 2 2 4 3 3 4 2 2 4 1 Income Low High Medium Low High High Medium Medium High High Medium Medium High High Medium Low Medium Medium High High Medium Medium Medium Low High Medium Medium High Medium Medium High Medium Medium Low High High Spendings 336 707 800 332 750 725 500 459 429 749 486 420 606 615 566 763 459 466 869 639 899 582 649 497 902 585 465 612 809 627 750 796 485 353 908 434 Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Gender Female Male Male Female Female Female Male Female Male Male Female Male Male Female Female Male Male Female Male Male Male Female Male Male Male Male Female Female Male Female Female Male Female Female Age Older Middle Middle Middle Middle Middle Middle Middle Middle Older Older Middle Middle Young Middle Middle Young Young Middle Middle Middle Older Young Young Young Middle Young Young Middle Young Middle Young Middle Middle Marinal Status Divorsed Married Married Married Divorsed Married Divorsed Single Divorsed Married Married Married Single Married Single Married Single Married Married Married Married Divorsed Married Married Single Single Married Married Married Divorsed Married Married Married Married Family size 4 3 2 3 4 1 2 2 1 2 5 3 3 2 1 4 2 3 2 2 3 5 2 5 3 2 3 4 4 2 2 3 1 2 Income, $'000 Spendings 22 734 26 469 40 348 39 540 41 665 31 192 96 458 111 484 42 228 52 488 92 978 64 534 28 469 93 535 122 339 103 750 30 375 121 700 55 399 39 389 56 520 66 936 126 571 61 890 72 630 64 420 107 664 37 741 48 684 93 525 89 477 39 548 42 201 76 438 Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Size Small Small Large Medium Large Large Medium Medium Large Large Large Large Medium Large Medium Medium Medium Medium Medium Small Medium Medium Small Large Assets Liabilities Current Fixed Current Long-term Net profit Sales 127 14 56 10.3 11 46.3 123 11.3 49 10.8 13 43.6 158 10.3 82 12 18 61.3 141 10.6 60 10.9 13 50.3 157 13.1 96 12.1 11 64.3 160 11.2 81 11.8 11 62.1 141 10.9 63 11.7 19 52.3 140 13.4 76 11.3 18 53 151 13 82 11.6 10 58.4 149 9.4 89 11.8 14 60 154 9.1 92 12.3 13 61.1 153 12.7 89 12.6 20 59.9 138 11.7 62 11.8 14 50.7 172 12.8 84 12.2 13 65.6 148 10.5 71 10.9 13 56.3 137 11.9 60 11.7 19 50.3 148 13.3 75 11.3 14 57.2 131 10.4 65 10.9 10 49.4 153 12.3 78 10.9 20 58.2 120 12.1 47 11.1 13 41.3 149 10.4 66 11 20 54.8 140 9.4 62 11.9 17 50.1 127 13.4 46 10.3 11 42.9 159 13.5 92 11.6 14 63.9 User 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Price per night Medium High Medium Medium Medium Medium Medium Medium Low Medium High Medium Medium High Medium Medium Medium Medium Medium Medium Medium Low Medium High Medium Low Low High Check-in 1 4 5 0 1 2 5 3 1 1 2 4 1 5 1 4 2 5 1 4 4 4 4 2 4 5 4 4 Service Room Dining 5 1 1 2 2 1 4 1 0 3 4 0 3 5 2 2 1 3 5 3 0 2 5 3 2 2 3 3 Exterior 5 1 5 5 0 5 3 2 1 2 0 4 3 2 2 5 2 0 3 2 2 5 4 2 0 1 2 2 1 1 5 2 4 4 5 2 1 4 2 5 0 0 2 1 5 2 0 1 2 5 2 1 0 0 0 2 Condition Lobby 3 4 5 0 0 1 1 1 0 1 1 1 1 3 4 5 4 5 1 5 1 4 0 5 5 0 3 1 Room 1 2 2 4 3 2 2 5 0 2 0 0 4 4 5 1 2 0 2 4 2 4 0 4 0 2 1 3 Overall satisfaction 47 46 70 48 31 57 73 41 12 41 35 42 38 67 65 60 51 47 31 70 44 79 47 57 36 31 42 48 Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Gender Male Male Male Female Female Female Male Male Female Male Male Male Male Female Male Male Female Male Male Female Male Male Male Female Female Male Female Male Male Male Male Male Male Female Female Female Age 49 55 63 34 37 64 37 23 42 39 66 48 64 20 60 36 33 36 21 23 47 54 57 54 32 56 37 60 64 57 21 43 50 20 27 44 Marinal Status Single Single Single Divorsed Single Married Married Married Married Divorsed Married Married Married Divorsed Married Married Married Divorsed Single Single Divorsed Divorsed Divorsed Married Married Married Married Married Married Married Married Married Divorsed Married Married Married Family size 3 3 4 1 1 2 5 2 2 1 4 4 3 1 3 4 3 4 4 4 2 4 4 2 2 4 4 1 1 1 1 4 5 3 3 3 Income High Low Medium Medium Medium High High High Medium Low High Low High Medium Medium Medium Low Low Medium Medium Medium High High Medium Medium Medium Medium Medium Medium Low Low Medium Medium Low Medium High Spendings 651 420 641 315 296 512 921 571 399 148 745 560 637 325 527 678 413 545 698 694 411 763 764 415 443 643 669 273 256 156 203 694 810 460 547 674 Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Gender Female Male Male Male Male Female Male Male Male Male Male Male Female Male Female Female Male Male Female Female Female Male Male Female Male Male Female Male Female Male Female Female Male Female Age 63 25 34 62 45 51 50 44 46 30 33 59 40 28 50 49 54 63 61 29 41 61 54 27 55 65 42 23 54 21 38 63 37 33 Years at company Question 1 Question 2 Question 3 35 2 3 2 1 1 2 3 0 4 4 2 0 3 5 2 12 1 2 3 26 3 5 3 4 2 1 5 8 5 5 4 11 2 5 3 8 2 3 4 7 3 2 2 32 3 4 2 6 2 2 2 3 2 5 3 4 3 2 2 24 2 1 2 0 1 2 5 36 2 5 2 13 3 3 3 2 1 2 5 15 3 1 5 21 1 5 5 14 2 4 2 2 3 1 5 11 2 2 2 0 3 2 5 13 3 1 3 1 1 4 3 0 4 1 5 0 1 2 1 3 5 2 2 27 1 3 4 5 2 3 2 10 5 2 2 User 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Price per night Low Medium High Low Low Medium Medium Medium Medium Low Medium Medium Low Medium Medium Medium Medium Low Medium Low Medium Medium Medium Medium Medium Low High Medium Medium Medium Medium High Low Low High Check-in 0 2 1 3 5 0 1 4 2 4 0 0 1 3 3 0 3 2 2 0 3 0 1 1 4 3 0 4 1 2 0 0 1 1 0 Service Room Dining 3 0 3 1 1 0 1 2 5 0 2 0 4 1 1 5 0 0 4 4 4 5 0 1 2 1 1 2 0 3 5 0 3 3 0 Exterior 3 5 3 2 4 2 2 5 2 2 1 0 4 5 2 1 5 5 0 5 5 3 3 5 0 2 2 5 4 0 5 0 1 0 2 2 1 2 1 3 2 0 1 1 2 0 2 0 0 0 2 3 2 2 2 3 4 0 0 0 3 3 2 2 5 1 5 3 0 2 Condition Lobby 1 0 2 1 5 0 1 4 0 3 0 0 5 0 5 0 2 2 5 2 2 5 0 4 1 4 0 0 4 1 0 0 2 0 1 Room 2 4 5 2 4 0 2 2 4 0 3 1 1 3 3 0 0 3 0 2 4 2 3 2 3 4 0 2 5 2 2 3 2 2 4 Overall satisfaction 38 53 58 45 84 22 14 64 59 52 31 1 63 40 39 21 43 47 41 52 81 63 18 42 40 69 15 61 49 54 50 24 43 28 33 Employee Team size 1 14 2 8 3 12 4 14 5 16 6 18 7 23 8 16 9 14 10 21 11 15 12 11 13 15 14 18 15 14 16 8 17 13 18 25 19 27 20 24 21 18 22 8 23 8 24 8 25 8 26 27 27 11 28 17 29 15 30 27 31 19 32 24 33 14 34 27 35 27 36 22 Project length 40 33 31 27 55 32 21 13 39 28 47 30 15 58 37 49 16 46 50 57 49 13 43 57 7 52 29 9 16 40 10 47 13 8 30 54 Project budget Medium Low Low Medium Medium Low Medium Medium High Low Low Medium Medium Medium Low High Medium Medium Low Medium Medium Low Medium Medium Low Low Low Low Medium Medium High Low Medium Medium High Medium Question 1 Question 2 Question 3 3 2 1 4 3 2 2 1 1 4 2 2 5 3 2 5 2 2 5 2 2 5 1 2 2 2 4 5 4 3 1 2 1 2 2 3 3 1 2 2 1 2 5 1 1 5 1 2 4 1 1 5 2 5 2 4 1 2 3 4 4 1 4 4 3 2 5 2 2 4 2 5 2 5 1 2 4 2 4 2 3 3 1 4 5 3 4 1 2 1 4 5 2 2 2 1 5 5 3 4 2 3 3 2 3 5 2 4 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Sales 85 87 105 91 87 95 102 121 103 107 113 99 111 112 115 124 108 123 124 134 140 127 134 126 Assets Liabilities Current Fixed Current Long-term Net profit 12.4 48 11 14 21.8 16.9 49 11.1 14 22.5 15.7 47 10.8 15 28.2 15.7 46 11.9 19 22.3 13.9 52 10.9 17 22.1 14.9 46 11.5 14 25.5 18 55 12.6 13 27.2 12.2 51 11.7 11 32.7 15 53 11.9 17 26.9 11 50 10.1 13 28.3 15.6 52 10.9 12 30.2 12.6 51 10.3 19 26 14.9 45 12.1 13 30.8 14 55 10.5 13 30.5 13.7 45 10.8 10 30.5 13.7 46 10.7 17 34.1 17.9 47 12.4 18 29.9 13.4 48 11.3 19 34.2 18.1 46 12.6 10 35 12 45 11 13 38.1 10.2 45 10.8 16 39.5 13.7 45 11.2 16 36.1 12 49 11.7 16 38.4 13.2 46 10.6 14 34 Inventory Medium Medium Medium High Medium Medium High Medium High Low Medium Low High Low Medium Low High Medium High Low Low Medium Medium Low Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Size Small Small Medium Small Large Medium Medium Medium Small Small Large Medium Large Large Large Medium Large Medium Large Medium Large Medium Large Small Assets Liabilities Current Fixed Current Long-term Net profit Sales 118 11.7 56 11 15 41.9 121 9.8 60 10.3 20 44.8 139 12.3 69 11.1 16 53 112 9.2 60 10.7 15 40.6 161 11.7 82 12.4 11 61.8 145 9.5 71 10.8 20 55.1 133 11.3 65 11.7 15 49.3 162 9 69 11.6 19 59 122 13.4 44 10.8 19 41.8 124 12.9 43 10.9 14 42.2 160 11.1 86 12.1 14 62.6 145 9.4 76 11.8 12 55.8 163 12 89 12.1 16 63.1 165 10 ...
Purchase answer to see full attachment

Tutor Answer

Ace_Tutor
School: Purdue University

attach...

flag Report DMCA
Review

Anonymous
awesome work thanks

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors