Please read this base date 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 to of pagell 3. Save the file to your computer 4. Attach the file to the question sheet in the McGraw-Hill Connect Mid-Term Sales Beginning Inventory January 30 February 15 February 30 August 15 October 30 December 15 Purchases 1.250 unko_510. purchase price 1.000 unita 511 purchase price 500 units 517 nehane Price 3.500 313. outshase price 250 units 2.000 units 300 units Instructions: This company uses a perpetual inventory system CAUTION PLEASE BE CAREFUL TO USE THE CORRECTLY HEADED ANSWER SHEET ANSWERS WILLIE MARKED BASED ON THE ANSWER SHLETUSED Section Part 0 Using the following information, calculate the Ending Invertery Levels (Unito cold, Cost of Good So Unito Musaining & Deler ... the following method Average Weighted Cost Erable Editing NU G M N o D Inventory Valuation XWC Average Weighted Cost 2 3 DATE PURCHASE 4 Quantity Unit Cout Total Cost 5 6 7 0 3 COGS Quantity Unit Cost COGS Ending Inventory Quantity Unit Price Total Value 10 71 12 13 14 15 16 17 18 15 30 21 20 24 24 2 22 29 30 31 O