all i really need is question e

Cash Budgeting 10% 75% 15% Collections during month of sale Collections during 1st month after sale Collections during 2nd month after sale General and administrative salaries Lease payments Depreciation charges Miscellaneous expenses $33,000 $11,000 $44,000 $4,950 Income tax payments (Sep & Dec) $66,000 $180,000 New design studio payment (Oct) Cash on hand on July 1 $124,000 Minimum cash balance $95,000 Sales adjustment factor 0% Sales May $160,000 $80,000 $80,000 Costs of labor and raw materials a. Preparing a monthly cash budget for the last 6 months of 2021 The Cash Budget May June Collections and purchases worksheet Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections Purchases Labor and raw materials Payments for labor and raw materials Cash gain or loss for month Collections Payments for labor and raw materials General and administrative salaries Lease payments Miscellaneous expenses Income tax payments Design studio payment Total naumante June July $160,000 $320,000 August September $480,000 $640,000 October November December January $320,000 $320,000 $80,000 $160,000 $272,000 $192,000 $128,000 $80,000 October November December $112.000 $736,000 July August September Income tax payments Design studio payment Total payments Net cash gain (loss) during month Loan requirement or cash surplus Cash at start of month Cumulative cash Target cash balance Cumulative surplus cash or loans outstanding to maintain the target cash balance b. Preparing monthly estimates of the required financing or excess funds July August Required financing or excess funds e. Doing a sensitivity analysis that shows the effects of the change in sales and the collection terms Maximum loan required Maximum loan required Change in sales (B14) % Collections in 2nd month (B5) 30% 45% 60% 0% 15% -100% -75% -50% -25% 0% 25% 50% 75% 100% September October November December 75% 90% Cash Budgeting 10% 75% 15% Collections during month of sale Collections during 1st month after sale Collections during 2nd month after sale General and administrative salaries Lease payments Depreciation charges Miscellaneous expenses $33,000 $11,000 $44,000 $4,950 Income tax payments (Sep & Dec) $66,000 $180,000 New design studio payment (Oct) Cash on hand on July 1 $124,000 Minimum cash balance $95,000 Sales adjustment factor 0% Sales May $160,000 $80,000 $80,000 Costs of labor and raw materials a. Preparing a monthly cash budget for the last 6 months of 2021 The Cash Budget May June Collections and purchases worksheet Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections Purchases Labor and raw materials Payments for labor and raw materials Cash gain or loss for month Collections Payments for labor and raw materials General and administrative salaries Lease payments Miscellaneous expenses Income tax payments Design studio payment Total naumante June July $160,000 $320,000 August September $480,000 $640,000 October November December January $320,000 $320,000 $80,000 $160,000 $272,000 $192,000 $128,000 $80,000 October November December $112.000 $736,000 July August September Income tax payments Design studio payment Total payments Net cash gain (loss) during month Loan requirement or cash surplus Cash at start of month Cumulative cash Target cash balance Cumulative surplus cash or loans outstanding to maintain the target cash balance b. Preparing monthly estimates of the required financing or excess funds July August Required financing or excess funds e. Doing a sensitivity analysis that shows the effects of the change in sales and the collection terms Maximum loan required Maximum loan required Change in sales (B14) % Collections in 2nd month (B5) 30% 45% 60% 0% 15% -100% -75% -50% -25% 0% 25% 50% 75% 100% September October November December 75% 90%