Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer 1-4 please 1. What were the 2022 annual budgeted indirect cost rates for the manufacturing operations activity and the machine setup activity? 2. Was

Answer 1-4 please
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1. What were the 2022 annual budgeted indirect cost rates for the manufacturing operations activity and the machine setup activity? 2. Was overhead over- or under-applied for the year? By how much? 3. What was the 2022 unit product cost for the basic and premium T-shirts under Normal costing? 4. What was the T-shirt Division's operating income for 2022? Use Normal costing and adjust for misapplied MOH. B. Actual information for 2022 that can be traced directly to each product: Directmaterialcost(DMUsed)FeetofcottonperT-shirtCottonininventory(12/31/2022)DirectlaborcostDirectlaborhoursperT-shirtNumberofT-shirtsperbatchMachinehoursNumberofbatchesSetuplaborhoursperbatchSetuplaborhoursTotalsalescommissionsUnitsproducedUnitssoldT-shirtsininventory(1/1/2022)SalesrevenueBasicT-shirts$1,326,0004feet80,000feet$816,0000.1hour85011,200hours60052,850$192,000510,000480,00050,000@$5.60each$4,080,000PremiumT-shirts$700,0004feet40,000feet$728,0000.26hours1756,300hours8006.55,200$140,000140,000140,0000$2,310,000 C. Addirionally, the T-shirt division had the following actual cosis by month in 2022 that were not directly traced to either product: \begin{tabular}{|l|r|} \hline Actual Annual Period Costs -2022 & \\ \hline Advertising expense & $500,000 \\ \hline Sales department salaries & 180,000 \\ \hline Selling and administration depreciation & 70,000 \\ \hline \end{tabular} D. Based on the information you have gathered you also make the following assumptions: - Becsuse of past financial trouble in the division, all expenses must be paid in cash. No sales are made on account (all sales are cash sales), - Information for the 2023 budget is as follows: The budgeted unit input quantities for materials used in 2022 will also be used in the 2023 budget. For the basic T-shirt the budgeted unit input quantities for labor and MOH (machine-hours and setup labor-hours) used in 2022 will also be used in the 2023 budget For the premium T-shirt the budgeted unit input quantity for direct manufacturing labor will be 0.25 hours/unit. The budgeted unit input quantities for MOH (machine-hours and setup labor-hours) used in 2022 will also be used in the 2023 budget The cost of preshrunk cotton is budgeted to increase by 8% in 2023 over 2022 actual costs. Organic cotton is budgeted to increase by 15% in 2023 over 2022 actual costs. Budgeted labor rates in 2023 are expected to increase by 14% over actual rates in 2022 . Calculate 2023 budgeted variable moh rates and total fixed moh from 2022 actual monthly cost and activity data. Use Regression Analysis to determine estimates for variable and monthly fixed costs. Convert monthly estimates of fixed costs into annual costs. Assume non-cash MOH item amounts remain unchanged from budgeted 2022 data. Production and sales forecasts are within the relevant range. Budgeted variable period costs per unit and fixed costs in total for 2023 are assumed to be the same as actual period costs in 2022. A 5% reduction in selling price for 2023 is expected for the basic and a 10% increase is expected for the premium I-shirts. - Normal costing is used. - There are two cost drivers for manufacturing overhead costs - machine-hours and setup labor-hours. - Machine-hours is the cost driver for the variable portion of manufhcturing operations overhead. Machine-hours is also used to allocate the fixed portion of manufacturing operations overhead. - Setup labor-hours is the cost driver for the variable portion of machine setup overhead. Setup laborhours is also used to allocate the fixed portion of machine setup overhead. - Projected sales for the basic T-shirt are 500,000 in 2023,475,000 in 2024, and 480,000 in 2025. - Projected sales for the premium T-shirt are 125,000 in 2023, 135,000 in 2024, and 140,000 in 2025. - Sales commission is paid as a rate per T-shirt sold. - 2023 input cost and quantity standards for direct materials, direct manufacturing labor and manufacturing overhead are the same as 2023 budgeted input costs and quantities. - You require an ending inventory of basic T-shirts of 10% of next year's total sales needs. Premium Tshirts are made to order and no inventory of finished goods is planned. - You require an ending raw material inventory of 12% of next year's production needs (for both product lines). - Assume a FIFO cost flow - Assume no WIP inventory. - Your beginning cash balance is $200,000 for 2023 . The company requires a minimum cash balance of $250,000. 1. What were the 2022 annual budgeted indirect cost rates for the manufacturing operations activity and the machine setup activity? 2. Was overhead over- or under-applied for the year? By how much? 3. What was the 2022 unit product cost for the basic and premium T-shirts under Normal costing? 4. What was the T-shirt Division's operating income for 2022? Use Normal costing and adjust for misapplied MOH. B. Actual information for 2022 that can be traced directly to each product: Directmaterialcost(DMUsed)FeetofcottonperT-shirtCottonininventory(12/31/2022)DirectlaborcostDirectlaborhoursperT-shirtNumberofT-shirtsperbatchMachinehoursNumberofbatchesSetuplaborhoursperbatchSetuplaborhoursTotalsalescommissionsUnitsproducedUnitssoldT-shirtsininventory(1/1/2022)SalesrevenueBasicT-shirts$1,326,0004feet80,000feet$816,0000.1hour85011,200hours60052,850$192,000510,000480,00050,000@$5.60each$4,080,000PremiumT-shirts$700,0004feet40,000feet$728,0000.26hours1756,300hours8006.55,200$140,000140,000140,0000$2,310,000 C. Addirionally, the T-shirt division had the following actual cosis by month in 2022 that were not directly traced to either product: \begin{tabular}{|l|r|} \hline Actual Annual Period Costs -2022 & \\ \hline Advertising expense & $500,000 \\ \hline Sales department salaries & 180,000 \\ \hline Selling and administration depreciation & 70,000 \\ \hline \end{tabular} D. Based on the information you have gathered you also make the following assumptions: - Becsuse of past financial trouble in the division, all expenses must be paid in cash. No sales are made on account (all sales are cash sales), - Information for the 2023 budget is as follows: The budgeted unit input quantities for materials used in 2022 will also be used in the 2023 budget. For the basic T-shirt the budgeted unit input quantities for labor and MOH (machine-hours and setup labor-hours) used in 2022 will also be used in the 2023 budget For the premium T-shirt the budgeted unit input quantity for direct manufacturing labor will be 0.25 hours/unit. The budgeted unit input quantities for MOH (machine-hours and setup labor-hours) used in 2022 will also be used in the 2023 budget The cost of preshrunk cotton is budgeted to increase by 8% in 2023 over 2022 actual costs. Organic cotton is budgeted to increase by 15% in 2023 over 2022 actual costs. Budgeted labor rates in 2023 are expected to increase by 14% over actual rates in 2022 . Calculate 2023 budgeted variable moh rates and total fixed moh from 2022 actual monthly cost and activity data. Use Regression Analysis to determine estimates for variable and monthly fixed costs. Convert monthly estimates of fixed costs into annual costs. Assume non-cash MOH item amounts remain unchanged from budgeted 2022 data. Production and sales forecasts are within the relevant range. Budgeted variable period costs per unit and fixed costs in total for 2023 are assumed to be the same as actual period costs in 2022. A 5% reduction in selling price for 2023 is expected for the basic and a 10% increase is expected for the premium I-shirts. - Normal costing is used. - There are two cost drivers for manufacturing overhead costs - machine-hours and setup labor-hours. - Machine-hours is the cost driver for the variable portion of manufhcturing operations overhead. Machine-hours is also used to allocate the fixed portion of manufacturing operations overhead. - Setup labor-hours is the cost driver for the variable portion of machine setup overhead. Setup laborhours is also used to allocate the fixed portion of machine setup overhead. - Projected sales for the basic T-shirt are 500,000 in 2023,475,000 in 2024, and 480,000 in 2025. - Projected sales for the premium T-shirt are 125,000 in 2023, 135,000 in 2024, and 140,000 in 2025. - Sales commission is paid as a rate per T-shirt sold. - 2023 input cost and quantity standards for direct materials, direct manufacturing labor and manufacturing overhead are the same as 2023 budgeted input costs and quantities. - You require an ending inventory of basic T-shirts of 10% of next year's total sales needs. Premium Tshirts are made to order and no inventory of finished goods is planned. - You require an ending raw material inventory of 12% of next year's production needs (for both product lines). - Assume a FIFO cost flow - Assume no WIP inventory. - Your beginning cash balance is $200,000 for 2023 . The company requires a minimum cash balance of $250,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Productivity Audit

Authors: Mark Spelman, Paul Spence

1st Edition

1907766073, 978-1907766077

More Books

Students also viewed these Accounting questions