Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022 follow: Requirements for each finished component: RM 1 RM 2 RM 3 Direct labor Product information: Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds. Finished Components C12 D57 10 pounds 0 8 pounds 4 pounds 2 pounds 2 hours $ 160 12,000 370 300 Direct Materials Information 1 pound 3 hours $ 190 12,000 190 200 RM1 $ 5 3,400 3,500 RM2 $ 1.50 2,000 1,000 RM3 $ 0.50 700 2,000 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. Indirect materials-variable Miscellaneous supplies and tools-variable Indirect labor-variable 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 $ 15,000 4,500 40,000 90,000 300,000 21,000 10,070 71,340 43,430 10,000 Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling and Administrative Expense Information $ 61,000 170,000 65,000 4,700 The effective income tax rate for the company is 40%. 61,000 250,000 4,500 6,200 $ 622,400 $ 605,340 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 Direct materials purchases budget (units and dollars) for 2022. (Round "Cost per pound" to 2 decimal places.) SPRING MANUFACTURING COMPANY Direct Materials Purchases Budget (units and dollars) Raw material (RM) 1: Budgeted production Pounds per unit RM 1 needed for production Add: Desired ending inventory (lbs.) Total RM 1 needed (lbs.) Less: Beginning inventory (lbs.) Required purchases of RM 1 (lbs.) Cost per pound Budgeted purchases, RM 1 For the Year 2022 C12 D57 Total 11,930 12,010 10 8 119,300 96,080 215,380 215,380 215,380 0 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 Direct labor budget for 2022. Budgeted production Direct labor hours per unit SPRING MANUFACTURING COMPANY Total direct labor hours needed Hourly wage rate Budgeted direct labor costs Direct Labor Budget For the Year 2022 C12 D57 Total 0 0 0 $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Factory overhead budget for 2022. SPRING MANUFACTURING COMPANY Variable factory overhead: Heat, light, and power Indirect labor Indirect materials Maintenance costs Factory Overhead Budget For the Year 2022 Miscellaneous supplies and tools Payroll taxes and fringe benefits Fixed factory overhead: Heat, light, and power Supervision Maintenance costs Total cash fixed factory overhead $ 0 Total budgeted factory overhead 0 $ 0 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses and Administrative Expenses for 2022. SPRING MANUFACTURING COMPANY Selling and Administrative Expense Budget For the Year 2022 Selling expenses: Advertising Depreciation-warehouse Travel and entertainment Sales salaries Administrative expenses: Depreciation-office Office salaries Executive salaries $ 0 Supplies $ 0 Total selling and administrative expenses $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Budgeted income statement, the last item of which is labeled After-tax Operating Income for 2022. (Round your intermediate calculations to 2 decimal places.) SPRING MANUFACTURING COMPANY Sales Cost of goods sold Gross profit Selling and administrative expenses Pre-tax operating income Income taxes After-tax operating income Budget Income Statement For the Year 2022 C12 D57 Total $ 0 0 $ 0 $ 0 $ 0 $ 0 $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Cost of goods sold and ending finished goods inventory budgets for 2022. (Round your intermediate calculatio to 2 decimal places.) Sales volume SPRING MANUFACTURING COMPANY Ending Finished Goods Inventory and Budgeted CGS For the Year 2022 C12 Cost per unit Cost of goods sold Ending finished goods inventory Cost per unit Budgeted ending inventories D57 Total 24,000 $ 0 $ 0 $ 0 EA 0 EA 0 EA $ 0 Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022 follow: Requirements for each finished component: RM 1 RM 2 RM 3 Direct labor Product information: Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds. Finished Components C12 D57 10 pounds 0 8 pounds 4 pounds 2 pounds 2 hours $ 160 12,000 370 300 Direct Materials Information 1 pound 3 hours $ 190 12,000 190 200 RM1 $ 5 3,400 3,500 RM2 $ 1.50 2,000 1,000 RM3 $ 0.50 700 2,000 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. Indirect materials-variable Miscellaneous supplies and tools-variable Indirect labor-variable 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 $ 15,000 4,500 40,000 90,000 300,000 21,000 10,070 71,340 43,430 10,000 Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling and Administrative Expense Information $ 61,000 170,000 65,000 4,700 The effective income tax rate for the company is 40%. 61,000 250,000 4,500 6,200 $ 622,400 $ 605,340 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 Direct materials purchases budget (units and dollars) for 2022. (Round "Cost per pound" to 2 decimal places.) SPRING MANUFACTURING COMPANY Direct Materials Purchases Budget (units and dollars) Raw material (RM) 1: Budgeted production Pounds per unit RM 1 needed for production Add: Desired ending inventory (lbs.) Total RM 1 needed (lbs.) Less: Beginning inventory (lbs.) Required purchases of RM 1 (lbs.) Cost per pound Budgeted purchases, RM 1 For the Year 2022 C12 D57 Total 11,930 12,010 10 8 119,300 96,080 215,380 215,380 215,380 0 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 Direct labor budget for 2022. Budgeted production Direct labor hours per unit SPRING MANUFACTURING COMPANY Total direct labor hours needed Hourly wage rate Budgeted direct labor costs Direct Labor Budget For the Year 2022 C12 D57 Total 0 0 0 $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Factory overhead budget for 2022. SPRING MANUFACTURING COMPANY Variable factory overhead: Heat, light, and power Indirect labor Indirect materials Maintenance costs Factory Overhead Budget For the Year 2022 Miscellaneous supplies and tools Payroll taxes and fringe benefits Fixed factory overhead: Heat, light, and power Supervision Maintenance costs Total cash fixed factory overhead $ 0 Total budgeted factory overhead 0 $ 0 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses and Administrative Expenses for 2022. SPRING MANUFACTURING COMPANY Selling and Administrative Expense Budget For the Year 2022 Selling expenses: Advertising Depreciation-warehouse Travel and entertainment Sales salaries Administrative expenses: Depreciation-office Office salaries Executive salaries $ 0 Supplies $ 0 Total selling and administrative expenses $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Budgeted income statement, the last item of which is labeled After-tax Operating Income for 2022. (Round your intermediate calculations to 2 decimal places.) SPRING MANUFACTURING COMPANY Sales Cost of goods sold Gross profit Selling and administrative expenses Pre-tax operating income Income taxes After-tax operating income Budget Income Statement For the Year 2022 C12 D57 Total $ 0 0 $ 0 $ 0 $ 0 $ 0 $ 0 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Prepare the Cost of goods sold and ending finished goods inventory budgets for 2022. (Round your intermediate calculatio to 2 decimal places.) Sales volume SPRING MANUFACTURING COMPANY Ending Finished Goods Inventory and Budgeted CGS For the Year 2022 C12 Cost per unit Cost of goods sold Ending finished goods inventory Cost per unit Budgeted ending inventories D57 Total 24,000 $ 0 $ 0 $ 0 EA 0 EA 0 EA $ 0
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A bottled water distributor wants to determine whether the mean amount of water contained in 1-gallon bottles purchased from a nationally known water bottling company is actually 1 gallon. You know...
-
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2010 follow: The firm expects the average wage rate to be $25 per hour in 2010. Spring...
-
Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2022 follow: The firm expects the average wage rate to be $25 per hour in 2022. Spring...
-
In a given week, 12 babies are born in hospital. Assume that this sample came from an underlying normal population. The length of each baby is routinely measured and is listed below (in cm): 49, 50,...
-
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $ 12 and will increase by $ 0.50 each year....
-
The iodine bromide molecule, IBr, is an inter-halogen compound. Assume that the molecular orbitals of IBr are analogous to the homo nuclear diatomic molecule F2. (a) Which valence atomic orbitals of...
-
What kinds of foreign exchange risk would a U.S. company face that is exporting goods to Mexico? What kinds of things would you monitor to determine what will happen to the value of the Mexican peso?
-
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company...
-
K estion 16 of Find the z-score for the value 90, when the mean is 59 and the standard deviation is 4 OA. z=7.50 OB. z=7.75 OC. z=1.46 OD. z=-1.46
-
3 DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production....
-
You have been hired to lead a software project to design a Library Management System (LMS) for your local library at Jonesville. The library has been managed manually using written documentation to...
-
STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls from the mill and cuts the...
-
One of the things that you absolutely have to know how to do in an online class is how to hand things in. Sounds kind of silly, but I will never be accepting paper from you in any format whatsoever....
-
Assuming frictionless, incompressible, one-dimensional flow of water through the horizontal tee connection sketched in the figure below, estimate values of (a) the x and (b) y components of the force...
-
Many managers and executives are too rushed to read long journal articles, but they are eager to stay current in their fields. Assume that your boss has asked you to help him/her to stay abreast of...
-
5 Summarize the reasons why capacity is lost on some days in mid-season. What could be done to reduce this problem?
-
Find a polar equation for the curve represented by the given Cartesian equation. 4y 2 = x
-
Tektronix, Inc., an Oregon-based MNE, manufactures scientific instruments. Jerry Davies, Treasurer, needs to choose an instrument to hedge a \( 2,000,000\) sale to Siemens in Germany, with payment...
-
Call Options on British Pounds (Option.xls) The set of assumptions used throughout the second half of this chapter assumed a spot rate of \(\$ 1.70 / \), a 90 -day maturity, U.S. dollar and British...
-
Jos Ballini is a currency trader and speculator for Bozano Simonsen, one of the largest investment banking firms in So Paulo. The current spot rate is \(\mathrm{R} \$ 1.7800 / \$\), and the 360 -day...
Study smarter with the SolutionInn App