Question: How to compute these from the table in the image in an excel In Column F, create a column titled Labor Cost . Using a
How to compute these from the table in the image in an excel
- In Column F, create a column titled Labor Cost. Using a formula, compute the Labor Cost for each product
- In Column G, create a column titled Unit Cost: Using a formula that includes Materials, Labor Costs and Shipping Costs.
- 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.
- Using a formula, compute the Totals for Columns B-G [excluding H.] Fill cell H19, with a light blue, shade.
- Center the data in columns C, D + E, and format column E data with a 1,000 separator (,) and 2 decimal places.
- 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.
- In Column J, create a column titled Overhead per Unit. Using a formula, compute the monthly overhead costs for each sold unit.
- Using a formula, compute the totals for I17 and J17.
- In the Title in A1, after Whovian Industries, add your Last Name and center across the sheet.
- Center all the titles, use a light green fill on the data in rows 2 + 3.
- Sort the Products with their relative data, in Ascending [Alpha] order. Make sure the data stays aligned correctly
Whovian Industries Products 5 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 Cost/Unit Units/Sold 1500 35 25 43 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 811.25 15 75 324 345 12 35 600 15 3.5 1.2 350 13 1 0.75 7500 78.15 4.3 4.3 256 346.1 23 75 157 1.5 0.75 0.55 9000 328 83 375 555 4325 Overhead Cost/month Labor Rate/hour 55
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
