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

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.

Using the result of your calculations in the “Financial Analysis” sheet, build a scenario in which you are able to save only $1,200 on a monthly basis. What should be an interest rate so that you achieve your goal in time?  Report your answer as the percentage with 2 (two) decimals and no % sign, i.e., if it is 10%, report 10. 

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.

Name your working file as ‘Exam I Excel Working file_ChangeYourNameLastname.xlsx’ and submit the proof of your work here.  Failure to submit the file with proof of your work will result in a grade reduction, even if you submit all correct answers.

What is the total dollar value of discounts given by the firm? Report your answer as a number with two decimal points, e.g., 9864.88.

Calculate your monthly savings.  Report your answer as the real number (positive or negative) with up to 2 digits after the dot.  Note that since it is a transfer from your account, the number will be negative.

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 extracting data from various sources, transforming it into a usable format, and loading it into a database or data warehouse for analysis?

A tech company named “CodeLink” offers a platform that connects freelance software developers with companies looking to hire them for short-term projects. CodeLink facilitates the entire process, from job postings to payment handling, and charges a commission for every successful transaction between developers and companies. What type of business model is CodeLink using in this scenario?