Attached is a spreadsheet with two problems I need help in solving. Their is two

Attached is a spreadsheet with two problems I need help in solving. Their is two tabs on the spreadsheet. One for each problem.One is titled Landis Company and the other is titled Clarke Company.

1/1/2013
100
4
4001/20/2013
400
5
20007/25/2013
200
7
140010/20/2013
300
8
24001000
62001234Beginning Inventory
Units
Unit Cost
Total Cost
Purchase
total
A Physical count of inventory on December 31 revealed that there were 400 units on hand.
Answer the following independent questions and show computations supporting your answers:
Assume that the company uses FIFO method. That Value of the ending inventory at December 21 is:
Assume that the company uses Average-Cost method. That Value of the ending inventory at December 21 is:
Assume that the company uses LIFO method. That Value of the ending inventory at December 21 is:
Determine the difference in the amount of income that the company would have reported if it had used the
FIFO method instead of the LIFO method. Would income have been greater or less?
Clarke Company uses the periodic inventory method and had the following inventory information available:
The income statement approach to estimating uncollectible accounts expense is used by Landis Company.
had a credit balance of $2140 before adjustment. Net credit sales for February amounted to $3000000.
The credit manager estimated that uncollectible accounts expense would amount to 1% of net credit sales made during February.
a.
Prepare the journal entries made by Landis on the following dates:
1. February 28
2. March 10
3. March 31
b.
Assume no other transactions occurred that affected the allowance account during March. Determine the
balance of Allowance for Doubtful Accounts at March 31.
On March 10 an accounts receivable from Kathy Brown for $6100 was determined to be uncollectible and written off. However on March 31
Brown received an inheritance and immediately paid her past due account in full.
On February 28 the firm had accounts receivable in the amount of $437000 and Allowance for Doubtful Accounts

Attachments: