ch6-2

ed into purchases and sales for March as shown in the Tableau Dashboard. arch ednesday Thursday Friday Saturday 1 2 N Purchase 100 units $50 each 6 7 8 9 March Sunday Monday Tuesday Wednesday Thursday Frid Legend No Purchases or Sales Purchases Sales 3 Keep Only Exclude 8 Purchase 400 units $55 each 10 11 12 13 17 18 19 20 Purchase 120 units $60 each 24 25 26 27 31 17 18 19 20 24 26 27 Purchase 200 units $62 each 31 1(a). Compute the number of units available for sale in March. 1(b). Compute the number of units in ending inventory on March 31. 2. Compute the cost assigned to ending inventory using specific identification. Note: The March 9 sale consists of 80 units from March 1 purchase and 340 units from the March 5 purchase, the March 29 sale consists of 40 units from the March 18 purchase and 120 unts from the March 25 purchase. Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Compute the number of units available for sale in March. Units Activity March 1 March 5 March 18 March 25 Units available for sale 0 > Required 18 1(a). Compute the number of units available for sale in March. 1(b). Compute the number of units in ending Inventory on March 31. 2. Compute the cost assigned to ending inventory using specific identification. Note: The March 9 sale consists of 80 units from March 1 purchase and 340 units from the March 5 purchase; the March 29 sale consists of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Complete this question by entering your answers in the tabs below. ncos Required 1A Required 15 Required 2 Compute the number of units in ending Inventory on March 31. Ending inventory units Required 1A Required 1B Required 2 Compute the cost assigned to ending Inventory using specific identification. Note: The March 9 sale consists of 80 units from March 1 purchase purchase; the March 29 sale consists of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Specific Identification Avaliable for Sale Cost of Goods Sold Ending Inventory Ending Ending Purchase Date Activity Units Unit Cont Units Sold Unit Cost COGS Inventory Cost Per Unit Inventory Units Coat March 1 March 5 March 18 March 25 Purchase Purchase Purchase Purchase 100 400 120 200 820 $ 5