Jim's Camera shop sells two high$-$end cameras, the Sky Eagle and Horizon. The demand for these two cameras are as follows $($DS $=$ demand for the Sky Eagle, Ps is the selling price of the Sky Eagle, DH is the demand for the Horizon and PH is the selling price of the Horizon$)$:

Ds $=220-0\mathrm{.}5$ Ps $+0\mathrm{.}15$ PH

DH $=275+0\mathrm{.}2$ Ps $-0\mathrm{.}52$ PH

The store wishes to determine the selling price that maximizes revenue for these two products. Select the revenue function for these two models. Choose the correct answer below.

$($iii$)$ Ps Ds $+$ PH DH $=$ Ps$(220-0\mathrm{.}5$ Ps $+0\mathrm{.}15$ PH$)+$ PH$(275+0\mathrm{.}2$ Ps $-0\mathrm{.}52$ PH$)$

Minimize ${\displaystyle \underset{j=1}{\overset{N}{}}}[C_j{D}_j+\frac{S_j{D}_j}{Q_j}+i{C}_j\frac{Q_j}{2}]$

$s.t{\displaystyle \underset{j=1}{\overset{N}{}}}{w}_j{Q}_{j}W$

$,Q_{j}0,j=1,2,$dotsN

In the objective function, the first term is the annual cost of goods, the second is the annual ordering cast $,$ is the number of orders$),$ and the last term is the annual inventory holding cost $(Q\frac{j}{2}$ is the average amount of

inventory$).$

Set up a spreadsheet model for the following data:

$W=5,000$

$i=0\mathrm{.}2$

Solve the problem using Excel Solver. Hint: You will need to start with decision variable values that are greater than o for Solver to find a solution.

If required, round your answers to two decimal places.

Optimal Solution:

If required, round your answer to the nearest dollar. Do not round intermediate calculations.

Total cost $=$$