Please help and please send the answers on MS Excel if possible. This question had been solved but requirement 2 is not showing the complete answer. Thank you!

3. A Corporation's record for the year 2021 show the following data: Net Sales (6,000 units) Cost of goods manufactured (7,000 units) Variable 21,000.00 9,450.00 4,725.00 Fixed Operating expenses Variable Fixed 1,470.00 2,100.00 There was no finished goods inventory at the beginning of the period. Neither was there any work-in-process inventory at the beginning of the year. Questions a. What is the amount of the finished goods inventory at the end of 2021 under both absorption and variable costing b. What are the operating income of A corporation under both costing method