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

Question

Examlex · Accepted Answer

The Answer is a. Gross Profit Percentage:
North = 58.26%
East = 60.20%
South = 46.35%
West = 47.24%
Net Income Percentage:
North = 15.32%
East = 15.77%
South = 12.55%
West = 12.95%
To calculate the Gross Profit Percentage, you need to create new cells with each region's name. In the cell to the right of the cell North, use the following formula: (Sales - COGS)/Sales, or = (C2-C8)/C2, which returns an answer of 58.26%. Repeat this for each region, and this results in: East = 60.20%, South = 46.35%, and West = 47.24%.To calculate the Net Income Percentage, you need to create new cells with each region's name. In the cell to the right of the name for North, use the following formula: (Sales - COGS - Expenses)/Sales, or = (C2-C8-C14)/C2, which returns an answer of 15.32%. Repeat this for each region, and this results in: East = 15.77%, South = 12.55%, and West = 12.95%.
b. Largest Percentage Increase: For Sales, North at 4.42%, for Cost of Goods Sold, West at 6.17%, and for Expenses, North at 5.96%.To calculate increases or decreases in sales, use the cell next to each region's name in Column D. Use the following formula: (Year 2 Sales - Year 1 Sales)/Year 1 Sales or, (C2-B2)/B2, which returns an answer of 4.42%. Repeat this for each region and this results in: East = -2.25%, South = 2.79%, and West = 0.93%. North had the largest percentage increase in Sales.To calculate increases or decreases in COGS, use the cell next to each region's name in Column D. Use the following formula: (Year 2 COGS - Year 1 COGS)/Year 1 COGS, or (C8-B8)/B8, which returns an answer of 5.15%. Repeat this for each region and this results in: East = -6.80%, South = 6.17%, and West = 4.36%. So, West has the largest percentage increase in COGS.To calculate increases or decreases in Expenses, use the cell next to each region's name in Column D. Use the following formula: (Year 2 Expenses - Year 1 Expenses)/Year 1 Expenses, or (C14-B14)/B14, which returns an answer of 5.96%. Repeat this for each region and this results in: East = -4.75%, South = -5.75%, and West = -5.47%. So, North has the largest percentage increase in Expenses.
c. The best graph to display a comparison of net incomes for each region in Year 2 would be a bar chart. Bar charts are useful when comparing total values between groups. To create a bar chart, enter the name of each region vertically. In the cell to the right of each name, you will need to calculate net income for that region for Year 2. Use the following formula: (Sales - COGS - Expenses). Repeat this for each region. Once you have finished, select the name of each region along with its Net Income. Select Insert, then Chart, and then Bar. The resulting chart should look like this:

a. Gross Profit Percentage: North = 58.26% East = 60.20% South = 46.35% West = 47.24% Net Income Percentage: North = 15.32% East = 15.77% South = 12.55% West = 12.95% To calculate the Gross Profit Percentage, you need to create new cells with each region's name. In the cell to the right of the cell North, use the following formula: (Sales - COGS)/Sales, or = (C2-C8)/C2, which returns an answer of 58.26%. Repeat this for each region, and this results in: East = 60.20%, South = 46.35%, and West = 47.24%.To calculate the Net Income Percentage, you need to create new cells with each region's name. In the cell to the right of the name for North, use the following formula: (Sales - COGS - Expenses)/Sales, or = (C2-C8-C14)/C2, which returns an answer of 15.32%. Repeat this for each region, and this results in: East = 15.77%, South = 12.55%, and West = 12.95%. b. Largest Percentage Increase: For Sales, North at 4.42%, for Cost of Goods Sold, West at 6.17%, and for Expenses, North at 5.96%.To calculate increases or decreases in sales, use the cell next to each region's name in Column D. Use the following formula: (Year 2 Sales - Year 1 Sales)/Year 1 Sales or, (C2-B2)/B2, which returns an answer of 4.42%. Repeat this for each region and this results in: East = -2.25%, South = 2.79%, and West = 0.93%. North had the largest percentage increase in Sales.To calculate increases or decreases in COGS, use the cell next to each region's name in Column D. Use the following formula: (Year 2 COGS - Year 1 COGS)/Year 1 COGS, or (C8-B8)/B8, which returns an answer of 5.15%. Repeat this for each region and this results in: East = -6.80%, South = 6.17%, and West = 4.36%. So, West has the largest percentage increase in COGS.To calculate increases or decreases in Expenses, use the cell next to each region's name in Column D. Use the following formula: (Year 2 Expenses - Year 1 Expenses)/Year 1 Expenses, or (C14-B14)/B14, which returns an answer of 5.96%. Repeat this for each region and this results in: East = -4.75%, South = -5.75%, and West = -5.47%. So, North has the largest percentage increase in Expenses. c. The best graph to display a comparison of net incomes for each region in Year 2 would be a bar chart. Bar charts are useful when comparing total values between groups. To create a bar chart, enter the name of each region vertically. In the cell to the right of each name, you will need to calculate net income for that region for Year 2. Use the following formula: (Sales - COGS - Expenses). Repeat this for each region. Once you have finished, select the name of each region along with its Net Income. Select Insert, then Chart, and then Bar. The resulting chart should look like this:

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

Essay

Correct Answer:
Verified

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

Essay

Correct Answer:VerifiedShow Answer

Correct Answer:
Verified