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

  1. In Column F, create a column titled Labor Cost. Using a formula, compute the Labor Cost for each product
  2. In Column G, create a column titled Unit Cost: Using a formula that includes Materials, Labor Costs and Shipping Costs.
  3. 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.
  4. Using a formula, compute the Totals for Columns B-G [excluding H.] Fill cell H19, with a light blue, shade.
  5. Center the data in columns C, D + E, and format column E data with a 1,000 separator (,) and 2 decimal places.
  6. 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.
  7. In Column J, create a column titled Overhead per Unit. Using a formula, compute the monthly overhead costs for each sold unit.
  8. Using a formula, compute the totals for I17 and J17.
  9. In the Title in A1, after Whovian Industries, add your Last Name and center across the sheet.
  10. Center all the titles, use a light green fill on the data in rows 2 + 3.
  11. Sort the Products with their relative data, in Ascending [Alpha] order. Make sure the data stays aligned correctlyHow to compute these from the table in the image in an

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!