Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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 correctlyimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations And Supply Chain Management

Authors: F. Robert Jacobs, Richard Chase

14th Edition

287

Students also viewed these Accounting questions