XM Flexible Budget and Variance Analysis

XM Flexible Budget & Variance Analysis

This assignment provides a fle × budget for XM inn an effort to revise the Actual vs. Budget Report. The goal of this analysis is to determine the overall profitability of XM and explain it to the XM CEO. Moreover, this study also includes the calculation and analysis of materials/labour/overhead (price & quantity) variances, along with an interpretation about them to the company CEO.

1: Revise the Actual vs. Budget Report using flexible budget / provide commons on the overall profitability of XM to the CEO.

The following table presents XM Actual vs. Static Budget Report:

Table 1: XM Actual vs. Static Budget Report

  
 

Actual Budget     (1)

Fixed Budget    (2)

Static Budget Variances    (3)=(1)−(2)

Sales units

1000

1050

−50

U

Price

$            700

          $            700

   $                  –

 

Revenue

  700,000

  735,000

  −35,000

U

Cost of Production

    

Material per unit

        

         250

−4

F

Total materials cost

  245,700

  262,500

−16,800

F

Labour per unit

        

         150

2.25

U

Total labor cost

  152,250

    157,500

−5,250

F

Manufacturing overhead per unit

           70

5.6

U

Total manufacturing overhead cost

      75,600

      73,500

             2,100

U

Total manufacturing cost

  473,550

  493,500

−19,950

F

Gross margin

  226,450

  241,500

−15,050

U

Selling and admin. expense

  183,500

  190,000

−6,500

F

Net operating profit

    42,950

    51,500

−8,550

U

>/div>

There are three variable costs present as part the fixed budget: material cost ($250 per unit), labour cost ($150 per unit), manufacturing overhead cost ($70 per unit), while there is only one fixed cost: selling and admin. expense ($190,000).

Based on the Actual vs. Budget Report shown in Table 1, XM is experiencing a significant shortfall in profits ($8,550).

Flexible budget is a budget designed to change as the level of activity for control purpose. It is vital that flexible budgeting is used for comparing what the cost should have been with the expenditure incurred at the actual activity level.  Table 2 presents the result of the flexible budget analysis:

Table 2: XM Actual vs. Flexible Budget Report

  
 

Actual Budget     (1)

Fixed Budget      (2)

Static Budget Variances (3)=(1)−(2)

Sales units

1000

1000

 —

 

Price

$            700

        $           700

 —

 

Revenue

 700,000

  700,000

 —

 

Cost of Production

    

Material per unit

         250

−4

F

Total materials cost

  245,700

  250,000

−4,300

F

Labour per unit

           

         150

2.25

U

Total labor cost

    152,250

    150,000

2,250

U

Manufacturing overhead per unit

           70

5.60

U

Total manufacturing overhead cost

      75,600

      70,000

      5,600

U

Total manufacturing cost

  473,550

  470,000

3,550

U

Gross margin

  226,450

  230,000

−3,550

F

Selling and admin. expense

  183,500

  190,000

−6,500

F

Net operating profit

    42,950

    40,000

2,950

F

>/div>

This analysis indicates that using the same activity level (1,000 units), XM is operating under budget—a favorable difference, and hence is profitable.

2. Calculate variances, and to indicate whether the variance is favorable or unfavorable, provide interpretations and explanations to the CEO on the meanings of those variances.

  • Materials price variance
  • Materials quantity variance
  • Labour price variance
  • Labour quantity variance
  • Overhead price variance
  • Overhead quantity variance

MPV = (AQ) × (AP) − (AQ) × (SP)

MQV = (AQ) × (SP) − (SQ) × (SP)

Want latest solution of this assignment
); }