Question
I have already completed the first two sections of this question- however, I am really struggling with the last piece. Screenshots of the first two
I have already completed the first two sections of this question- however, I am really struggling with the last piece. Screenshots of the first two (completed) sections are attached.
Monty Company uses budgets in controlling costs. The August 2017 budget report for the companys Assembling Department is as follows.
MONTY COMPANY Budget Report Assembling Department For the Month Ended August 31, 2017 | ||||||
Difference | ||||||
Manufacturing Costs | Budget | Actual | Favorable Unfavorable | |||
Variable costs | ||||||
Direct materials | $55,040 | $53,940 | $1,100 | Favorable | ||
Direct labor | 62,720 | 59,320 | 3,400 | Favorable | ||
Indirect materials | 30,720 | 30,820 | 100 | Unfavorable | ||
Indirect labor | 21,760 | 21,260 | 500 | Favorable | ||
Utilities | 16,000 | 15,890 | 110 | Favorable | ||
Maintenance | 11,520 | 11,650 | 130 | Unfavorable | ||
Total variable | 197,760 | 192,880 | 4,880 | Favorable | ||
Fixed costs | ||||||
Rent | 11,300 | 11,300 | 0 | |||
Supervision | 17,900 | 17,900 | 0 | |||
Depreciation | 5,000 | 5,000 | 0 | |||
Total fixed | 34,200 | 34,200 | 0 | |||
Total costs | $231,960 | $227,080 | $4,880 | Favorable |
The monthly budget amounts in the report were based on expected production of 64,000 units per month or 768,000 units per year. The Assembling Department manager is pleased with the report and expects a raise, or at least praise for a job well done. The company president, however, is unhappy with the results for August because only 62,000 units were produced.
This is the section I need help with:
In September, 68,000 units were produced. Prepare the budget report using flexible budget data, assuming (1) each variable cost was 10% higher than its actual cost in August, and (2) fixed costs were the same in September as in August. (List variable costs before fixed costs.)
The options for the tabs on the left:
The options for the tabs on the right:
(a) Your answer is correct. State the total monthly budgeted cost formula. (Round cost per unit to 2 decimal places, e.g. 1.25.) 34200 The formula is $ + variable costs of $ 5.09) per unit. SHOW SOLUTION LINK TO TEXT LINK TO TEXT VIDEO: SIMILAR PROBLEM Attempts: 1 of 10 used (61) Your answer is correct. Prepare a budget report for August using flexible budget data. (List variable costs before fixed costs.) MONTY COMPANY Assembling Department Flexible Budget Report For the Month Ended August 31, 2017 Difference Favorable Unfavorable Neither Favorable nor Unfavorable Budget Actual Costs 62000 Units 62000 Variable Costs - Direct Materials 53320 ) 620 T Unfavorable Direct Labor 60760 T 1440 | Favorable 29760 1 "Indirect Materials Indirect Labor 59320 3 0820 21260 21260 1060 T Unfavorable 180 ( Unfavorable 9 T 21080 1 T Utilities - 15890 11650 T T 390 490 Unfavorable Unfavorable Maintenance 60 Total Variable Costs 1300|| Unfavorable Fixed Costs Rent | Neither Favorable nor Unfavorable Supervision 17900 Neither Favorable nor Unfavorable Depreciation | 5000 Neither Favorable nor Unfavorable Total Fixed Costs | Neither Favorable nor Unfavorable T Total Costs 227080 1300 T Unfavorable SHOW SOLUTION LINK TO TEXT LINK TO TEXT VIDEO: SIMILAR PROBLEM Attempts: 1 of 10 used MONTY COMPANY Assembling Department Flexible Budget Report Difference Favorable Unfavorable Neither Favorable nor Unfavorable Budget Actual Costs Depreciation Direct Labor Direct Materials Fixed Costs Indirect Labor Indirect Materials Maintenance Rent Supervision Total Costs Total Fixed Costs Total Variable Costs Units Utilities Variable Costs Favorable Unfavorable Neither Favorable nor UnfavorableStep 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