Pp110 week 4 assignment instructionsa. calculate retail selling price: start in c2. create a formula using cost and markup in b15 to determine the selling price. use an absolute reference formula to allow auto-fill. =b2*$b$15�autofill or copy down for range c3: c13.�format column c (range c2: c13) in the accounting number format. b. calculate the inventory value: start in e2. create a formula using retail selling price and inventory on-hand to determine the value of the product in the store. =c2*d2�autofill or copy down for column e (range e3: e13). resize column to fit all numbers. format column e (range e2: e13) in the currency number format. c. calculate the sales: start in g2. create a formula that uses retail selling price and units sold to determine the dollar amount of product sold, year to date. =c2*f2�autofill or copy down for column g (range g3: g13). resize column to fit numbers. format column g (range g2: g13) in the accounting number format. d. calculate the profit: start in h2. create a formula finds the difference between retail selling price and cost, then multiply by units sold. =(c2-b2)*f2�autofill or copy down for column h (range h3: h13).�format column h (range h2: h13) in the accounting number format. resize column to fit numbers. in h14 use autosum to sum column h (range h2: h13).�add the text ‘year to date profit total’ in g14. format g14 with wrap text and center both vertically and horizontally. adjust row and column to fit. bold both g14 and h14. e. apply conditional formatting to highlight products for re-order: �apply conditional formatting to column d (range d2: d13) calling attention to items with an inventory less than 15 on-hand. use green fill with dark green text. f. apply icon sets under conditional formatting: �choose an icon set for the range d2: d13 using icon sets from conditional formatting. g. la grange hardware has added a new steel grip corded miter saw; add the new product to the analysis. add a new row above “t-shank jig saw blade 3-pack”�add the text “steel grip corded miter saw” to a8, 129.99 to b8, 24 to d8, 10 to f8. calculate c8, e8 and g8 by copying down with autofill if it does not automatically populate.�delete row 6 (carbide tipped circular saw blade 24 teeth 1-pack) from the worksheet. h. format as a table with headers: highlight the range a1: h14. click the ‘format as table’ icon on the home ribbon and choose a table color theme. make sure the ‘my table has headers’ box is checked, then click ‘ok’. resize all rows and columns to fit. i. show profit (ytd) in a column chart: select column a (range a1: a13) then hold the control key (crtl) and select column h (range h1: h13). do not click and release on a1 or h1 when highlighting. highlight a1: a13 and h1: h13 in one, fluid motion.�select insert > choose insert column chart > choose the first 2-d column, clustered column. move the graph under the table. j. proof, compare and name your file: proof your work and compare it to the sample below. save your file using the naming convention: app110_your last name_week4_assignment