how to get the formula for the unit % total sales and overhead per unit
e Search Save om = Final_Workbook_Data_Web-2 - Read-Only - Excel Insert Formulas Data View Review Page Layout Home Help AutoSum Il logical Lookup & Reference Recently Used Text Math & Trig- ction Financial Date & Time - More Functions Function Library Define Name Use in formats Name Manager Ed Create from Selection Defined as Trace Precedents Trace Dependents Remove Arrows sent Fo 2 Units A C D E F G 1 Whovian Industries 2 Products Material Labor Shipping Annual Labor Cost Unit Cost Unit Labor Unit 3 Costs Hours Cost/Unit Units/Sold Cost Total Sales 4 Tardis $1,500.00 35.00 $25.00 43.00 $1.925.00 $3,450.00 55.80% Gallifrey $950.00 22.00 $95.00 50.00 SL. 210.00 $2.265.00 53.42% Cap Gamma Rays $360.75 15.00 $10.00 300.00 $825.00 $1,195.73 68.999 2 Sonic Screwdriver $750.45 5.00 $65.00 700.00 $275,00 SL.090.45 25.22 8 Set Motor $233.13 10.00 $45.00 300.00 $550.00 $3281 66.41% 9 Jelly Babies $25,00 2.00 $5.00 7,000.00 $110.00 $140.00 78.57% 1 Daleks SA6.10 9.00 $53:00 150.00 $495.00 $594.10 83.32 Rockets $81125 15.00 $75.00 324.00 $825.00 $1,721 25 48.215 12 cybermen $345.00 12.00 $35.00 600.00 5660.00 $1.00.00 63.46 Detonator $15.00 3.50 $1.20 350.00 $192.50 $208.70 92% 14 Bandnis $13.00 100 $0.75 7,500.00 $55.00 S675 SOLOON 55 Weeping Angels $76.15 4.30 $4.30 255.00 $236.50 53125 20.15% 16 let Propelled Unicycle $346.10 23.00 $75.00 157.00 SI 265.00 $1.5.10 75.63 WKS 51.50 0.75 $0.55 5.000.00 $41.23 $4330 982 12vons $32.00 89.00 $175.00 555.00 54.555.00 $2800 36665 Totals $8,813.43 240:55 $864.80 27 235.00 $1,21025 $19. 20 21 22 Oveshead cost month $4,325.00 25 Laboratout 155.00 24 25 26 RD 20 acer H cader slae to Side M ve Zoom Window Zoom 100% Arrange AB Switch Navigation Pane Split Windows Page Movement Show 20 ASWALLSBODE 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. 8 In Column , 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 117 1. In the Title in A1, after Whovian Industries, add your Last Name and center across the sheet. 1. 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 Step 3 a. Apply Conditional Formatting so that in Labor Costs, >250 light red. b. Apply Conditional Formatting so that in Unit Labor Cost, > 70% Is Bold Dark Green text c. Re-name Sheet 1 - Products IST 103 Flashing Sheet acer