Question

7. The Dean of Hagan School of Business must plan the school’s course offerings for the spring semester. Student demands make it necessary to offer at least 30 undergraduate and 20 graduate courses in the semester. Faculty contracts also dictate that at least 60 courses be offered in total. Each undergraduate course taught costs the college an average of $2,500 in faculty wages, while each graduate course costs $3,000. How many undergraduate and graduate courses should be taught in the spring so that the total faculty salaries are kept to a minimum?

Answer 1

Answer:

We have to minimize the total faculty salaries

This is possible whenever change the variable cells that means changing the graduate and undergraduate couirses.

Let us consider constraints C1,C2,and C3

Where,

C1 = Number of undergraduates courses = 30

C2 = Number of graduate courses = 20

C3 = Total number of courses = 60

Consider total undergraduate course = 40

Average faculty wages for undergraduates = 2500

Average faculty wages for graduate = 3000

Total faculty salaries = (No.of undergraduate course*average faculty wages) + (No.of graduate courses*Average faculty wages)

Total faculty salaries = (40*2500) + (20*3000) = 160,000

By using excel,

	A	B	C	D
1
2		STREAM	NUMBER OF COURSES	COST
3		Undergraduate	40	2500
4		Graduate	20	3000
5		Total	60
6
7		Total faculty salaries	160,000

Cosider C7 as Total faculty salaries

Total faculty salaries (C7) = SUMPRODUCT(C3;C4 , D3;D4)