Can someone answer this please

Problem 6-7B Gross profit comparisons and cost flow assumptions-perpetual LO2, 3 excel CHECK FIGURES: 1. Ending inventory, a. $9.966.00:b. $11,367.90 The Singh Bamboo Company has the following sales, inventory, and purchases during the fiscal year ended Singhamboo Company uses a perpetual inventory system. CHAPTER 6 Inventory Costing and Valuation Darmber 31, 2020. Beginning inventory March 10 purchased March 20 sold April 30 purchased July 5 purchased September 15 sold. 290 units 205 units 370 units 281 units 255 units 510 units $ 82/unit $ 86/unit $162/unit $ 80/unit $ 66/unit $162/unit a Required 1. Calculate the dollar value of ending inventory and cost of goods sold using: FIFO be Moving weighted average method. Round all unit costs to two decimal places. 2 using your calculations from Part 1, complete the following schedule: Moving Weighted Average FIFO Sales Cost of goods sold. Gross profit Analysis Component: How would the gross profits calculated in Part 2 above change if Singh Bamboo Company had been experiencing increasing prices in the purchase of additional inventory? Pmhlom hon Income catamant eamnaricane and cast flow assumptions-perpetual 102 2. Ycal