eco last homework

Sheet1

Linear equations using SOLVER
1	Profit, Y = 60X-2400
	X, Sales	Profit, Y
	0	-2400
	10
	20
	30
	40
	50
	60
	70
	80
	90
	100
	120
	140
	150
	A. The Profit equation is Y = 60X-2400. Graph this equation, insert a trendline, and label completely.
	B. Use SOLVER to find the number of sales, X, in order to earn $575 in profit.
	C. Use SOLVER to find the number of sales, X in order to earn $4500 in profit.
2	Y=30,000-400X
	X	Y
	30
	35
	40
	45
	50
	55
	60
	65
	70
	73
	75
	A. The equation is Y = 30000-400X. Graph this equation, insert a trendline, and label completely.
	B. Use SOLVER to find X, when Y = $15,500.
	C. Use Solver to find X, when Y = $25,000.
	D. How much is the value of Y when X = 450?
3	Y = 50X-2500
	X, Sales	Y, Profit
	20
	30
	40
	50
	60
	70
	80
	90
	100
	110
	120
	130
	140
	150
	A. Create a scatter plot graph for the data above. Insert a trendline, and label completely.
	B. How many Sales, X must be sold in order for Profit, Y = $5000?
	C. How much profit is earned if sales, X = 240?
4	A person's weekly pay depends on the volume of sales. If she sells X units of goods, then her pay is Y = 5X+60 dollars.
	A. Create a scatter plot showing her pay equation.
	B. How many sales, X, does she have to sell to earn $1250?
	C. How many sales, X, does she need to sell to earn $1375?
	D. How much pay will she earn if she sells 200 units?
	PAY, Y =5X +60
	X, Sales	Y, PAY
5	A salesman earns $450 week plus 10% in commissions on sales. Let X denote sales and Y be Pay Amount.
	A. Create a scatter plot showing the Pay equation.
	B. How many sales, X, does she have to sell to earn $825?
	C. How many sales, X, does she need to sell to earn $1075?
	D. How much pay will she earn if she sells 125 units.
	Pay, Y = 450+0.1X
	X, SALES	Y, PAY
6	X,TIME	Y,COST
	0	0.93
	11	1.44
	A. Create a graph, and display the trendline, and the equation of the line.
	B. When did white bread cost $1.27 per pound?
	C. When did white bread cost $1.34 per pound?
	D. How much will white bread cost at X =15 years?
7	Maximize Profit
	Profit = 150+120X-3X^2
	where X is the number of dollars, in thousands, spent on advertising.
	How much should be spent on advertising to maximize profit?
	Use SOLVER.
	Graph the profit curve.

COST AND TIME

QUESTION 6

X,TIME

COST

0 11 0.93 1.44

YEAR AFTER 2000, X

COST