Please ans with cell references.

Brilliant Builds Ltd. (BB) had the following static budget and actual results for the previous year Units Sold Actual Results 750 Static Budget 1.000 Sales Variable Costs Contribution Margin Fixed Costs Operating Income 39,000 15,750 23,250 12,698 10,552 50,000 24.000 26,000 12.000 14,000 Management at BB is wondering if the negative variance is due to lower volume or poor cost control and inefficiencies. Complete the flexed budget. Note: not all cells highlighted in blue must have an answer. Variable Components (per unit) Fixed Components (total dollars) Flexed Budget inite Sold Complete the flexed budget. Note: not all cells highlighted in blue must have an answer, 1 Variable Components (per unit) Fixed Components (total dollars) Units Sold Flexed Budget Sales Variable costs Contribution Margin Fixed Costs Operating Income When comparing the actual results to the static budget and flexed budget: a) What is the variance attributed to (or due to efficiency and cost controls? a) What is the variance attributed to (or due to lower sales volume? Brilliant Builds Ltd. (BB) had the following static budget and actual results for the previous year Units Sold Actual Results 750 Static Budget 1.000 Sales Variable Costs Contribution Margin Fixed Costs Operating Income 39,000 15,750 23,250 12,698 10,552 50,000 24.000 26,000 12.000 14,000 Management at BB is wondering if the negative variance is due to lower volume or poor cost control and inefficiencies. Complete the flexed budget. Note: not all cells highlighted in blue must have an answer. Variable Components (per unit) Fixed Components (total dollars) Flexed Budget inite Sold Complete the flexed budget. Note: not all cells highlighted in blue must have an answer, 1 Variable Components (per unit) Fixed Components (total dollars) Units Sold Flexed Budget Sales Variable costs Contribution Margin Fixed Costs Operating Income When comparing the actual results to the static budget and flexed budget: a) What is the variance attributed to (or due to efficiency and cost controls? a) What is the variance attributed to (or due to lower sales volume