The warehouse fire on April 30 was a disaster! exclaimed Paul May, FRS Inc.s Chief production officer. We need to fill out the insurance forms as soon as possible to get back all our lost inventories. It seems the fire destroyed our accounting system as well as backup production documentation, he continued.

John Christensen, the companys controller walks into Mr. Mays office and shouts I was able to salvage some data. Have a look.

Johns data contained the following:

Beginning Inventories (April 1):

Direct Materials: $40,000

Finished Goods Inventory: $48,000

Work-in-Process: $64,000.

I also know that our gross profit percentage is 40% and that prime costs are 60% of manufacturing costs continued John.

That sounds about right replies Paul May. I was also told that overhead costs amount to 60% of conversion costs. Also, Id say that our ending work-in process inventories were about 20% of the monthly manufacturing costs.

After further discussions, it was revealed that Aprils sales were $1,000,000 and that direct labour costs and direct material purchase costs amounted to $400,000 and $550,000 respectively.

John, can you get back to me by tomorrow letting me know how much we can expect to get from our insurance company?

Required:

Using the Excel template provided, assume the role of John Christensen and estimate the ending inventory balances that should be recoverable from insurance.