Data Table -X form hat ell foi Transaction Units Sales in Units Unit Cost unit cost Total Cost $ 180.000 10,000 $ 18 Beginning inventory 1/1 Purchases and Sales Use a mi is in On punts tot February 8 18 5.500 2.200 99.000 57 200 26 17,700 $ June 24 Subtotal September 18 336.200 5,600 2,500 31 77 500 December 24 413.700 Total available for sale 20 200 (5.600) Units sold September 18 14.600 Ending inventory eck A Print Done Bayne Manufacturing Company provided the following information regarding its inventory transactions for the current year, Click the icon to view the inventory transactions) Determine the ending inventory and cost of goods sold that Bayne should report assuming that the firm uses the moving-average cost method perpetui bass) Round per unit cost to od calculations. Only round the amount you input into the cell for cont per unit to two decimal places and all other amounts to the nearest whole dollar) Begin by entering Bayne's purchase and sale transactions in chronological order one line at a time, calculating a new moving average cost per unitate every transactions amoustic reduction in cost. Do not round intermediary calculations. Only round the amount you input into the cel for unit cost and cost per unit to two decimal places and are amounts to the neares Moving-average: Units Average Purchased Unit Cumulative Total Cumulative Cost Transaction (Sold) Cost Units Cost Cost Per Unit Beginning inventory Purchase - February 8 Purchase - June 24 Sale September 18 old that Bayne should report assuming that the firm uses the moving average cost method (perpetual basis) Round per unit cost to two decimal places (Do not toonid intermediary e cell for cost per unit to two decimal places and all other amounts to the nearest whole dollar) actions in chronological order one line at a time, calculating a new moving-average cost per unit after every transaction (Use a manus sign or prontline for units sold or fora tions. Only round the amount you input into the cell for unit cost and cont per unit to two decimal places and all other amounts to the nearest wholdstot) Average Unit Cumulative Total Cumulative Cost Cost Units Cost Cost Per Unit