Hide Assignment InformationInstructions

This assignment will address CO1: Create communication documents using assigned software applications.

The scenario:

All That Glitter Jewelry is considering an expansion of the company website to sell more merchandise. Wanda Delana, the US Sales Director, has asked you to complete a business letter for a proposal.

For this assignment, you will need the following files:

New blank Word document  

You will save your files as:

Lastname_Firstname_Memo.docx

1. Create a memo in Microsoft Word®  (preferably)

From: All That Glitter Jewelry

          12589 Crystalline Lane

          Paris, Texas 78956

1. Address the memo to Michael Cavern, President, 53300 Francis Street, Wilmar, Delaware 45678
2. Add the current date
3. Subject: Web site expansion
4. Add the following content (cut and paste this content): 

The All That Glitter Jewelry Web site has been more successful than we originally anticipated. We had planned to expand the Web site late next year; however, considering the success we have seen, we would like to move up the expansion date.

The following worksheet and chart highlight the projected sales data for the first four quarters that the expanded Web site is in operation:

1. Create a table with the following information:

All That Glitter Jewelry  

Projected Web Site Sales

Quarter                       Low End Sales          Expected Sales         High End Sales

First Quarter               3500                           12500                          17500

Second Quarter          15000                          21000                          19000

Third Quarter             13750                          16750                          23750

Fourth Quarter           10000                          25000                          35000

Totals                        

1. Add formulas to calculate totals of each column in the table.
2. Create a 3-D Cluster Chart containing the data in the chart (graph)- see the video in the Week 1 Lesson, Reading and Resources area. Add chart title and the legend information as written in the table (without the total row).

Upload the completed assignment files in the Assignment area.

• Special Instructions: Use the Supporting Materials provided in the Week 1 Lesson, Reading and Resources area as illustrated below to complete the project.
• Grading: Please review the rubrics for particulars.
•