Reference no: EM131203049
Specifically, the following critical elements must be addressed: II. Prepare and Perform a) What are your fixed costs? Segregate them in the budget model. b) Determine how variable costs change as activity measures change. How can this information be applied? c) Create the budget model, ensuring fixed costs are hard coded into the model (variable costs are stated as a percentage of the relevant activity measures or as a cost per unit of activity measure). d) Add actual activity measures to the model. Make sure all information is added accurately. e) Add the flexible budget calculations to the budget model. Make sure all information is accurate. f) Compare the flexible budget to the actual expenses. What does this inform? Be sure to discuss the following variances: i. Static budget variance, including sales volume and flexible budget variances ii. Price and efficiency variances for direct materials and direct labor iii. Spending and efficiency variances for variable manufacturing overhead g) Determine the aspects of the budgeting process that are in need of improvement. Justify your response. h) Interpret what budget variances represent. Should all variances be investigated? Guidelines for Submission: Your paper must be submitted using the Student Workbook to present your budgets and variances and a 1–2 page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins to explain your findings
Milestone Two, Part I
Use Tables I through IV on the MDE Manufacturing Budget to complete your calculations.
Refer to Exhibit 7-2 on page 253 of the text
Budget Model From Flexible Budget Calculations Sheet
Actual Flexible Budget Variance Favorable/ Unfavorable Flexible Budget Sales Volume Variance Favorable/ Unfavorable Static Budget
Units Sold 47,000 47,000 -3,000 50,000
Revenues $991,700 $4,700 Favorable $987,000 ($63,000) Unfavorable $1,050,000
Variable Costs
DM-Plastic 248160 211500 225000
DM-Cedar 37741 35250 37500
Direct Manuf. Labor 332760 282000 300000
Variable Manuf. Overhead 2585 2820 3000
Total Variable Costs 621246 531570 565500
Fixed Manuf. Overhead 94500 95000 95000
Total Costs 715746 626570 660500
Gross Margin 275954 389500
Milestone Two, Part II
Use the variance supporting calculation tab to complete your calculations.
Price Variance Efficiency Variance
Direct Materials - Cedar -22560 -14100
Direct Materials - Plastic 1034 -3525
Direct Labor 5640 -56400
Spending Variance Efficiency Variance
Variable Manufacturing Overhead
|
Calculate cindys net capital gain for current financial year
: MLC 703- PRINCIPLES OF INCOME TAX LAW - Critically discuss the whether capital gains should be subject to a 50% discount. Please consider this in the context of fairness, economic efficiency, protection of government revenue and any other relevant..
|
|
What is the appropriate setup? time
: Given the following information about a? product, at Phyllis? Simon's firm, what is the appropriate setup? time? Setup labor cost ?$30.00 per hour Annual holding cost ?$17 per unit Daily production 1,200 ?units/day Annual demand 29,000 Desired lot si..
|
|
What is the armature resistance ra of this machine
: Assuming that the speed of rotation and magnetic flux density are constant, plot the terminal voltage of this machine as a function of the current drawn from it.
|
|
Name two materials that are good conductors of electricity
: Name two materials not listed in Table that are good conductors of electricity.
|
|
Create budget model-ensuring fixed costs are hard coded
: Specifically, the following critical elements must be addressed: II. Prepare and Perform. What are your fixed costs? Segregate them in the budget model. Determine how variable costs change as activity measures change. How can this information be appl..
|
|
Determine which costs are variable-fixed and step fixed
: The Cattle Company has gathered the following information about operations for the past three years. The owner has been expanding herd size and is frustrated that profits have not shown consistent growth. Determine which costs are variable, fixed, a..
|
|
Are sally current special education services consistent
: Are Sally's current special education services consistent with the inclusion model? Why? Why not? What should Sally's general education 3rd grade teacher do to help fully include her within the 3rd grade classroom?
|
|
All public for-profits are audited annually
: It is a SOX requirement that all public for-profits are audited annually. However, that's not the case for other types of businesses. If you think about small to mid-sized nonprofits, you may or may not have a full-blown audit every year. Would you r..
|
|
Oxley act is defined as not being part of management team
: The Sarbanes-Oxley Act requires that each member of the company's audit committee be a member of the board of directors and be independent. Independence in the Act is defined as not being part of the management team and not receiving any compensation..
|