Help Save & Ext 1. Please read this base data 2. The using either MS Word, or Excel, complete the inventory calculation for COGS and Ending Inventory as we did in class (excel attached - but allow for editing if necessary button top of pagell) 3. Save the file to your computer 4. Attach the file to the question sheet in the McGraw-Hill Connect Mid-Term Purchoses Sales 1.250 units 510 purchase price 1.000 units 511 purchase price 250 units Beginning Inventory January 30 Eebruary 15 February 30 August 15 October 30 December 15 500 units 512 purchase price 2.000 units 1.500 units $13 purchase orice a 300 units Instructions. This company uses a perpetual inventory system CAUTION PLEASE BE CAREFUL TO USE THE CORRECTLY HEADED ANSWER SHEET ANSWERS WILL BE MARKED BASED ON THE ANSWER SHEET USED Section I Porta Using the following information calculate the Ending Inventory levels (Units sold. Cost of Goods Sold Units Remaining & Doller Value) sing the following method Firstein, Fir-Out L6 fi 8 E F H M N o C D FIFO - First-In First-Out 1 Inventory Valuation 2 3 DATE PURCHASE Quantity Unit Cost Total Cost 4 COGS Quantity Unit Cost COGS Ending Inventory Quantity Unit Price Total Value 5 6 7 B 9 10 72 13 14 15 16 17 18 19 20 21 22 23 25 26 27 20 20 30 39 Sheet