× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
ChichiIloka ChichiIloka
wrote...
Posts: 2
Rep: 0 0
7 years ago
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.

 
Read 1169 times

Related Topics

New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1059 People Browsing
Related Images
  
 260
  
 100
  
 45
Your Opinion
Who's your favorite biologist?
Votes: 585

Previous poll results: Do you believe in global warming?