XYZ Company prepared the following table showing a budget analysis of budget vs. actual expenses for the month of June. The initial budgeted values assumed 10,000 units of production. Management is disappointed with the unfavorable variances for each cost category. The production manager has prepared her own calculations using a flexible budget and reports that there was actually no overall variance for the month, after adjusting for volume. Click in the boxed area beneath the word "Budget," and use the associated pick list to select alternative volume levels. The budget column values change (i.e., "flexible") based on volume. Examine the results and respond to the question at the bottom of the page, which will turn green upon selecting the correct response. Budqet Analysis for June, 20XX Which level of volume is consistent with the manager's claim? Solve the Excel document Flexible budgets.xIsx and then assume the following to prepare Direct Material (DM) Spending variance, Direct Labor (DL) Spending variance, and Variable OverHead (OH) Spending variance to answer questions: Standard DM price per pound (Lbs): $20 Standard DM needed per unit: 2 Lbs Standard DL rate: $15 per hour Standard DL hours per unit: 2 hours of Direct Labor per unit "The actual DM used for 11000 units of production is 24200 lbs which means: 24200lbs/11000 actual units produced =2.2lbs actual quantity of DM used per unit Actual DL hours: 20000 hours Variable Overhead Rate applied based on per DL hour: $10 'Note: I am helping you here! - AQ(APSP)=DM Price Variance - (AQAP)(AQSP)=42000 Favorable (less spending for DM) - $442,000(24200$20)= DM Price Variance - 442,000484,000= DM Price Variance - \$42,000 Favorable DM Price Variance XYZ Company prepared the following table showing a budget analysis of budget vs. actual expenses for the month of June. The initial budgeted values assumed 10,000 units of production. Management is disappointed with the unfavorable variances for each cost category. The production manager has prepared her own calculations using a flexible budget and reports that there was actually no overall variance for the month, after adjusting for volume. Click in the boxed area beneath the word "Budget, " and use the associated pick list to select alternative volume levels. The budget column values change (i.e., "flexible") based on volume. Examine the results and respond to the question at the bottom of the page, which will turn green upon selecting the correct response. Budget Analysis for June, 20XX Which level of volume is consistent with the manager's claim? Solve the Excel document Flexible budgets.xisx and then assume the following to prepare Direct Material (DM). Spending variance, Direct Labor (DL) Spending variance, and Variable OverHead (OH) Spending variance to answer the questions: Standard DM price per pound (Lbs): $20 Standard DM needed per unit: 2 Lbs Standard DL rate: $15 per hour Standard DL hours per unit: 2 hours of Direct Labor per unit "The actual DM used for 11000 units of production is 24200lbs which means: 24200lbs/11000 actual units produced =2.2lbs actual quantity of DM used per unit Actual DL hours: 20000 hours Variable Overhead Rate applied based on per DL hour: $10 "Note: I am helping you here! - AQ(APSP)=DM Price Variance - (AQAP)(AQSP)=42000 Favorable (less spending for DM) - $442,000(24200$20)= DM Price Variance - 442,000484,000= DM Price Variance - \$42.000 Favorable DM Price Variance XYZ Company prepared the following table showing a budget analysis of budget vs. actual expenses for the month of June. The initial budgeted values assumed 10,000 units of production. Management is disappointed with the unfavorable variances for each cost category. The production manager has prepared her own calculations using a flexible budget and reports that there was actually no overall variance for the month, after adjusting for volume. Click in the boxed area beneath the word "Budget," and use the associated pick list to select alternative volume levels. The budget column values change (i.e., "flexible") based on volume. Examine the results and respond to the question at the bottom of the page, which will turn green upon selecting the correct response. Budqet Analysis for June, 20XX Which level of volume is consistent with the manager's claim? Solve the Excel document Flexible budgets.xIsx and then assume the following to prepare Direct Material (DM) Spending variance, Direct Labor (DL) Spending variance, and Variable OverHead (OH) Spending variance to answer questions: Standard DM price per pound (Lbs): $20 Standard DM needed per unit: 2 Lbs Standard DL rate: $15 per hour Standard DL hours per unit: 2 hours of Direct Labor per unit "The actual DM used for 11000 units of production is 24200 lbs which means: 24200lbs/11000 actual units produced =2.2lbs actual quantity of DM used per unit Actual DL hours: 20000 hours Variable Overhead Rate applied based on per DL hour: $10 'Note: I am helping you here! - AQ(APSP)=DM Price Variance - (AQAP)(AQSP)=42000 Favorable (less spending for DM) - $442,000(24200$20)= DM Price Variance - 442,000484,000= DM Price Variance - \$42,000 Favorable DM Price Variance XYZ Company prepared the following table showing a budget analysis of budget vs. actual expenses for the month of June. The initial budgeted values assumed 10,000 units of production. Management is disappointed with the unfavorable variances for each cost category. The production manager has prepared her own calculations using a flexible budget and reports that there was actually no overall variance for the month, after adjusting for volume. Click in the boxed area beneath the word "Budget, " and use the associated pick list to select alternative volume levels. The budget column values change (i.e., "flexible") based on volume. Examine the results and respond to the question at the bottom of the page, which will turn green upon selecting the correct response. Budget Analysis for June, 20XX Which level of volume is consistent with the manager's claim? Solve the Excel document Flexible budgets.xisx and then assume the following to prepare Direct Material (DM). Spending variance, Direct Labor (DL) Spending variance, and Variable OverHead (OH) Spending variance to answer the questions: Standard DM price per pound (Lbs): $20 Standard DM needed per unit: 2 Lbs Standard DL rate: $15 per hour Standard DL hours per unit: 2 hours of Direct Labor per unit "The actual DM used for 11000 units of production is 24200lbs which means: 24200lbs/11000 actual units produced =2.2lbs actual quantity of DM used per unit Actual DL hours: 20000 hours Variable Overhead Rate applied based on per DL hour: $10 "Note: I am helping you here! - AQ(APSP)=DM Price Variance - (AQAP)(AQSP)=42000 Favorable (less spending for DM) - $442,000(24200$20)= DM Price Variance - 442,000484,000= DM Price Variance - \$42.000 Favorable DM Price Variance