Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Evan Exert has approached you with the following activity-based costing information and corresponding questions. Read through the information and then respond to the questions below. Acme Sporting Goods Division Budgeted Costs and Activities For the Year Ended December 31, 2015 Direct materialsBasketballs $168,100 Direct materialsHockey Sticks 303,280 Direct materialsBaseball Gloves 505,280 TOTAL $976,660 Direct manufacturing laborBasketballs $111,800 Direct manufacturing laborHockey Sticks 100,820 Direct manufacturing laborBaseball Gloves 150,820 TOTAL $363,440 Other Indirect Fixed Costs Setup $ 257,500 Equipment and maintenance costs 215,200 Factory rent 310,000 Total $ 782,700 Additional Budget Information Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Product quantity Basketballs 58,000 Hockey Sticks 85,000 Baseball Gloves 100,000 Number of batches (cost driver) Basketballs 450 Hockey Sticks 300 Baseball Gloves 600 Machine hours (cost driver) Basketballs 13,500 Hockey Sticks 10,500 Baseball Gloves 15,000 Square footage of production space used (cost driver) Basketballs 3,200 Hockey Sticks 5,000 Baseball Gloves 7,800 Factors to consider: Number of batches is the cost driver for setup costs. Number of machine hours is the cost driver for equipment and maintenance costs. Factory rent is paid per square foot. Total available factory square footage is 20,000 and Acme's Sporting Goods Division is currently using only 80% of this capacity. Acme records the cost of unused capacity as a separate line item and not as a product cost. ------------------------------------------------------------------------------------------------------------------------------Answer the following questions for Evan. Be sure to show your work as well as your answers in the boxes below (the boxes will expand as your enter your work). Where necessary, round your answers to three places after the decimal point. 1. Calculate the budgeted setup cost per unit: Budgeted setup cost per unit (Basketballs): Budgeted setup cost per unit (Hockey Sticks): Budgeted setup cost per unit (Baseball Gloves): 2. Calculate the budgeted equipment and maintenance cost per unit: Budgeted equipment and maintenance cost per unit (Basketballs): Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Budgeted equipment and maintenance cost per unit (Hockey Sticks): Budgeted equipment and maintenance cost per unit (Baseball Gloves): 3. Calculate the budgeted production space cost per unit: Budgeted production space cost per unit (Basketballs): Budgeted production space cost per unit (Hockey Sticks): Budgeted production space cost per unit (Baseball Gloves): 4. What is the budgeted cost of unused square footage capacity? 5. What is the budgeted total cost and the cost per unit of resources used to produce Basketballs, Hockey Sticks and Baseball Gloves? Complete the following table to show your answers: Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Basketballs Hockey Sticks Baseball Gloves Totals Direct materials Direct manufacturing Labor Total direct costs Setup Equip. & maint. Factory rent Total indirect costs Total costs Units Total cost/unit 6. Why might excess square footage capacity be beneficial for Acme's Sporting Goods Division? 7. A salesman from the Sewn Up Supply Company has proposed that Acme buy its new, more pliable leather stitching for use in manufacturing baseball gloves. This new material will reduce the time required for manually stitching the gloves from one hour to forty minutes per glove, which Evan estimates will decrease the budgeted direct manufacturing labor cost for baseball gloves to $130,000; increase the direct materials cost for baseball gloves to $525,000; and increase equipment & maintenance costs by $11,800 because the new stitching requires a Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis special type of electronic needle that would be leased from and maintained by the Sewn Up Supply Company. All other things being equal, do you recommend that Acme decide to use this new stitching? Why or why not? Complete the following table and then write your response in the box provided. Total Costs Before New Stitching Total Costs After New Stitching Better/(Worse)? (and by how much?) Direct materials Direct mfg. labor Total direct costs Setup Equip. & maint. Factory rent Total indirect costs Total costs Written Response: 8. Acme is considering sending its supervisors and staff to a regional seminar series that shares industry best practices about manufacturing process innovations. The cost of participation (an indirect fixed cost that Acme would allocate equally among its three product lines) is $30,000 but a colleague of one of the Acme executives told him that he had attended the same seminar series and learned about efficiencies that enabled him to increase his company's production (i.e. number of units produced) by 5% without incurring any additional direct costs. If Acme experienced the same 5% increase in product quantity, what would be its new budgeted total cost and cost per unit of resources used to produce: a. Basketballs b. Hockey Sticks c. Baseball Gloves Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Do you recommend that Acme decide to pay to send its supervisors and staff to this seminar? Why or why not? Complete the below tables and write your response in the box provided. Before the seminar: Basketballs Hockey Sticks Baseball Gloves Total Basketballs Hockey Sticks Baseball Gloves Total Direct materials Direct mfg. labor Total direct costs Setup Equip. & maint. Space rental Total indirect costs Total costs Units Total cost/unit After the seminar: Direct materials Direct mfg. labor Total direct costs Setup Equip. & maint. Space rental Seminar Total indirect costs Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Determine Manufacturing Overhead Costs Sporting Goods DivisionManufacturing Overhead Analysis Total costs Units Total cost/unit Written Response: Copyright 2016 College for America at Southern New Hampshire University. All rights reserved