Use the data shown below to answer the following question(s).
Malone Inc.has identified five potential new processes; however,the firm is constrained by its available budget and human resources.Each process is expected to generate a return (given by the net present value)but requires a fixed amount of cash and personnel.Because the resources are limited,all processes cannot be selected.Processes cannot be partially completed; thus,either the process must be undertaken completely or not at all.The data are given in the table below.If a process is selected,it generates the full value of the expected return and requires the full amount of cash and personnel shown in the table.Define X i = 1 if process i is selected,and 0 otherwise.
-Using Solver,identify the combination of the processes that are selected.
A)Process 2,Process 3,and Process 4
B)Process 3 and Process 4
C)Process 1,Process 2,and Process 5
D)Process 1,Process 4,and Process 5

Question

Use the data shown below to answer the following question(s).
Malone Inc.has identified five potential new processes; however,the firm is constrained by its available budget and human resources.Each process is expected to generate a return (given by the net present value)but requires a fixed amount of cash and personnel.Because the resources are limited,all processes cannot be selected.Processes cannot be partially completed; thus,either the process must be undertaken completely or not at all.The data are given in the table below.If a process is selected,it generates the full value of the expected return and requires the full amount of cash and personnel shown in the table.Define X i = 1 if process i is selected,and 0 otherwise. 
-Using Solver,identify the combination of the processes that are selected.
A)Process 2,Process 3,and Process 4 
B)Process 3 and Process 4 
C)Process 1,Process 2,and Process 5 
D)Process 1,Process 4,and Process 5

Quizplus · Accepted Answer

Solver is a Microsoft Excel add-in program you can use for what-if analysis. It finds an optimal value for a formula in one cell—called the objective cell—subject to constraints, or limits, on the values of other formula cells on a worksheet. Without specific details about the objective function, constraints, and the processes involved, it's impossible to determine the correct combination of processes. However, based on the question's structure, it seems like option C is presented as the correct answer, but remember, in real scenarios, Solver's output depends on the specific problem setup including the objective function and constraints.

Use the Data Shown Below to Answer the Following Question(s)