Using Solver (trouble with constraints)

[Sarge12]

I am having trouble setting up the constraints within Excel Solver, I am pretty green at using Solver with very limited knowledge other than a couple of YouTube videos showing the basics. Here the problem:

There is a news channel that is trying to fit 4 segments within 20 mins with the lowest cost.

Costs:
Local news cost $300 per min
National news $200 per min
Weather $100 per min
Sports $100 per min

Constraints:
At least 15% of the time total time must go to local news
At least 50% total time must be for both local and National news
Weather must be less than or equal to time spent on sports
Weather must be at least 20% of the available time
Sports must be no longer than the total time of local and national news

Book3 (version 1).xlsb
	A	B	C	D	E	F
1	Available time	20
2
3
4	Broadcast	Local news	National news	Weather	Sports	Total
5	Percentages	0%	0%	0%	0%	0%
6	total time mins	7.00	3.00	4.00	10	24.00
7	Production cost	$300.00	$200.00	$100.00	$100.00
8	Total Production cost	$2,100.00	$600.00	$400.00	$1,000.00	$4,100.00
9
10
11
12						Sum of national and local
13						10.00
Question 31

Cell Formulas
Range	Formula
F5:F6,F8	F5	=SUM(B5:E5)
B8:E8	B8	=B7*B6
F13	F13	=SUM(B6:C6)

Named Ranges
Name	Refers To	Cells
'Question 31 '!solver_lhs1	='Question 31 '!$B$6	F6, F13, B8
'Question 31 '!solver_lhs2	='Question 31 '!$D$6	F6, D8
'Question 31 '!solver_lhs3	='Question 31 '!$D$6	F6, D8
'Question 31 '!solver_lhs4	='Question 31 '!$E$6	F6, E8
'Question 31 '!solver_rhs2	='Question 31 '!$E$6	F6, E8