Solve the question with Ms. Excel Format or Convertible to Ms. Word with Clear Numerical Explanations.

1. What would be the companys ending inventory value after using total inventory method.
2. Discuss how using a different method for inventory costing can affect the balance sheet of company.

Please Solve Both Parts.

Q1: Balance sheets are supposed to show true picture of a company and for that reasons its item must be valued at the end of an accounting period. Inventory being crucial item for a manufacture concern are adjusted by different methods and Lower the Cost of Market rule is one of them. Given below is the data of a company: Cost per Quantit Est selling Price Cost of completion Normal Profit unit Prod uct # 1 $1.00 1800 1200 450 500 2 Cost to replace $4.50 $2.70 $3.00 $2.25 $3.70 $2.30 $2.70 $2.00 $5.00 $3.50 $3.80 $3.25 $0.40 $0.50 $0.40 $0.80 3 $0.50 $0.50 $0.60 4 5 2000 100 $3.00 $3.10 $3.20 $3.60 $4.50 $3.20 $0.35 $0.25 $1.25 $0.90 6 Required