a. Ignore any current plans. Using the data and sales mix provided for 2019 answer the following questions: How many total cases would Alex need to sell in order to earn $80,000 operating income? b. What is the percentage increase in the total cases over the 2019 data if the desired operating income is $80,000? How many of these cases would be Nastre Blue Pilsner (assume that sales mix remains the same)? c. E Open with Preview Screen Shot 2021-10-27 at 6.42.30 PM Exhibiti Cont Sales information for 2019 yearyl Pero Pale Ale More Beck Total Sale Price percase 2000 Nastro Blue Plane 22.755 23 50 5 Menabra Stout 25 50 5 Direct Materials per case Direct aber per me Other Variable Costs per case Total Variable costs per case Contribution Marion per Case 2.50 $ 3.455 5.25 $ 21.70 2405 3455 5585 3132 11.925 2655 3.00 5.RO 5 1145 1130 $ 3.25 495 634 1654 330$ 10 96 Number of cues sold 12.300 7150 5.900 4,050 30.900 Direct Labor Hours (per Total DLH 023 2,944.00 0.23 1,544 50 0.20 1.380.00 03) 1336 50 7.305.00 Machine Hours (M) per case Total MH 017 2.176.00 0.40 2.860.00 0.23 1,58700 031 1,255 50 787850 Contribution Margin income Statement Total Sales Revenue Total Variable costs Contribution Margin Derected Costs Segment Man Commen Fed Costi Operating income Perone Pale Ale 256,000.00 $ 149.750.00 106,240,00 10.329.62 95,310 38 5 More Block 168.025.00 5 82 419.50 85,585 50 839291 77,192.59 $ Nastro Blue Pane 156,975.00 5 79,00500 77970.00 6.01239 21,952 61 5 Menabra Stout Tota 103,275.00 $ 684,275.00 58.887.00 37009150 44,388.00 314,183 50 9.893.92 3453384 34494 08 $ 279,549.66 $ 245,389.44 $ 34,160.22 a. Ignore any current plans. Using the data and sales mix provided for 2019 answer the following questions: How many total cases would Alex need to sell in order to earn $80,000 operating income? b. What is the percentage increase in the total cases over the 2019 data if the desired operating income is $80,000? How many of these cases would be Nastre Blue Pilsner (assume that sales mix remains the same)? c. E Open with Preview Screen Shot 2021-10-27 at 6.42.30 PM Exhibiti Cont Sales information for 2019 yearyl Pero Pale Ale More Beck Total Sale Price percase 2000 Nastro Blue Plane 22.755 23 50 5 Menabra Stout 25 50 5 Direct Materials per case Direct aber per me Other Variable Costs per case Total Variable costs per case Contribution Marion per Case 2.50 $ 3.455 5.25 $ 21.70 2405 3455 5585 3132 11.925 2655 3.00 5.RO 5 1145 1130 $ 3.25 495 634 1654 330$ 10 96 Number of cues sold 12.300 7150 5.900 4,050 30.900 Direct Labor Hours (per Total DLH 023 2,944.00 0.23 1,544 50 0.20 1.380.00 03) 1336 50 7.305.00 Machine Hours (M) per case Total MH 017 2.176.00 0.40 2.860.00 0.23 1,58700 031 1,255 50 787850 Contribution Margin income Statement Total Sales Revenue Total Variable costs Contribution Margin Derected Costs Segment Man Commen Fed Costi Operating income Perone Pale Ale 256,000.00 $ 149.750.00 106,240,00 10.329.62 95,310 38 5 More Block 168.025.00 5 82 419.50 85,585 50 839291 77,192.59 $ Nastro Blue Pane 156,975.00 5 79,00500 77970.00 6.01239 21,952 61 5 Menabra Stout Tota 103,275.00 $ 684,275.00 58.887.00 37009150 44,388.00 314,183 50 9.893.92 3453384 34494 08 $ 279,549.66 $ 245,389.44 $ 34,160.22