Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $59,000. The following information for the month of November was available from company records: Purchases Freight-in Sales Sales returns Purchases returns $115,000 3,500 205,000 10,000 6,500 In addition, the controller is aware of $10,500 of inventory that was stolen during November from one of the company's warehouses. Required: 1. Calculate the estimated inventory at the end of November, assuming a gross profit ratio of 40%. 2. Calculate the estimated inventory at the end of November, assuming a markup on cost of 60%. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the estimated inventory at the end of November, assuming a markup on cost of 60%. (Do not round intermediate calculations.) $ 59,000 108,500 3,500 171,000 Beginning inventory Plus: Net purchases Freight-in Cost of goods available for sale Less: Cost of goods sold: Net sales Less: Estimated gross profit Estimated cost of goods sold Estimated cost of inventory before theft Less: Stolen inventory Estimated ending inventory $ 195,000 97,500 X 97,500 73,500 10,500 63,000 $ *Red text indicates no response was expected in a cell or a formula-based calculation incorrect; no points deducted