Please assist with the three sections on this excell sheet. Thanks!

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