Problem 4:
			Net Sales					Earnings
			$ Millions					$ Millions
	1997		387	100		1997		24	100
	1998		420	109		1998		39	162
	1999		477	123		1999		35	146
	2000		513	133		2000		45	188
	2001		530	137		2001		29	121
Sketch a chart that demonstrates the trends for sales and earnings, using 1997 as the base and showing
succeeding years as a percentage of the base year

D G K M B E 1 Homework 6 2 Develop business charts for the following five problems using the 3-step charting process + Step 1: Determine your message Step 2: Identify the comparison 5 Step 3: Select the chart form 3 4 6 7 Problem 1: Share of Industry Sales by Company, 2007 8 mo> 9 % Share 10 Your Company 19.3 11 Competitor A 10.1 12 Competitor B 16.6 13 Competitor C 12.4 14 Competitor D 31.8 15 Competitor 9.8 16 100.00% 17 18 Sketch a chart to demonstrate your company's share of industry 19 20 21 22 23 Problem 2: Return on Assets by Company, 2007 24 25 % 26 Your Company 8.3 27 Competitor 9.8 28 Competitor B 15.9 29 Competitor 22.4 30 Competitor D 14.7 31 Competitor E 19.1 32 33 34 Sketch a chart to demonstrate how your company's return on assets ranks in the industry Sheet1 Sheet2 Sheet3 COO % 8.3 9.8 15,9 22.4 14.7 19.1 35 34 Sketch a chart to demonstrate how your company's return on assets ranks in the industry 35 36 37 Problem 3: Share of Industry Sales by Company, 2007 Return on Assets by Company, 2007 39 40 % Share 41 Your Company 19.3 Your Company 42 Competitor A 10,1 Competitor 43 Competitor B 16.6 Competitor B 44 Competitor 12,4 Competitor 45 Competitor D 31.8 Competitor D 45 Competitor E 9.8 Competitor E 47 48 49 Sketch a chart that demonstrates whether a relationship exists between share of sales and return on assets 50 51 S2 53 Problem 4: 55 Net Sales Earnings 56 57 $ Millions S Millions 58 1997 387 100 1997 24 59 1998 420 109 1998 39 60 1999 477 123 1999 35 61 2000 513 133 2000 45 62 2001 530 137 2001 29 63 Sketch a chart that demonstrates the trends for sales and earnings, using 1997 as the base and showing 64 succeeding years as a percentage of the base year 65 Problem 5: 56 Percentage of Total Sales by Product 67 Sheet1 Sheet2 Sheets + Ready Calculate 100 162 146 188 121 D G K M B E 1 Homework 6 2 Develop business charts for the following five problems using the 3-step charting process + Step 1: Determine your message Step 2: Identify the comparison 5 Step 3: Select the chart form 3 4 6 7 Problem 1: Share of Industry Sales by Company, 2007 8 mo> 9 % Share 10 Your Company 19.3 11 Competitor A 10.1 12 Competitor B 16.6 13 Competitor C 12.4 14 Competitor D 31.8 15 Competitor 9.8 16 100.00% 17 18 Sketch a chart to demonstrate your company's share of industry 19 20 21 22 23 Problem 2: Return on Assets by Company, 2007 24 25 % 26 Your Company 8.3 27 Competitor 9.8 28 Competitor B 15.9 29 Competitor 22.4 30 Competitor D 14.7 31 Competitor E 19.1 32 33 34 Sketch a chart to demonstrate how your company's return on assets ranks in the industry Sheet1 Sheet2 Sheet3 COO % 8.3 9.8 15,9 22.4 14.7 19.1 35 34 Sketch a chart to demonstrate how your company's return on assets ranks in the industry 35 36 37 Problem 3: Share of Industry Sales by Company, 2007 Return on Assets by Company, 2007 39 40 % Share 41 Your Company 19.3 Your Company 42 Competitor A 10,1 Competitor 43 Competitor B 16.6 Competitor B 44 Competitor 12,4 Competitor 45 Competitor D 31.8 Competitor D 45 Competitor E 9.8 Competitor E 47 48 49 Sketch a chart that demonstrates whether a relationship exists between share of sales and return on assets 50 51 S2 53 Problem 4: 55 Net Sales Earnings 56 57 $ Millions S Millions 58 1997 387 100 1997 24 59 1998 420 109 1998 39 60 1999 477 123 1999 35 61 2000 513 133 2000 45 62 2001 530 137 2001 29 63 Sketch a chart that demonstrates the trends for sales and earnings, using 1997 as the base and showing 64 succeeding years as a percentage of the base year 65 Problem 5: 56 Percentage of Total Sales by Product 67 Sheet1 Sheet2 Sheets + Ready Calculate 100 162 146 188 121