A software-support division of Blain Information Services has eight projects that can be performed. Each project requires different amounts of development time and testing time. In the coming planning period, 1,150 hours of development time and 900 hours of testing time are available, based on the skill mix of the staff. The internal transfer price (revenue to the support division) and the times required for each project are shown in the table. Which projects should be selected to maximize revenue?

Project	Development time	Testing Time	Transfer Price
1	80	67	$23520
2	248	208	$72912
3	41	180	$62054
4	10	92	$32340
5	240	202	$70560
6	195	164	$57232
7	269	226	$19184
8	110	92	$32340

	Billables/hr	Minimum Hours	Maximum Hours
Business Consulting	$200.00	30	45
Criminal Work	$150.00	20	100
Nonprofit Consulting	$100.00	35	70

	Billables/Client	Minimum Cases	Maximum Cases	Hours/Case	Hours Worked per Month
Wills/Trust	53,000	2.00	6.00	17	200.00

Please show in excel