spreadsheet and influence chart question (Loan Calculator)

Sheet1

Simple Profit Model			DS 601			2/1/18		Demand		=Sheet1!$B$5
								Fixed_Cost		=Sheet1!$B$6
Inputs								Number_Leftover		=Sheet1!$B$15
Unit Price	$30							Number_Sold		=Sheet1!$B$14
Demand	1,000							Production		=Sheet1!$B$11
Fixed Cost	$10,000							Total_Cost		=Sheet1!$B$16
Variable Cost	$14							Total_Revenue		=Sheet1!$B$17
Salvage Value	$10							Unit_Price		=Sheet1!$B$4
								Variable_Cost		=Sheet1!$B$7
Decision Variable
Production	1,200				1-way Data Table
					Production	Profit	Total Cost
Calculated Quantities						$5,200	$26,800
Number Sold	1000		1000		700	$1,200	$19,800
Number Leftover	200		200		800	$2,800	$21,200
Total Cost	$26,800				900	$4,400	$22,600
Total Revenue	$32,000				1000	$6,000	$24,000
					1100	$5,600	$25,400
Output					1200	$5,200	$26,800
Total Profit	$5,200				1300	$4,800	$28,200
					1400	$4,400	$29,600
					1500	$4,000	$31,000
					1600	$3,600	$32,400
					1700	$3,200	$33,800
2-way Data Table
					Demand
	$5,200	700	800	900	1000	1100	1200	1300	1400	1500
	700	1200	1200	1200	1200	1200	1200	1200	1200	1200
	800	800	2800	2800	2800	2800	2800	2800	2800	2800
	900	400	2400	4400	4400	4400	4400	4400	4400	4400
Production	1000	0	2000	4000	6000	6000	6000	6000	6000	6000
	1100	-400	1600	3600	5600	7600	7600	7600	7600	7600
	1200	-800	1200	3200	5200	7200	9200	9200	9200	9200
	1300	-1200	800	2800	4800	6800	8800	10800	10800	10800
	1400	-1600	400	2400	4400	6400	8400	10400	12400	12400
	1500	-2000	0	2000	4000	6000	8000	10000	12000	14000

1-way data table graphed

700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1200 2800 4400 6000 5600 5200 4800 4400 4000 3600 3200

Production

Total Profit