Explore BrainMass

Compiling automobile ratings into charts

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

You work for an independent automobile rating company that provides statistics to consumers. A group of testers recently evaluated four 2012 mid-sized passenger car models and provided the data to you in a worksheet. You need to transform the data into meaningful charts that you will include on your company's Web site. Refer to figure 3.54 as you complete the exercise (see attachment).

a. Open e03m1autos and save it as 03m1autos_RobinSquires.
b. Select the rand A3:F8, and then create a stacked column chart. You realize that the data in this chart is not cumulative and that you included the overall ratings by category. You also notice that the chart is located to the side of the data. Make the following changes:
• Change the chart to a clustered column chart.
• Remove the overall category from the data source.
• Position the chart starting in cell A11, and then increase the chart width through cell G27.
c. Make the following design changes:
• Select Layout 1 as the chart layout size.
• Edit the chart title to be 2012 Mid-Sized Car Ratings by Category.
• Apply the Red, Accent 2, Darker 25% font color to the chart title.
• Apply the Style 12 chart style.
d. Create a screen print of the file at this point. Save the image to a MS Word document with the file name, Lesson 6_Car_RobinSquires.docx
• Select the range A4:A7, press and hold Ctrl, and then select the range G4:G7-the models and overall ratings.
• Create a clustered bar chart.
• Move the chart to its own sheet named Overall Ratings.
e. Make the following changes to the bar chart (see figure 3.54/attached):
• Remove the legend.
• Add the title 2012 Mid-Sized Car Overall Ratings above the chart.
• Apply the Style 2 chart style, if necessary.
• Add data labels in the Outside End position, and the bold the data labels. Apply the Fog gradient fill color to the data labels.
• Select the data series, and then apply a picture fill, searching for clip art of a blue automobile. Select the option to stack the images instead of stretching one image per data marker.
f. Insert a footer with Robin Squires and ROB2209353 on the left side, the sheet name code in the center, and the file name code on the right side on all worksheets.
g. Adjust the page setup option to fit the worksheet to one page with 0.5" left and right margins.
h. Save and close the workbook *Note: When completed there should be two attachments: 6_Car_RobinSquires.docx and e03m1autos_RobinSquires.xlsx

© BrainMass Inc. brainmass.com October 17, 2018, 12:01 pm ad1c9bdddf


Solution Summary

A solution-only Excel spreadsheet with Word document containing the required plots.

Similar Posting

Project Management Protocols

Case # 1

Kendrick discusses the project charter, which defines a project, in Chapters 2 (pp. 13-14) and 5. Usually the project charter is written by senior management; it authorizes the project leader to proceed with the execution of a project. The charter provides project leaders with the broad authority over all the elements associated with a project. In that sense it is a method of control over a project team where direct authority is lacking. Through the project charter, the project team members know that senior management stands behind the project and their failure to perform will be made known to their functional managers. Consider the following:

Company XYZ's board of directors has approved a project to build a new assembly line for widgets in an existing plant. The new assembly line will be fully automated, thus requiring relatively few employees, and will cost in the area of $10 million. This has become a high priority project because the existing plant, located in the United States with a relatively high manpower requirement, cannot compete against low-cost Chinese imports. But having an automated production line, coupled with certain advantages of having a plant within the United States, would restore the competitiveness of the company and turn growing losses around into profits. For that reason, completing the project in the shortest possible time is of utmost importance to the company.

Review the major parts of a project charter outlined in Kendrick, Chapter 2, pp. 13-14. Write a project charter for the project just described, including as much detail as possible. (You may invent certain details if you wish, but anything you invent must fit into the general parameters given in the previous paragraph description.) The charter will be signed by the XYZ board of directors and given to the project leader as the directive to proceed with the project (to be completed in the shortest possible time without exceeding the cost estimate of $10 million).

# 2. Questions

After reading Leading Virtual Teams (Pocket Mentor), write a 3-4 page, double-spaced paper (700 to 1000 words) that examines the following questions:

1. What are the competencies that a project manager needs in order to lead global virtual teams? Consider the kind of competencies you need to improve upon. How do you plan to acquire these skills?

2. What are some technological, cultural, and communication challenges inherent in global virtual project teams? How would you mitigate these challenges so that they do not impact timely and successful project executions/completions?

3. As the senior vice-president for global projects, how would you coach/train your new project managers to build effective high performing virtual teams? How would you determine which project managers are the best candidates to successfully manage resources in dispersed geographies around the world?

4. Kendrick discusses project staffing—establishing a team—in Chapter 5. Examine his suggestions on staffing (page 115 and following), and then write 2 to 4 paragraphs (200 to 400 words) that explain how following his suggestions would help a project leader to gain control during the initiation stage of the project.

Case # 2

This assignment has two parts. Complete all of the questions in both parts.

Part 1

1. Two projects are described below. For each, make a list of deliverables you would include to ensure that the project fulfills its objectives.

a. You are in the process of working with a contractor to pave a new driveway for your house as well as to build a detached two-car garage at the end of it. What deliverables would you place in the contract?

b. You work for a company that makes widgets. You have a single plant located in the United States. The plant has order, credit, manufacturing, warehousing, shipping, and invoicing departments. Each of these departments has its own unique legacy computer software programs. Information is passed from one department to the next by hand-keying the necessary information into a different computer hardware and software system. Your firm wants to implement enterprise resource planning (ERP), which involves replacing such individual legacy systems with one integrated software system, where an order will proceed from beginning to end without anyone having to input data other than what was entered when the order was originally placed. Make a list of deliverables you would expect from the software company setting up the ERP system.

2. What is involved in testing the limits as you do initial scoping?

3. What is the value of a scope document?

Part 2
A work breakdown structure (WBS) is a deliverable-oriented hierarchical decomposition of the work to be executed by the project team in order to accomplish the project objectives and create the required deliverables. In short, it is a giant "to do" list that shows how the team will accomplish the project objectives. A WBS organizes and defines the total scope of the project while subdividing the project into smaller, more manageable pieces in descending levels. Kendrick describes this process in Chapter 6. For a brief explanation and sample, see the chart below.

Look back to Part 1 of this assignment, where you made a list of deliverables. Choose one of the two projects described in Part 1, and create a work breakdown structure for it.

View Full Posting Details