Static Budget versus Flexible Budget
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $698,000 |
| Utilities | 43,000 |
| Depreciation | 72,000 |
| Total | $813,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $767,000 | 122,000 | ||
| February | 732,000 | 111,000 | ||
| March | 699,000 | 100,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 813,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $21 |
| Utility cost per direct labor hour | $1.3 |
| Direct labor hours per unit | 0.25 |
| Planned monthly unit production | 133,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places.
| Niland Company | |||
| Machining Department Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | 122,000 | 111,000 | 100,000 |
| $ | $ | $ | |
| Total | $ | $ | $ |
| Supporting calculations: | |||
| Units of production | 122,000 | 111,000 | 100,000 |
| Hours per unit | x | x | x |
| Total hours of production | |||
| Wages per hour | x $ | x $ | x $ |
| Total wages | $ | $ | $ |
| Total hours of production | |||
| Utility costs per hour | x $ | x $ | x $ |
| Total utilities | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | |
| The department is spending more than would be expected. |
In: Accounting
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year: Niland Company Machining Department Monthly Production Budget Wages $271,000 Utilities 16,000 Depreciation 27,000 Total $314,000 The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows: Amount Spent Units Produced January $296,000 73,000 February 284,000 67,000 March 270,000 60,000 The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 314,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows: Wages per hour $17 Utility cost per direct labor hour $1 Direct labor hours per unit 0.2 Planned monthly unit production 80,000 a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places. Niland Company Machining Department Budget For the Three Months Ending March 31 January February March Units of production 73,000 67,000 60,000 $ $ $ Total $ $ $ Supporting calculations: Units of production 73,000 67,000 60,000 Hours per unit x x x Total hours of production Wages per hour x $ x $ x $ Total wages $ $ $ Total hours of production Utility costs per hour x $ x $ x $ Total utilities $ $ $ b. Compare the flexible budget with the actual expenditures for the first three months. January February March Total flexible budget $ $ $ Actual cost Excess of actual cost over budget $ $ $ What does this comparison suggest? The Machining Department has performed better than originally thought. The department is spending more than would be expected.
In: Accounting
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $629,000 |
| Utilities | 33,000 |
| Depreciation | 55,000 |
| Total | $717,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $676,000 | 110,000 | ||
| February | 644,000 | 100,000 | ||
| March | 613,000 | 90,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 717,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $21 |
| Utility cost per direct labor hour | $1.1 |
| Direct labor hours per unit | 0.25 |
| Planned monthly unit production | 120,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places.
| Niland Company | |||
| Machining Department Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | 110,000 | 100,000 | 90,000 |
| $ | $ | $ | |
| Total | $ | $ | $ |
| Supporting calculations: | |||
| Units of production | 110,000 | 100,000 | 90,000 |
| Hours per unit | x | x | x |
| Total hours of production | |||
| Wages per hour | x $ | x $ | x $ |
| Total wages | $ | $ | $ |
| Total hours of production | |||
| Utility costs per hour | x $ | x $ | x $ |
| Total utilities | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | |
| The department is spending more than would be expected. |
In: Accounting
Static Budget versus Flexible Budget
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $590,000 |
| Utilities | 28,000 |
| Depreciation | 47,000 |
| Total | $665,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $626,000 | 57,000 | ||
| February | 598,000 | 52,000 | ||
| March | 571,000 | 47,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 665,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $19 |
| Utility cost per direct labor hour | $0.9 |
| Direct labor hours per unit | 0.5 |
| Planned monthly unit production | 63,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places.
| Niland Company | |||
| Machining Department Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | 57,000 | 52,000 | 47,000 |
| $ | $ | $ | |
| Total | $ | $ | $ |
| Supporting calculations: | |||
| Units of production | 57,000 | 52,000 | 47,000 |
| Hours per unit | x | x | x |
| Total hours of production | |||
| Wages per hour | x $ | x $ | x $ |
| Total wages | $ | $ | $ |
| Total hours of production | |||
| Utility costs per hour | x $ | x $ | x $ |
| Total utilities | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | |
| The department is spending more than would be expected. |
In: Accounting
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $1,535,000 |
| Utilities | 63,000 |
| Depreciation | 105,000 |
| Total | $1,703,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $1,602,000 | 128,000 | ||
| February | 1,531,000 | 117,000 | ||
| March | 1,451,000 | 105,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 1,703,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $22 |
| Utility cost per direct labor hour | $0.9 |
| Direct labor hours per unit | 0.5 |
| Planned monthly unit production | 140,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places.
| Niland Company | |||
| Machining Department Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | 128,000 | 117,000 | 105,000 |
| $ | $ | $ | |
| Total | $ | $ | $ |
| Supporting calculations: | |||
| Units of production | 128,000 | 117,000 | 105,000 |
| Hours per unit | x | x | x |
| Total hours of production | |||
| Wages per hour | x $ | x $ | x $ |
| Total wages | $ | $ | $ |
| Total hours of production | |||
| Utility costs per hour | x $ | x $ | x $ |
| Total utilities | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | |
| The department is spending more than would be expected. |
In: Accounting
The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports—the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 63 students enrolled in those two courses. Data concerning the company’s cost formulas appear below:
| Fixed Cost per Month | Cost per Course | Cost per Student |
|||||
| Instructor wages | $ | 2,970 | |||||
| Classroom supplies | $ | 280 | |||||
| Utilities | $ | 1,210 | $ | 50 | |||
| Campus rent | $ | 4,500 | |||||
| Insurance | $ | 2,000 | |||||
| Administrative expenses | $ | 3,700 | $ | 46 | $ | 7 | |
For example, administrative expenses should be $3,700 per month plus $46 per course plus $7 per student. The company’s sales should average $850 per student.
The company planned to run four courses with a total of 63 students; however, it actually ran four courses with a total of only 59 students. The actual operating results for September appear below:
| Actual | ||
| Revenue | $ | 50,650 |
| Instructor wages | $ | 11,160 |
| Classroom supplies | $ | 17,490 |
| Utilities | $ | 1,820 |
| Campus rent | $ | 4,500 |
| Insurance | $ | 2,140 |
| Administrative expenses | $ | 3,751 |
Required:
1. Prepare the company’s planning budget for September.
Prepare the company’s planning budget for September.
|
|||||||||||||||||||||||||||||||||
2. Prepare the company’s flexible budget for September.
Prepare the company’s flexible budget for September.
|
|||||||||||||||||||||||||||||||||
3. Calculate the revenue and spending
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
1.
By royal decree, there is only a single toothpaste manufacturer in Arlington, and the following represents his demand curve (shown below). If the ATC of producing toothpaste is constant at $16.50, then the monopolist will produce:
| Demand | $20.00 | $19.50 | $19.00 | $18.50 | $18.00 | $17.50 | $17.00 | $16.50 | $16.00 |
| Price | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Quantity |
Group of answer choices
A. shut down because AVC is not covered
B. 3 tubes at a total profit of $8
C. 4 tubes at a total profit of $6
D. 4 tubes at a total profit of $1.50
E. shut down because ATC is not covered
F. none of the above
2.
Monopoly is inefficient because
A. Group of answer choices production is not at minimum ATC
B. marginal revenue (MR) does not equal marginal cost (MC)
C. Price < Marginal cost
D. None of the above
E. added resources would be more valuable to society as inputs into the monopolized industry than where they are currently being used
3. (a)
Twenty-Twenty, LLC is a chartered monopoly supplier of fashion glasses frames and it produces with the following costs (shown below). What would Twenty-Twenty's output be?
| Cost | |||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 |
7 |
|
Total Cost ($) |
$5 | 8 | 9 | 16 | 25 | 36 | 49 |
|
Demand |
|||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Price | $13 | 12.50 | 12 | 11.50 | 11 | 10.50 | 10 |
Group of answer choices
A. none of the above
B. 3
C. 1
D. 0
E. 5
3(b)
Twenty-Twenty, LLC is a chartered monopoly producer of fashion glasses frames and it produces with the following demand and costs schedule (shown below). At the profit maximizing level of output, what will Twenty-Twenty's profits be? What would Twenty-Twenty's output be?
| Cost | |||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 |
7 |
|
Total Cost ($) |
$5 | 8 | 9 | 16 | 25 | 36 | 49 |
|
Demand |
|||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Price | $13 | 12.50 | 12 | 11.50 | 11 | 10.50 | 10 |
Group of answer choices
A. $11
B. $0
C. $30
D. None of the above
E. $35
3(C)
Twenty-Twenty, LLC is a monopolist producer of fashion glasses frames. It produces with the following cost and demand schedule (shown in the table below). At the profit maximizing output. the difference between Price and Marginal Cost would be: What would Twenty-Twenty's output be?
| Cost | |||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 |
7 |
|
Total Cost ($) |
$5 | 8 | 9 | 16 | 25 | 36 | 49 |
|
Demand |
|||||||
| Qty | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Price | $13 | 12.50 | 12 | 11.50 | 11 | 10.50 | 10 |
Group of answer choices
A. 2
B. $5
C.$6
D. $4.50
E. 0
F. none of the above
In: Economics
In: Accounting
Material cost = $40 per unit
Labor hours = 10 per unit for the first unit, Labor cost = $10/hour
List the material and labor cost and labor + material cost for the first 8 units when the supplier utilizes a learning curve of 85%.
PLEASE PROVIDE THE FORMULA SO I ACTUALLY KNOW HOW TO DO THIS STUFF.
|
Unit |
Material Cost |
Labor Cost |
Total Cost |
|
1 |
$40 |
||
|
2 |
$80 |
||
|
3 |
120 |
||
|
4 |
$160 |
||
|
5 |
$200 |
||
|
6 |
$240 |
||
|
7 |
$280 |
||
|
8 |
$320 |
In: Accounting
4. Prepare a Budget that estimates direct labor hours and related costs needed to support budgeted production.direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a Budget that estimates the cost for each item of factory overhead needed to support budgeted production.factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
|
|||
|
|||
| Direct materials: | |||
|
|||
|
|||
| Cost of direct materials available for use | |||
|
|||
| Cost of direct materials placed in production | |||
|
|||
|
|||
| Total manufacturing costs | |||
| Total work in process during the period | |||
|
|||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
|
|||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
|
|||
|
|||
|
|||
| Selling and administrative expenses: | |||
|
|||
|
|||
| Total selling and administrative expenses | |||
|
|||
| Other revenue: | |||
|
|||
| Other expenses: | |||
|
|||
|
|||
|
|||
|
$ | ||
Feedback
Loading item
There was an error loading this item. If this continues to occur, please contact Technical Support.
Check My Work1 more Check My Work uses remaining.
Basic Calculatorclose
0
UseEntBSBSpCEHomCEnd
789+
456-
123*
0.=/
In: Accounting