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 $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 $ 2.00 $ 2.50 $ 0.50
Estimated beginning inventory in pounds 3,000 1,500 1,000
Desired ending inventory in pounds 4,000 1,000 1,500

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 5,000
Indirect labor—variable 40,000
Supervision—fixed 120,000
Payroll taxes and fringe benefits—variable 250,000
Maintenance costs—fixed 20,000
Maintenance costs—variable 10,080
Depreciation—fixed 71,330
Heat, light, and power—fixed 43,420
Heat, light, and power—variable 11,000
Total $ 580,830
Selling and
Administrative
Expense Information
Advertising $ 60,000
Sales salaries 200,000
Travel and entertainment 60,000
Depreciation—warehouse 5,000
Office salaries 60,000
Executive salaries 250,000
Supplies 4,000
Depreciation—office 6,000
Total $ 645,000

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

Spring Manufacturing Company has had a continuous improvement (kaizen) program for the last two years. According to the kaizen program, the firm is expected to manufacture C12 and D57 with the following specifications:

Cost Element C12 D57
Raw material 1 9 lbs. 7 lbs.
Raw material 2 0 3.6 lbs.
Raw material 3 1.8 lbs. 0.8 lb.
Direct labor 1.5 hrs. 2 hrs.

The company specifies that the variable factory overhead is to decrease by 10% while the fixed factory overhead is to decrease by 5%, except for depreciation expenses. The company does not expect the price of the raw materials to change. However, the hourly wage rate is likely to be $30.

Required:

Assume the firm can attain the expected operating level as prescribed by the kaizen program:

1-a. Prepare the Sales budget for 2019.

1-b. Prepare the Production budget for 2019.

1-c. Prepare the Direct materials purchases budget (units and dollars) for 2019.

1-d. Prepare the Direct labor budget for 2019.

1-e. Prepare the Factory overhead budget for 2019.

1-f. Prepare the Cost of goods sold and ending finished goods inventory budgets for 2019.

1-g. Prepare the Selling and administrative expense budget for 2019.

1-h. Prepare the 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 $ 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 $ 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