prepare a schedule that estimates the amount of inventory (at cost) lost in the fire.

1) Kennebec Design Co. is a large retail furniture company that operates in two adjacent warehouses. One warehouse is a showroom, and the other is used to store merchandise. On the night of February 20, 20x5, a fire broke out in the storage warehouse and destroyed the merchandise stored there. Fortunately, the fire did not reach the showroom, so all the merchandise on display was saved. Although the company maintained a perpetual inventory system, its records were rather haphazard, and the last reliable phsical inventory had been taken on December 31, 20x4 In addition, there was no control of the flow of goods between the showroom and the warehouse. Thus, it was impossible to tell which goods should have been in either place. As a result, the insurance company required an independent estimate of the amount of loss. The insurance company examiners were satisfied when they received the following information Merchandise inventory, December 31, 20x4 Purchases, January 1 to February 20, 20x5 Purchase returns, January 1 to February 20, 20x5 Freight-in, January 1 to February 20, 20x5 Sales, January 1 to February 20, 20x5 Sales returns, January 1 to February 20, 20x5 Merchandise inventory in showroom on February 20, 20x5 Average gross margin $ 842,000 1,442,000 8,350 26,440 2,015,000 26,520 262,100 45% REQUIRED: Prepare a schedule that estimates the amount of inventory (at cost) lost in the fire