In the attached I need help identifying the following (see yellow highlights in attachment).

1. In the budget cash section I need the receivablesfor Q1 - Q4

2. In the budget cash section I need the Payablesfor Q1 - Q4

3. Income statement updated

Life Jacket Sales unit sales Selling Price (Unit) Recievables 1st qtr 2nd qtr 3rd qtr 4th qtr Q1 10,000 $16 $160,000 Q2 12,000 $16 $192,000 Q3 25,000 $16 $400,000 $160,000 $192,000 $400,000 $80,000 $112,000 $48,000 134,400 $112,000 $182,400 Purchases Jacket to be Certified plus: desired ending inventory total jackets less: beginning inventory total jackets needed cost per jacket total cost of jacket purchase Q1 10,000 3,000 13,000 0 13,000 $10 $130,000 Q2 12,000 6,250 18,250 3,000 15,250 $10 $152,500 Q3 25,000 1,250 26,250 6,250 20,000 $10 $200,000 Payables 1st qtr 2nd qtr 3rd qtr 4th qtr $130,000 $152,500 $200,000 $82,500 52,000 78,000 61,000 $52,000 $139,000 Q1 10,000 0.12 1,200 $12 $14,400 Q2 12,000 0.12 1,440 $12 $17,280 Q3 25,000 0.12 3,000 $12 $36,000 Q1 Q2 Q3 Labor units to be produced labor hours per / unit total labor hours cost per hour total cost S&A Sales commissions Fixed Costs Advertising Rent Sales Salaries Office Salaries Depreciation Property Taxes and Insurance Total Fixed costs Total S&A Expenses $16,000 $19,200 $40,000 1,300 750 1,800 1,800 75 95 5,820 $21,820 1,300 750 1,800 1,800 75 95 5,820 $25,020 1,300 750 1,800 1,800 75 95 5,820 $45,820 MOH Q1 Variable Expenses Ink Maintenance Utilities Graphics Design Total variable Fixed Expenses Rent Maintenance Utilities Grapics Design Property taxes and insurance Depreciation Total Fixed Total MOH direct labor hours Q2 Q3 $6,000 264 400 800 7,464 $7,500 330 500 1,000 9,330 $15,000 660 1,000 2,000 18,660 2,250 4,950 3,000 1,500 560 690 12,950 $20,414 2,250 4,950 3,000 1,500 560 690 12,950 $22,280 2,250 4,950 3,000 1,500 560 690 12,950 $31,610 1,200 1,440 3,000 $0 Q2 ($45,309) Q3 ($118,564) $0 ($45,309) ($118,564) 14,400 20,414 21,820 8,675 17,280 22,280 25,020 8,675 36,000 31,610 45,820 Budget Cash Q1 Beg cash balance add: Recieviables - collections from customers Total available cash Less: Disbursements Payables - Payments for jacket purchases Labor MOH S&A Equipment purchases Total Disbursements Excess(deficiency) Financing Borowings Ending Cash Balance 65,309 (65,309) 73,255 (118,564) 113,430 (231,994) 20,000 ($45,309) ($118,564) ($231,994) Income Statement Sales COGS Gross Profit S&A expenses Income from operations Interest Expense Income before income taxes Income taxes Net Income ***Note - COGS - Use cost of labor, MOH & cost of L 0 0 1,600 -1,600 -320 -$1,280 Q4 5,000 $16 $80,000 57,600 280,000 $337,600 Q4 5,000 4,500 9,500 1,250 8,250 $10 $82,500 91,500 80,000 120,000 56,000 $176,000 Total Year 52,000 4,500 56,500 0 56,500 $10 $565,000 $171,500 120,000 33,000 $153,000 5,000 0.12 600 $12 $7,200 Total Year 52,000 0.12 6,240 $12 $74,880 Q4 Q4 Total Year 52,000 $16 $832,000 Total Year $8,000 $83,200 1,300 750 1,800 1,800 75 95 5,820 $13,820 5,200 3,000 7,200 7,200 300 380 23,280 $106,480 Q4 Total Year $4,000 175 350 750 5,275 $32,500 1,429 2,250 4,550 40,729 2,250 4,950 3,000 1,500 560 690 12,950 $18,225 9,000 19,800 12,000 6,000 2,240 2,760 51,800 $92,529 600 6,240 $14.83 Q4 ($231,994) ($231,994) 7,200 18,225 5,820 0.8 0.035 0.07 0.15 31,245 (263,239) ($263,239) e cost of labor, MOH & cost of Life jackets