File Home Insert Draw Page Layout *Formulas Data Review to X Calibri == - 11 A 3.A a Wrap Text + Merge & Cent Paste BIU Clipboard Font Alignment D4 X fx 18 B D E 1 Acme Industries 2 Products Labor 3 Hours 25.00 4 Cap Gamma Rays 5 Boom Machine 6 Anvils 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 Material Costs $860.75 $1,550.50 $960.00 $750.45 $233.13 $25.00 $46.10 $811.25 $345.00 $15.00 $13.00 $78.15 $346.10 $1.50 $455.00 35.00 22.00 5.00 10.00 2.00 4.00 15.00 12.00 3.50 1.00 4.30 23.00 0.75 83.00 Shipping Annual Labor Cost/Unit Units/Sold Cost 18.00 475.00 25.00 47.00 95.00 60.00 65.00 700.00 45.00 300.00 5.00 5,000.00 2.00 150.00 75.00 324.00 35.00 600.00 1.20 350.00 7,500.00 4.30 188.00 75.00 157.00 0.55 9,000.00 375.00 555.00 0.75 Sheet1 Sheet2 Sheet3 Ready Sheet4 Type here to search o Calibri LG Paste B I U A. Merge & Cer Clipboard Font Alignment C17 X fi =SUM(C7:016) B D E F G 20 23 20 20 A 7 Bugs Bunny 8 Daffy Duck 9 Foghorn Leghorn 10 Yakko 11 Wakko 12 Dot 13 Pinky 14 Brain 15 Slappy Squirrel 18 5 5 8 30 10 25 18 10 10 12 25 20 25 247.5 410.5 16 17 Totals 18 19 Insurance Rates 20 Health 21 Workers Comp 22 Unemployment 23 24 25 26 27 % 0.29 0.09 0.16 Sheet1 Sheet2 Sheet3 Sheet4 Ready Type here to search o esc 12 12 f3 a. In Column F, create a column titled "Labor Cost". Using a formula, compute the Labor Cost for each product b. In Column G, create a column titled "Unit Cost: Using a formula that includes Materials, Labor and Shipping Costs. In Column H, create a column titled "Unit Labor Cost%". Using a formula, compute the percentage of labor cost for each C. File Home Insert Draw Page Layout *Formulas Data Review to X Calibri == - 11 A 3.A a Wrap Text + Merge & Cent Paste BIU Clipboard Font Alignment D4 X fx 18 B D E 1 Acme Industries 2 Products Labor 3 Hours 25.00 4 Cap Gamma Rays 5 Boom Machine 6 Anvils 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 Material Costs $860.75 $1,550.50 $960.00 $750.45 $233.13 $25.00 $46.10 $811.25 $345.00 $15.00 $13.00 $78.15 $346.10 $1.50 $455.00 35.00 22.00 5.00 10.00 2.00 4.00 15.00 12.00 3.50 1.00 4.30 23.00 0.75 83.00 Shipping Annual Labor Cost/Unit Units/Sold Cost 18.00 475.00 25.00 47.00 95.00 60.00 65.00 700.00 45.00 300.00 5.00 5,000.00 2.00 150.00 75.00 324.00 35.00 600.00 1.20 350.00 7,500.00 4.30 188.00 75.00 157.00 0.55 9,000.00 375.00 555.00 0.75 Sheet1 Sheet2 Sheet3 Ready Sheet4 Type here to search o Calibri LG Paste B I U A. Merge & Cer Clipboard Font Alignment C17 X fi =SUM(C7:016) B D E F G 20 23 20 20 A 7 Bugs Bunny 8 Daffy Duck 9 Foghorn Leghorn 10 Yakko 11 Wakko 12 Dot 13 Pinky 14 Brain 15 Slappy Squirrel 18 5 5 8 30 10 25 18 10 10 12 25 20 25 247.5 410.5 16 17 Totals 18 19 Insurance Rates 20 Health 21 Workers Comp 22 Unemployment 23 24 25 26 27 % 0.29 0.09 0.16 Sheet1 Sheet2 Sheet3 Sheet4 Ready Type here to search o esc 12 12 f3 a. In Column F, create a column titled "Labor Cost". Using a formula, compute the Labor Cost for each product b. In Column G, create a column titled "Unit Cost: Using a formula that includes Materials, Labor and Shipping Costs. In Column H, create a column titled "Unit Labor Cost%". Using a formula, compute the percentage of labor cost for each C
