what is the formula to calculate these a to j in excel
How to compute these from the table in the image in an excel 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 Costs 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 light blue, shade. e Center the data in columns C, D+E, and format column E data with a 1,000 separator (.) and 2 decimal places. f. In Column I, create a column titled "Unit % Total Sales". Using a formula, compute the % of each unit against the total sales. 4 decimal places. g. In Column J, 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, after Whovian Industries, add your Last Name and center across the sheet. j. Center all the titles, use a light green fill on the data in rows 2+3. k. Sort the Products with their relative data, in Ascending [Alpha] order. Make sure the data stays aligned correctly Whovian Industries Products Cost/Unit Units/sold Tardis Gallifrey Cap Gamma Rays Sonic Screwdriver Jet Motor Jelly Babies Daleks Rockets Cybermen Detonator Bandrils Weeping Angels Jet Propelled Unicycle K-9 Zygons Totals Material Labor Shipping Annual Costs Hours 1500 35 25 960 22 95 60 360.75 15 10 300 750.45 5 65 700 233.13 10 45 300 25 2 5 7000 46.1 9 53 150 81125 15 75 324 345 12 35 15 3.5 1.2 13 1 0.75 7500 78.15 4.3 43 256 346.1 23 75 157 1.5 0.75 0.55 9000 328 83 375 555 600 350 Overhead Cost/month Labor Rate/hour 4325 55