Can you please help me with my accounting problem?

Bill's Lawn Care Module 3 Mini Practice Problem 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 Feed All Fertilizer Weed and Feed All Fertilizer Selling Price $27.00 $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 6/9/2014 6/9/2014 6/16/2014 6/16/2014 6/23/2014 6/23/2014 6/30/2014 6/30/2014 All sales are Feed All Fertilizer Weed and Feed All Feed All Fertilizer Weed and Feed All Feed All Fertilizer Weed and Feed All Feed All Fertilizer Weed and Feed All on credit. Fertilizer Fertilizer Fertilizer Fertilizer Quantity (Bags) 6 4 12 5 8 2 10 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: 1. 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. 2. 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. 3. Prepare the Cost of Goods Sold section of the Income Statement. 1) Average Cost Date Explanation COST OF GOODS AVAILABLE FOR SALE Feed All Fertilizer Units ENDING INVENTORY Unit Cost COST OF GOODS SOLD COST OF GOODS AVAILABLE FOR SALE Weed and Feed All Fertilizer Date Explanation Units ENDING INVENTORY Unit Cost COST OF GOODS SOLD 2) First-In, First-Out (FIFO) COST OF GOODS AVAILABLE FOR SALE Feed All Fertilizer Date Explanation Units ENDING INVENTORY Unit Cost COST OF GOODS SOLD COST OF GOODS AVAILABLE FOR SALE Weed and Feed All Fertilizer Date Explanation Units Unit Cost ENDING INVENTORY COST OF GOODS SOLD 2) Last-In, First-Out (LIFO) COST OF GOODS AVAILABLE FOR SALE Feed All Fertilizer Date Explanation Units ENDING INVENTORY Unit Cost COST OF GOODS SOLD COST OF GOODS AVAILABLE FOR SALE Weed and Feed All Fertilizer Date Explanation ENDING INVENTORY Units Unit Cost COST OF GOODS SOLD l Fertilizer Total Cost Sample of how to fill out this page using Average Cost COST OF GOODS AVAILABLE FOR SALE xxxxx Fertilizer Date Explanation 6/15 6/28 Units Purchase Purchase 10 25 Total 35 ENDING INVENTORY $ 177.50 Units 11 /35 COST OF GOODS SOLD $5.07 Cost of Goods Available for Sale Less: Ending Inventory Cost of Goods Sold Unit Cost Total Cost $ 5.07 $55.77 A good example is located in your e-text (Illustration 6-6) nd Feed All Fertilizer Total Cost l Fertilizer Total Cost Sample of the EI and COGS calculation for FIFO or LIFO, Cost of Goods Available is the same as in the Average Cost sample above ENDING INVENTORY Date 6/28 Total nd Feed All Fertilizer Total Cost Units COST OF GOODS SOLD Unit Cost Total Cost 11 5.10 56.10 11 $ 56.10 Cost of Goods Available for Sale Less: Ending Inventory Cost of Goods Sold l Fertilizer Total Cost nd Feed All Fertilizer Total Cost ILABLE FOR SALE xxxxx Fertilizer Unit Cost Total Cost $5.00 $5.10 $50.00 $127.50 $ 177.50 Cost of Goods Available for Sale $ 177.50 Less: Ending Inventory Cost of Goods Sold $ $ 55.77 121.73 COST OF GOODS SOLD Cost of Goods Available is the same as in the COST OF GOODS SOLD Cost of Goods Available for Sale Less: Ending Inventory Cost of Goods Sold $ $ $ 177.50 56.10 121.40 Lower of Cost or Market (LCM) Item Total Cost Total Market LCM Sample of how to fill out the LCM sheet Item XXX Fertilizer YYY Fertilizer Total Inventory Total Cost* $ Total Market* 150.00 $ 85.00 LCM 175.00 $ 150.00 79.00 ### $ 229.00 *These numbers are total cost and market, not per unit A good example is located IN your e-text (Illustration 6-16) Sample of COGS section of Income Statement Cost of Goods Sold Inventory, June 1 Purchases Less: Purchase Returns and Allowances Cost of Goods Purchased Cost of Goods Available for Sale Inventory, June 30 Cost of Goods Sold A good example is located in your e-text (Illustration 5-B2) $0 $0 $0 $0