Conditional For Formatting as Table Call Styles e rt Delene Form 16 x fx Problem 23-3A M N OF store 1. Emine the monthly read budget to the len and determine the price per for each of the steder cost perforach wariable cost. The identify the deverhead cos per month Direct Materials mined over factory's capacity of 20000 at the capacity level te ($18.50 per direct labor hours based on an expected volume of of the per month Following are the com b udged overhead costs per month Variable Overhead Costs Indirect Materials Indirect labor 45,000.00 45.000,00 2. Prepare flexible overhead ESN 75, and capacity s asinta 23.12) for October showing themes of each ware and fed cont at the Repairs & Maintenan Total Varle Overhead Costs Faed Overhead Costs Deprecantonbudne Depreciation Machinery Total Red Overhead Costs Total Overhead Costs Direct Materials 191,000 lbs 55 10 per Direct Labor (10.500 huse $17.25 perhe Overhead Costs Indirea Maters Compute the direct materials cest variance, including price and Repair & Maintenance Depreciation - Bulding Deprecation - Machinery Formula Total Cost Price Variance Quanti Variance Problem 23-JA Chapter 23 Excel Assignment - Original Home Review View A Insert Page Layout Formulas Cut Calibri (Body) - 11 - Copy. Format BIU. . x fx Data A A General Paste . SA . . Conditional Format Formatting Table insert Sly E16 24,000.00 12,000.00 22 Depreciation. Building 23 Depreciation - Machinery 24 Taxes & Insurance 25 Supervision 26 Total Fined Overhead Costs 27 Total Overhead Costs 29 The company incurred the following actual costs when it operated at 75% of capacity in October 464,100.00 526.125.00 s 31 Direct Materials (91,000 lbs @ $5.10 per 32 Direct Labor (10,500 $17.per 31 Overhead Costs indirect Materials 44.250.00 Indirect Labor 177,750.00 36 Power 43.000 37 Repairs & Maintenance 3. Compute the direct materials cost variance, including its price and quantity variances Depreciation - Machinery Taxes & Insurance Supervision 11.500.00 89,000.00 Total Cost Price Variance Quantity Variance 4. Compute the direct labor cost variance, including Formula Total Cost Efficiency Variance 1 Problem 23-3A Antuan Company set the following standard costs for one unit of its product Ibs/hrs 6 Direct Materials Direct Labor Overhead Total Standard Cost price per lb/hr $ 5.00 $ 17.00 $ 18.50 2 2 price per unit $ 30.00 $ 34.00 $ 37.00 101.00 $ 11 The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the 12 factory's capacity of 20,000 units per month. Following are the company's budgeted overhead costs per month 13 at the 75% capacity level. 18 15 Variable Overhead Costs 16 Indirect Materials 45,000.00 17 Indirect Labor 180,000.00 Power 45,000.00 19 Repairs & Maintenance 90,000.00 20 Total Varaible Overhead Costs 360,000.00 21 Fixed Overhead Costs 22 Depreciation - Building 24,000.00 23 Depreciation - Machinery 80,000.00 24 Taxes & Insurance 12,000.00 25 Supervision 79,000.00 26 Total Fixed Overhead Costs 195,000.00 27 Total Overhead Costs 555,000.00 28 29 The company incurred the following actual costs when it operated at 75% of capacity in October 464,100.00 526,125.00 35 31 Direct Materials (91,000 lbs @ $5.10 per lb) 32 Direct Labor (30,500 hrs $17.25 per hr) 33 Overhead Costs 34 Indirect Materials 44,250.00 Indirect labor 177,750.00 Power 43,000.00 Repairs & Maintenance 96,000.00 Depreciation - Building 24,000.00 Depreciation - Machinery 75,000.00 Taxes & Insurance 11,500.00 Supervision 89,000.00 42 Total Costs 43 560,500.00 1,550,725.00 Marya Formatting as Table Styles NOP Use the drop down bones when necessary and use formulas for cells requiring amounts for answers. 1. Examine the monthly overhead budget to the left and determine the price per unit for each of the Isted expenses and the total cost per unit for each variable cost. Then Identify the total fooed overhead costs per month. Variable Overhead Costs Price/Unit Fixed Overhead Costs Cost/Month 2. Prepare flexible overhead budgets (as in Exhibit 23.12) for October showing the amounts of each variable and feed cost at the 65%, 75%, and 85% capacity levels. 3. Compute the direct materials cost variance, including its price and quantity variances. Actual Flexible Standard Formula Total Cost Price Variance Quantity Variance DM Cost Variance 9-7-PSOASP w gaga N0P 2. Prepare flexible overhead budgets (as in Exhibit 23.12) for October showing the amounts of each variable and foxed cost at the 65%, 75%, and 85% capacity levels. 65% 75% 3. Compute the direct materials cost variance, including its price and quantity variances. Actual Flexible Standard Formula Total Cost Price Variance Quantity Variance DM Cost Variance 4. Compute the direct labor cost variance, including its rate and efficiency variances Actual Flexible Standard Formula Total Cost Rate Variance Efficiency Variance DL Cost Variance Conditional For Formatting as Table Call Styles e rt Delene Form 16 x fx Problem 23-3A M N OF store 1. Emine the monthly read budget to the len and determine the price per for each of the steder cost perforach wariable cost. The identify the deverhead cos per month Direct Materials mined over factory's capacity of 20000 at the capacity level te ($18.50 per direct labor hours based on an expected volume of of the per month Following are the com b udged overhead costs per month Variable Overhead Costs Indirect Materials Indirect labor 45,000.00 45.000,00 2. Prepare flexible overhead ESN 75, and capacity s asinta 23.12) for October showing themes of each ware and fed cont at the Repairs & Maintenan Total Varle Overhead Costs Faed Overhead Costs Deprecantonbudne Depreciation Machinery Total Red Overhead Costs Total Overhead Costs Direct Materials 191,000 lbs 55 10 per Direct Labor (10.500 huse $17.25 perhe Overhead Costs Indirea Maters Compute the direct materials cest variance, including price and Repair & Maintenance Depreciation - Bulding Deprecation - Machinery Formula Total Cost Price Variance Quanti Variance Problem 23-JA Chapter 23 Excel Assignment - Original Home Review View A Insert Page Layout Formulas Cut Calibri (Body) - 11 - Copy. Format BIU. . x fx Data A A General Paste . SA . . Conditional Format Formatting Table insert Sly E16 24,000.00 12,000.00 22 Depreciation. Building 23 Depreciation - Machinery 24 Taxes & Insurance 25 Supervision 26 Total Fined Overhead Costs 27 Total Overhead Costs 29 The company incurred the following actual costs when it operated at 75% of capacity in October 464,100.00 526.125.00 s 31 Direct Materials (91,000 lbs @ $5.10 per 32 Direct Labor (10,500 $17.per 31 Overhead Costs indirect Materials 44.250.00 Indirect Labor 177,750.00 36 Power 43.000 37 Repairs & Maintenance 3. Compute the direct materials cost variance, including its price and quantity variances Depreciation - Machinery Taxes & Insurance Supervision 11.500.00 89,000.00 Total Cost Price Variance Quantity Variance 4. Compute the direct labor cost variance, including Formula Total Cost Efficiency Variance 1 Problem 23-3A Antuan Company set the following standard costs for one unit of its product Ibs/hrs 6 Direct Materials Direct Labor Overhead Total Standard Cost price per lb/hr $ 5.00 $ 17.00 $ 18.50 2 2 price per unit $ 30.00 $ 34.00 $ 37.00 101.00 $ 11 The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the 12 factory's capacity of 20,000 units per month. Following are the company's budgeted overhead costs per month 13 at the 75% capacity level. 18 15 Variable Overhead Costs 16 Indirect Materials 45,000.00 17 Indirect Labor 180,000.00 Power 45,000.00 19 Repairs & Maintenance 90,000.00 20 Total Varaible Overhead Costs 360,000.00 21 Fixed Overhead Costs 22 Depreciation - Building 24,000.00 23 Depreciation - Machinery 80,000.00 24 Taxes & Insurance 12,000.00 25 Supervision 79,000.00 26 Total Fixed Overhead Costs 195,000.00 27 Total Overhead Costs 555,000.00 28 29 The company incurred the following actual costs when it operated at 75% of capacity in October 464,100.00 526,125.00 35 31 Direct Materials (91,000 lbs @ $5.10 per lb) 32 Direct Labor (30,500 hrs $17.25 per hr) 33 Overhead Costs 34 Indirect Materials 44,250.00 Indirect labor 177,750.00 Power 43,000.00 Repairs & Maintenance 96,000.00 Depreciation - Building 24,000.00 Depreciation - Machinery 75,000.00 Taxes & Insurance 11,500.00 Supervision 89,000.00 42 Total Costs 43 560,500.00 1,550,725.00 Marya Formatting as Table Styles NOP Use the drop down bones when necessary and use formulas for cells requiring amounts for answers. 1. Examine the monthly overhead budget to the left and determine the price per unit for each of the Isted expenses and the total cost per unit for each variable cost. Then Identify the total fooed overhead costs per month. Variable Overhead Costs Price/Unit Fixed Overhead Costs Cost/Month 2. Prepare flexible overhead budgets (as in Exhibit 23.12) for October showing the amounts of each variable and feed cost at the 65%, 75%, and 85% capacity levels. 3. Compute the direct materials cost variance, including its price and quantity variances. Actual Flexible Standard Formula Total Cost Price Variance Quantity Variance DM Cost Variance 9-7-PSOASP w gaga N0P 2. Prepare flexible overhead budgets (as in Exhibit 23.12) for October showing the amounts of each variable and foxed cost at the 65%, 75%, and 85% capacity levels. 65% 75% 3. Compute the direct materials cost variance, including its price and quantity variances. Actual Flexible Standard Formula Total Cost Price Variance Quantity Variance DM Cost Variance 4. Compute the direct labor cost variance, including its rate and efficiency variances Actual Flexible Standard Formula Total Cost Rate Variance Efficiency Variance DL Cost Variance