USING EXCEL - AND THE SOLVER FUNCTION

Your employer, yPlum Corporation is manufacturing two types of products: Mirabelle smartphone, and Blackamber laptop. The company has a well-established position on the phone market, but has recently decided to conquer the PC market with its new product - Blackamber workstation. YPlum has very ambitious plans and is determined to become a significant player in the computer market, while maintaining its strong position in the smartphone area. Your task is to find a product mix that would maximize yPlum's profits in the next month. Since you always had interest in accounting and financial analysis, you have quickly identified the relevant information. On average, it costs the company $250 to manufacture the Mirabelle phone, and $700 to produce the Blackamber. The products are being sold for $650 and $1200 respectively. After exchanging emails with your supply chain group, you have established that the phone requires 50 days of labor, while the laptop - 70 days. The computers take longer to produce because the customers can build their own setups. Your total manufacturing capacity is 160 million working days. Your monthly materials budget is set at $1,200 million. Finally, the company's executives expect that yPlum will sell at least 1 million phones and 0.5 million computers next month. Find the optimal mix of product quantity that would maximize yPlum profits.