Case information Machine Setup Overhead Costs Variable costs Supplies Indirect manuf. Labor Power Fixed costs Depreciation Supervision Power $40,000 80,000 60,000 $180.000 Beginning of the year: January 1, 2020 75,000 25,000 40,000 $140.000 The "Good-Crack" Company (GCC) Inc., a baseball products manufacturer, recently hired you as a management accountant in its Bat division. GCC's Bat division produces two products, an "entry-level' bat made of Northern White Ash and a 'pro-series' bat made of Rock Maple wood. The production process involves tuming the wood (billets) on a lathe and then sanding and finishing work to complete each bat. The entry-level bat comes in a standard size weight and finish. The pro-series bat requires additional attention to procurement, quality control, and sanding and finishing work. The pro-series bat is sold to professional players, who visit the production facilities to discuss technical details such as weight, balance and personalization. The pro-series line of bats was recently introduced and GCC has been selling as many of this product as it can produce. Further expansion of the pro-series bat is planned; however, production personnel are not too enthusiastic about this because of the manufacturing demands placed on them by this additional product In response to demands for more relevant costing information your predecessor introduced an ABC system. Two key production activities, manufacturing operations and machine setups, were identified Production costs related to these activities are now assigned to the two lines of bats based on the cost drivers of direct manufacturing labor and setup labor hours, respectively. The old product costing system allocated all manufacturing overhead based on direct manufacturing labor hours. Your predecessor argued for a move to ABC because production runs for the pro-series bat take longer to setup and allocating setup costs based on setup labor hours better represents resources consumed by the two bat lines. The bat division is growing in complexity and part of your job is to manage and explain the more advanced accounting information systems used within the division Your first task is to review the bat division's existing costing and budgeting information. To your dismay you are told that the division's records are in disarray and the 2020 budget has not been compiled. Since you are short on time, you decide to use the information from the last year's (2019) records to do an initial examination of the division. These records include some budget estimates assembled before the start of 2019 and actual information for 2019. 4. Budget information assembled at the start of 2019 Entry-level Bats Pro-series Bats Budgeted production 50,000 10,000 Number of bats per batch 100 20 Setup labor hours per batch 5 hours 8 hours Feet of lumber per bat 4 feet 4 feet Direct labor hours per bat 1 hr 2 hrs B. Actual information for 2019 that can be traced directly to each product: Entry-level Bats Pro-series Bats Direct material cost (DM Used) $1,030,000 $266,000 Feet of lumber per bat (billets) 4 feet 4 feet Lumber in inventory (12/31/2019) 40,000 feet 10,000 feet Direct labor cost $849.750 $456,000 Direct labor hours per Bat 1.1 hour 2.4 hours Number of bats per batch 100 20 Number of batches 515 475 Setup labor hours per batch 5 8 Setup labor hours 2,575 3,800 Total sales commissions $240,000 $95,000 Units produced 51,500 9,500 Units sold 48.000 9,500 Bats in inventory (1/1/2019) 2,000 a $42.44 each 0 Sales revenue $2,832,000 $1,282,500 C. Additionally, the Bat division had the following actual costs in 2019 that were not directly traced to either product: Actual Manufacturing Overhead Costs, 2019 Cost Setup-Hours Cost Manufacturing Operations Overhead Costs Variable costs Supplies Indirect manuf. Labor Power Maintenance Fixed costs Depreciation Supervision Power Maintenance $25,000 80,000 21,000 85,000 $211,000 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Direct Labor-Hours 5.472 5,022 5,422 6,573 7,054 8,231 9,753 8,744 7,320 6,311 4,977 $_34.755 $ 31.658 $_34276 $_41.889 $_40.788 $_44.987 $ 49.785 $_51265 $_46.387 $_43.200 $ 42.265 301 326 400 399 467 499 556 540 820 725 645 $ 21959 $_23.959 $ 22.424 $_24.444 $ 24.888 $_29.990 $ 34.321 $_33.567 $_34.833 $_34 131 $ 38,484 35,000 100,000 82,000 60,000 $277,000 697 6.375 $ 32.000 $355.000 Dec 4,571 $_35.745 Total 79,450 $497.000 Actual Period Costs - 2019 Advertising expense Sales department salaries Selling and administration depreciation $240.000 210.000 35,000 . Requirements Requirements for the two parts of the case are listed below. Better answers will clearly present workings for calculations. Presenting calculations so that management can understand them is important. The quality of your spreadsheet will be graded - create a model that can be easily updated and modified by using appropriate formulas and referencing. See Canvas for model design tips. Requirements for Part 1 - due Friday, October 16 Actual and Normal Costing, CVP analysis, and Activity-Based Costing 1. What were the budgeted indirect cost rates for the manufacturing operations activity and the machine setup activity in 2019? Was overhead over- or under-applied for the year? By how much? 3. What was the unit product cost for the entry-level and pro-series Bats under normal costing? What was the Bat Division's operating income for 2019? Use normal costing and adjust for mis- applied MOH 5. Use the 2019 actual monthly MOH information to calculate annual estimates of cost behavior (fixed and variable components) for each MOH activity. These estimates will be used for the 2020 budget. Use the Regression function found under Data: Data Analysis in Excel. Place output on a separate sheet. 6. For Setup Operations overhead activity, evaluate the selected cost driver and compare it to the altemative of Direct Labor Hours as the cost driver. Refer to Exhibit 10-18. i.e., run a regression for DLHrs as the cost driver for Setup Operations activity and compare the results according to the criteria in Ex 10-18. 7. Calculate the break-even point in units (calculate the number of units of each product required), and the number of units of both products that must be sold to eam an operating income of $150,000. Use 2020 budgeted information - refer to section D bullet point 2 and your results from requirement 5 4 o D. Based on the information you have gathered you also make the following assumptions: Because 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 2020 budget is as follows: The budgeted unit input quantities for materials used in 2019 will also be used in the 2020 budget. For the entry-level bat the budgeted unit input quantities for labor and MOH (direct manufacturing labor-hours and machine setup labor hours) used in 2019 will also be used in the 2020 budget For the pro-series bat the budgeted unit input quantity for direct manufacturing labor will be 2.4 hours unit. The budgeted unit input quantity for setup labor hours used in 2019 will also be used in the 2020 budget The cost of Ash and Maple are budgeted to increase by 10% in 2020 over 2019 actual costs. Budgeted labor rates in 2020 are expected to increase by 8% over actual rates in 2019. Calculate 2020 budgeted variable moh rates and total fixed moh from 2019 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 2019 data. Production and sales forecasts are within the relevant range. o Budgeted variable period costs per unit and fixed costs in total for 2020 are assumed to be the same as actual period costs in 2019. A 5% increase in selling price for 2020 expected for both the entry-level and the pro-series bats. Normal costing is used. There are two cost drivers for manufacturing overhead costs - direct manufacturing labor-hours and setup labor-hours. Direct manufacturing labor-hours is the cost driver for the variable portion of manufacturing operations overhead. Direct manufacturing labor-hours i 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 labor- hours is also used to allocate the fixed portion of machine setup overhead. Projected sales for the entry-level Bat are 52,000 in 2020, 51,000 in 2021, and 48,000 in 2022. Projected sales for the pro-series Bat are 10,400 in 2020, 11,000 in 2021, and 12,000 in 2022. Sales commission is paid as a rate per bat sold. 2020 input cost and quantity standards for direct materials, direct manufacturing labor and manufacturing overhead are the same as 2020 budgeted input costs and quantities. You require an ending inventory of entry-level Bats of 20% of next year's total sales needs. Pro-series bats are made to order and no inventory of finished goods is planned. You require an ending raw material inventory of 30% of next year's production needs (for both product lines) Assume a FIFO cost flow Assume no WIP inventory. Your beginning cash balance is $125,000 for 2020. The company requires a minimum cash balance of $100,000 Requirements for Part 2 - due Friday, November 20 Budgeting and Variance Analysis 8. Compute the sales budget, the production budget, the direct material usage and purchases budget, the direct labor budget, the manufacturing overhead budget, the ending inventories budget, the cost of goods sold budget, the selling and administration budget, the budgeted income statement, and the cash budget for 2020. a. ACC 531 Student Requirement-only for students enrolled in ACC 531. Due Friday, November 20 GCC's newly appointed CEO recently attended an IMA seminar and got excited about the benefits of introducing a Balanced Scorecard to help link corporate strategy to the operational decisions made within the divisions. She asks you to report on the following: Provide some background on the Balanced Scorecard (BSC). Describe the four perspectives of the Define strategy and describe how the BSC is designed to fit a chosen strategy. (Better answers will reference textbooks and/or journal articles that discuss this issue). b. Design a BSC for the Bat division. Refer to C12 (Strategy, Balanced Scorecard, and Strategic Profitability Analysis) of the text (exhibits 1, 2, & 3) for guidance. For each perspective identify 2-4 objectives and develop measures and initiatives related to these objectives (target and actual performance metrics are not required). BSc Skip to the end of 2020. At the end of 2020 the following actual quantities and costs were recorded: A total of 53,000 entry-level Bat's and 9,800 pro-series Bats were produced and sold in 2020 at average selling prices of $60.75 and $144.20, respectively. A total of 250,000 feet of Northern White Ash wood was purchased for the entry-level Bats at a cost of $1,350,000. A total of 55,000 feet of Rock Maple wood was purchased for the pro-series Bats at a cost of $437.250. 213,060 feet of Ash were used to produce the entry-level Bats, and 42,140 feet of Maple were used to create the pro- series Bats. 51,800 direct labor hours were traced to the entry-level Bats, and 24,010 direct labor hours were traced to the pro-series Bats. A total of $1,247,085 in wages was paid to the manufacturing workers (traced to entry-level $802,900 and pro-series $444,185 workers). Further, for manufacturing operations overhead actual fixed costs were $265,335 and actual variable costs were $231.220.50. For machine setup overhead costs, actual fixed costs were $152.000, and actual variable costs were $211,750. Entry-level bats were produced in batches of 106 bats and used 4.9 hours per batch. Pro-series bats were produced in batches of 14 and used 7.5 hours per batch. Relate discussion question answers to the case and where appropriate reference articles, textbooks, or your own experience. Present your own work, in your own words, and adequately reference your sources. 8. a. Calculate the direct material price variance, the direct material efficiency variance, the direct labor price variance, and the direct labor efficiency variance for each of the product lines separately. Also, for each MOH activity calculate the FMOH (spending and production volume) variances for the Bat division and the VMOH (spending and efficiency) variances for the two product lines. Which of the variances that you calculated should you investigate - and why? Provide possible reasons for the variances. b. Case information Machine Setup Overhead Costs Variable costs Supplies Indirect manuf. Labor Power Fixed costs Depreciation Supervision Power $40,000 80,000 60,000 $180.000 Beginning of the year: January 1, 2020 75,000 25,000 40,000 $140.000 The "Good-Crack" Company (GCC) Inc., a baseball products manufacturer, recently hired you as a management accountant in its Bat division. GCC's Bat division produces two products, an "entry-level' bat made of Northern White Ash and a 'pro-series' bat made of Rock Maple wood. The production process involves tuming the wood (billets) on a lathe and then sanding and finishing work to complete each bat. The entry-level bat comes in a standard size weight and finish. The pro-series bat requires additional attention to procurement, quality control, and sanding and finishing work. The pro-series bat is sold to professional players, who visit the production facilities to discuss technical details such as weight, balance and personalization. The pro-series line of bats was recently introduced and GCC has been selling as many of this product as it can produce. Further expansion of the pro-series bat is planned; however, production personnel are not too enthusiastic about this because of the manufacturing demands placed on them by this additional product In response to demands for more relevant costing information your predecessor introduced an ABC system. Two key production activities, manufacturing operations and machine setups, were identified Production costs related to these activities are now assigned to the two lines of bats based on the cost drivers of direct manufacturing labor and setup labor hours, respectively. The old product costing system allocated all manufacturing overhead based on direct manufacturing labor hours. Your predecessor argued for a move to ABC because production runs for the pro-series bat take longer to setup and allocating setup costs based on setup labor hours better represents resources consumed by the two bat lines. The bat division is growing in complexity and part of your job is to manage and explain the more advanced accounting information systems used within the division Your first task is to review the bat division's existing costing and budgeting information. To your dismay you are told that the division's records are in disarray and the 2020 budget has not been compiled. Since you are short on time, you decide to use the information from the last year's (2019) records to do an initial examination of the division. These records include some budget estimates assembled before the start of 2019 and actual information for 2019. 4. Budget information assembled at the start of 2019 Entry-level Bats Pro-series Bats Budgeted production 50,000 10,000 Number of bats per batch 100 20 Setup labor hours per batch 5 hours 8 hours Feet of lumber per bat 4 feet 4 feet Direct labor hours per bat 1 hr 2 hrs B. Actual information for 2019 that can be traced directly to each product: Entry-level Bats Pro-series Bats Direct material cost (DM Used) $1,030,000 $266,000 Feet of lumber per bat (billets) 4 feet 4 feet Lumber in inventory (12/31/2019) 40,000 feet 10,000 feet Direct labor cost $849.750 $456,000 Direct labor hours per Bat 1.1 hour 2.4 hours Number of bats per batch 100 20 Number of batches 515 475 Setup labor hours per batch 5 8 Setup labor hours 2,575 3,800 Total sales commissions $240,000 $95,000 Units produced 51,500 9,500 Units sold 48.000 9,500 Bats in inventory (1/1/2019) 2,000 a $42.44 each 0 Sales revenue $2,832,000 $1,282,500 C. Additionally, the Bat division had the following actual costs in 2019 that were not directly traced to either product: Actual Manufacturing Overhead Costs, 2019 Cost Setup-Hours Cost Manufacturing Operations Overhead Costs Variable costs Supplies Indirect manuf. Labor Power Maintenance Fixed costs Depreciation Supervision Power Maintenance $25,000 80,000 21,000 85,000 $211,000 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Direct Labor-Hours 5.472 5,022 5,422 6,573 7,054 8,231 9,753 8,744 7,320 6,311 4,977 $_34.755 $ 31.658 $_34276 $_41.889 $_40.788 $_44.987 $ 49.785 $_51265 $_46.387 $_43.200 $ 42.265 301 326 400 399 467 499 556 540 820 725 645 $ 21959 $_23.959 $ 22.424 $_24.444 $ 24.888 $_29.990 $ 34.321 $_33.567 $_34.833 $_34 131 $ 38,484 35,000 100,000 82,000 60,000 $277,000 697 6.375 $ 32.000 $355.000 Dec 4,571 $_35.745 Total 79,450 $497.000 Actual Period Costs - 2019 Advertising expense Sales department salaries Selling and administration depreciation $240.000 210.000 35,000 . Requirements Requirements for the two parts of the case are listed below. Better answers will clearly present workings for calculations. Presenting calculations so that management can understand them is important. The quality of your spreadsheet will be graded - create a model that can be easily updated and modified by using appropriate formulas and referencing. See Canvas for model design tips. Requirements for Part 1 - due Friday, October 16 Actual and Normal Costing, CVP analysis, and Activity-Based Costing 1. What were the budgeted indirect cost rates for the manufacturing operations activity and the machine setup activity in 2019? Was overhead over- or under-applied for the year? By how much? 3. What was the unit product cost for the entry-level and pro-series Bats under normal costing? What was the Bat Division's operating income for 2019? Use normal costing and adjust for mis- applied MOH 5. Use the 2019 actual monthly MOH information to calculate annual estimates of cost behavior (fixed and variable components) for each MOH activity. These estimates will be used for the 2020 budget. Use the Regression function found under Data: Data Analysis in Excel. Place output on a separate sheet. 6. For Setup Operations overhead activity, evaluate the selected cost driver and compare it to the altemative of Direct Labor Hours as the cost driver. Refer to Exhibit 10-18. i.e., run a regression for DLHrs as the cost driver for Setup Operations activity and compare the results according to the criteria in Ex 10-18. 7. Calculate the break-even point in units (calculate the number of units of each product required), and the number of units of both products that must be sold to eam an operating income of $150,000. Use 2020 budgeted information - refer to section D bullet point 2 and your results from requirement 5 4 o D. Based on the information you have gathered you also make the following assumptions: Because 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 2020 budget is as follows: The budgeted unit input quantities for materials used in 2019 will also be used in the 2020 budget. For the entry-level bat the budgeted unit input quantities for labor and MOH (direct manufacturing labor-hours and machine setup labor hours) used in 2019 will also be used in the 2020 budget For the pro-series bat the budgeted unit input quantity for direct manufacturing labor will be 2.4 hours unit. The budgeted unit input quantity for setup labor hours used in 2019 will also be used in the 2020 budget The cost of Ash and Maple are budgeted to increase by 10% in 2020 over 2019 actual costs. Budgeted labor rates in 2020 are expected to increase by 8% over actual rates in 2019. Calculate 2020 budgeted variable moh rates and total fixed moh from 2019 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 2019 data. Production and sales forecasts are within the relevant range. o Budgeted variable period costs per unit and fixed costs in total for 2020 are assumed to be the same as actual period costs in 2019. A 5% increase in selling price for 2020 expected for both the entry-level and the pro-series bats. Normal costing is used. There are two cost drivers for manufacturing overhead costs - direct manufacturing labor-hours and setup labor-hours. Direct manufacturing labor-hours is the cost driver for the variable portion of manufacturing operations overhead. Direct manufacturing labor-hours i 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 labor- hours is also used to allocate the fixed portion of machine setup overhead. Projected sales for the entry-level Bat are 52,000 in 2020, 51,000 in 2021, and 48,000 in 2022. Projected sales for the pro-series Bat are 10,400 in 2020, 11,000 in 2021, and 12,000 in 2022. Sales commission is paid as a rate per bat sold. 2020 input cost and quantity standards for direct materials, direct manufacturing labor and manufacturing overhead are the same as 2020 budgeted input costs and quantities. You require an ending inventory of entry-level Bats of 20% of next year's total sales needs. Pro-series bats are made to order and no inventory of finished goods is planned. You require an ending raw material inventory of 30% of next year's production needs (for both product lines) Assume a FIFO cost flow Assume no WIP inventory. Your beginning cash balance is $125,000 for 2020. The company requires a minimum cash balance of $100,000 Requirements for Part 2 - due Friday, November 20 Budgeting and Variance Analysis 8. Compute the sales budget, the production budget, the direct material usage and purchases budget, the direct labor budget, the manufacturing overhead budget, the ending inventories budget, the cost of goods sold budget, the selling and administration budget, the budgeted income statement, and the cash budget for 2020. a. ACC 531 Student Requirement-only for students enrolled in ACC 531. Due Friday, November 20 GCC's newly appointed CEO recently attended an IMA seminar and got excited about the benefits of introducing a Balanced Scorecard to help link corporate strategy to the operational decisions made within the divisions. She asks you to report on the following: Provide some background on the Balanced Scorecard (BSC). Describe the four perspectives of the Define strategy and describe how the BSC is designed to fit a chosen strategy. (Better answers will reference textbooks and/or journal articles that discuss this issue). b. Design a BSC for the Bat division. Refer to C12 (Strategy, Balanced Scorecard, and Strategic Profitability Analysis) of the text (exhibits 1, 2, & 3) for guidance. For each perspective identify 2-4 objectives and develop measures and initiatives related to these objectives (target and actual performance metrics are not required). BSc Skip to the end of 2020. At the end of 2020 the following actual quantities and costs were recorded: A total of 53,000 entry-level Bat's and 9,800 pro-series Bats were produced and sold in 2020 at average selling prices of $60.75 and $144.20, respectively. A total of 250,000 feet of Northern White Ash wood was purchased for the entry-level Bats at a cost of $1,350,000. A total of 55,000 feet of Rock Maple wood was purchased for the pro-series Bats at a cost of $437.250. 213,060 feet of Ash were used to produce the entry-level Bats, and 42,140 feet of Maple were used to create the pro- series Bats. 51,800 direct labor hours were traced to the entry-level Bats, and 24,010 direct labor hours were traced to the pro-series Bats. A total of $1,247,085 in wages was paid to the manufacturing workers (traced to entry-level $802,900 and pro-series $444,185 workers). Further, for manufacturing operations overhead actual fixed costs were $265,335 and actual variable costs were $231.220.50. For machine setup overhead costs, actual fixed costs were $152.000, and actual variable costs were $211,750. Entry-level bats were produced in batches of 106 bats and used 4.9 hours per batch. Pro-series bats were produced in batches of 14 and used 7.5 hours per batch. Relate discussion question answers to the case and where appropriate reference articles, textbooks, or your own experience. Present your own work, in your own words, and adequately reference your sources. 8. a. Calculate the direct material price variance, the direct material efficiency variance, the direct labor price variance, and the direct labor efficiency variance for each of the product lines separately. Also, for each MOH activity calculate the FMOH (spending and production volume) variances for the Bat division and the VMOH (spending and efficiency) variances for the two product lines. Which of the variances that you calculated should you investigate - and why? Provide possible reasons for the variances. b