Question
In: Accounting
Waterways Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual...
Waterways
Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual overhead for March. (Refer to Waterways 9 if you are uncertain about variable versus fixed costs.)
Waterways Corporation Waterways Corporation
Manufacturing Overhead Budget Manufacturing Overhead Costs (Actual)
(Static) For the Month of March For the Month of March
|
Budgeted Production (Units) |
118,000 |
Production in units |
118,500 |
|
|
Indirect materials |
$ 5,900 |
Indirect materials |
$ 5,910 |
|
|
Indirect labor |
14,160 |
Indirect labor |
14,195 |
|
|
Utilities |
11,800 |
Utilities |
11,880 |
|
|
Maintenance |
8,260 |
Maintenance |
8,275 |
|
|
Salaries |
42,000 |
Salaries |
42,100 |
|
|
Depreciation |
16,800 |
Depreciation |
16,800 |
|
|
Property taxes |
3,000 |
Property taxes |
3,000 |
|
|
Insurance |
1,200 |
Insurance |
1,200 |
|
|
Janitorial |
1,500 |
Janitorial |
1,650 |
|
|
Total budgeted costs |
$104,620 |
Total costs |
$105,010 |
Waterways produced 118,500 units in March rather than the budgeted number of units.
Instructions:
a. Prepare a flexible budget overhead budget based on the following amounts produced.
(1) 115,000 units
(2) 116,000 units
(3) 117,000 units
(4) 118,000 units
(5) 119,000 units
b. Prepare a flexible budget performance report showing the differences (favorable and unfavorable) in manufacturing overhead costs for the month of March.
c. Prepare a responsibility report for the manufacturing overhead for March assuming only variable costs are controllable.
Solutions
Expert Solution
| a) Water Way Corporation | |||||||
| Manufacturing Overhead Flexible Budget | |||||||
| Prodution Unit | |||||||
| Production in Unit | Per Unit Cost | 118000 | 115000 | 116000 | 117000 | 118500 | 119000 |
| Variable Cost | |||||||
| Indirect Materal | $0.05 | $5,900 | $5,750 | $5,800 | $5,850 | $5,925 | $5,950 |
| Indirect Labour | $0.12 | $14,160 | $13,800 | $13,920 | $14,040 | $14,220 | $14,280 |
| Utilities | $0.10 | $11,800 | $11,500 | $11,600 | $11,700 | $11,850 | $11,900 |
| Maintainance | $0.07 | $8,260 | $8,050 | $8,120 | $8,190 | $8,295 | $8,330 |
| Fixed Cost | |||||||
| Salaries | $42,100 | $42,100 | $42,100 | $42,100 | $42,100 | $42,100 | |
| Depreciation | $16,800 | $16,800 | $16,800 | $16,800 | $16,800 | $16,800 | |
| Property Tax | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Insurance | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
| Janitorial | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | |
| Total Budgeted Cost | $1,04,870 | $1,03,850 | $1,04,190 | $1,04,530 | $1,05,040 | $1,05,210 | |
| b) Water Way Corporation | |||||
| Manufacturing Overhead Flexible Budget Report | |||||
| Budget | Actual | Difference | |||
| Production in Unit | 118500 | 118500 | |||
| Variable Cost | |||||
| Indirect Materal | $5,925 | $5,910 | $15 | F | |
| Indirect Labour | $14,220 | $14,195 | $25 | F | |
| Utilities | $11,850 | $11,880 | -$30 | U | |
| Maintainance | $8,295 | $8,275 | $20 | F | |
| Fixed Cost | |||||
| Salaries | $42,100 | $42,100 | $0 | ||
| Depreciation | $16,800 | $16,800 | $0 | ||
| Property Tax | $3,000 | $3,000 | $0 | ||
| Insurance | $1,200 | $1,200 | $0 | ||
| Janitorial | $1,650 | $1,650 | $0 | ||
| Total Budgeted Cost | $1,05,040 | $1,05,010 | $30 | F | |
| Waterway Corporation | ||||
| Responsibility Report | ||||
| Manufacturing Overhead | ||||
| Controllable Cost | Budget | Actual | Difference | |
| Indirect Materal | $5,925 | $5,910 | $15 | F |
| Indirect Labour | $14,220 | $14,195 | $25 | F |
| Utilities | $11,850 | $11,880 | -$30 | U |
| Maintainance | $8,295 | $8,275 | $20 | F |
| $40,290 | $40,260 | $30 | F | |
ekkarill92 answered 2 years agoRelated Solutions
Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual overhead...
Waterways Corporation is continuing its budget preparations.
Waterways had the following static budget and actual overhead costs
for March. WATERWAYS CORPORATION Manufacturing Overhead Budget
(Static) For the Month of March Budgeted production in units
123,000 Budgeted costs Indirect materials $6,150 Indirect labor
14,760 Utilities 12,300 Maintenance 8,610 Salaries 43,800
Depreciation 16,100 Property taxes 3,000 Insurance 1,200 Janitorial
1,600 Total budgeted costs $107,520 WATERWAYS CORPORATION
Manufacturing Overhead Costs (Actual) For the Month of March
Production in units 124,000 Costs Indirect materials...
Waterways Continuing Problem 09 Waterways Corporation is preparing its budget for the coming year, 2020. The...
Waterways Continuing Problem 09
Waterways Corporation is preparing its budget for the coming
year, 2020. The first step is to plan for the first quarter of that
coming year. The company has gathered information from its managers
in preparation of the budgeting process.
Sales
Unit sales for November 2019
111,000
Unit sales for December 2019
101,000
Expected unit sales for January 2020
112,000
Expected unit sales for February 2020
112,000
Expected unit sales for March 2020
116,000
Expected unit sales...
5. Capstone, Inc. (Chapter 9) Capstone, Inc. is continuing its budget preparations and had the following...
5. Capstone, Inc. (Chapter 9)
Capstone, Inc. is continuing its
budget preparations and had the following static budget and
overhead costs for March 2020.
CAPSTONE, INC.
Manufacturing Overhead Budget
(Static)
For the Month of March 2020
Budgeted production in units
117,500
Budgeted costs
Indirect materials
$ 5,875
Indirect labor
14,100
Utilities
11,750
Maintenance
8,225
Salaries
45,000
Depreciation
16,800
Property taxes
3,000
Insurance
1,200
Janitorial...
Waterways for Chapter 9 Waterways Corporation is preparing its budget for the coming year. The first...
Waterways for Chapter 9
Waterways Corporation is preparing its budget for the coming
year. The first step is to plan for the first quarter of that
coming year. Waterways gathered the following information from the
managers.
Sales:
Actual unit sates for November
113,500
Actual unit sales for December
103,100
Expected unit sales for January
114,000
Expected unit sales for February
113,500
Expected unit sales for March
116,000
Expected unit sales for April
126,000
Expected unit sales for May
138,500
Unit...
You are given the following static budget report: Budget Actual Variance Unit Sales  
You are given the following static budget report:
Budget Actual Variance
Unit
Sales 10,000 15,000 5,000
F
Variable Expenses:
Commissions $30,000
$33,000 $3,000 U
Advertising $1,000
$1,200 $200 U
Travel $10,000
$11,000 $1,000 U
Samples $2,500
$2,300 $200 F
Total
Variable $43,500
47,500 $4,000 U
Fixed Expenses
Rent $5,000
$5,000 0
Salaries –
Sales $2,000
$2,000 0
Salaries –
Office $1,200
$1,200 0
Depreciation $1,500
$1,500 0
Total
Fixed $9,700
$9,700 0
Total Expenses $53,200 $57,200 $4,000 U
Prepare a flexible budget analysis and explain whether you
believe that costs were controlled. How do the results
of...
Waterways Continuing Problem 06 (Part 2) Waterways packages some of its products into sets for home...
Waterways Continuing Problem 06 (Part 2)
Waterways packages some of its products into sets for home
installations. One set (small) sells for $75 with variable costs of
production for the set at $51. Another set (large) sells for $147
with variable costs of $101. The parts for the $75 set take 8
machine hours to produce. The parts for the $147 set take 20
machine hours to produce.
Given the information above, and assuming all of the package sets
produced...
In addition to the static budget, the clinic also created a flexible and actual budget to...
In addition to the static budget, the clinic also created a
flexible and actual budget to reflect the realized volume &
actual volume respectively (see table below). Fill in the blanks on
the table below & answer the following questions using the
numbers from the table:
a-Calculate & interpret the profit variance
b-Calculate and interpret the revenue variance
c-Calculate & interpret the cost variance
d-Calculate & interpret the volume & price variances on
the revenue side
e-Calculate & interpret the...
In addition to the static budget , the clinic also created a flexible and actual budget...
In addition to the static budget , the clinic also created a
flexible and actual budget to reflect the realized volume &
actual volume, respectively. Fill in the blanks on the table below
& answer the questions using the numbers in the table
a)calculate & interpret the profit variance? (b) calculate
& interpret the revenue variance (c) calculate & interpret
the cost variance (d) calculate & interpret the volume &
price variances on the revenue side (e)calculate & interpret
the...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming
year, 2020. The first step is to plan for the first quarter of that
coming year. The company has gathered information from its managers
in preparation of the budgeting process.
Sales
Unit sales for November 2019
111,000
Unit sales for December 2019
101,000
Expected unit sales for January 2020
112,000
Expected unit sales for February 2020
114,000
Expected unit sales for March 2020
115,000
Expected unit sales for April 2020
124,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming
year, 2020. The first step is to plan for the first quarter of that
coming year. The company has gathered information from its managers
in preparation of the budgeting process.
Sales
Unit sales for November 2019
114,000
Unit sales for December 2019
103,000
Expected unit sales for January 2020
114,000
Expected unit sales for February 2020
111,000
Expected unit sales for March 2020
116,000
Expected unit sales for April 2020
125,000...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
- Samsung Industry that requires you to act as a change agent to form an organizational change...
- Use fork() Create a program that reads characters from an input file. Use fork to create...
- A pension fund manager is considering three mutual funds. The first is a stock fund, the...
- Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not...
ADVERTISEMENT