Produce the exact spreadsheet shown below:

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

               


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.

 

6.   Change the 3-D pie chart to Bar chart.
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.