"Percy," Jerry Roberts, Roberts' CFO, said happily as he walked into the controller's office. "How are you doing? Well, "Percy said carefully. "I was doing okay" What do you mean yo were doing okay?" Jerry said, frowning. "Every time you walk in here with that kind of energy it means that you are going to ask me to do something." Jerry laughed. "I guess I'm getting a little predictable, huh?" "T'm afraid so. So, what do you want?" "Well, I have an idea for improving our cost accounting process." "Uh, huh. Just come back from a conference, didn't you?" "As a matter of fact, I did. How did you know?" "Because you only come up with accounting ideas when you've been to a conference. So, what is it this time?" Percy asked. "Have you ever thought about switching to an ABC costing system?" Percy shuddered. "Do you have any idea how much work is involved in creating one of those systems, not to mention maintaining the system after it is supposedly done? Believe me, Uncle Jerry, we don't want to go there, not without a much larger accounting staff than we currently have." 7 know it's a lot of work, Percy," Jerry said after a moment. "But I think we need to look into it anyway. The numbers are more accurate and they allow for better decision making. With the new system coming online, I think that we are going to need a solid ABC system in order to really determine which of our new products, if any, are making money." "But." Percy started to protest. "No "buts" Percy. I want you to do it. Y'l talk to Lauren in HR about hiring another staff member to free up some resources." Percy sighed. "Alright, if that's your decision. When do you want to hold the first meeting?" "First meeting?" Jerry frowned. To determine the cost centers and other components of the ABC system. We'll all have to agree on what they are if this is going to work. That means that you'll have to be part of the process in creating this system." "Oh, that. I did that on the plane. Here's what I came up with." He handed Percy a set of notes. (in Excel). I started with the questions the presenter at the conference asked us, and realized that I already had a lot of those answers that I could pull from the information I had with me. What do you think?" Percy spent a moment going over the notes, nodding to hirnself as he went. "I have to hand it to you, Uncle Jerry. These look really good. When did you learn about accounting?" While he was talking to Jerry, he quickly added the actual overhead costs to a spreadsheet (In Excel). "Ha, ha. That's very funny." Jerry said with mockindignation. "Just because I don't flaunt my knowledge, doesn't mean that it isn't there. Now, what else do we need?" "Well, we just need to figure out what activities are consuming the various types of overhead expenses. After I have that information, the rest of the processis long, but pretty straightforward." "Okay," lerry nodded as he looked again at the llst of costs and activities. "So, the biggest overhead expenses are the indirect salaries. I would think that 30% of those salaries are paid to the workers who help set up the production runs, 40% are paid to the experts in quality control, 20% paid to the maintenance staff, and the remainder are paid to those who help with transporting materlals and goods around the factory and receiving merchandise form vendors." Percy nodded. That sounds about right; so that pool of overhead money needs to be split up between four activities. Let's call those activities "setups," "quality control," "maintenance," and "transportation/receiving." He continued examining the document. "The ceaning supplies and depreciation are both part of maintaining the equipment. Shipping costs are all part of transportation and receiving," "That sounds right, "Jerry agreed. "Let's see. Well, most of the rent on the warehouse, probably 80%, is part of the transportationand receiving, wouldn't you say?" Percy nodded, "The rest is for hoiding merchandise waiting for quality control inspections." "Right. And maintenance and setup of production runs each account for 45% of the utility costs. The remainder is pretty everily split between transportation and quality control. Theparts and repair costs are evenly split between maintenance and setups." He pondered a minute more. "Finally, the insurance costs are evenly distributed among all four of these activities." "Perfect," lerry said. That didn't take long at all." "No, it didn't, which surprises me. But then, we still have all of the numbers to crunch and drivers to choose. And don't forget that we have to maintain this system. It's still a lot of work," "Agreed, but I still think that it will be worth the effort," "Well, you're the bosst" Percy said with a grin. "And don't you ever forget it!" With a return grin, Jerry headed out the door. "Jennifer," Percy looked up as she knocked on his open door. "Come in and meet Cassandra Lee." Jennifer shook the hand of the young woman. "We just hred Cassandra this morning as another member of our accounting staff. She is from Newark, DE and has fust completed her accounting degree at the University of Delaware." "l'm pleased to meet you, Cassandra" Jennifer said as she took a seat "rm excited to work with someone new." Cassandra nodded. "So, Percy, what do you need?" "Now that we have some extra help, we are going to move forward on one of Jerry's pet projects." Jennifer frowned. "Why does that not make me feel very excited?" Percy laughed. "Because of the amount of work his projects usually cause. This one is no exception to that rule, although it might give us some good data." He looked at his to young staff members. "We're going to create an ABC costing system." Cassandra nodded. "Those do provide the best data." Jennifer added. "And they can be difficult to create." Well, in this case we have most of the basics done. We are going to have four activities; setups, quality control, maintenance, and transportation/receiving. After some careful analysis, we will be using the number of set-up hours as the driver for setups, number of batches checked for the quality control activity, machine hours for maintenance, and items transported as the driver for the transportation and receiving activity. "Cassandra," he continued for a moment. "T'm going to have you start the process by determining the various activity rates. Here are my estimates of next year's driver usage." He handed a llst to Cassandra (In Excel). "For right now, you'll only need to use the first table on this list. Later, when you are actually allocating costs to the different products, you'll need the second table." "Okay," she said as she took the paper. "Till get it done right away." "Cassie?" Cassandra looked up as Jennifer stepped into her office. "Can I help you?" she asked politely. Jennifer smilied. "Tm not the boss. You don't have to be nervous when I stop by. I only graduated a few months ago myself." Cassandra smiled. "This is my first real job; I want to do everything correctly." 7I know the feeling, which is why I stopped by." Jennifer pulled a form out of her pocket. "I thought you might want to take the next step on that ABC project assigned from earlier in the quarter without waiting to be asked." "What do you mean?" "Well," Jennifer put the paper on her desk 7 just compled my end-of-quarter reports for the new special chip divsion, including my estimates of the drivers they used. Why don't we go ahead and run the numbers and see just how much overhead will be applied to each kind of chip?" Cassandra smiled. "And surprise Percy with the numbers al ready to gol" "Exactly." 1. Using the information from Jerry's notes and his discussion with Percy, calculate the amount of overhead that should be allocated to each of the four ABC activities. 2. Using the information provided by Percy about estimated cost driver usage and your answer to question 1 , determine the activity rate for each activity in the new ABCy stem. 3. Using information compiled by Jennifer about the drivers used by each specialty chip line, determine the amount of overhead that will be allocated to eachline. 4. Assuming that Roberts produced 180,000 bags of habanero chips; 200,000 bags of garlic & pepper chips; and 70,000 bags of basil \& chive chips, how much MOH will be assigned to a bag of each type of chip under the ABC system? Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 22 Actual Driversused by the three seccisficchip lines during the 1st quarter of this veae "Percy," Jerry Roberts, Roberts' CFO, said happily as he walked into the controller's office. "How are you doing? Well, "Percy said carefully. "I was doing okay" What do you mean yo were doing okay?" Jerry said, frowning. "Every time you walk in here with that kind of energy it means that you are going to ask me to do something." Jerry laughed. "I guess I'm getting a little predictable, huh?" "T'm afraid so. So, what do you want?" "Well, I have an idea for improving our cost accounting process." "Uh, huh. Just come back from a conference, didn't you?" "As a matter of fact, I did. How did you know?" "Because you only come up with accounting ideas when you've been to a conference. So, what is it this time?" Percy asked. "Have you ever thought about switching to an ABC costing system?" Percy shuddered. "Do you have any idea how much work is involved in creating one of those systems, not to mention maintaining the system after it is supposedly done? Believe me, Uncle Jerry, we don't want to go there, not without a much larger accounting staff than we currently have." 7 know it's a lot of work, Percy," Jerry said after a moment. "But I think we need to look into it anyway. The numbers are more accurate and they allow for better decision making. With the new system coming online, I think that we are going to need a solid ABC system in order to really determine which of our new products, if any, are making money." "But." Percy started to protest. "No "buts" Percy. I want you to do it. Y'l talk to Lauren in HR about hiring another staff member to free up some resources." Percy sighed. "Alright, if that's your decision. When do you want to hold the first meeting?" "First meeting?" Jerry frowned. To determine the cost centers and other components of the ABC system. We'll all have to agree on what they are if this is going to work. That means that you'll have to be part of the process in creating this system." "Oh, that. I did that on the plane. Here's what I came up with." He handed Percy a set of notes. (in Excel). I started with the questions the presenter at the conference asked us, and realized that I already had a lot of those answers that I could pull from the information I had with me. What do you think?" Percy spent a moment going over the notes, nodding to hirnself as he went. "I have to hand it to you, Uncle Jerry. These look really good. When did you learn about accounting?" While he was talking to Jerry, he quickly added the actual overhead costs to a spreadsheet (In Excel). "Ha, ha. That's very funny." Jerry said with mockindignation. "Just because I don't flaunt my knowledge, doesn't mean that it isn't there. Now, what else do we need?" "Well, we just need to figure out what activities are consuming the various types of overhead expenses. After I have that information, the rest of the processis long, but pretty straightforward." "Okay," lerry nodded as he looked again at the llst of costs and activities. "So, the biggest overhead expenses are the indirect salaries. I would think that 30% of those salaries are paid to the workers who help set up the production runs, 40% are paid to the experts in quality control, 20% paid to the maintenance staff, and the remainder are paid to those who help with transporting materlals and goods around the factory and receiving merchandise form vendors." Percy nodded. That sounds about right; so that pool of overhead money needs to be split up between four activities. Let's call those activities "setups," "quality control," "maintenance," and "transportation/receiving." He continued examining the document. "The ceaning supplies and depreciation are both part of maintaining the equipment. Shipping costs are all part of transportation and receiving," "That sounds right, "Jerry agreed. "Let's see. Well, most of the rent on the warehouse, probably 80%, is part of the transportationand receiving, wouldn't you say?" Percy nodded, "The rest is for hoiding merchandise waiting for quality control inspections." "Right. And maintenance and setup of production runs each account for 45% of the utility costs. The remainder is pretty everily split between transportation and quality control. Theparts and repair costs are evenly split between maintenance and setups." He pondered a minute more. "Finally, the insurance costs are evenly distributed among all four of these activities." "Perfect," lerry said. That didn't take long at all." "No, it didn't, which surprises me. But then, we still have all of the numbers to crunch and drivers to choose. And don't forget that we have to maintain this system. It's still a lot of work," "Agreed, but I still think that it will be worth the effort," "Well, you're the bosst" Percy said with a grin. "And don't you ever forget it!" With a return grin, Jerry headed out the door. "Jennifer," Percy looked up as she knocked on his open door. "Come in and meet Cassandra Lee." Jennifer shook the hand of the young woman. "We just hred Cassandra this morning as another member of our accounting staff. She is from Newark, DE and has fust completed her accounting degree at the University of Delaware." "l'm pleased to meet you, Cassandra" Jennifer said as she took a seat "rm excited to work with someone new." Cassandra nodded. "So, Percy, what do you need?" "Now that we have some extra help, we are going to move forward on one of Jerry's pet projects." Jennifer frowned. "Why does that not make me feel very excited?" Percy laughed. "Because of the amount of work his projects usually cause. This one is no exception to that rule, although it might give us some good data." He looked at his to young staff members. "We're going to create an ABC costing system." Cassandra nodded. "Those do provide the best data." Jennifer added. "And they can be difficult to create." Well, in this case we have most of the basics done. We are going to have four activities; setups, quality control, maintenance, and transportation/receiving. After some careful analysis, we will be using the number of set-up hours as the driver for setups, number of batches checked for the quality control activity, machine hours for maintenance, and items transported as the driver for the transportation and receiving activity. "Cassandra," he continued for a moment. "T'm going to have you start the process by determining the various activity rates. Here are my estimates of next year's driver usage." He handed a llst to Cassandra (In Excel). "For right now, you'll only need to use the first table on this list. Later, when you are actually allocating costs to the different products, you'll need the second table." "Okay," she said as she took the paper. "Till get it done right away." "Cassie?" Cassandra looked up as Jennifer stepped into her office. "Can I help you?" she asked politely. Jennifer smilied. "Tm not the boss. You don't have to be nervous when I stop by. I only graduated a few months ago myself." Cassandra smiled. "This is my first real job; I want to do everything correctly." 7I know the feeling, which is why I stopped by." Jennifer pulled a form out of her pocket. "I thought you might want to take the next step on that ABC project assigned from earlier in the quarter without waiting to be asked." "What do you mean?" "Well," Jennifer put the paper on her desk 7 just compled my end-of-quarter reports for the new special chip divsion, including my estimates of the drivers they used. Why don't we go ahead and run the numbers and see just how much overhead will be applied to each kind of chip?" Cassandra smiled. "And surprise Percy with the numbers al ready to gol" "Exactly." 1. Using the information from Jerry's notes and his discussion with Percy, calculate the amount of overhead that should be allocated to each of the four ABC activities. 2. Using the information provided by Percy about estimated cost driver usage and your answer to question 1 , determine the activity rate for each activity in the new ABCy stem. 3. Using information compiled by Jennifer about the drivers used by each specialty chip line, determine the amount of overhead that will be allocated to eachline. 4. Assuming that Roberts produced 180,000 bags of habanero chips; 200,000 bags of garlic & pepper chips; and 70,000 bags of basil \& chive chips, how much MOH will be assigned to a bag of each type of chip under the ABC system? Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 22 Actual Driversused by the three seccisficchip lines during the 1st quarter of this veae