Lab 4

.docx

School

University Of Georgia *

*We aren’t endorsed by this school

Course

1001

Subject

Chemistry

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by MegaHummingbirdPerson304

Report
L AB 4- S YEDA J AWERIA H ASSAN Lab 4.1: Screenshot 4-1MA: Screenshot 4-1MB: Objective Answers: OQ1-Imperial Stout is the top-selling product based on total revenue. OQ2-Imperial Stout generated a total revenue of $370,440. OQ3- Texas had the highest total revenue overall. OQ4-Texas generated a total revenue of $294,440.
Analysis Answers: AQ1 Ans: The size and colour of the data points helps in distinguishing the overall revenue generated by each state. AQ2 Ans: The sales revenue by product can be depicted using a pie chart. AQ3 Ans: We can determine the level of sales generated by Imperial Stout in each state. This will help managers to increase the sales of their highest selling product. Lab 4-1 Part 2: Screenshot 4-1MC: Screenshot 4-1MD: Objective Answers: OQ1. The total sales volume for January 2020 is 2295 units. OQ2. Slainte exceeded its sales volume target by 2380 (more than 10000) units by selling 12380 units in total
OQ3. In February 2020, Imperial Stout, IPA and Stout were sold over 300 units. OQ4. Slainte missed its sales goal by 1814 units (by selling 8186 units so far). Analysis Answers: AQ1. The sales revenue generated by each product indicates its corresponding sales volume. AQ2. We can analyse the desired sales volume target with the sales volume by month data. AQ3. Pie chart can be used to represent the sales revenue by product data. Lab 4.2 Screenshot 4.2-MA: Screenshot 4.2-MB: Objective answers: OQ1. Beverage Distributors is the largest customer in Iowa. OQ2. 14 customers reside in Texas. OQ3. Pale Ale has the most uncertain forecast. OQ4. The trend in the forecast for sales overall relative to March is $78,225.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help