Please assist with solvingspread sheetand answering questions 1-3

\fChapter 16 Decision Guideline Omaha Fertilizer Company Inventory Valuation Analysis November 24, 2013 Beginning Inventory Inventory Purchases Scenario #1 ($12 per bag): FIFO $200,000 $360,000 LIFO Available Inventory COGS Ending Inventory $560,000 #VALUE! $200,000 $360,000 $560,000 #VALUE! Scenario #2 ($8 per bag): FIFO $200,000 $240,000 $440,000 #VALUE! $240,000 $440,000 #VALUE! LIFO $200,000 (yellow boxes are the required for cost of goods sold and end under lifo/fifo; $12 a bag and $ yellow boxes are the required answers or cost of goods sold and ending inventory nder lifo/fifo; $12 a bag and $8 a bag