Formulate and solve Problem B$\mathrm{.}8($Lifang Wu$)$ on p$.720$ of Heizer and Render $(12$th edition$)$ in Excel and run Solver on it$.$ You can check your answer against that in the back of the book to ensure you have it set up correctly.

Assume you are allowed to produce a fractional unit, so if your answer calls for $3\mathrm{.}5$ units of something, you could make that.

Your dollar figures change so that A nets you $$900$ per unit and B nets you $$1500$ per unit. The constraints remain the same.

What is your new optimal profit? Enter your answer as a number without any commas. For example, if you want to enter $12,345\mathrm{.}67,$ type in $12345\mathrm{.}67.$ $

How many of the Alpha $1$ will you now produce?

How many of the Beta $2$ will you now produce?