in column I create a column title Unit% Total sale. using a formula, compute the % of each unit against the total sale. 4 decimal places.
Hepl me please with the formula I am not finding the rigth one
AutoSave Muanda Final.xlsx File Home Formulas View Data Help Page Layout Review X Calibri 11 - A A === Wrap Text Percentage Paste A- El Merge Center - $%98-98 Cand Formal Font Clipboard Alignment Number 14 X B D E F G H 2 Products Material Labor Shipping Annual Labor Unit Unit Labor Unit% 3 Costs Hours Cost/Unit Units/Sold Cost Cost Cost% Total Sales 4 Bandrils $13.00 1.00 $0.75 7,500.00 $55.00 $68.75 80.00% 5 Cap Gamma Rays $360,75 15.00 $10.00 300.00 $825.00 $1,195.75 68.99% 6 Cybermen $345.00 12.00 $35.00 600.00 $660.00 $1,040.00 63.46% 7 Daleks $46.10 9.00 $53.00 150.00 $495.00 $594.10 83.32% 8 Detonator $15.00 3.50 $1.20 350.00 $192.50 $208.70 92.249 9 Gallifrey $960.00 22.00 $95.00 60.00 $1,210.00 $2,265.00 53.42% 10 Jelly Babies $25.00 2.00 $5.00 7,000.00 $110.00 $140.00 78.57% 11 Jet Motor $233.13 10.00 $45.00 300.00 $550.00 $828.13 66.41% 12 Jet-Propelled Unicycle $346.10 23.00 $75.00 157.00 $1,265.00 $1,686.10 75.03% 13 K-9 $1.50 0.75 $0.55 9,000.00 $41.25 $43.30 95,27% 14 Rockets $811.25 15.00 $75.00 324.00 $825.00 $1,711.25 48.21% 15 Sonic Screwdriver S750.45 5.00 $65.00 700.00 $275.00 $1,090.45 25.22% 16 Tardis $1,500.00 35.00 $25.00 43.00 $1,925.00 $3,450.00 55.8096 17 Weeping Angels $78.15 4.30 $4.30 256.00 $236.50 $338.95 74.1596 18 Zygons $328.00 83.00 $375.00 555.00 $4,565.00 $5,268.00 86,66% 19 Totals S5,813.43 240.55 $864.80 27,295.00 $13,230.25 $19,908.48 20 21 22 Overhead Cost/month 4325 23 Labor Rate/hour 55 Sheet1 Sheet Sheet Type here to search hp Home insert Page Layout Formulas Data Review View Help Calibri Percentage D 11 ' ' Wrap Text a. A-Merge & Center - ste BIU $ - %98 pboard Font Alignment Number fo D E H Products Material Labor Shipping Annual Labor Unit Unit Labor Unit Costs Hours Cost/Unit Units/Sold Cost Cost Cost % Total Sales Bandrils $13.00 1.00 $0.75 7,500.00 $55.00 $68.75 80.00% Cap Gamma Rays $360.75 15.00 $10.00 300.00 $825.00 $1,195.75 68.99% - Cybermen $345.00 12.00 $35.00 600.00 $660.00 $1,040.00 63.46% Daleks $46.10 9.00 $53.00 150.00 $495.00 $594.10 83.32% 3 Detonator $15.00 3.50 $1.20 350.00 $192.50 $208.70 92.24% Gallifrey $960.00 22.00 $95.00 60.00 $1,210.00 $2,265.00 53.4296 10 Jelly Babies $25.00 2.00 $5.00 7,000.00 $110.00 $140.00 78.57% 11 Jet Motor $233.13 10.00 $45.00 300.00 $S50.00 $828.13 66.4196 12 Jet-Propelled Unicycle $346.10 23.00 $75.00 157.00 $1,265.00 $1,686.10 75.03% 13 K-9 $1.50 0.75 $0.55 9,000.00 $41.25 $43.30 95.27% 14 Rockets $811.25 15.00 $75.00 324.00 $825.00 $1,711.25 48.21% 15 Sonic Screwdriver $750.45 5.00 $65.00 700.00 $275.00 $1,090,45 25.22% 15 Tardis $1,500.00 35.00 $25.00 43.00 $1.925.00 $3,450.00 55.80% 17 Weeping Angels $78.15 4.30 $4,30 256.00 $236.50 $318.95 74.1556 18 Zygons $328.00 83.00 $375.00 555.00 $4,565.00 $5,268.00 86.66% 19 Totals $5,813.43 240.55 $864.80 27,295.00 $13,230.25 $19,908.48 20 21 23 Overhead Cost/month 4325 23 Labor Rate/hour 55 Sheet1 Short shoot Sheet Type here to search hp File Muanda_Final.xlsx . Saved - Home Insert Page Layout Formulas X Data Calibri Review View Paste -11 Help BIU ~ - A A A. Merge & Center 29 Wrap Text Clipboard 5 Font 14 Alignment Products Bandrils Cap Gamma Rays Cybermen Daleks Detonator Gallifrey Jelly Babies Jer Motor Jet Propelled Unicycle K-9 Rockets Sonic Screwdriver Tardis Weeping Angels Zyrons Totals Whovian Industries Student Lastname Material Labor Shipping Annual Labor Unit Unit Labor Unit Costs Overhead Hours Cost/Unit Units/Sold Cost Cost Cost Total Sales S 13.00 Per Unit 1 $ 0.75 7,500.00 S 55.00 s 68.75 80.00 27.4776% 5 1.188.40 S 360.75 15 $ 10.00 300.00 S 825.00 $ 1.195.75 68.99% 1.0991 S 4754 $ 345,00 12 S 35.00 600.00 $ 660.00 $ 1.040.00 63.46 2.1982NS 95.07 $ 46.10 9 $ 53.00 150.00 $ 495.00$ 5944.10 83 325 0.5496NS 23.77 S 15.00 3.5 S 1.20 350.00 $ 192.505 208.70 92.24% 1.2823S 55.46 S 960.00 22 S 95.00 60.00 S 1,210.00 $ 2.265.00 53.42% 0.2198 S 9.51 S 25.00 2 $ 5.00 7,000.00 $ 110.00 $ 140.00 78.57% 25.6457% $ 1,109 18 $ 233.13 10 $ 45.00 300.00 5 550.00 828.13 66.419 1.0991 4754 S 346.10 23 $ 75,00 157.00 $ 1.265.00 S 1,685.10 75.03% 0.575295 24.88 s 1.50 0.75 $ 0.55 9,000.00 $ 41.25S 43.30 95.27% 32.9731% $ 1,426.09 $ 811.25 15 $ 75.00 324.00 5 825.005 1.711.25 48.21% 1.1870 S 51.34 S 750.45 S 65.00 5 700.00 S 275.00 1,090.45 110.92 25.22 2.5646NS $ 1,500.00 $ 25,00 43.00 35 0.15755 $ 1,925.00 S 3450.00 55 SON 6.81 43 S 256.00 $ 4.30 5 318.95 78.15 74.15 236.50 $ 40.56 09379 87.94 20333MS 83 $ 328.00 86.66 $ 375.00 555.00 $ 4565.00 S 5,268.00 1000000 54,325.00 $ 5813.43 240.55 $ 864.80 27,295,00 $ 13,230.25 $ 19,908.48 Overhead Cost/month Labor Rate/hour $ 4325.00 $ 55.00 Products Employees Sheet3 Sheets Student Lastname Employee costs 30 25 Anal Anal Workers Annalena Toating Con Cou 20522 111337 1005211105 SMOS 25262301023 230 L2 22510 5000100019 TO S157104 041 10 DOTS 17.10460 130$ OLI 20 GOO 14 05 413236 37 RODOGOS 2.0 2.950 BOO 11 ET DO 786 208434615ITAS 027 2005 WS 7 210.00 TA3 054 0552 11 30
