Excel Section 3 For the next question, read the following sc…
Excel Section 3 For the next question, read the following scenario and make the respective calculations in Excel using Solver. A tech company called “CloudOptima” provides cloud storage solutions for both small businesses and large enterprises. The company has two different subscription packages: Package A: Designed for small businesses, offering a basic set of cloud storage and data management features. Each subscription generates $250 in revenue per month. Package A incurs an operational cost of $200 per subscription. Package B: Designed for large enterprises, offering advanced features such as enhanced security, data analytics, and unlimited storage. Each subscription generates $500 in revenue per month. Package B incurs an operational cost of $300 per subscription. CloudOptima has a limited server capacity that can support up to 1,200 total subscriptions per month. Additionally, the company has budgeted $400,000 per month for operational costs, which include maintenance, customer support, and server management. In addition, the company is bind by the government contract to sell at least 100 of Packages A and no more than 800 of Packages B. Objective:On a spreadsheet, ‘Production Analysis,’ determine the optimal number of Package A and Package B subscriptions CloudOptima should sell to maximize profit, given the server capacity and operational budget constraints. Note: Total profit is the total revenue minus the total cost.