Comprehensive Problem 2 Part 5: Optional work sheet Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data. a. Inventory on May 31 $570,000 b. Insurance expired during the year 12,000 c. Store supplies on hand on May 31 4,000 d. Depreciation for the current year 14,000 e. Accrued salaries on May 31: Sales salaries $7,000 Office salaries 6,600 13,600 1. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold If an amount box does not require an entry, leave it blank. Palisade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 2016 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Unadjusted Trial Balance Debit Credit Account Title Cash Accounts Receivable Comprehensive Problem 2 Part 5: Optional work sheet Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data. a. Inventory on May 31 $570,000 b. Insurance expired during the year 12,000 c. Store supplies on hand on May 31 4,000 d. Depreciation for the current year 14,000 e. Accrued salaries on May 31: Sales salaries $7,000 Office salaries 6,600 13,600 1. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold If an amount box does not require an entry, leave it blank. Palisade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 2016 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Unadjusted Trial Balance Debit Credit Account Title Cash Accounts Receivable