Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Will someone please help me on understanding the second part. i am completely lost ACC 207 MDE Manufacturing Budget: Bird Feeder I. Sales and Manufacturing
Will someone please help me on understanding the second part. i am completely lost
ACC 207 MDE Manufacturing Budget: Bird Feeder I. Sales and Manufacturing Expenses: Budget and Actual (2014) You will use this table to complete Milestones One and Two. Budget ($) Actual ($) 1,050,000 991,700 Expenses Materials - Cedar Materials - Plastic Factory Worker Labor Materials - Indirect Factory Depreciation Factory Utilities Factory Maintenance and Repairs Shipping ($2.25/each) Sales Commissions ($2.00/unit sold) Office Rent Advertising Liability insurance Office Depreciation Office Salaries 225,000 37,500 300,000 3,000 78,000 12,000 5,000 112,500 100,000 12,000 20,000 5,000 1,000 48,000 248,160 37,741 332,760 2,585 78,000 12,000 4,500 105,750 94,000 12,000 20,000 5,000 1,000 48,000 Total Expenses 959,000 1,001,496 Sales II. Contribution Margin: Static Budget and Actual Results (2014) You will use this table to complete Milestone Two. Actual Results Units Sold Revenues ($) Manufacturing Costs ($) Variable Fixed Gross Margin Static Budget Amount 47,000 991,700 50,000 1,050,000 621,246 94,500 275,954 565,500 95,000 389,500 III. Standard Variable Manufacturing Costs (2014) You will use this table to complete Milestone Two. Static Budget Costs Standard Input 225,000 37,500 300,000 3,000 3.0 ft/unit 1.0 ft/unit 0.5 hrs/unit 0.3 ft/unit Direct Materials: Cedar Direct Materials: Plastic Direct Manufacturing Labor Variable Manufacturing Overhead IV. Actual Variable Manufacturing Costs (2014) You will use this table to complete Milestone Two. Actual Costs Direct Materials: Cedar Direct Materials: Plastic Direct Manufacturing: Labor ($) Variable Manufacturing Overhead Actual Input 248,160 37,741 332,760 2,585 3.2 ft/unit 1.1 ft/unit 11.80/hr 0.2 ft/unit Milestone One, Part I Product Costs Materials - Cedar Materials - Plastic Factor Worker Labor Materials - Indirect Shipping Sales Commission Period Costs Factory Depreciation Factory Utilities Factory Maintenance Office Rent Advertising Liability Insurance Office Depreciation Office Supplies Milestone One, Part II Use Table I on the MDE Manufacturing Budget to complete your calculations. Sales Price per Unit Totals Budget $ 21 Totals Actual $ 21.10 Variable Costs Materials - Cedar Materials - Plastic Factory Worker Labor Materials - Indirect Shipping ($2.25/ea) Sales Commissions ($2/unit sold) $ $ $ $ $ $ 4.50 0.75 6.00 0.06 2.25 2.00 $ $ $ $ $ $ 5.28 0.80 7.08 0.06 2.25 2.00 17.47 Variable Cost per Unit $ 15.56 $ 17.47 Contribution Margin $ 5.44 $ 3.63 $ 78,000 $ 12,000 $ 5,000 $ 12,000 $ 20,000 $ 5,000 $ 1,000 $ 48,000 $ 181,000 $ $ $ $ $ $ $ $ $ 78,000 12,000 4,500 12,000 20,000 5,000 1,000 48,000 180,500 Fixed Costs Factory Depreciation Factory Utilities Factory Maintenance and Repairs Office Rent Advertising Liability Insurance Office Depreciation Office Salaries Total Fixed Costs Using Budgeted Amounts Breakeven Point - 33272 units Breakeven Point - Using Actual Amounts + 10,000 profit $ 21.10 Units at Current Sales Price Using actual amounts + 10,000 profit $ $ $ 4.05 New Contribution Margin 17.47 Current Variable Costs 21.52 New Sales Price 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 From Flexible Budget Calculations Sheet Budget Model Units Sold Revenues Variable Costs DM-Plastic DM-Cedar Direct Manuf. Labor Variable Manuf. Overhead Total Variable Costs Fixed Manuf. Overhead Total Costs Gross Margin Actual 47,000 $991,700 Flexible Budget Variance Favorable/ Unfavorable Flexible Budget 0 47,000 $4,700 Favorable $987,000 Sales Volume Variance (3,000) Favorable/ Unfavorable Unfavorable Static Budget 50,000 ($63,000) Unfavorable $1,050,000 Milestone Two, Part II Use the variance supporting calculation tab to complete your calculations. Price Variance Efficiency Variance Spending Variance Efficiency Variance Direct Materials - Cedar Direct Materials - Plastic Direct Labor Variable Manufacturing Overhead Revenues Variable Costs DM-Plastic DM-Cedar Direct Manuf. Labor Variable Manuf. Overhead Total Variable Manufacturing Costs Fixed Manufacturing Overhead Total Manufacturing Costs Gross Margin Budgeted Unit Amounts $ 21.00 4.50 Actual Volume 47,000 Flexible Budget Amount $987,000 47,000 211,500 Use Tables III and IV on the MDE Manufacturing Budget to complete your calculations. Development of Price and Efficiency Variances - Calculations Actual Ounces per Unit Actual Units Actual Ounces Used Actual Cost Actual Cost per Unit DM-Plastic DM-Cedar Actual Labor Cost per Hour Actual Labor Costs Actual Labor Hours Actual Units Actual Labor Hours per Unit Direct Manuf. Labor Actual Costs Incurred (Actual Input Qty. Actual Price) Actual Units Actual Feet per Unit Flexible Budget (Budgeted Input Qty. Allowed for Actual Output Budgeted Price) Actual Input Qty. Budgeted Price Actual Price per Ounce Actual Units Actual Feet per Budgeted Cost Unit per Ounce Actual Units Budgeted Feet per Budgeted Cost per Unit Ounce Direct Material Plastic $ - $ $ Price Variance $ - Price Variance $ $ $ - Efficiency Variance $ - Efficiency Variance Direct Material Cedar $ Actual Units - Actual Hours per Unit $ Actual Cost per Hour Actual Units - Actual Hours per Unit Budgeted Cost per Hour Actual Units Budgeted Hours Budgeted Cost per per Unit Hour Direct Manufacturing Labor $ - $ $ - Price Variance $ $ Efficiency Variance Flexible Budget (Budgeted Input Qty. Allowed for Actual Output Budgeted Price) Actual Input Qty. Budgeted Price Actual Costs Actual Costs Actual Units - Actual Feet per Budgeted Cost Unit per Foot Actual Units Budgeted Feet per Budgeted Cost per Unit Foot Variable manufacturing overhead $ - $ $ Spending Variance - $ $ Efficiency VarianceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started