This is a cost allocation problem for a merchandising firm. Since merchandising firms do not have overhead, you must allocate "support costs" instead of "overhead costs." Also, the allocations in this problem are to a product line, not to an individual product or job. Nonetheless, the allocation process is the same. Just follow the three steps used in the lectures:
1. Read the problem and question carefully to determine the cost driver.
2. Compute the "overhead" rate - budgeted operating costs / budgeted driver for all product lines.
3. Allocate to the specific product line; overhead rate X driver for the specific product line.
Remember that with activity-based costing (Part B), there is more than one driver and more than one rate, and the allocation to a product line is the sum of several individual allocations.
Each part of the problem is worth five points, and you get five tries per part.
Family Supermarkets has decided to increase the size of its Lansing store. It wants information about the profitability of its individual product lines: meats, fresh produce, and packaged food. The following data is for the year 2014 for each product line:
|
|
Meats
|
Fresh Produce
|
Packaged Foods
|
|
Revenue
|
5795,000
|
5840,000
|
5460,000
|
|
Cost of goods sold
|
5595,000
|
5600,000
|
5340,000
|
|
purchase orders
|
273
|
334
|
134
|
|
hours of stocking shelves
|
216
|
2,259
|
1,033
|
|
items sold
|
321,000
|
432,000
|
104,000
|
The Company also provides the following information for 2014 for its three support activities:
The Company also provides the following information for 2014 for its three support activities:
|
Support Activity
|
Budgeted Cost
|
Cost Driver
|
|
Ordering
|
$107,000
|
purchase orders
|
|
Shelf stocking
|
$84,000
|
hours of stocking shelves
|
|
Customer support
|
$175,000
|
items sold
|
REQUIRED [ROUND ALL OVERHEAD RATES TO THREE DECIMAL PLACES AND ALL ALLOCATIONS TO THE NEAREST DOLLAR.]
Part A
Family Supermarkets currently uses a single-driver system to allocate period costs to its product lines. The single driver that is used is the the number of items sold of each product line. Using this system, compute the allocation to Meats. 141610
Incorrect
Part B
If Family Supermarkets instead used an activity-based costing system to allocate period costs, with the cost pools and cost drivers listed in the tables above, how much would be allocated to Packaged Foods?