Assignment #5

profilelar.ro

Inventory Costing and Periodic and Perpetual inventory Systems

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:

 

Date

Transaction

Quantity

Price/Cost

1/1

Beginning inventory

2,900

$10

2/12

Purchase

3,300

$15

3/2

Sale

2,400

$28

4/18

Purchase

4,500

$18

5/31

Sale

3,800

$30

  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 submission must show all calculations used to arrive at the answers. Any written comments must be formatted according to the CSU-Global Guide to Writing and APA Requirements. Insert comments, as needed, using Excel’s “Add a Comment” function.

    • 9 years ago
    • 20
    Answer(7)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      depreciaiton_and_others.xls
    • attachment
      _cost_of_goods_sold.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      redster_company__answers.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      cost_flow.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      2014-02-17_034424_cost_of_goods_sold.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      redster_company_is_a_manufacturing_firm.docx
    • attachment
      redster_company_is_a_manufacturing_firm.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      redster_company_tutorial.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      depreciaiton_and_others.xlsx
    Bids(0)
    other Questions(10)