A1 Calibri 2 Enter your last name here BA General Editing C PO Accessibility tab summary: An entry field for student presentation is provided in 82. Information about a Company is provided in row 4. A statement for student presentation is provided in row D E F G H 4 Your Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system 5 Required: Determine the cost assigned to ending inventory and cost of goods sold using FFO and UFO Date Activities Units Acquired at Cost Units Cost per unit Total cost Units Units Sold at Retail Selling price per Total Sales unit January 01 Beginning inventory 150 $7.50 $1,125.00 10 January 09 Sales 110 $16.50 $1,815.00 11 January 19 Purchase BO $6.50 520.00 12 13 January 25 January 30 Sales 90 $16.50 1,485.00 14 Purchase Totals 200 $6.00 1.200.00 430 $2.845.00 200 $3.300.00 15: 16 17 18 K L McGraw Hill Check Answers Check My Work Legend Graded cell Leave blank if no answer needed. Scratchoad Use as a non-graded 19 Students The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 20 Nothing in this area will be graded, but it will be submitted with your assignment. 31 =B Question Data BFFO BUFO + Calculation Mode Automatic Workbook Sutto Save and Return to Assignment 13 FSW Hill Excel Question Saved P Search (Option+Q) File Home Insert Draw Formulas Data Review View Help 5x Calibri B & A M9 h A c D E 2 Required: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO General Weekly F G H 1 L M McGraw Hill Check Answers Date Activities Units Acquired at Cost Units Sold at Retail Units Cost Total cost per unit Units Selling Total Sales price per unit 6 January 01 Beginning inventory 150 $7.50 $1,125.00 7 January 09 Sales 110 $16.50 $1.815.00 January 19 Purchase 80 $6.50 $20.00 15 January 25 Sales 90 $16.50 1,485.00 10 January 30 11 Purchase Totals 200 430 56.00 1,200.00 $2,845.00 200 $3,300.00 12 13 14 Perpetual FIFO Units available Unit Cost of Goods Sold-Jan 9 Cost Cost of per unit goods sold Cost of Goods Sold-Jan 25 Units Cost Cast of Ending Inventory Units Cost Inventory per unit goods sold per unit 15 150 units from beginning inventory $7.50 $7.50 $7.50 16 80 units purchased on January 19 56.50 56.50 $6.50 17 200 units purchased on January 30 $6.00 $6.00 $6.00 18 Totals $0.00 50.00 50.00 19 Question Data RFO BUFO + Calculation Mode: Automatic Workbook Statistics Editing D Check My Work Legend Graded cell: Leave blank if no ant needed Scratcboast Use as a non-graded workspace Save and Retum to Assignment Gwback to Mo A1 X fx Accessibility tab summary: A statement for student presentation is provided in row 2. A table D G Activities Units 2 Required Determine the cost assigned to ending inventory and to cost of goods sold using LIFO 214 S Date Units Acquired at Cost Units Sold at Retail Selling Total Sales price per unit Cost per an Total cost Units 6 January 01 T January 09 January 19 Beginning inventory Sales Purchase 150 $7.50 $1,125.00 110 $16.50 $1,815.00 80 $6.50 520.00 " January 25 Sales 90 $16.50 1,485.00 10 January 30 Purchase 11 Totals 200 430 $6.00 1,200.00 $2,845.00 200 $1,300.00 12 13 Perpetusi UFO 14 Units avaliable Cost of Goods Sold-Jan 9 Units Cost Cost of per unit goods sold 15 150 units from beginning inventory $7.50 10 Cost of Goods Sold-Jan 25 Units Cost Cost of per unit goods sold $7.50 $75.00 Ending Inventory Units Cost per unit Inventory $7.50 16 80 units purchased on January 19 $6.50 56.50 $6.50 17 200 units purchased on January 30 $6.00 $6.00 $6.00 18 Totals D 50.00 10 $75.00 $0.00 19 20 + 21 22 23 Students The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 24 Nothing in this area will be graded, but it will be submited with your assignment