"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 you 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?" "I'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." "I 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. I'll talk to Lauren in HR about hiring another staff member to free up some resources." Percy ed. "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 himself 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 mock indignation. "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 process is long, but pretty straightforward." "Okay," Jerry nodded as he looked again at the list of costs and activities. "So, the biggest overhead expenses are the indirect salaries. I would think that 35% of those salaries are paid to the workers who help set up the production runs, 45% are paid to the experts in quality control, 15% paid to the maintenance staff, and the remainder are paid to those who help with transporting materials 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 cleaning 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 70%, is part of the transportation and receiving, wouldn't you say?" Percy nodded. "The rest is for holding 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 evenly split between transportation and quality control. The parts 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," Jerry 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 boss!" 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 hired Cassandra this morning as another member of our accounting staff. She is from Newark, DE and has just completed her accounting degree at the University of Delaware." "I'm pleased to meet you, Cassandra" Jennifer said as she took a seat. "I'm 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. "I'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 list 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. "I'll get it done right away." "Cassie?" Cassandra looked up as Jennifer stepped into her office. "Can I help you?" She asked politely. Jennifer smiled. "I'm 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." "I 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. "I just compiled my end-of-quarter reports for the new special chip division, 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 all ready to go!" "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 ABCsystem. 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 each line. 4. Assuming that Roberts produced 180,500 bags of habanero chips; 201,500 bags of garlic & pepper chips; and 68,000 bags of basil & chive chips, how much MOH will be assigned to a bag of each type of chip under the ABC system? A B Overhead Costs by category (from Jerry's notes) 1 2 Indirect salaries 3 Cleaning supplies 4 Shipping costs 5 Rent on warehouse 6 Depreciation 7 Utilities 8 Parts and repairs 9 Insurance 10 Total 1 12 13 Drivers Used by the company last year (Budget for next year) 14 15 16 Setups 17 Batches Checked Driver 18 Machine Hours 19 Items transported 20 $400,000 $20,000 $155,000 $60,000 $310,000 $50,000 $15,000 $10,000 $1,020,000 24 Habenero 25 Garlic & Pepper 26 Basil & Chive 27 28 29 30 Budgeted Drivers 24,500 4,100 9,100 567,000 21 22 Actual Drivers used by the three specialty chip lines during the 1st quarter of this year 23 Products Setups Batches Checked 563 1,400 844 300 330 113 D Machine Hours 750 505 1,260 E Items Transported 60,938 158,430 24,355 LL F Batches Produced 9,000 10,050 3,425 G H