Help thx

Boyles Bicycles Ltd sells a mountain bike, Trekker, that is popular with cycling enthusiasts. Below is information relating to Boyles Bicycles purchases of Trekker bikes during July. During the same month, 104 Trekker bikes were sold. B Cell referencing recommen but not required for this Date lanation Units Unit Cost Total Cost 2,500 $2,912 $3,816 $4,104 13,332 question. 12 Jul 19 Ju 26 Jul Invento Purchases Purchases Purchases Total 28 36 38 127 100 104 106 108 Use the "Date", "Units" & "Unit Cost" columns below for workings. Only your "Total Cost" entries will be assessed. Required(a1 Use the table below to calculate 31 July inventory and the Cost of sales using the FIFO method. FIFO PROOF Units Unit Cost Total Cost Date 1 July 12 July 19 July 26 July 100 $2,500 104$2,912 106 $3,816 108 $1,620 $10,848 2,500 28 36 15 10,832 Less endi Click to enter $2,484 $ value Click cell & use d Click cell & use dr Cost of sales $ value $ value $ value These two values s be the same 10,848 Ending inventory calculation are important & difficult Required(a2) Use the table below to calculate 31 July inventory and the Cost of sales using the LIFO method LIFO PROOF Unit Cost Date ?77 Total Cost S value S value Units nning inventor $2,500 ?77 ?77 Purchases Less endi Click to enter $10,832 $2,484 $ value S value $ value ??7? ?7? ?7? Click cell & use dr Click cell & use d Cost of sales $ value $ value $ value $10,848 These two valuess be the same