您的AI财务准则专家
Problem Title: Variance Analysis in Manufacturing Background: You are the manager of a manufacturing company that produces widgets. Your company's standard cost per widget is as follows: Direct Materials: £10 per widget (10 pounds (lb) per widget) Direct Labor: £8 per widget (1.2 hours per widget) Variable Manufacturing Overhead: £4 per widget Fixed Manufacturing Overhead: £5,000 per month (based on producing 1,000 widgets) During the last month, your company produced 900 widgets. After reviewing the actual costs and production data, you want to perform a variance analysis to understand how well your company performed compared to the standard costs. Additional Information: Actual direct materials cost: £10.50 per widget Actual direct materials used: 9,000 pounds (lb) Actual direct labour cost: £8.25 per hour Actual direct labour hours worked: 1,080 hours Actual variable manufacturing overhead cost: £3,600 Actual fixed manufacturing overhead cost: £4,800 Task: Calculate and analyse the following variances:

The variances to be calculated are as follows:

  1. Direct Materials Price Variance: This variance compares the actual price paid for materials against the standard price. To calculate, we subtract the standard cost per pound of direct materials from the actual cost per pound.

  2. Direct Materials Quantity Variance: This variance assesses the efficiency in using materials. It's calculated by comparing the standard quantity of material allowed for production against the actual quantity used.

  3. Direct Labor Efficiency Variance: This is the difference between the standard labor rate and the actual labor cost per hour.

  4. Direct Labor Rate Variance: This variance compares the standard labor rate with the actual labor rate per hour.

  5. Variable Overhead Spending Variance: This is the difference between the standard variable overhead cost and the actual variable overhead cost.

  6. Fixed Overhead Spending Variance: As fixed overhead is not volume-sensitive, this variance compares the budgeted fixed overhead cost for the planned production level (1,000 widgets) with the actual amount spent.

Let's compute these variances to understand the performance gaps.

Please note that a favorable variance means the actual cost was lower than the standard or budgeted cost, while an unfavorable variance indicates the opposite, i.e., the actual cost exceeded the standard or budgeted cost.

Please provide the calculations for each variance to proceed with the analysis.