Use this data information to fill out this empty Retail inventory chart

The following information was taken from Duncan Company, Inc Cost 250,000 914,500 (60,000) (18,000) Retail 390,000 1,460,000 (80,000) 1,410,000 (97,500) Inventory Jan 1, 2019 Purchases Purchase Returns Purchase Discounts Sales (gross) Sales returns Sales Discounts Employee Discounts granted Estimated goods shop lifted Freight In Freight Out Loss from Breakage Markups Markup cancellations Markdowns Markdown cancellations (8,000) 42,000 50,000 (4,500) 120,000 (40,000) 45,000 (20,000) Price index if $ value LIFO Fluctuating 110% Duncan Company, Inc Conventional Retail Inventory: Average, lower of Cost or NRV For the Year Ending December 31, 2019 Cost Retal Inventory, Jan. 1, 2019 Net Purchases Purchases Purchase Returns Purchase Discounts Freight In Net Purchases Goods Available Add: Markups Markups Markup Cancellations Less : Abnormal Shortages Total after Net Markups and Abnormal Shortages Cost to Retail Ratio Deduct: Net Markdowns Markdowns Markdown Cancellations Total Goods Available Deduct: Net Sales Sales Sales Returns And Allowances Less : Normal Shortages Employee Discounts Ending Inventory at Retail Ending inventory at Retail Ratio: Cost to Retail Percentage Ending inventory at lower of cost or market Cost of Goods Sold The following information was taken from Duncan Company, Inc Cost 250,000 914,500 (60,000) (18,000) Retail 390,000 1,460,000 (80,000) 1,410,000 (97,500) Inventory Jan 1, 2019 Purchases Purchase Returns Purchase Discounts Sales (gross) Sales returns Sales Discounts Employee Discounts granted Estimated goods shop lifted Freight In Freight Out Loss from Breakage Markups Markup cancellations Markdowns Markdown cancellations (8,000) 42,000 50,000 (4,500) 120,000 (40,000) 45,000 (20,000) Price index if $ value LIFO Fluctuating 110% Duncan Company, Inc Conventional Retail Inventory: Average, lower of Cost or NRV For the Year Ending December 31, 2019 Cost Retal Inventory, Jan. 1, 2019 Net Purchases Purchases Purchase Returns Purchase Discounts Freight In Net Purchases Goods Available Add: Markups Markups Markup Cancellations Less : Abnormal Shortages Total after Net Markups and Abnormal Shortages Cost to Retail Ratio Deduct: Net Markdowns Markdowns Markdown Cancellations Total Goods Available Deduct: Net Sales Sales Sales Returns And Allowances Less : Normal Shortages Employee Discounts Ending Inventory at Retail Ending inventory at Retail Ratio: Cost to Retail Percentage Ending inventory at lower of cost or market Cost of Goods Sold