Antonio's Company has been making pizza sauce for the last 90 years. The company supplies pizza sauce to three different market segments including food service firms, manufacturers, and supermarkets. The company is trying to improve its financial position and in doing so is performing an analysis of each segment to decide whether any should be eliminated. The following Tableau dashboard visualizes the performance of each segment. The dashboard contains a summary for all segments combined. The sales and profitability for each segment are shown in the bar chart at the top right. The lower section visualizes the sales for a specific segment and the margin that remains after each type of cost is calculated. Click on a segment in the bar chart at the top right to update the lower section. Use the information within the various visualizations to assist you in answering the following questions. Antonio's Pizza Sauce | Segment Performance Summary Sales by Primary Segment Sales Unit Level Costs Batch Level Costs Product Level Costs Segment Level Direct Fixed Costs Allocated Common Fixed Costs Net Income $6.0M $5.0M $5,376,956 $5,376,956 $2,576,583 $573,133 $362,541 $602,000 $500,000 $762,700 28.4% Food Service Firmis O $5.4M 28.8% Manufacturers 42.8% Supermarkets Profitability by Segment Sales Bar | Net Income = Line | Profit Margin = % Prev Pizza Stores Restaurants Frozen Pizza Packaged Ingredients International Domestic Sales and Costs Select a segment in the bar chart shown at the top right to update. 1 of 1 $0.0M Next > $0.5M -1.4% 39.9% 20.6% 31.2% -7.8% 14.2% $1.0M $1.5M

Segment Elimination Analysis Antonio's Company has been making pizza sauce for the last 90 years. The company supplies pizza sauce to three different market segments including food service firms, manufacturers, and supermarkets. The company is trying to improve its financial position and in doing 50 is performing an analysis of each segment to decide whether any should be eliminated. The following Tableau dashboard visualizes the performance of each segment. The dashboard contains a summary for all segments combined. The sales and profitability for each-segment are shown in the bar chart at the top right. The lower section visualizes the sales for a specific segment and the margin that remains after each type of cost is calculated. Click on a segment in the bar chart at the top right to update the lower section. Use the information within the various visualizations to assist you in answering the following questions. Antonio's Pizza Sauce | Segment Performance Sales and Costs Select a seament in the bar chart shown at the too riaht to codate Segment Elimination Analysis Antonio's Company has been making pizza sauce for the fast 90 years. The compary supplies pizza sauce to three different market segments including food service firms, manufacturers, and supermarkets. The company is trying to improve its financial position and in doing so is performing an analysis of each segment to decide whether any should be eliminated. The following Tableau dashboard visualizes the performance of each segment. The dashboard contains a summary for all segments combined. The sales and profitability for each segment are shown in the bar chart at the top right. The lower section visualizes the sales for a specific segment and the margin that remains after each type of cost is calculoted. Click on a segment in the bar chart at the top right to update the lower section. Use the information within the various visualizations to assist you in answering the following questions. Antonio's Pizza Sauce | Segment Performance Sales and Costs Select a secment in the bar chart shown at the too right to update. Required: 1. Which type of cost is the largest for the company as a whole? 2. Which primary segment has the most sales? 3. Does the primary segment with the most sales have the highest net income? 4. Which if any of the company's segments are not profitable? 5. Based on your answer to question 4 , should any segment be eliminated due to not turning a profit? Complete this question by entering your answers in the tabs below. Which type of cost is the largest for the company as a whole? Complete this question by entering your answers in the tabs below. Which primary segment has the most sales? Does the primary segment with the most sales have the highest net income? Does the primary segment with the most sales have the highest net income? Which if any of the company's segments are not profitable? Which if any of the company's segments are not profitable? Based on your answer to question 4 , should any segment be eliminated due to not turning a profit