On February 19, 2018, Exploits Inc.'s (Exploits) entire inventory was stolen in a daring daylight robbery. The thieves held warehouse personnel at gunpoint while they methodically loaded trucks with the contents of the warehouse. There were no injuries.
Exploits is fully insured against theft and so must file a claim with its insurance company for the loss suffered. Because Exploits uses a periodic inventory control system, it doesn't know for certain the amount of inventory that was stolen. However, from your discussions with company personnel you have learned that Exploits has two categories of inventory. Category one inventory usually generates a gross margin percentage of 65 percent whereas the category two usually generates a gross margin percentage of 48 percent. Sales of category one since the company's year-end on October 31, 2017 were $610,000. Sales of category two over the same time period were about $595,000. During the period since the year-end, Exploits purchased $300,000 of category one inventory and $285,000 of category two inventory. The financial records show that on October 31, 2017 there was $325,000 of category one inventory and $525,000 of category two inventory on hand.
Prepare a report to Exploits' management that computes the amount of the loss that should be claimed from the insurance company as a result of the robbery. Explain any factors that management should be aware of that would change the amount of the claim.