accounting help

On September 22, 2016, a flood destroyed the entire merchandise inventory on hand in a warehouse owned by the Rocklin Sporting Goods Company. The following information is available from the records of the company's periodic inventory system Complete the below table to estimate the cost of inventory destroyed in the flood using the gross profit method