Please help with part E, the sensitivity analysis table. When using the What If analysis data table function in Excel with the table, I cannot get it to work properly. It repeats the same number for each row.

Collections during month of sale	10%
Collections during 1st month after sale	75%
Collections during 2nd month after sale	15%
General and administrative salaries	$36,000
Lease payments	$12,000
Depreciation charges	$48,000
Miscellaneous expenses	$3,600
Income tax payments (Sep & Dec)	$71,000
New design studio payment (Oct)	$190,000
Cash on hand on July 1	$124,000
Minimum cash balance	$85,000
Sales adjustment factor	0%
	May	June	July	August	September	October	November	December	January
Sales	$180,000	$180,000	$360,000	$540,000	$720,000	$360,000	$360,000	$90,000	$180,000
Costs of labor and raw materials	$90,000	$90,000	$108,000	$828,000	$306,000	$216,000	$162,000	$90,000
a. Preparing a monthly cash budget for the last 6 months of 2021
The Cash Budget
	May	June	July	August	September	October	November	December
Collections and purchases worksheet
Sales (gross)	$180,000	$180,000	$360,000	$540,000	$720,000	$360,000	$360,000	$90,000
Collections
During month of sale			$36,000	$54,000	$72,000	$36,000	$36,000	$9,000
During 1st month after sale			135,000	270,000	405,000	540,000	270,000	270,000
During 2nd month after sale			27,000	27,000	54,000	81,000	108,000	54,000
Total collections			$198,000	$351,000	$531,000	$657,000	$414,000	$333,000
Purchases
Labor and raw materials	$90,000	$90,000	$108,000	$828,000	$306,000	$216,000	$162,000	$90,000
Payments for labor and raw materials			$90,000	$108,000	$828,000	$306,000	$216,000	$162,000
Cash gain or loss for month
Collections			$198,000	$351,000	$531,000	$657,000	$414,000	$333,000
Payments for labor and raw materials			$90,000	$108,000	$828,000	$306,000	$216,000	$162,000
General and administrative salaries			36,000	36,000	36,000	36,000	36,000	36,000
Lease payments			12,000	12,000	12,000	12,000	12,000	12,000
Miscellaneous expenses			3,600	3,600	3,600	3,600	3,600	3,600
Income tax payments			0	0	71,000	0	0	71,000
Design studio payment			0	0	0	190,000	0	0
Total payments			$141,600	$159,600	$950,600	$547,600	$267,600	$284,600
Net cash gain (loss) during month			$56,400	$191,400	-$419,600	$109,400	$146,400	$48,400
Loan requirement or cash surplus
Cash at start of month			$124,000	$180,400	$371,800	-$47,800	$61,600	$208,000
Cumulative cash			$180,400	$371,800	-$47,800	$61,600	$208,000	$256,400
Target cash balance			85,000	85,000	85,000	85,000	85,000	85,000
Cumulative surplus cash or loans outstanding to maintain the target cash balance			$95,400	$286,800	-$132,800	-$23,400	$123,000	$171,400
b. Preparing monthly estimates of the required financing or excess funds
			July	August	September	October	November	December
Required financing or excess funds			$95,400	$286,800	-$132,800	-$23,400	$123,000	$171,400
e. Doing a sensitivity analysis that shows the effects of the change in sales and the collection terms
Maximum loan required	-132800
Change in sales (B14)	Maximum loan required
	% Collections in 2nd month (B5)
	0%	15%	30%	45%	60%	75%	90%
-100%
-75%
-50%
-25%
0%
25%
50%
75%
100%