Can i get help with parts A, B, D, E, F

AE2-1. Figure AE-1 shows an Excel spreadsheet that the resort bicycle rental business uses to value and analyze its bicycle inventory. Examine this figure to understand the meaning of the data. Now use Excel to create a similar spreadsheer. Note the following: The top heading is in 20-point Calibri font. It is centered in the spreadsheet. Cells A1 through H1 have been merged. The second heading. Bicycle Inventory Valuation, is in 18-point Calibri, italics. It is centered in cells A2 through H2, which have been merged. The column headings are set in 11-point Calibri, bold. They are centered in their cells, and the text wraps in the cells. a. Make the first two rows of your spreadsheet similar to that in Figure AE-1. Choose your own colors for background and type, however. b. Place the current date so that it is centered in cells C3, D3, and E3, which must be merged. 1 G D Resort Bicycle Rental Bicycle Inventory Valuation Saturday, May 27, 2018 Revenue as Number on Cost of Current Number of Total Rental Revenue per Percent of Cost Hand Inventory Rentals Revenue Bike of Inventory 12 $3,900 85 $6,375 $531 163.5% $1,540 34 $4,570 $1,143 296.8% $3,800 44 $5,200 $650 136.8% $5,240 25 $2,480 $310 47.3% $2,620 40 $6,710 $1,678 256.1% $2,385 37 $5,900 $1,967 247.4% Make of Bike 5 Wonder Bike 6 Wonder Bike II 7 Wonder Bike Supreme 8 LiteLift Pro 9 Lite Lift Ladies 10 LiteUift Racer Bike Cost $325 $385 $475 $655 5655 $795 w 00 00 c. Outline the cells as shown in Figure AE-1. d. Figure AE-1 uses the following formulas: Cost of Current Inventory = Bike Cost X Number on Hand Revenue per Bike = Rental Revenue/Number on Hand Revenue as a Percent of Cost of Inventory = Total Rental Revenue/ Cost of Current Inventory Use these formulas in your spreadsheet, as shown in Figure AE-1. e. Format the cells in the columns as shown. f. Give three examples of decisions that management of the bike rental agency might make from this data. g. What other calculation could you make from this data that would be useful to the bike rental management? Create a second version of this spreadsheet in your work- sheet document that has this calculation