In: Accounting
Sara’s Salsa Company produces its condiments in two types: Extra
Fine for restaurant customers and Family Style for home use. Salsa
is prepared in department 1 and packaged in department 2. The
activities, overhead costs, and drivers associated with these two
manufacturing processes and the company’s production support
activities follow.
| Process | Activity | Overhead cost | Driver | Quantity | ||
| Department 1 | Mixing | $ | 5,800 | Machine hours | 2,200 | |
| Cooking | 12,900 | Machine hours | 2,200 | |||
| Product testing | 113,800 | Batches | 1,000 | |||
| $ | 132,500 | |||||
| Department 2 | Machine calibration | $ | 315,000 | Production runs | 500 | |
| Labeling | 20,000 | Cases of output | 145,000 | |||
| Defects | 9,000 | Cases of output | 145,000 | |||
| $ | 344,000 | |||||
| Support | Recipe formulation | $ | 82,000 | Focus groups | 40 | |
| Heat, lights, and water | 33,000 | Machine hours | 2,200 | |||
| Materials handling | 78,000 | Container types | 8 | |||
| $ | 193,000 | |||||
Additional production information about its two product lines
follows.
| Extra Fine | Family Style | |||
| Units produced | 33,000 | cases | 112,000 | cases | 
| Batches | 330 | batches | 670 | batches | 
| Machine hours | 900 | MH | 1,300 | MH | 
| Focus groups | 30 | groups | 10 | groups | 
| Container types | 6 | containers | 2 | containers | 
| Production runs | 240 | runs | 260 | runs | 
4. Using ABC, compute the total cost per case
for each product type if the direct labor and direct materials cost
is $9 per case of Extra Fine and $8 per case of Family Style.
(Round your intermediate calculations to 2 decimal places.
Round "Activity Rate" and "Overhead cost per unit" answers to 2
decimal places.)
| Extra fine | Family style | |||||||||||||||
| overhead | Avtivity Driver | Activity rate | Activity Drivers | overhead | Activity Drivers | overhead | ||||||||||
| 4) | Activity | cost | assinged | assinged | ||||||||||||
| Mixing & cooking | 18,700 | 2,200 | machine hours | 8.5 | per machine hour | 900 | 7650 | 1300 | 11050 | |||||||
| product testing | 113,800 | 1000 | Batches | 113.8 | per batch | 330 | 37554 | 670 | 76246 | |||||||
| Machine Calibration | 315,000 | 500 | production run | 630 | per production run | 240 | 151200 | 260 | 163800 | |||||||
| Labeling & Defects | 29,000 | 145,000 | cases of output | 0.2 | per case | 33000 | 6600 | 112,000 | 22400 | |||||||
| Recipe formulation | 82,000 | 40 | Focus groups | 2050 | per focus group | 30 | 61500 | 10 | 20500 | |||||||
| heat,light and water | 33,000 | 2,200 | machine hours | 15 | per machine hour | 900 | 13500 | 1300 | 19500 | |||||||
| Material handling | 78,000 | 8 | container type | 9750 | per container type | 6 | 58500 | 2 | 19500 | |||||||
| 669,500 | total OH cost assign | 336504 | total OH cost assign | 332996 | ||||||||||||
| total units produced | 33,000 | total units produced | 112,000 | |||||||||||||
| oh cost per unit | 10.20 | oh cost per unit | 2.97 | |||||||||||||
| Extra | Family | |||||||||||||||
| fine | Style | |||||||||||||||
| Direct materials & direct labor | 9.00 | 8.00 | ||||||||||||||
| overhead | 10.20 | 2.97 | ||||||||||||||
| tota cost/case | 19.20 | 10.97 | ||||||||||||||