BAVARIA DAIRY FARM - COST VOLUME PROFIT ANALYSIS You are working as the accountant for Bavaria Dairy Farm, a newly established small dairy farm that sells three products - milk, yogurt and cheese. Data concerning these three products appear below: Milk Description Sales mix Selling price per unit Variable expense per unit Fixed expenses per quarter 40% $6.00 $3.00 Yogurt 45% $16.00 $14.00 $18,000 Cheese 15% $24.00 $18.00 The 2020 total budgeted unit sales for all three products of Bavaria Dairy Farm are provided below: Quarter Quarter Total Budgeted Unit Sales 6,000 6 ,120 6 ,242 6 ,367 2 3 4 Product Milk Yogurt Cheese Milk Yogurt Cheese Milk Yogurt Cheese Milk Yogurt Cheese Budgeted Actual Units Unit Sales Sold 2400 1440 2700 3225 900 790 2448 2700 2754 2755 918 680 2497 2520 2809 936 1205 2547 2550 2865 2900 955 1105 2850 In constructing your spreadsheet, use the template above as the starting point to create and add further required data. Determine (1) actual versus breakeven sales dollar figures for each product, broken down by quarters; (2) net income of each product, broken down by quarters; (3) In considering all four quarters together, which product brings in the highest sales value overall, and which product is the most profitable overall? At the end of 2020, the owner of Bavaria Dairy Farm would like you to perform an end-of-year analysis