5/27: Charts and Graphs in Documents

Charts and Graphs tutorial...

Practicing Chart

Below is the data that we will use to familiarize ourselves with making charts and graphs. Though the process can be intimidating (at least it is to me, the professor!), and involves using both Word and Excel, once you get the hang of making the graphics, you'll find them not as hard to really make.


1) Having your data handy is the very important first step. You need:

• The numerical values (money spent, intervals)
  
• The items whose values you are comparing (on Excel they call these "categories")
  
• How many times you plan to compare the items (one year, two year, etc.)
  

Example: 2009 Budget for Nike-Apple Integration for Apple

1. Project Management combined salary (executive personnel): 200,000

2. Software Design Team combinedsalary: 450, 000

3. Chicago Technology Lab (new division/area): 1 million

4. Ground transportation of product: 300, 000

5. Air Transportation of product/ team members: 150, 000

Okay, above are example budget concerns that may show up in a proposal. All of this numerical data can be better displayed using graphics. Below are steps outlined for using Word 2003.


Microsoft 2003 steps for making a chart:

1) On the Insert menu, click Object, and then click the Create New tab.

2) In the Object type box, click Microsoft Graph Chart, and then click OK.

Microsoft Graph displays a chart and its associated sample data in a table called a datasheet.

3) To replace the sample data, click a cell (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.) on the datasheet, and then type the new text or numbers.


Note: If you close the datasheet you can reopen it by double-clicking the chart and then clicking Datasheet on the View menu.

BTS 3: Economic Proposal

Due: Friday, 5/29/2009 


Your task:

After sending the first memo recommending a business venture (BTS 2), your CEO asks to see a follow-up memo from you explaining how our company will integrate the product into its business. His/Her schedule is pretty busy so you need to be clear and concise, using graphics to help out. He/She wants to know a few basics on the suggested use of the other company’s product, including discussion of economic factors. The boss really wants to see some economic studies done within the area 

The basic questions that he’d like addressed in your proposal are (p. 413):

1) What personnel is necessary to go through with the projected integration? How many of the company’s own workers will need to be included in the integration? What kind of personnel? What is the role of the other company, the one whose product your company is going to use?

2) Whose facilities are going to be used – theirs or ours, or both, or someone else’s?

3) What kind of equipment is involved? Are we going to have to buy or subcontract new equipment?

All of these questions should be integrated in your proposal to the CEO. However, you will want to structure your proposal as follows (p. 414-419):

I. Introduction:

a. Explain the product again and how and why using the product will benefit company (What is the opportunity?)
b. Explain the basic structure of the integration/use of the product (What is the scope of the project?)
c. Who would be in charge? This goes along with b., but should be emphasized.

d. Introduction of economic viability (mention a relevant economic study done that you will then explain in the third section of proposal (see below).

II. Proposed Program:

a. Go into more detail about each of the basic questions asked above.
b. Use at least one chart or graph that clarifies your company's projected economic expenses or profits. Here are some options for this graphic:

- Profit of your company, profit of their company’s product, predicted potential profit increase
- Cost of integration versus potential profit increase
- Budget for product integration, which would include projection of how much money is put in manpower, facilities and equipment over next five years. This projection should be a visual representation of the information within the proposal.

III. Economic Research Study

- Section dealing with a current economic market trend relevant to your project 

- Use both writing and a graphic to support the recommendation for doing project.

IV. References or Experience:

- Choose one of these brief sections to end the proposal
o References: source material used for economic projections
o Experience: qualifications of those would will be in charge of overseeing the project

Format Requirements: TWO (2) pages; 10-12 pt font size; Times New Roman font