Formula to calculate sales price

[ASBM24]

Hey guys, I'm sure this is an easy formula, but for some reason today I cannot seem to figure it out. I'm trying to come up with either a table or formula that I can have on an Excel spreadsheet which will help me calculate a sales price. Here is my example:

I have some materials which costs me $1600 for 1600 sq ft. I want to mark it up by 130% which would put my base sales price at $2080. If a customer orders more material, I want it to add extra $0.30 per square foot. So for example, I know that if a customer orders 8000 sq ft, it should be 8000-1600 = 6400*$0.30 = $1920 + 2080 = $4000

I'm sure I'm making this too complicated, but any help would be appreciated. I've stared at this for way too long.

 

[Snakehips]

@ASBM24 Welcome
Does this help?

AutoTraining2.xlsm
	A	B	C	D	E	F
1	Base Sq Ft	Base Cost $	Base Markup %	Additional $/SsFt	Supply Sq Ft	Supply $
2	1600	1600	130%	0.3	8000	4000
3
Sheet6

Cell Formulas
Range	Formula
F2	F2	=((MIN(A2,E2)*B2/A2)*C2)+MAX(0,E2-A2)*D2

 

[ASBM24]

@ASBM24 Welcome
Does this help?

AutoTraining2.xlsm
	A	B	C	D	E	F
1	Base Sq Ft	Base Cost $	Base Markup %	Additional $/SsFt	Supply Sq Ft	Supply $
2	1600	1600	130%	0.3	8000	4000
3
Sheet6

Cell Formulas
Range	Formula
F2	F2	=((MIN(A2,E2)*B2/A2)*C2)+MAX(0,E2-A2)*D2

@Snakehips, yes thank you! I think this is what I am looking for. Much appreciated!