Complete the flexible budget (of lemon flavour and all products combined) and associated variances using the template provided.

Mountain Spring manufactures and sells varieties of sports drink (berry, lemon and orange) in bulk to upmarket. Budgeted and actual results for 2019 are as follows: Mountain Spring Income Statement Year Ended 30 June 2019 budget actual sales revenue $ 18,680,000 19,079,500 (11,400,000 variable costs $ (11,794,000) contribution margin $ 7,280,000 7,285,500 non-variable costs $ (5,580,000) (5,680,000) net operating profit $ 1,700,000 1,605,50 Boxes $ per box $ per box $ per box 500,000 7.00 (4.50) 2.50 400,000 6.90 (4.40) 2.50 Boxes $ per box $ per box $ per box 900,000 7.00 (4.00) 3.00 1,100,000 6.90 (4.30) 2.60 Product Breakdown Berry sales volume selling price variable costs contribution margin Lemon sales volume selling price variable costs contribution margin Orange sales volume selling price variable costs contribution margin All Products Combined sales volume market share selling price variable costs contribution margin per box Boxes $ $ per box $ per box 1,110,000 8.00 (5.00) 3.00 1,105,000 7.90 (4.80) 3.10 Boxes $ per box $ per box $ per box 2,510,000 11.409% 7.44 (4.54) 2.90 2,605,000 13.025% 7.32 (4.53) 2.80 Mountain Spring manufactures Flexible Budget Year Ended 30 June 2019 variance flexible budget variance $ $ (325,000) (11,725,000) (69,000) sales revenue variable costs contribution margin non-variable costs net operating profit budget 18,680,000 (11,400,000) 7,280,000 (5,580,000) 1,700,000 actual total variance 19,079,500 399,500 (11,794,000) (394,000) 7,285,500 5,500 (5,680,000) (100,000) 1,605,500 (94,500) $ $ $ 335,000 2,035,000 (429,500) Boxes (100,000) $ per box $ per box $ per box 500,000 7.000 (4.500) 2.500 400,000 7.000 (4.500) 2.500 (0.100) 0.100 0.000 400,000 6.900 (4.400) 2.500 (0.100) 0.100 0.000 Boxes $ per box $ per box $ per box 900,000 7.000 (4.000) 3.000 1,100,000 6.900 (4.300) 2.600 (4.000) 3.000 (0.300) (0.400) (0.100) (0.300) (0.400) Product Breakdown Berry sales volume selling price variable costs contribution margin Lemon sales volume selling price variable costs contribution margin Orange sales volume selling price variable costs contribution margin All Products Combined sales volume market share selling price variable costs contribution margin (5,000) Boxes $ per box $ per box $ per box 1,110,000 8.000 (5.000) 3.000 1,105,000 8.000 (5.000) 3.000 (0.100) 0.200 0.100 1,105,000 7.900 (4.800) 3.100 (0.100) 0.200 0.100 Boxes 1.616% 13.025% $ per box $ per box $ per box 2,510,000 11.409% 7.442 (4.542) 2.900 2,605,000 13.025% 7.324 (4.527) 2.797 (0.118) 0.014 (0.104) 0.023 2.923 (0.126)