Shelly Cashman Word 2019 | Modules 4-7: SAM Capstone Project 1a

/0 Comments/in /by

Shelly Cashman Word 2019 | Modules 4-7: SAM Capstone Project 1a

 Shelly Cashman Word 2019 | Modules 4-7: SAM Capstone Project 1a

Hankins Aerospace

DEVELOPING AN ANNUAL REPORT

GETTING STARTED

  • Open the file SC_WD19_CS4-7a_FirstLastNamedocx, available for download from the SAM website.
  • Save the file as SC_WD19_CS4-7a_FirstLastNamedocx by changing the “1” to a “2”.
    • If you do not see the .docx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
  • To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
    • Support_WD19_CS4-7a_Data.png
    • Support_WD19_CS4-7a_Founder.docx
    • Support_WD19_CS4-7a_List.docx
    • Support_WD19_CS4-7a_Table.docx
  • With the file SC_WD19_CS4-7a_FirstLastNamedocx still open, ensure that your first and last name is displayed in the footer.
    • If the footer does not display your name, delete the file and download a new copy from the SAM website.
  • PROJECT STEPS
  1. As an executive assistant at Hankins Aerospace in San Diego, California, you are drafting an annual report for the members of a management committee to review. The report begins with a personalized cover letter to shareholders.

    Change the margins and orientation of the document as follows:

    1. Change the page orientation to Portrait to use the standard format for letters.
    2. Change the top and bottom margins to .75″ to allow more space for content.
  2. Use the content placeholders as follows to include standard information for a form letter:
    1. Delete the COMPANY NAME content control because the letterhead already displays the company name.
    2. Use the Date content control with the “CLICK TO SELECT A DATE” placeholder text to display JANUARY 17, 2022 as the date.
  3. Apply the Basic (Stylish) style set to use the standard style set for Hankins Aerospace reports.
  4. Create custom theme colors and fonts to apply to this report and other Hankins Aerospace reports as follows:
    1. Create a customized set of theme colors named Hankins that uses Teal, Accent 4 as the Hyperlink color.
    2. Create a customized set of theme fonts named HA Reports that uses Calibri Light as the heading font and Constantia as the body font.
  5. Create a new paragraph style as follows to use for the inside address:
    1. Create a paragraph style named Inside Address based on the “INSERT INSIDE ADDRESS” paragraph.
    2. Change the Spacing After paragraph setting of the Inside Address style to 2 point.
    3. Change the font color of the Inside Address style to Black, Text 1, Lighter 35%.
  6. Save the new formatting settings as a custom theme, using Hankins as the name, so that you can use the theme with other company documents.
  7. At the bottom of the letter, insert a hyperlink as follows:
    1. Replace the text “[insert email address]” with the text info@hankins.cengage.com to insert the company email address.
    2. Format the text “info@hankins.cengage.com” as a hyperlink that links to the info@hankins.cengage.com email address.
    3. Add the ScreenTip Hankins general email address to the hyperlink.
  8. To set up the document as a form letter, start the Step-by-Step Mail Merge Wizard, accept Letters as the document type, and then choose to use the current document as the starting document. Choose to create a new recipient list, and then customize the columns in the recipient list as follows:
    1. Customize the columns by deleting the Country or Region, Home Phone, Work Phone, and E-mail Address fields.
    2. Rename the ZIP Code field using Postal Code as the new field name.
    3. Add a new field to the end of the address list using Year as the field name.
  9. Enter the address information for the two recipients as shown in Table 1, and then save the data source using a name of your choice.

Table 1: Recipient Addresses

 

