**** Solve using Excel Solver**** Ina works in a juice firm and has to develop the production plan for the lemon and the

[answerhappygod]

Solve Using Excel Solver Ina Works In A Juice Firm And Has To Develop The Production Plan For The Lemon And The 1 (449.64 KiB) Viewed 39 times

**** Solve using Excel Solver**** Ina works in a juice firm and has to develop the production plan for the lemon and the orange juice concentrates. The fruits (lemon and orange) that she needs to make the juice are not the bottleneck but Ina is concerned about the other main ingredients that go into making the juice: a water-based solution, sugar, and a vitamin mix. Checking with the ERP system tells her that she has 9.5 metric tons of the water solution, 2.99 metric tons of sugar, and 1940 kg of vitamin mix. The recipe tells her to use 46 kg of water solution to make a metric ton of lemon drink and 78 kg of water solution to make a metric ton of orange drink. For the lemon drink she also needs 18 kg of sugar and 16 kg of vitamin mix. The orange drink needs 14 kg of sugar and 7 kg of vitamin mix. From the sales department, Ina knows that the lemon soft drink sells at 55 SEK/ton and the orange drink sells at 68 SEK/ton. (SEK = Swedish krona). How much lemon drink should Ina produce to maximize revenue? Give your answer in metric ton and round to two decimal places. How much orange drink should Ina produce to maximize revenue? Give your answer in metric ton and round to two decimal places. How much revenue can Ina generate with the optimal production plan? Round your answer to one decimal place and do not put any currency symbols in the answer field.