MarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales. Car Sales Manufacturer Jan.-Nov. 2017 Jan.-Nov. 2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota 2,211,533 2,205,762 Fiat Chrysler 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 542,245 Mercedes (includes Sprinter) 332,990 318,012 BMW 271,432 276,657 VW 309,395 322,017 Mazda 262,577 274,455 Audi 199,534 200,558 Tesla (Est.) 40,320 106,050 Land Rover 66,759 81,526 Volvo 71,828 89,437 Mitsubishi 95,185 109,088 Porsche 51,507 53,116 MINI 42,494 40,887 Jaguar 36,180 27,021 Others 18,901 17,251 smart 2,905 1,154 Click here for the Excel Data File a. Using computer software, compare 2017 sales to the 2018 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales compared to 2017; make a list of manufacturers that decreased sales. Which manufacturers are in the top five with increased sales? Which manufacturers are in the bottom five with decreased sales? (Enter values in decreasing order and negative values with a minus sign.) b. Using computer software, compare 2017 sales to 2018 sales for each manufacturer by computing the percentage change in sales. Make a list of the manufacturers in order of increasing percentage changes. Which manufacturers are in the top five in percentage change? Which manufacturers are in the bottom five in percentage change? (Enter values in decreasing order and negative values with a minus sign. Round percentage answers to 1 decimal place.) c-1. Using computer software, first sort the data using the 2018 year-to-date sales. Then, design a bar graph to illustrate the 2017 and 2018 year-to-date sales for the top 10 manufacturers and select the most appropriate graph below. Bar Graph A Bar Graph B Bar Graph C multiple choice 1 Bar Graph A Correct Bar Graph B Bar Graph C
Critical Path Method
The critical path is the longest succession of tasks that has to be successfully completed to conclude a project entirely. The tasks involved in the sequence are called critical activities, as any task getting delayed will result in the whole project getting delayed. To determine the time duration of a project, the critical path has to be identified. The critical path method or CPM is used by project managers to evaluate the least amount of time required to finish each task with the least amount of delay.
Cost Analysis
The entire idea of cost of production or definition of production cost is applied corresponding or we can say that it is related to investment or money cost. Money cost or investment refers to any money expenditure which the firm or supplier or producer undertakes in purchasing or hiring factor of production or factor services.
Inventory Management
Inventory management is the process or system of handling all the goods that an organization owns. In simpler terms, inventory management deals with how a company orders, stores, and uses its goods.
Project Management
Project Management is all about management and optimum utilization of the resources in the best possible manner to develop the software as per the requirement of the client. Here the Project refers to the development of software to meet the end objective of the client by providing the required product or service within a specified Period of time and ensuring high quality. This can be done by managing all the available resources. In short, it can be defined as an application of knowledge, skills, tools, and techniques to meet the objective of the Project. It is the duty of a Project Manager to achieve the objective of the Project as per the specifications given by the client.
MarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales.
| Car Sales | ||||
| Manufacturer | Jan.-Nov. 2017 |
Jan.-Nov. 2018 |
||
| GM (Est.) | 2,691,493 | 2,654,568 | ||
| Ford | 2,334,290 | 2,265,590 | ||
| Toyota | 2,211,533 | 2,205,762 | ||
| Fiat Chrysler | 1,887,430 | 2,038,684 | ||
| Honda | 1,492,112 | 1,449,713 | ||
| Nissan | 1,455,238 | 1,345,157 | ||
| Hyundai | 621,961 | 612,225 | ||
| Subaru | 584,614 | 615,594 | ||
| Kia | 546,629 | 542,245 | ||
| Mercedes (includes Sprinter) | 332,990 | 318,012 | ||
| BMW | 271,432 | 276,657 | ||
| VW | 309,395 | 322,017 | ||
| Mazda | 262,577 | 274,455 | ||
| Audi | 199,534 | 200,558 | ||
| Tesla (Est.) | 40,320 | 106,050 | ||
| Land Rover | 66,759 | 81,526 | ||
| Volvo | 71,828 | 89,437 | ||
| Mitsubishi | 95,185 | 109,088 | ||
| Porsche | 51,507 | 53,116 | ||
| MINI | 42,494 | 40,887 | ||
| Jaguar | 36,180 | 27,021 | ||
| Others | 18,901 | 17,251 | ||
| smart | 2,905 | 1,154 | ||
Click here for the Excel Data File
a. Using computer software, compare 2017 sales to the 2018 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales compared to 2017; make a list of manufacturers that decreased sales. Which manufacturers are in the top five with increased sales? Which manufacturers are in the bottom five with decreased sales? (Enter values in decreasing order and negative values with a minus sign.)
b. Using computer software, compare 2017 sales to 2018 sales for each manufacturer by computing the percentage change in sales. Make a list of the manufacturers in order of increasing percentage changes. Which manufacturers are in the top five in percentage change? Which manufacturers are in the bottom five in percentage change? (Enter values in decreasing order and negative values with a minus sign. Round percentage answers to 1 decimal place.)
c-1. Using computer software, first sort the data using the 2018 year-to-date sales. Then, design a bar graph to illustrate the 2017 and 2018 year-to-date sales for the top 10 manufacturers and select the most appropriate graph below.
| Bar Graph A | Bar Graph B | Bar Graph C |
multiple choice 1
-
Bar Graph A Correct
-
Bar Graph B
-
Bar Graph C
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 9 images