Field Record 1 Record 2
Title Ms. Mr.
First Name Karen Mark
Last Name Hong Roby
Company Name Blair Group AJ Global
Address 1 232 Ford Drive 58 Pacific Highway
Address 2   Suite 500
City San Diego Seattle
State CA WA
Postal Code 92112 98111
Year 2015 2017

 

  1. Continue to Step 4 in the Mail Merge Wizard, and then insert the inside address as follows:
    1. Select the placeholder text “INSERT INSIDE ADDRESS”, and then insert an AddressBlock merge field using the Joshua Randall Jr. format.
    2. Delete the placeholder text.
  2. Insert the greeting line as follows:
    1. Select the placeholder text “INSERT GREETING LINE”, and then insert a GreetingLine merge field using the Dear Mr. Randall,
    2. Delete the placeholder text.
  3. In the last paragraph in the body of the letter, select the “[YEAR]” placeholder text, and then insert the “Year” merge field to include the year the recipient became a shareholder.
  4. To include personalized text, add an IF field as follows:
    1. At the end of the second body paragraph (“We remain committed…world around us.”), insert an If…Then…Else
    2. Compare whether the City field is equal to San Diego as the condition.
    3. Insert the following sentence if the condition is true:
      We want to help San Diego continue to provide excellent support to businesses.
    4. Leave the false condition option blank so that Word does not insert text if the City is not San Diego.
  5. Continue to Step 5 of the Mail Merge wizard, and then edit the recipient list to filter the data records to select only recipients where the Year field is equal to 2015 to prepare the first batch of letters for the most long-term shareholders.
  6. Complete the mail merge as follows in the lettered steps below. You will merge to a new document and then copy a page of the merged file to your original document, so that all of your assignment appears in the same file.
    1. Continue to Step 6 of the Mail Merge wizard, and then merge all records to a new document.
    2. In the new document containing the merged form letters, copy the contents of page 1, beginning with the blank paragraph at the top of the page and ending with the paragraph “enc.”
    3. In the original form letter document, move the insertion point to the blank paragraph at the top of page 2, and then paste the merged form letter into the main document.
    4. Verify that the pasted merged form letter appears only on page 2 of the original form letter document.
    5. Turn off the preview of the mail merge results, and close the new, merged document without saving it.
  7. On page 3, crop the yellow rectangle from the picture at the top of the page.
  8. Expand the character spacing of the heading paragraph “Strategic Growth and Advanced Technology” by 2 point to call attention to the heading.
  9. Format text in columns as follows:
    1. Insert a Continuous section break at the beginning of the first body paragraph on page 3 (“The market strategy…than ever before.”) to prepare for setting the section text into columns.
    2. On page 4, insert a Continuous section break in the blank paragraph above the picture to mark the end of the section.
    3. Format the new section beginning “The market strategy…” and ending “…retailers every day.” into two columns.
    4. Insert a line between the columns.
  10. Add a drop cap as follows to include a professional typeface element:
    1. Format the first letter in the column text (the “T” in “The”) as a Dropped drop cap.
    2. Change the font color of the drop cap to Dark Red, Accent 1, Darker 25%.
  11. Format the bulleted list in column 2 as follows to make the list more logical and attractive:
    1. Demote the two bulleted items after the “Landing Gear” item (“Axle beams” and “Main cylinders”) by one level.
    2. Change the color of the bullets for the five first-level bulleted items (“Structural”, “Landing Gear”, “Engine”, “Interior”, and “Systems Control”) to Dark Red, Accent 1.
  12. Call attention to a quotation from the company founder by inserting a text box as follows:
    1. Near the top of column 2, insert the Ion Quote (Dark) text box.
    2. Insert the text as an object from the file Support_WD19_CS4-7a_Founder.docx without copying and pasting the text.
    3. Delete the blank paragraph and the “[Cite your source here.]” paragraph.
    4. Resize the text box to a height of 2″ and a width of 2.9″.
    5. Set the text box to an absolute horizontal position of 5″ to the right of the Margin, and an absolute vertical position of 6.9″ below the Margin to position it on the page.
  13. On page 4, change the design and format of the first “Financial Highlights” table as follows to make the table more attractive and easier to interpret:
    1. Split the cell containing the text “2021 2020” into 2 columns and 1 row.
    2. Merge cells A2 through A8 (the cell containing the text “Dollar amounts in millions” and the six cells below it).
    3. Shade row 1 (the header row) using Brown, Accent 2.
    4. Set the top and bottom cell margins to 02 for all cells in the table.
    5. Change the direction of the “Dollar amounts in millions” text so that it reads from bottom to top.
    6. Change the width of the merged cell to 5″.
    7. Resize column D (the “2020” column) using AutoFit.
  14. Insert and format a table in the “Net Sales (Millions) – Past Five Years” section as follows:
    1. Sort the seven paragraphs in the “Net Sales (Millions) – Past Five Years” section in ascending order.
    2. Convert the seven paragraphs into a table using tabs to separate the columns and a fixed column width.
    3. Move row 7 in the table so that it becomes row 1 and provides headings for each column in the table.
    4. Apply the Grid Table 2 – Accent 2 table style and shade the header row using Brown, Accent 2 to match the formatting of the “Financial Highlights” table.
    5. Remove the First Column special formatting to follow the design of the “Financial Highlights” table.
    6. Change the height of all rows to 25″. Change the width of column B to 1.65″.
    7. Insert a new row at the end of the table and type Total in the first cell of the new row.
    8. In the second cell of the new row, insert a formula that sums the values above the cell.
  15. In the “Capital Allocation” section, insert a table of capital allocations as follows that Hankins Aerospace uses in many documents:
    1. Save the table in the file Support_WD19_CS4-7a_Table.docx as a Quick Part using Cap as the name of the Quick Part.
    2. Select the paragraph “[insert table here]” and then insert the Cap Quick Part to include the table in the report.
  16. In the “Notable Numbers” section, insert a bulleted list as follows to include statistics in the report:
    1. Copy the bulleted list in the file Support_WD19_CS4-7a_List.docx.
    2. Select the paragraph “[insert list here]” and then keep source formatting as you paste the bulleted list in the report.
  17. On page 5, complete and modify the SmartArt as follows to make it more useful:
    1. Change the text wrapping of the SmartArt to Top and Bottom.
    2. Change the layout to Captioned Pictures to emphasize the pictures.
    3. Change the width of the SmartArt to 6″ to increase its size.
    4. Insert the picture Support_WD19_CS4-7a_Data.png in the picture placeholder for the “Analyze data” shape.
  18. Format the shaded paragraph at the end of the document as follows to set it apart from the rest of the document:
    1. Change the indentation of the paragraph to a 5″ Left Indent and a 0.5″ Right Indent.
    2. Format the bold text “Hankins Aerospace, Inc.” in Small caps to distinguish it from the other text in the paragraph.
  19. At the bottom of the page, rotate the Hankins Aerospace logo to the right so that the “H” is oriented correctly.
  20. Insert a Confidential 1 watermark to emphasize that the document information is confidential.

