Question

In: Accounting

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                                       1,500

Total budgeted costs                           $107,450

CAPSTONE, INC.

Manufacturing Overhead Costs (Actual)

For the Month of March 2020

Production in units                             118,500

Costs

Indirect materials                     $ 5,910

Indirect labor                             14,195

Utilities                                      11,880

Maintenance                                8,275

Salaries                                      45,000

Depreciation                              16,800

Property taxes                          3,000

Insurance                                     1,200

Janitorial                                      1,500

Total costs                                          $107,760

Capstone, Inc. produced 118,500 units in March rather than the budgeted number of units.

Instructions

  1. Prepare a flexible overhead budget based on the following amounts produced.
    1. 115,500 units
    2. 116,500 units
    3. 117,500 units
    4. 118,500 units
    5. 119,500 units
  1. Prepare a flexible budget report showing the differences (favorable and unfavorable) in manufacturing overhead costs for the month of March.

  1. Prepare a performance report for the manufacturing overhead for March, assuming only variable costs are controllable.

Solutions

Expert Solution

First we will calculate overhaed rate
Variable Rate
Indirect materials       I       5875/117500 $0.05
Indirect labor            L   14100/117500 0.12
Utilities                    U              11750/117500 0.1
Maintenance           M                8225/117500 0.07
ans 1 Flexible Overhead Budget
For the month ended March
Budgeted production B 115500 116500 117500 118500 119500
Budgetd cost in $
Indirect materials       I *B 5775 5825 5875 5925 5975
Indirect labor            L *B 13860 13980 14100 14220 14340
Utilities                    U *B            11550 11650 11750 11850 11950
Maintenance           M*B                8085 8155 8225 8295 8365
Salaries                                      45000 45000 45000 45000 45000
Depreciation                         16800 16800 16800 16800 16800
Property taxes                          3000 3000 3000 3000 3000
Insurance                                1200 1200 1200 1200 1200
Janitorial 1500 1500 1500 1500 1500
Total budgeted cost 106770 107110 107450 107790 108130
ans 2
Flexible Budget Report
For the month ended March Budget Actual Variance
Production 118500 118500
Indirect materials       I *B 5925 5910 15 Unfavorable
Indirect labor            L *B 14220 14195 25 Unfavorable
Utilities                    U *B            11850 11880 30 Favorable
Maintenance           M*B                8295 8275 20 Unfavorable
Total variable cost V 40290 40260 30 Unfavorable
Fixed cost
Salaries                                      45000 45000 0 None
Depreciation                         16800 16800 0 None
Property taxes                          3000 3000 0 None
Insurance                                1200 1200 0 None
Janitorial 1500 1500 0 None
Total Fixed cost F 67500 67500 0 None
Total Manufacturing overhead V+F 107790 107760 30 Unfavorable
ans 3
Performace report
Manufacturing overhead
For the month ended March
Budget Actual
Indirect materials       I *B 5925 5910 15 Unfavorable
Indirect labor            L *B 14220 14195 25 Unfavorable
Utilities                    U *B            11850 11880 30 Favorable
Maintenance           M*B                8295 8275 20 Unfavorable
40290 40260 30 Unfavorable
If any d oubt please comment

Related Solutions

4. Capstone, Inc. (Chapter 9) Capstone, Inc. is preparing its budget for the coming year, 2020....
4. Capstone, Inc. (Chapter 9) Capstone, Inc. is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. Capstone, Inc. gathered the following information from the managers. Sales Unit sales for November 2019                       113,000 Unit sales for December 2019                        103,000 Expected unit sales for January 2020                        115,000 Expected unit sales for February 2020           114,500 Expected unit sales for March 2020               118,000 Expected...
4. Capstone, Inc. (Chapter 9) Capstone, Inc. is preparing its budget for the coming year, 2020....
4. Capstone, Inc. (Chapter 9) Capstone, Inc. is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. Capstone, Inc. gathered the following information from the managers. Sales Unit sales for November 2019                       113,000 Unit sales for December 2019                        103,000 Expected unit sales for January 2020                        115,000 Expected unit sales for February 2020           114,500 Expected unit sales for March 2020               118,000 Expected...
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...
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...
3. Capstone, Inc. (Chapter 8) Part 1 Capstone, Inc. mass-produces a special connector unit that it...
3. Capstone, Inc. (Chapter 8) Part 1 Capstone, Inc. mass-produces a special connector unit that it normally sells for $4.25. It sells approximately 45,000 of these units each year. The variable costs for each unit are $2.50. A company in Canada that has been unable to produce enough of a similar connector to meet customer demand would like to buy 25,000 of these units at $3.00 per unit. The production of these units is near full capacity at Capstone, Inc.,...
3. Capstone, Inc. (Chapter 8) Part 1 Capstone, Inc. mass-produces a special connector unit that it...
3. Capstone, Inc. (Chapter 8) Part 1 Capstone, Inc. mass-produces a special connector unit that it normally sells for $4.25. It sells approximately 45,000 of these units each year. The variable costs for each unit are $2.50. A company in Canada that has been unable to produce enough of a similar connector to meet customer demand would like to buy 25,000 of these units at $3.00 per unit. The production of these units is near full capacity at Capstone, Inc.,...
7. Capstone, Inc. (Chapter 12) Capstone, Inc. puts much emphasis on cash flow when it plans...
7. Capstone, Inc. (Chapter 12) Capstone, Inc. puts much emphasis on cash flow when it plans for capital investments. The company chose its discount rate of 8% based on the rate of return it must pay its owners and creditors. Using that rate, Capstone, Inc. then uses different methods to determine the best decisions for making capital outlays. In 2020 Capstone, Inc. is considering buying five new backhoes to replace the backhoes it now has. The new backhoes are faster,...
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...
Capstone, Inc. (Chapter 7) The VP for Sales and Marketing, Morgan Lusk, is trying to plan...
Capstone, Inc. (Chapter 7) The VP for Sales and Marketing, Morgan Lusk, is trying to plan for the coming year in terms of production needs to meet the sales demand. She is also trying to determine ways in which the company’s profits might be increased in the coming year. Instructions Capstone, Inc. markets a simple water control and timer that it mass-produces. During 2019, the company sold 650,000 units at an average selling price of per solution $10.00 per unit....
Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies to the...
Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.34 per pound) 50 pounds 90 pounds Corrugating medium ($0.17 per pound) 40...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT