Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Accounting Excel File Format with all the answers, clearly identifying all steps, results, journals and including comments besides each answer

Accounting Excel File Format with all the answers, clearly identifying all steps, results, journals and including comments besides each answer

Accounting

Accounting

Excel File Format with all the answers, clearly identifying all steps, results, journals and including comments besides each answer.

Jim has recently opened a snack food wholesale company dedicated to the sale of peanuts, almonds and pistachios. During its first month of activity, the company has made the following transactions:

 

Kg

Price per Kg

Amount

February 2: Purchase of Pistachios:

2300

$12

$27,600

Purchase of Almonds:

4000

$6

$24,000

Purchase of Peanuts:

4000

$4

$16,000

 

February 3: Purchase of Pistachios:

1500

$14

$21,000

Purchase of Almonds:

1500

$7

$10,500

Purchase of Peanuts:

2500

$5

$12,500

 

February 6: Sold to several clients:

 

 

 

Pistachios:

1900

$21

$39,900

Almonds:

2500

$12

$30,000

Peanuts:

2500

$10

$25,00

 

February 6: Sold to Fruits Lovers Inc.:

 

 

 

Pistachios:

500

$21

$10,500

Almonds:

750

$13

$9,750

Peanuts:

1500

$9

$13,500

 

 

February 12 Purchase of Pistachios:

1350

$15

$20,250

Purchase of almonds:

3000

$8

$24,000

February 13: Sale of peanuts to peanuts Lovers Inc.:

3250

$9

$29,250

February 14: Purchase of Peanuts

2000

$5

$10,000

 

Besides these transactions, the company has had the following expenses:

Salaries: $3,750
Electricity bill: $400
Renting of equipment: $1,50

 Rent of warehouse and office: $3,250

Miscellaneous: $1,250

Questions

Jim’s accountant recommended that he should use the average cost method in order to determine the cost of the inventory sold but he is not sure about the consequences it may have on his financial situation.

Relying on your accounting knowledge, Jim asks you the following questions:

1: Why in your opinion did Jim’s accountant recommend the average cost method and what difference is there with the three other methods? Explain the main characteristics of each method of valuation of the inventory and the consequences they may have on the valuation of the inventory and determination of the net income in case of price fluctuation.

2: Prepare an Income statement of the company at the end of February using as method of valuation of the inventory the average cost method, FIFO and LIFO for each one of the products sold by Jim and calculate the balance of the inventory at the end of the month. Explain the calculations.  

3: In order to compare with the records made by his accountant, Jim asks you to prepare the different journal entries for the purchases and sales mentioned above for each one of the 3 different methods used above.  

4: Jim would like to know a forecast of the number of days to sell the inventory based on the results of the month of February. Explain your calculation and the steps followed.  

 

 

Option 1

Low Cost Option
Download this past answer in few clicks

14.99 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE