Kakungulub Final Workhool B View Acrobat Tell me what you want to do Review Formulas Data File Home Insert Page Layout General Wrap Text - 11 Calibri - A A Con * $ . % Merge & Center Form Xcut E Copy Paste Format Painter Clipboard Number Alignment Fone X M9 G H B Labor Unit Cost Unit Labor Unit% Overhead Cost% Sales Per Unit 1 2 Products Material 3 Costs 4 Anvils $ 960.00 5 Boom Machine $ 550.50 6 Cap Gamma Rays $360.75 7 Traffic lights $ 750,45 8 Jet Motor $ 233.13 9 Roller Skates $ 25.00 10 Dehydrated Boulders $ 46.10 11 Rockets $ 811.25 12 Out Board Motor $345.00 13 Detonator $ 15.00 14 Explosive Tennis Ball $ 13.00 15 Disintegrating Pistol $ 78.15 16 Jet Propelled Unicycle S 346.10 17 Giant Rubber Band S 1.50 18 TNT $ 455.00 19 Totals $4,990.93 20 21 22 Overhead Cost/month $3,265.00 23 Labor Rate/hour $ 55.00 24 23 26 27 28 29 D F Acme Industries Shipping Annual Labor Hours Cost/Unit Units/Sold Cost 22 $ 95.00 60 $ 1,210.00 32 $ 15.00 35 $ 1,760.00 15 S 10.00 300 825.00 5 $ 65.00 700 $ 275.00 10 $ 45.00 300 $ 550.00 2 $ 5.00 5000 $ 110,00 4 $ 2.00 150 $ 220.00 15 S 75.00 324 S 825.00 12 $ 35.00 600 $ 660.00 3.5 $ 1.20 350 $ 192.50 1 $ 0.75 7500 S 55.00 4.3 $ 4.30 188 S 236.50 23 $ 75.00 157 S 1,265.00 0.75 $ 0.55 9000 $ 41.25 83 $375.00 555 S 4,565.00 $232.55 $803.80 25,219 $12.790.25 an Product Employees STO Food Dust Ready ER D Step 2 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. c. In Column H, create a column titled "Unit Labor Cost%". Using a formula, compute the percentage of labor cost for each unit. 2 decimal places. d. Using a formula, compute the Totals for Columns B-G (excluding H.] Fill cell H19, with a dark green shade. e. Center the data in columns C + E, and format column E data with a comma separator. f. In Column I create a column titled "Unit % of Sales". Using a formula, compute the % of each unit again the total sales. 4 decimal places. 8. In Column ), create a column titled "Overhead per Unit". Using a formula, compute the monthly overhead costs for each sold unit. h. Using a formula, compute the totals for 117 and J17. i. In the Title in A1, Insert your initials and center across the sheet. j. Center all the titles, use a light grey fill on the data in rows 2 + 3, merge and center row 1. DELL Kakungulub Final Workhool B View Acrobat Tell me what you want to do Review Formulas Data File Home Insert Page Layout General Wrap Text - 11 Calibri - A A Con * $ . % Merge & Center Form Xcut E Copy Paste Format Painter Clipboard Number Alignment Fone X M9 G H B Labor Unit Cost Unit Labor Unit% Overhead Cost% Sales Per Unit 1 2 Products Material 3 Costs 4 Anvils $ 960.00 5 Boom Machine $ 550.50 6 Cap Gamma Rays $360.75 7 Traffic lights $ 750,45 8 Jet Motor $ 233.13 9 Roller Skates $ 25.00 10 Dehydrated Boulders $ 46.10 11 Rockets $ 811.25 12 Out Board Motor $345.00 13 Detonator $ 15.00 14 Explosive Tennis Ball $ 13.00 15 Disintegrating Pistol $ 78.15 16 Jet Propelled Unicycle S 346.10 17 Giant Rubber Band S 1.50 18 TNT $ 455.00 19 Totals $4,990.93 20 21 22 Overhead Cost/month $3,265.00 23 Labor Rate/hour $ 55.00 24 23 26 27 28 29 D F Acme Industries Shipping Annual Labor Hours Cost/Unit Units/Sold Cost 22 $ 95.00 60 $ 1,210.00 32 $ 15.00 35 $ 1,760.00 15 S 10.00 300 825.00 5 $ 65.00 700 $ 275.00 10 $ 45.00 300 $ 550.00 2 $ 5.00 5000 $ 110,00 4 $ 2.00 150 $ 220.00 15 S 75.00 324 S 825.00 12 $ 35.00 600 $ 660.00 3.5 $ 1.20 350 $ 192.50 1 $ 0.75 7500 S 55.00 4.3 $ 4.30 188 S 236.50 23 $ 75.00 157 S 1,265.00 0.75 $ 0.55 9000 $ 41.25 83 $375.00 555 S 4,565.00 $232.55 $803.80 25,219 $12.790.25 an Product Employees STO Food Dust Ready ER D Step 2 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. c. In Column H, create a column titled "Unit Labor Cost%". Using a formula, compute the percentage of labor cost for each unit. 2 decimal places. d. Using a formula, compute the Totals for Columns B-G (excluding H.] Fill cell H19, with a dark green shade. e. Center the data in columns C + E, and format column E data with a comma separator. f. In Column I create a column titled "Unit % of Sales". Using a formula, compute the % of each unit again the total sales. 4 decimal places. 8. In Column ), create a column titled "Overhead per Unit". Using a formula, compute the monthly overhead costs for each sold unit. h. Using a formula, compute the totals for 117 and J17. i. In the Title in A1, Insert your initials and center across the sheet. j. Center all the titles, use a light grey fill on the data in rows 2 + 3, merge and center row 1. DELL
