PLEASE SHOW IN EXCEL STEP BY STEP USING SOLVER$****$ 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,050$ hours of

development time and $850$ 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?

Select all that apply.

A$.$ Project $1$

B$.$ Project $6$

C$.$ Project $4$

D$.$ Project $5$

E$.$ Project $8$

F$.$ Project $3$

G$.$ Project $7$

H$.$ Project $2$