According to Bowen’s reaction series,

Which of the following statements about Mount Krakatau is false?

How many items did the salesperson with the maximum discount sell in total? Report your answer as a number without decimal points.

The optimal number of Packages A is and of Packages B is . Meeting these sales numbers will generate a maximum profit of US dollars.

What is the salesperson’s name who gave the highest percentage discount?  Report your answer as text (name) as it appears in the Excel document.

What is the total actual sales in USD in North America (NA) according to the data in the file? Report your answer as a number with two decimal points, e.g., 1004.04.

I acknowledge that: I did download the Excel working file. Exam I Excel Working file_ChangeYourNameLastname.xlsx  I will not discuss the contents of the exam with anyone until the entire exam period is over and the exam and results have been posted. This includes, but is not limited to, posts to websites, personal discussions with anyone, tweets, texts, e-mails, etc. You may use Excel Help to work on solutions. I further understand that breaking these rules is an Honor Code violation that will result in sanctions that may be applied by the Office of Academic Integrity, up to and including permanent expulsion from the University.  Select True if you agree with the statements above; select False otherwise. (0 points) Unless otherwise selected, the True option will be considered by default.

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.

What term best describes the process of transforming raw data into meaningful insights using tools and techniques for analysis and reporting that assist organizations in making strategic, data-driven decisions?  

What term best describes a plan for the firm to achieve a set of market performance goals, e.g., increase market share or objectives?