Maximum turnover from linear sales and cost functions

[Jesper Greve]

Hi folkes.

I have a liniear function for sales (Q = 2000- Price/10.) It shows my sales quantity at a given price.

I also have a liniear funktion for cost that are based on a calculation 7648Q +224000 and i want to finde my maximum turnover (income-expences) from at using the tabel function, how can i do that ?

My tabel looks like this and my price funktion goes from 0 - 20000. I would like to find out what price would give me the best turnover.

Price Sales per. Quarter Turnover
0 kr -
0 1900 kr (50.748.800,00)
1000 1800 kr (40.889.600,00)
2000 1700 kr (31.830.400,00)
3000 1600 kr (23.571.200,00)
4000 1500 kr (16.112.000,00)
5000 1400 kr (9.452.800,00)
6000 1300 kr (3.593.600,00)
7000 1200 kr 1.465.600,00
8000 1100 kr 5.724.800,00
9000 1000 kr 9.184.000,00
10000 900 kr 11.843.200,00
11000 800 kr 13.702.400,00
12000 700 kr 14.761.600,00
13000 600 kr 15.020.800,00
14000 500 kr 14.480.000,00
15000 400 kr 13.139.200,00
16000 300 kr 10.998.400,00
17000 200 kr 8.057.600,00
18000 100 kr 4.316.800,00
19000 0 kr (224.000,00)

How can i do this, any thoughts are welcome.

Best regards

Jesper

 

[Juan Pablo González]

Is the third column in your example the turnover that you're looking for ? if so, the answer that you're looking for is Price = 13000 ?

 

[Jesper Greve]

Well yes, and then no. I would like to be able to get the answer without knowing the result in advance, and perhaps without creating the list. Can excel do a simulation based on the funktions?

Best regards

Jesper

 

[Mark W.]

Here are the results of a Solver model without any constraints...

Book1
	A	B	C	D	E	F	G	H
1	Price	Quantity	Cost	Sales	Income-Expenses
2	13824,00	617,60	4947404,82	8537702,42	3590297,60
3
4
5
Sheet2