excel and excess skill

MICROSOFTEXCELPROJECT.docx

Home >Business & Finance homework help >Management homework help >excel and excess skill

MICROSOFT EXCEL PROJECT

1. Produce the exact spreadsheet shown below:

Texas Spectrum Wireless
Car Products Inventory Valuation
As of December 31
	Warehouse Location	Quantity In Stock	Retail Price	Total Retail Value	Percent of Total Retail Value
Antenna Signal Booster	Dallas	1,126	$ 19.99	$ 22,508.74	8.27%
Car Power Port Adapter	Dallas	3,546	19.49	69,111.54	25.39%
Repeater Antenna	Houston	1,035	39.99	41,389.65	15.21%
SIM Card Reader and Writer	Houston	2,875	16.90	48,587.50	17.85%
Sticky Dash Pad	Houston	3,254	11.99	39,015.46	14.33%
Window Mount GPS Holder	Dallas	2,458	20.99	51,593.42	18.95%
Total Retail Value for All Products				$ 272,206.31

E11

2. Compute the total Retail Value by multiplying Quantity in stock with Retail Price.

3. Compute the total Retail value for all products ( use sum function)

4. Compute Percent of Total Retail Value by dividing Total Retail Value with Total Retail Value for All Products (use absolute value function:( =E5/$E$11))

5. Plot a 3-D pie chart using Product column against Total Retail Value column.

The 3-D pie chart will look exactly as shown below:

6. Plot a Bar chart using Product column against Total Retail Value column.

Hint: Copy your 3-D pie chart and paste it where you want to insert the par chart.

Select the chart you pasted.

Click on Home tab, then click Format under Chart Tools. Click on Change Chart Type.

Select Bar and choose this chart below.

Texas Spectrum Wireless Car Products Inventory Valuation

Antenna Signal Booster Car Power Port Adapter Repeater Antenna SIM Card Reader and Writer Sticky Dash Pad Window Mount GPS Holder 22508.739999999998 69111.539999999994 41389.65 48587.499999999993 39015.46 51593.42

Texas Spectrum Wireless Car Products Inventory Valuation