Bill's Lawn Care Mini
In June, Bill decided to open a small retail operation selling bags of fertilizer to the public. He has decided to begin by offering two kinds of fertilizer. Below is the information for the month of June, 2014, for the two types of fertilizer.
|
Product
|
Selling Price
|
|
Feed All Fertilizer
|
$27.00
|
|
Weed and Feed All Fertilizer
|
$35.00
|
Purchase Data
|
Date
|
Product
|
Quantity (Bags)
|
Price per Bag
|
|
6/1/2014
|
Feed All Fertilizer
|
10
|
15.00
|
|
6/1/2014
|
Weed and Feed All Fertilizer
|
10
|
20.00
|
|
6/11/2014
|
Feed All Fertilizer
|
20
|
15.50
|
|
6/15/2014
|
Weed and Feed All Fertilizer
|
10
|
19.50
|
|
6/22/2014
|
Feed All Fertilizer
|
10
|
15.75
|
|
6/28/2014
|
Feed All Fertilizer
|
10
|
15.50
|
|
6/28/2014
|
Weed and Feed All Fertilizer
|
10
|
19.75
|
All purchases are paid in cash at the time of the purchase and Bill picks up the fertilizer from the distributor, so there is no freight charge.
Sales Data (summarized by week)
|
Date
|
Product
|
Quantity (Bags)
|
|
6/9/2014
|
Feed All Fertilizer
|
6
|
|
6/9/2014
|
Weed and Feed All Fertilizer
|
4
|
|
6/16/2014
|
Feed All Fertilizer
|
12
|
|
6/16/2014
|
Weed and Feed All Fertilizer
|
5
|
|
6/23/2014
|
Feed All Fertilizer
|
8
|
|
6/23/2014
|
Weed and Feed All Fertilizer
|
2
|
|
6/30/2014
|
Feed All Fertilizer
|
10
|
|
6/30/2014
|
Weed and Feed All Fertilizer
|
4
|
In addition to the sales, on 6/20/14, a customer returned one bag of Feed All Fertilizer to Bill for credit on account.
Instructions:
Calculate the Cost of Goods Sold and the Ending Inventory values for the fertilizer products under 1) Average Cost, 2) First-In, First-Out(FIFO), and 3) Last-In, First-Out (LIFO). You will need to calculate ending inventory from the purchase, sale and return data given, you may assume that a physical count confirmed your calculation of the number of units in ending inventory.
Assume that Bill decides to use the FIFO method and compute the lower of cost or market (LCM) value to be reported for the end of June, 2014.Use the last purchase prices for the market value. You only need to calculate cost under the FIFO method for this comparison.
Prepare the Cost of Goods Sold section of the Income Statement.