Title: Produce the exact spreadsheet shown below: Post by: ChichiIloka on Jul 27, 2016 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. |