Your document should look like the Final Figure on the following pages. Note: When opening your file or the Graded Summary report for this Project, you may be prompted to Select From “Office Address List”. Select No in the dialog box to view your report. Save your changes, close the document, and then exit Word. Follow the directions on the SAM website to submit your completed project.

Capital Type Percentage
Capital expenditures 30%
Dividends 22%
Mergers and acquisitions 19%
Share repurchases 29%

COMPANY NAME

Click to Select A Date

INSERT INSIDE ADDRESS

INSERT GREETING LINE

The past year was exceptionally productive for Hankins Aerospace as we increased profitability and established a foundation for the future through sustainable growth and continued excellence in our products and services.

We remain committed to our mission of improving the performance and integrity of aerospace parts and systems. We are equally committed to our shareholders, customers, employees, their families, and the world around us.

To summarize the highlights of the enclosed report, consolidated sales in the past year were $895 million, an increase of 12 percent from the previous year. The company generated $108 million in cash flow, with 45 percent of that returning to shareholders. Since we began paying dividends 10 years ago, annual dividends have increased 210 percent.

As a shareholder in Hankins Aerospace since [YEAR], you are a valuable member of the Hankins team. Through your investment, you have made our success possible. We are dedicated to the integrity, innovation, leadership, and hard work that has earned your confidence so far. We will continue to follow these principles as we strive to meet our goals.

Sincerely,

Louis Feeney

President and Chief Executive Officer

[insert email address]

 

enc.

Strategic Growth and Advanced Technology

The market strategy at Hankins Aerospace begins with steady growth in our core aerospace parts manufacturing business and extends to increasing our distribution network domestically and abroad. We are expanding our global market presence with targeted acquisitions and a just-in-time manufacturing system that introduces our products to new customers faster than ever before.

The aerospace industry demands higher efficiency and lightweight products to increase fuel economy and reduce environmental impact. With a long history as the leader in aerospace product innovation, Hankins Aerospace continues to anticipate customer needs and thrive in an increasingly competitive pricing environment.

We offer the most innovative manufacturing and advanced technology resources in the aerospace industry. Hankins is known for its market knowledge and extensive technical expertise. Our services range from machining structural parts, engine components, landing gear, and systems controls from super alloys, aluminum, titanium, and stainless steels. We aim to improve manufacturing operations and produce the highest quality parts while increasing productivity and customer satisfaction.

In addition, we are actively diversifying our products, services, and markets. In the past year, we have expanded to offer the following range of aerospace applications.

  • Structural
    • Fuselage
    • Wings
    • Tail assembly
    • Cockpit
  • Landing Gear
  • Axle beams
  • Main cylinders
    • Brakes
  • Engine
    • Blade
    • Casings
    • Ducts
    • Fittings
    • Turbine rings
    • Turbo housings
  • Interior
    • Gallery parts
    • Support beams
  • Systems Control
    • Housings
    • Gears
    • Hydraulic manifolds

Because Hankins Aerospace is focused on its long-term vision, we strengthen our relationships with suppliers, engineers, contractors, and retailers every day.

PLACE YOUR ORDER NOW

Financial Highlights

  Category 2021

