Question: Need help setting this up in microsoft excel using solver! Two types of ISR pods are available. Performance between the pods differs due to resolution

Need help setting this up in microsoft excel using solver!

Two types of ISR pods are available. Performance between the pods differs due to resolution and field of view. When installed on the same air platform, Pod A can scan 350 nm 2 /hr and Pod B can scan 450 nm 2 /hr. Each pod's imagery must be processed by a satellite, router relay, and GIG (Global Information Grid) entry point station before use. Bandwidth demands and availability are as follows:

Need help setting this up in microsoft excel using solver! Two types

Due to contracting commitments, a minimum of 20% of the pods must be type A and 30% of the pods must be type B. Recommended proposal: "Pod B is has better scan rate, so change the contracts and order zero type A and 100% type B. Set up the problem as a Linear Programming problem that does not have integer constraints for the numbers of Pods. Identify key parts of the model (objective function, decision variables, constraints).

\begin{tabular}{|l|l|l|l|} \hline Process & Pod A [GB/pod/hr] & Pod B [GB/pod/hr] & Total GB/hr available \\ \hline Satellite & 1.5 & 2.0 & 100 \\ \hline Router Relay & 3.0 & 4.5 & 200 \\ \hline GIG Entry Sta. & 2.5 & 1.5 & 150 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!