Assignment:

Create the spreadsheet shown below using MS EXCEL.

Be sure to use formulas to do ALL calculations :
The First Cell Of the Columns that need formulas is given so that you can check your answers.
- Profit ( how much money you make on each item sold)
- Total Sales (the total amount of cash made from all units of that product sold)
- Profit from Sales (the total profit made from all units of that product sold)
- % of Total Sales (what percentage of the total sales each product accounted for)
- Totals (column totals)
You will have to use the 'merge' option for the title
Make sure you use formating options to create a 'good looking' spreadsheet.
Hint : Use the Format Cells menu to get $ and %
Create a 3-D Pie graph of the % of Total Profit for the New Products. (see chart below - include title and legend)
Save the file as Pronto in your directory

PRONTO SALSA
Projected Sales Impact of New Products
Product	Price	Cost	Profit	Units Sold	Total Sales	Profit from Sales	% of Total Sales
Verde Mild	$10.89	$10.05	$0.84	132100	$1,438,569	$110,964	21.0%
Fresca Medium	$10.77	$9.51	$1.26	115400	$1,242,858	$145,404	18.2%
Mexicana Hot	$10.80	$9.50	$1.30	110500	$1,193,400	$143,650	17.4%
Picante Very Hot!	$20.10	$12.10	$8.00	94600	$1,901,460	$756,800	27.8%
de Chili Guero Medium	$10.65	$7.80	$2.85	100000	$1,065,000	$285,000	15.6%
Totals				$552,600	$6,841,287	$1,441,818

Last Updated on 1/5/00
By Charla Beaulieu