Redster Company is a manufacturing firm. Presented below is

Redster Company is a manufacturing firm. Presented below is information concerning one of its products, called Ander.Using an Excel spreadsheet, compute the cost of goods sold under the following situations:DateTransactionQuantityPrice/Cost1/1Beginning inventory2,900$102/12Purchase3,300$153/2Sale2,400$284/18Purchase4,500$185/31Sale3,800$30Periodic system, FIFO cost flowPerpetual system, FIFO cost flowPeriodic system, LIFO cost flowPerpetual system, LIFO cost flowPeriodic system, weighted-average cost flowPerpetual system, moving-average cost flowYour submission must show all calculations used to arrive at the answers,AND A SHORT WRITTEN NARRATIVE OF TOPIC . Any written comments must be formatted according to the APA REQUIREMENTS Insert comments, as needed, using Excel’s “Add a Comment” function.