Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I-17.03 XYZ Company prepared the following table showing a budget analysis of budget vs. actual expenses for the month of June. The initial budgeted values

I-17.03 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 (ie., "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 Actual Budget 9,000 units Variance Variable Manufacturing Direct material $ 442,000 $ 360,000 $ (82,000) Direct labor 328,000 270,000 (58,000) Variable factory overhead 215,000 180,000 (35,000) Total variable costs 985,000 $ 810,000 $ (175,000) Fixed factory overhead 255,000 250,000 (5,000) Total manufacturing costs 1.240.000 1,060,000 $180,000) Which level of volume is consistent with the manager's claim? >>>>> Under 11000 units of production in the Excel document, you will see that there is no overall production cost variance. Assume that Under the actual 11000 units of production, the company used 24200 lbs of Direct Material (DM). 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 Actual DL hours: 20000 hours Variable Overhead Rate applied based on per DL hour: $10 D Question 1 2 pts After preparing DM variance analysis, what is the Material Quantity Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative. D Question 2 2 pts After preparing DM variance analysis, what is the Material Price Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative. Question 3 1 pts After preparing DM variance analysis, what is the Total Material spending Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative. Question 4 2 pts After preparing DL variance analysis, what is the Labor Efficiency Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative. Question 5 2 pts After preparing DL variance analysis, what is the Labor Rate Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative. Question 6 1 pts After preparing DL variance analysis, what is the Total Direct Labor spending Variance based on (the flex budget) 11000 units of production? Note: for Favorable enter the number as positive. For unfavorable enter the number as negative

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Scoreboard Your Practice 7 Numbers To Understand Your Design Firms Financials

Authors: Rick J Linley

1st Edition

1039138985, 978-1039138988

More Books

Students also viewed these Accounting questions

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago

Question

10. What is meant by a feed rate?

Answered: 1 week ago