Managerial Accounting Lab$-$Assignment #$1$ Moore Bicycle Manufacture Company You just got hired at Moore Bicycle Manufacture Company and were given data to prepare a report. Follow the instructions below. Please refer to the excel file located on MYHSSU under resources: $$ Assignment#$1$ Excel file Listed below are the requirements to complete the assignment: $1.)$ Add a row a$.)$ create a header for each column b$.)$ header must be centered c$.)$ helpful hints $1.)$ Column C contains F$-$Female$/$M$-$Male $($name the column appropriately$)2.)$ Column F consist of items sold $($name the column appropriately$)3.)$ Column G identifies number of items sold $($name the column appropriately$)4.)$ Column H is the cost of the item sold $($name the column appropriately$)5.)$ Column I is the price the item was sold for $($name the column appropriately$)6.)$ Column B is the customer$$s age $($name the column appropriately$)$ The column headers should not be more than two words $2.)$ Create a column for the following: a$.)$ total cost of item sold b$.)$ total earned from item sold c$.)$ both columns must contain formulas d$.)$ The last row must have the word $$Total$$ in bold e$.)$ You must provide a total dollar amount for the columns you added a$.)$ format the grand total $0$ decimals places, bold and dollar sign b$.)$ single line$/$double line$2/19/1629$ F Washington Tires and Tubes $180\mathrm{.}00109\mathrm{.}002/20/1629$ F Washington Gloves $224\mathrm{.}5028\mathrm{.}502/27/1629$ F Washington Tires and Tubes $33\mathrm{.}675\mathrm{.}003/12/1629$ F Washington Tires and Tubes $287\mathrm{.}50116\mathrm{.}503/12/1629$ F Washington Tires and Tubes $335\mathrm{.}0041\mathrm{.}674/8/1629$ F Washington Tires and Tubes $166\mathrm{.}0078\mathrm{.}004/17/1629$ F Washington Tires and Tubes $252\mathrm{.}0060\mathrm{.}004/17/1629$ F Washington Tires and Tubes $160\mathrm{.}0068\mathrm{.}006/22/1629$ F Washington Tires and Tubes $28\mathrm{.}0010\mathrm{.}007/1/1629$ F Washington Tires and Tubes $340\mathrm{.}0048\mathrm{.}677/22/1629$ F Washington Tires and Tubes $246\mathrm{.}0060\mathrm{.}007/22/1629$ F Washington Tires and Tubes $19\mathrm{.}0010\mathrm{.}008/18/1529$ F Washington Helmets $3151\mathrm{.}67181\mathrm{.}338/30/1529$ F Washington Tires and Tubes $370\mathrm{.}0072\mathrm{.}677/22/1518$ F California Bike Stands $1636\mathrm{.}00677\mathrm{.}0010/10/1518$ F California Bike Stands $3159\mathrm{.}00170\mathrm{.}676/11/1618$ M California Mountain Bikes $1769\mathrm{.}00875\mathrm{.}008/13/1518$ M California Mountain Bikes $12,295\mathrm{.}002,242\mathrm{.}009/10/1518$ M California Mountain Bikes $1769\mathrm{.}00776\mathrm{.}0010/20/1518$ M California Mountain Bikes $21,160\mathrm{.}001,005\mathrm{.}0012/21/1518$ M California Mountain Bikes $12,295\mathrm{.}002,303\mathrm{.}007/27/1519$ F Oregon Hydration Packs $2797\mathrm{.}50813\mathrm{.}002/7/1619$ M Washington Mountain Bikes $3180\mathrm{.}00188\mathrm{.}337/24/1519$ M Washington Mountain Bikes $12,320\mathrm{.}002,160\mathrm{.}003/20/1619$ M California Jerseys $3100\mathrm{.}00117\mathrm{.}673/21/1619$ M California Jerseys $1750\mathrm{.}00985\mathrm{.}005/6/1619$ M California Jerseys $3133\mathrm{.}33164\mathrm{.}336/6/1619$ M California Fenders $388\mathrm{.}0095\mathrm{.}336/9/1619$ M California Jerseys $2300\mathrm{.}00384\mathrm{.}008/20/1519$ M California Jerseys $3133\mathrm{.}33161\mathrm{.}008/21/1519$ M California Jerseys $2594\mathrm{.}00569\mathrm{.}509/27/1519$ M California Jerseys $275\mathrm{.}0079\mathrm{.}501/27/1619$ M California Cleaners $299\mathrm{.}50126\mathrm{.}001/25/1619$ F California Helmets $346\mathrm{.}6751\mathrm{.}671/26/1619$ F California Helmets $1175\mathrm{.}00218\mathrm{.}005/20/1619$ F California Helmets $252\mathrm{.}5060\mathrm{.}007/26/1519$ F California Helmets $2122\mathrm{.}50139\mathrm{.}5012/6/1519$ F California Helmets $1420\mathrm{.}00458\mathrm{.}006/24/1620$ M Washington Socks $345\mathrm{.}0052\mathrm{.}6710/5/1520$ M Washington Socks $227\mathrm{.}0030\mathrm{.}507/18/1520$ F California Mountain Bikes $12,295\mathrm{.}002,146\mathrm{.}007/25/1520$ F California Mountain Bikes $12,320\mathrm{.}002,030\mathrm{.}0012/4/1520$ F California Mountain Bikes $12,295\mathrm{.}001,884\mathrm{.}007/16/1522$ F Washington Caps $1216\mathrm{.}00228\mathrm{.}008/14/1524$ F California Bike Stands $3530\mathrm{.}00529\mathrm{.}3312/28/1524$ F California Bike Stands $11,113\mathrm{.}001,297\mathrm{.}003/26/1640$ M Oregon Mountain Bikes $1769\mathrm{.}00873\mathrm{.}005/24/1640$ M Oregon Touring Bikes $3247\mathrm{.}33250\mathrm{.}337/8/1540$ M Oregon Mountain Bikes $12,320\mathrm{.}002,340\mathrm{.}007/13/1540$ M Oregon Mountain Bikes $2384\mathrm{.}50353\mathrm{.}508/8/1540$ M Oregon Mountain Bikes $12,320\mathrm{.}002,340\mathrm{.}0012/25/1540$ M Oregon Mountain Bikes $12,320\mathrm{.}002,095\mathrm{.}00$