which formula they used to calculated the unit% of sale and the overhead per unit?

they are asking to use a formula to compute the % of each unit again the total sales for 4decimal place and this is the full image of the excel

H Shiling 1 2 Products 3 4 Avis 5 Boom Machine 6 Cap Gamma Rays 7 Traffic lights 8 let Motor 9 Roller Skates 10 Dehydrated Boulders 11 Rockets 12 Out-Board Motor 13 Detonator 14 Explosive Tennis Ball 15 Disintegrating Pistol 16 Pet-Propelled Unicycle 17 Giant Rubber Band 18 TNT 19 Totals 20 21 22 Overhead Cost/month 23 Labor Rate/hour 24 25 26 27 B C D G Acme industries Material Labor Annual Labor Unit Costs Hours Cost/Unit Units/Sold Cost Cost $ 960.00 22 $ 95.00 60 $ 1.210.00 $ 2.265.00 $ 550.50 32 S 15.00 35 $ 1.760.00 2.325,50 S 360.75 15 $10.00 300 $ 825.00 $ 1.195.75 $ 750.45 5 5 65.00 700 $ 275.00 $ 1090.45 $ 233,13 10 $ 45.00 300 $ 550.00 S 828.13 $ 25.00 2 $500 $110.00 $ 140.00 $ 46.10 $ 2.00 150 $ 270.00 268.10 $ 811.5 15 S 75.00 324 $ 825.00S 1.711.25 5 345.00 12 $ 35.00 600 $ 660.00 $ 1.040.00 $ 15.00 3.5 $ 120 350 'S 192.50 S 208.70 S 13.00 1 S0.75 7.500 $ 35.00 S 68.75 S 78.15 5430 188 S 236.50 $ 318.95 $ 346.10 23 S 75.00 157 $ 1.265.00 1686.10 $ 1.50 0.75 $ 0.55 9.000 S. 4125$ 43.30 $455.00 83 $ 375.00 555 $ 4,565.00 $ 5.395.00 $ 4,990 93 232.55 S80380 25,219 $12.790 25 S 18.5848 5.000 Unit Labor Cost 53.42% 75.6896 68.99 25.22% 66.41% 78.57% 82.CON 48.219 63.46% 92.245 80.00 74.15% 25.03% 95.225 34629 Unit Overhead of Sales per Unit 0.23799 $ 7.77 0.1388% 4.53 1.1896% $ 38.84 2.7757 S 90.63 1.1896%S 38 84 19.82639/S 647.33 0.50485 19.42 1.284793 223792 77.68 1387855 45.31 29.73955 S 970.99 0.7455 2034 0.622515 20:33 35.6870 $ 1.165.19 2.200795 71.85 100 COCOS $ 3.265.00 $3.265.00 $ 55.00 Unit Labor Cost% 120.00 30.00 H per Unit B D E F G Acme Industries Material Labor Shipping Annual Labor Unit Costs Hours Cost/Unit Units/Sold Cost Cost $ 960.00 22 $ 95.00 60 $ 1.210.00 $ 2,265.00 $ 550.50 32 $ 15.00 35 $ 1,760.00 $ 2,325.50 $360.75 15 $ 10.00 300 $ 825.00 $ 1,195.75 $ 750.45 5 $ 65.00 700 275.00 $ 1,090.45 $ 233.13 10 $ 45.00 300 550.00 $ 828.13 $ 25.00 2 $ 5.00 5,000 110.00 $ 140.00 $ 46.10 4 $ 2.00 150 220.00 $ 268.10 $ 811.25 15 $ 75.00 324 $ 825.00 $ 1,711.25 $ 345.00 12 $ 35.00 600 660.00 $ 1,040.00 $ 15.00 3.5 $ 1.20 350 192.50 $ 208.70 $ 13.00 1 $ 0.75 7,500 55.00 $ 68.75 $ 78.15 4.3 $ 4.30 188 $ 236.50 $ 318.95 $ 346.10 23 $ 75.00 157 $ 1.265.00 S 1,686.10 $ 1.50 0.75 $ 0.55 9,000 $ 41.25S 43.30 $ 455.00 83 $ 375.00 555 $4,565.00 $ 5,395.00 $ 4,990.93 S 232.55 S 803.80 25,219 $12.790.25 $ 18,584.98 1 2 Products 3 4 Anvils 5 Boom Machine 6 Cap Gamma Rays 7 Traffic lights 8 Jet Motor 9 Roller Skates 10 Dehydrated Boulders 11 Rockets 12 Out-Board Motor 13 Detonator 14 Explosive Tennis Ball 15 Disintegrating Pistol 16 Jet Propelled Unicycle 17 Giant Rubber Band 18 TNT 19 Totals 20 21 22 Overhead Cost/month 23 Labor Rate/hour 24 25 26 27 28 29 30 21 Products Unit Labor Cost * 53.42% 75.68% 68.99% 25.22% 66.41% 78.57% 82.06% 48.21% 63,46% 92.24% 80.00% 74.1596 75.03% 95.279 84.62% Unit % Overhead of Sales 0.2379% $ 7.77 0.1388% $ 4.53 1.1896% $ 38.84 2.7757% S 90.63 1.1896% S 38.84 19.8263% $ 647.33 0.5948% 19.42 1.2847% S 41.95 2.3792% $ 77.68 1.3878%$ 45.31 29.7395% S 970.99 0.7455% $ 24.34 0.6225% S 20.33 35.6874% $ 1.165.19 2.2007 S 71.85 100.0000% $3,265.00 Unit Labor Cost % $ 3,265.00 $ 55.00 120.00 100.00% 30,00 60.00 40.00 20.00 ODOS Hoom Machine Rockets drated Boulder Put Board Mato Shes the Tunin sa tegrating Pistol Anvils Detector Teatric Lights het Motor Roler Skates Jet Propelled entfubber Band TNT 3 STD 2020 Food Dist Employees