xxx Palm-West Products (C) The company's monthly operating expenses(organized by cost behavior)are provided in Exhibit 2. For simplicity, the company assumes that all operating expenses are paid in cash during the month incurred, with the exception of depreciation and insuranceexpense To simplify, assume no tax Unit Sales Forecasted Sales Volume July August September 12.700 Total 10.200 .956 2244 11.400 8,550 2,850 BASE 3,683 Sales Price BASE 225 372 221 365 PREMIUM 358 155 225 155 15s 225 Unit Cost BASE PREMIUM Variabie Sales commissions% of sales dollars) Shipping &handling(per unit sold) 5% of sales S15 per unit Fixed per month) 315,000 26,000 9,500 ,300 16,000 38,000 Wages and salaries Utilities Insurance expired Depreciation Ocher S&A Palm-West Products actual Adiusted Trial Balanec (incompletc), as of July1, is provided in Exhibit 3. July Debit Credit 40,000 2,817,494 1.474,875 15,500 Accounts Receivable Inventory Prepaid Insurance Fixed Assets, net of depreciation Accounts Payable Line-of-Credit Dividends Payable Capital Stock Retained Earnings Sales Revenue Cost of Goods Sold Depreciation Expensc Insurance Expense Rent Expense Sales Commissions Shipping & Handling Utilities Expense Wagcs and Salaries Expensc Other S&A Expenses Totals 1,464,000 960,053 234,297 1,750,000 2,673,975 Exhikt 3, PW Adusted Trial alinee 1.2 Requirements fin an Excei spreadsheet) . Complete the Unadjusted Trial Balance in Erhibit 3 for 2. Prepare closing entries for Jaly Ju! 3. Prepare a Worksheet for July witk the foliowing coiunns a. Adjusted Trial Balance b. Incoune Statemen e. Balance Shee d. Closing Entries e. Post-Closing Trial Balance xxx Palm-West Products (C) The company's monthly operating expenses(organized by cost behavior)are provided in Exhibit 2. For simplicity, the company assumes that all operating expenses are paid in cash during the month incurred, with the exception of depreciation and insuranceexpense To simplify, assume no tax Unit Sales Forecasted Sales Volume July August September 12.700 Total 10.200 .956 2244 11.400 8,550 2,850 BASE 3,683 Sales Price BASE 225 372 221 365 PREMIUM 358 155 225 155 15s 225 Unit Cost BASE PREMIUM Variabie Sales commissions% of sales dollars) Shipping &handling(per unit sold) 5% of sales S15 per unit Fixed per month) 315,000 26,000 9,500 ,300 16,000 38,000 Wages and salaries Utilities Insurance expired Depreciation Ocher S&A Palm-West Products actual Adiusted Trial Balanec (incompletc), as of July1, is provided in Exhibit 3. July Debit Credit 40,000 2,817,494 1.474,875 15,500 Accounts Receivable Inventory Prepaid Insurance Fixed Assets, net of depreciation Accounts Payable Line-of-Credit Dividends Payable Capital Stock Retained Earnings Sales Revenue Cost of Goods Sold Depreciation Expensc Insurance Expense Rent Expense Sales Commissions Shipping & Handling Utilities Expense Wagcs and Salaries Expensc Other S&A Expenses Totals 1,464,000 960,053 234,297 1,750,000 2,673,975 Exhikt 3, PW Adusted Trial alinee 1.2 Requirements fin an Excei spreadsheet) . Complete the Unadjusted Trial Balance in Erhibit 3 for 2. Prepare closing entries for Jaly Ju! 3. Prepare a Worksheet for July witk the foliowing coiunns a. Adjusted Trial Balance b. Incoune Statemen e. Balance Shee d. Closing Entries e. Post-Closing Trial Balance