2020
Dollar amounts in millions Net sales $895 $804
  Gross profit $173 $144
  Adjusted operating income $42 $37
  Adjusted earnings per share $0.74 $0.71
  Cash and cash equivalents $108 $99
  Total assets $1250 $981
  Total debt $274 $275

 

Net Sales (Millions) – Past Five Years

2020     $804

2018     $788

2021     $895

2017     $752

2019     $790

2016     $723

Year        Sales

Capital Allocation

[insert table here]

Notable Numbers

[insert list here]

PLACE YOUR ORDER NOW

Digital Solutions

Hankins Aerospace creates a competitive advantage through custom software solutions that take aerospace manufacturing to the next level of productivity and precision.

Hankins Aerospace, Inc. filings with the SEC, including full financial statements, annual reports from previous years, and this year’s quarterly reports, are available free of charge on our website at hankins.cengage.com.

COMPANY NAME

Click to Select A Date

INSERT INSIDE ADDRESS

INSERT GREETING LINE

The past year was exceptionally productive for Hankins Aerospace as we increased profitability and established a foundation for the future through sustainable growth and continued excellence in our products and services.

We remain committed to our mission of improving the performance and integrity of aerospace parts and systems. We are equally committed to our shareholders, customers, employees, their families, and the world around us.

To summarize the highlights of the enclosed report, consolidated sales in the past year were $895 million, an increase of 12 percent from the previous year. The company generated $108 million in cash flow, with 45 percent of that returning to shareholders. Since we began paying dividends 10 years ago, annual dividends have increased 210 percent.

As a shareholder in Hankins Aerospace since [YEAR], you are a valuable member of the Hankins team. Through your investment, you have made our success possible. We are dedicated to the integrity, innovation, leadership, and hard work that has earned your confidence so far. We will continue to follow these principles as we strive to meet our goals.

Sincerely,

Louis Feeney

President and Chief Executive Officer

[insert email address]

 

enc.

PLACE YOUR ORDER NOW

Strategic Growth and Advanced Technology

The market strategy at Hankins Aerospace begins with steady growth in our core aerospace parts manufacturing business and extends to increasing our distribution network domestically and abroad. We are expanding our global market presence with targeted acquisitions and a just-in-time manufacturing system that introduces our products to new customers faster than ever before.

The aerospace industry demands higher efficiency and lightweight products to increase fuel economy and reduce environmental impact. With a long history as the leader in aerospace product innovation, Hankins Aerospace continues to anticipate customer needs and thrive in an increasingly competitive pricing environment.

We offer the most innovative manufacturing and advanced technology resources in the aerospace industry. Hankins is known for its market knowledge and extensive technical expertise. Our services range from machining structural parts, engine components, landing gear, and systems controls from super alloys, aluminum, titanium, and stainless steels. We aim to improve manufacturing operations and produce the highest quality parts while increasing productivity and customer satisfaction.

In addition, we are actively diversifying our products, services, and markets. In the past year, we have expanded to offer the following range of aerospace applications.

  • Structural
    • Fuselage
    • Wings
    • Tail assembly
    • Cockpit
  • Landing Gear
  • Axle beams
  • Main cylinders
    • Brakes
  • Engine
    • Blade
    • Casings
    • Ducts
    • Fittings
    • Turbine rings
    • Turbo housings
  • Interior
    • Gallery parts
    • Support beams
  • Systems Control
    • Housings
    • Gears
    • Hydraulic manifolds

Because Hankins Aerospace is focused on its long-term vision, we strengthen our relationships with suppliers, engineers, contractors, and retailers every day.

PLACE YOUR ORDER NOW

Financial Highlights

  Category 2021

2020
Dollar amounts in millions Net sales $895 $804
  Gross profit $173 $144
  Adjusted operating income $42 $37
  Adjusted earnings per share $0.74 $0.71
  Cash and cash equivalents $108 $99
  Total assets $1250 $981
  Total debt $274 $275

 

Net Sales (Millions) – Past Five Years

2020     $804

2018     $788

2021     $895

2017     $752

2019     $790

2016     $723

Year        Sales

Capital Allocation

[insert table here]

Notable Numbers

[insert list here]

 

Digital Solutions

Hankins Aerospace creates a competitive advantage through custom software solutions that take aerospace manufacturing to the next level of productivity and precision.

 

Hankins Aerospace, Inc. filings with the SEC, including full financial statements, annual reports from previous years, and this year’s quarterly reports, are available free of charge on our website at hankins.cengage.com.

PLACE YOUR ORDER NOW

 

 

 

 

 

 

 

 

 

 

 

 

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *