Wally's Window Emporium is a leading producer and provider of residential windows across the United States. They just completed their second year of operations and compiled the following data: Management feels overwhelmed when they look at the data in this format, and management does not feel comfortable making decisions for the upcoming year until the data is easier to understand. The analytics team needs to present this information in a more user-friendly fashion so management can make data-informed decisions for the coming year. With this information in mind, please answer the following questions.
a. What are the average sales, average cost of goods sold (COGS), and average expenses for each region across both years?
b. Which region had the largest increase in gross profit from Year 1 to Year 2, and which region showed the largest increase in net income from Year 1 to Year 2?
c. What kind of graph would be the most useful to display the division of sales revenues for the South region in Year 1?

Question

Wally's Window Emporium is a leading producer and provider of residential windows across the United States. They just completed their second year of operations and compiled the following data:  Management feels overwhelmed when they look at the data in this format, and management does not feel comfortable making decisions for the upcoming year until the data is easier to understand. The analytics team needs to present this information in a more user-friendly fashion so management can make data-informed decisions for the coming year. With this information in mind, please answer the following questions. 
a. What are the average sales, average cost of goods sold (COGS), and average expenses for each region across both years?
b. Which region had the largest increase in gross profit from Year 1 to Year 2, and which region showed the largest increase in net income from Year 1 to Year 2?
c. What kind of graph would be the most useful to display the division of sales revenues for the South region in Year 1?

Quizplus · Accepted Answer

The Answer of Wally's Window Emporium is a leading producer and provider of residential windows across the United States. They just completed their second year of operations and compiled the following data:  Management feels overwhelmed when they look at the data in this format, and management does not feel comfortable making decisions for the upcoming year until the data is easier to understand. The analytics team needs to present this information in a more user-friendly fashion so management can make data-informed decisions for the coming year. With this information in mind, please answer the following questions. 
a. What are the average sales, average cost of goods sold (COGS), and average expenses for each region across both years?
b. Which region had the largest increase in gross profit from Year 1 to Year 2, and which region showed the largest increase in net income from Year 1 to Year 2?
c. What kind of graph would be the most useful to display the division of sales revenues for the South region in Year 1?

Wally's Window Emporium Is a Leading Producer and Provider of Residential