use a formula to compute the % of each unit again the total sale

AutoSave CH 2.8. Final Workbook Data Group C Rov3 (2)xx - Excel File Data Review View Help Search Home Insert Draw Page Layout Formulas Calibri - 12 - A A ==> BIU.B -0.A Paste 2 Wrap Text Merge & Center. Percentage $ . % 8-28 Clipboard Conditional For Formatting" Te Style Font Alignment Number 118 --- f A B C D E F G H 2 Products Material Labor Shipping Annual labor Unit Unit Labor Unit % of 3 Costs Hours Cost/Uni Units/Sold Cost Cost Cost Sales 4 Cap Gamma Rays $860.75 25 $18.00 475 $1,612.50 $2,491.25 64.73% 5 Boom Machine $1,550.50 35 $25.00 47 $2,257.50 $3,833.00 58.90% 6 Anvils $960.00 22 $95.00 60 $1,419.00 $2,474.00 57.36% 7 Traffic Lights $750.45 5 $65.00 700 $322.50 $1,137.95 28.34% 8 Jet Motor $233.13 10 $45.00 300 $645.00 $923.13 69.87% 9 Roller Skates $25.00 2. $5.00 5000 $129.00 $159.00 81.13% 10 Dehydrated Boulders $46.10 4 $2.00 150 $258.00 $306.10 84.29% 11 Rockets $811.25 15 $75.00 324 $967.50 $1,853.75 52.19% 12 Out-Board Motor $345.00 12 $35.00 600 $774.00 $1,154.00 67.07% 13 Detonator $15.00 3.5 $1.20 350 $225.75 $241.95 93.30% 14 Explosive Tennis Ball $13.00 1 $0.75 7500 $64.50 $78.25 82.43% 15 Disintegrating Pistol $78.15 4.3 $4.30 188 $277.35 $359.80 77.08% 16 Jet-Propelled Unicycle $346.10 23 $75.00 157 $1,483.50 $1,904.60 77.89% 17 Giant Rubber Band $1.50 0.75 $0.55 9000 $48.38 $50.43 95.93 18 TNT $455.00 83 $375.00 555 $5,353.50 $6,183.50 86.58% 19 Totals $6,490.93 245.55 $821.80 25,406 UN IN 20 21 $5,403.00 22 Overhead Cost/month $64.50 23 Labor Rate/hour Sheet1 Sheet2 Sheet3 Sheet4 Ready EF Type here to search esc ES 2 3 4 5 6 7 8 14/ C