The Hornet Catering Company's trial balance prior to making adjusting entries at the end Problem 18 of 20X3 is as follows: CR Hornet Catering Company Trial Balance December 21, 20X3 DR $10,500 1,000 500 25,000 Cash Food Inventory Prepaid Insurance Equipment Accumulated Depr., Equipment Accounts Payable W. H. Hornet, Capital Catering Revenue Wages Food Expense Supplies Expense Utilities Insurance Expense Advertising Total $5,000 1,000 13,100 160,000 60,000 60,000 10,000 3,000 1,100 8,000 $179,100 $179,100 1. The actual food inventory, according to the physical count, is only $500. 2. The paid insurance coverage at the end of 20X3 extends through April 20X4. The aver- age insurance cost per month is $100. 3. Unpaid wages at the end of December, 20X3, total $1,000. 4. The unrecorded depreciation expense for the entire year equals $2,000. The following adjusting entries must be prepared: Required: Prepare a worksheet for the year ended December 31, 20x3