Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. A consultant has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow. Cost Driver Volume Activity Cost Driver Cost Driver Volume Processing order Number of orders $ 42,000 3,000 orders Loading truck Number of items 243,000 135,000 items Delivering merchandise Number of orders 51,000 3,000 orders Processing invoice Number of invoices 34,000 2,000 invoices Total overhead $ 370,000 Two of Marvin's customers are City Diner and Le Chien Chaud. Data for orders and deliveries to these two customers follow. City Diner Le Chien Chaud Order value $ 76,000 $ 86,000 Number of orders 56 180 Number of items 400 2,200 Number of invoices 10 220 Required: a. What would the delivery charge for each customer be under the current policy of 10 percent of order value? b. Calculate the cost of each activity for both restaurants to determine the total activity-based costing estimate of the cost of delivering to each customer.
Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. A consultant has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow.
Cost Driver Volume | |||||||
Activity | Cost Driver | Cost | Driver Volume | ||||
Processing order | Number of orders | $ | 42,000 | 3,000 | orders | ||
Loading truck | Number of items | 243,000 | 135,000 | items | |||
Delivering merchandise | Number of orders | 51,000 | 3,000 | orders | |||
Processing invoice | Number of invoices | 34,000 | 2,000 | invoices | |||
Total |
$ | 370,000 | |||||
Two of Marvin's customers are City Diner and Le Chien Chaud. Data for orders and deliveries to these two customers follow.
City Diner | Le Chien Chaud | |||||
Order value | $ | 76,000 | $ | 86,000 | ||
Number of orders | 56 | 180 | ||||
Number of items | 400 | 2,200 | ||||
Number of invoices | 10 | 220 | ||||
Required:
a. What would the delivery charge for each customer be under the current policy of 10 percent of order value?
b. Calculate the cost of each activity for both restaurants to determine the total activity-based costing estimate of the cost of delivering to each customer.
Step by step
Solved in 2 steps with 2 images