Question

In: Accounting

Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...

Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow:

Finished Components
C12 D57
Requirements for each finished component:
RM 1 10 pounds 8 pounds
RM 2 0 4 pounds
RM 3 2 pounds 1 pound
Direct labor 2 hours 3 hours
Product information:
Sales price $ 170 $ 200
Sales (units) 12,000 9,000
Estimated beginning inventory (units) 410 110
Desired ending inventory (units) 300 200
Direct Materials Information
RM1 RM2 RM3
Cost per pound $ 2 $ 2.50 $ 0.50
Estimated beginning inventory in pounds 2,900 1,400 700
Desired ending inventory in pounds 3,900 1,500 1,800

The firm expects the average wage rate to be $25 per hour in 2019. Spring Manufacturing uses direct labor hours to apply overhead. Each year the firm determines the overhead application rate for the year based on budgeted direct labor hours for the year. The firm maintains negligible Work-in-Process Inventory and expects the cost per unit for both beginning and ending inventories of finished products to be identical.

Factory
Overhead
Information
Indirect materials—variable $ 10,000
Miscellaneous supplies and tools—variable 4,500
Indirect labor—variable 45,000
Supervision—fixed 170,000
Payroll taxes and fringe benefits—variable 200,000
Maintenance costs—fixed 25,000
Maintenance costs—variable 10,130
Depreciation—fixed 71,330
Heat, light, and power—fixed 43,470
Heat, light, and power—variable 10,000
Total $ 589,430
Selling and
Administrative
Expense Information
Advertising $ 63,000
Sales salaries 160,000
Travel and entertainment 63,000
Depreciation—warehouse 5,000
Office salaries 61,000
Executive salaries 260,000
Supplies 4,000
Depreciation—office 5,900
Total $ 621,900

The effective income tax rate for the company is 50%.

Required:

1. Prepare the Sales budget for 2019.

2. Prepare the Production budget for 2019.

3. Prepare the Direct materials purchases budget (units and dollars) for 2019.

4. Prepare the Direct labor budget for 2019.

5. Prepare the Factory overhead budget for 2019.

6. Prepare the Cost of goods sold and ending finished goods inventory budgets for 2019.

7. Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses, and Administrative Expenses for 2019.

8. Prepare the Budgeted income statement, the last item of which is labeled After-tax Operating Income for 2019.

Solutions

Expert Solution


Related Solutions

Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 200 $ 210 Sales (units) 12,000 12,000 Estimated beginning inventory (units) 420 110 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 170 $ 200 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 410 110 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 160 $ 180 Sales (units) 12,000 10,000 Estimated beginning inventory (units) 410 110 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $150 $220 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 400 150 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost per pound...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 200 $ 210 Sales (units) 12,000 12,000 Estimated beginning inventory (units) 420 110 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 190 $ 230 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 410 130 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 200 $ 220 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 430 160 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow:
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2019 follow: Finished Components C12 D57 Requirements for each finished component: RM 1 10 pounds 8 pounds RM 2 0 4 pounds RM 3 2 pounds 1 pound Direct labor 2 hours 3 hours Product information: Sales price $ 180 $ 240 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 450 190 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM2 RM3 Cost...
Ginger LLC makes two products identified as G1 and G2. Selected data for 2018 follow: Requirements...
Ginger LLC makes two products identified as G1 and G2. Selected data for 2018 follow: Requirements for each finished product (Raw Materials & Labor): G1 G2 H1 (pounds) 12 10 H2 (pounds) 0 2 H3 (pounds) 2 1 Direct Labor (hours) 2 3 Other Product Information: G1 G2 Sales price ($) $155 $225 Sales (units) 11,500 9,500 Estimated beginning inventory (units) 400 150 Desired ending inventory (units) 300 200 H1 H2 H3 Cost per pound $2.00 $2.50 $0.50 Estimated beginning...
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two...
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1,000 units of each of the other...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT