inventory costing and periodic and perpetual inventory systems

Benson Company is a manufacturing firm. Presented below is information concerning one of its products:

1/1

Beginning inventory

3,190

$10

2/12

Purchase

3,630

$15

3/2

Sale

2,640

$28

4/18

Purchase

4,950

$18

5/31

Sale

4,180

$30

Part A

Compute the cost of goods sold under the following situations:

  1. Periodic system, FIFO cost flow
  2. Perpetual system, FIFO cost flow
  3. Periodic system, LIFO cost flow
  4. Perpetual system, LIFO cost flow
  5. Periodic system, weighted-average cost flow
  6. Perpetual system, moving-average cost flow

Your answers must be submitted in an Excel file and must show all calculations used to arrive at the final answers.

Part B

Summarize the cost of goods sold in a one-page memo to Benson Corporation’s CEO. Format your memo according to the CSU-Global Guide to Writing and APA Requirements.

Please ensure you follow the instructions and use APA format for both the Excel portion and the memo. I know it is a memo but please do not forget your sources. Thank you! Please let me know if you have any questions. Thank you