Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please all parts of this question as this is all one question thanks Spring Manufacturing Company makes two components identified as C12 and D57. Selected
please all parts of this question as this is all one question thanks
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022 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 $ 240 Sales (units) 12,000 9,000 Estimated beginning inventory (units) 370 200 Desired ending inventory (units) 300 200 Direct Materials Information RM1 RM3 Cost per pound $6 $ 1.50 $ 0.50 Estimated beginning inventory in pounds 3,200 1,600 800 Desired ending inventory in pounds 4,100 900 1,200 The firm expects the average wage rate to be $25 per hour in 2022. 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 RM2 Indirect material variable Miscellaneous supplies and tools-variable Indirect labor-variablo Supervision-fixed Payroll taxes and fringe benefits-variable Maintenance costs fixed Maintenance costs-variable Depreciation-fixed Heat, light, and power-fixed Heat, light, and power-variable Total Factory Overhead Information $ 10,000 4,700 41,000 110,000 260,000 20,000 10,030 71,290 43,440 10,000 $ 580, 460 Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation office Total Selling and Administrative Expense Information $ 58,000 250,000 60,000 5,300 60,000 300,000 3,800 6,000 $ 743, 100 The effective income tax rate for the company is 40% Required: 1. Prepare the Sales budget for 2022 2. Prepare the Production budget for 2022 3. Prepare the Direct materials purchases budget (units and dollars) for 2022. 4. Prepare the Direct labor budget for 2022 5. Prepare the factory overhead budget for 2022 6. Prepare the cost of goods sold and ending finished goods inventory budgets for 2022. 7. Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses and Administrative Expenses for 2022 8. Prepare the Budgeted income statement, the last item of which is labeled After-tax Operating Income for 2022 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Rudneted inema catamant that Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Sales budget for 2022. SPRING MANUFACTURING COMPANY Sales Budget For the Year 2022 C12 D57 Total Sales (in units) Selling price per unit Total sales revenue Required 1 Required 2 > Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Requir Prepare the Production budget for 2022. SPRING MANUFACTURING COMPANY Production Budget For the Year 2022 C12 D57 Budgeted sales (in units) Total units needed Budgeted production (in units) Required 2 Required 3 Required 1 Required 4 Required 5 Requi Required 6 Prepare the Direct materials purchases budget (units and dollars) for 2022. (Round "Cost per SPRING MANUFACTURING COMPANY Direct Materials Purchases Budget (units and dollars) For the Year 2022 C12 D57 Total Raw material (RM) 1: Budgeted production RM 1 needed for production Total RM 1 needed (lbs.) Required purchases of RM 1 (lbs.) Budgeted purchases, RM 1 Raw material (RM) 2 Budgeted production RM 2 needed for production Total RM 2 needed (lbs.) Required 1 R Required 2 Re Required 3 Required 4 Required 5 Required 6 Prepare the Direct labor budget for 2022. SPRING MANUFACTURING COMPANY Direct Labor Budget For the Year 2022 C12 D57 Total Budgeted production Total direct labor hours needed Budgeted direct labor costs compiere is question by enteriny y Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Prepare the Factory overhead budget for 2022. SPRING MANUFACTURING COMPANY Factory Overhead Budget For the Year 2022 Variable factory overhead: Fixed factory overhead: Total cash fixed factory overhead Total budgeted factory overhead Required 1 Required 2 Requir Required 3 Required 4 Required 5 Required 6 Prepare the cost of goods sold and ending finished goods inventory budgets for 2022. (Round to 2 decimal places.) SPRING MANUFACTURING COMPANY Ending Finished Goods Inventory and Budgeted CGS For the Year 2022 C12 D57 Total Sales volume 21,000 Cost of goods sold Ending finished goods inventory Budgeted ending inventories Required 1 Required 2 Required 3 Required 4 Required 5 Red Required 6 Required 7 Prepare the Selling and administrative expense budget, broken down into two components: Selling Exper Administrative Expenses for 2022. SPRING MANUFACTURING COMPANY Selling and Administrative Expense Budget For the Year 2022 Selling expenses: Administrative expenses: Total selling and administrative expenses Required 2 Required 1 Required 3 Required 4 Required 5 Required 6 Required 8 WE Required 7 Prepare the Budgeted income statement, the last item of which is labeled After-tax Operating Income for 2022. (Ro Intermediate calculations to 2 decimal places.) SPRING MANUFACTURING COMPANY Budget Income Statement For the Year 2022 C12 D57 Total Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started