Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

what is the formula to calculate these a to j in excel image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Financial Planning Demystified A Self Teaching Guide

Authors: Paul Lim

1st Edition

0071476717,0071709711

More Books

Students also viewed these Finance questions