Marvin's Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to coverthe 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.ActivityProcessing orderLoading truckDelivering merchandiseProcessing invoiceTotal overheadOrder valueNumber of ordersNumber of itemsNumber of invoices.Cost DriverNumber of ordersNumber of itemsNumber of ordersNumber of invoicesTwo 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$75,000$90,000Required A Required B5260012Cost Driver Volume1101,500150Processing orderLoading truckDelivering merchandiseProcessing invoiceTotal costCost$ 75,000150,00090,00072,000$387,000Driver Volume5,000 orders100,000 items5,000 orders4,000 invoicesRequired: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 deliveringto each customer.Complete this question by entering your answers in the tabs below.Calculate the cost of each activity for both restaurants to determine the total activity-based costing estimate of the cost ofdelivering to each customer. (Do not round intermediate calculations.)City DinerLe Chien Chaud Marvin's Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to coverthe 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.ActivityProcessing orderLoading truckDelivering merchandiseProcessing invoiceTotal overheadOrder valueNumber of ordersNumber of itemsNumber of invoicesCost DriverNumber of ordersNumber of itemsNumber of ordersNumber of invoicesTwo 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$75,000$90,0001101,500150Required ACost Driver Volume5260012Cost$ 75,000150,00090,00072,000$387,000Required BCity DinerLe Chien ChaudDriver Volume5,000 orders100,000 itemsRequired: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 deliveringto each customer.Complete this question by entering your answers in the tabs below.5,000 orders4,000 invoicesWhat would the delivery charge for each customer be under the current policy of 10 percent of order value?Delivery ChargePer Customer

Activity-based costing refers to the method in which the overheads are assigned to each product or…

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. Activity Processing order Loading truck Delivering merchandise Processing invoice Total overhead Cost Driver Number of orders Number of items Number of orders Number of invoices Order value Number of orders Number of items Number of invoices 52 600 12 Cost Driver Volume Driver Volume 5,000 orders 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 $75,000 $90,000 110 1,500 150 Cost $ 75,000 150,000 90,000 72,000 $387,000 100,000 items 5,000 orders 4,000 invoices 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. Activity Processing order Loading truck Delivering merchandise Processing invoice Total overhead Cost Driver Number of orders Number of items Number of orders Number of invoices Order value Number of orders Number of items Number of invoices 52 600 12 Cost Driver Volume Driver Volume 5,000 orders 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 $75,000 $90,000 110 1,500 150 Cost $ 75,000 150,000 90,000 72,000 $387,000 100,000 items 5,000 orders 4,000 invoices 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.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 4BE: Activity-based costing: selling and administrative expenses Jungle Junior Company manufactures and...

See similar textbooks

Similar questions

Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?
Rupert’s Appliance Warehouse (RAW) delivers appliances to retailers throughout the city. The firm adds 6 percent to the cost of the appliances to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. The finance team at RAW has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow: Activity Cost Driver Activity Cost Cost Driver Volume Processing order Number of orders $ 84,000 6,000 orders Loading truck Number of items 290,000 145,000 items Delivering order Number of orders 102,000 6,000 orders Billing Number of invoices 85,000 5,000 invoices Total overhead $ 561,000 Two of Rupert's customers are McLean Designs and Neveux Appliances. Data for orders and deliveries to these two customers follow: McLean Designs Neveux Appliances Order value (total) $ 86,000 $ 96,000 Number of orders 66 236 Total number of items 900 1,600 Number of invoices 14 180…
Comfort Foods Inc. uses activity-based costing to determine product costs. For each activity listed in the left column, match an appropriate activity base from the right column. You may use items in the activity-base list more than once or not at all. Activity Activity Base Cafeteria Engineering change orders Customer return processing Electric power Kilowatt hours used Number of customers Human resources Number of customer orders Number of customer returns Inventory control Invoice and collecting Machine depreciation Materials handling Order shipping Payroll Performance reports Number of employees Number of inspections Number of inventory transactions Number of machine hours Number of material moves Number of payroll checks processed Number of performance reports Number of production orders Number of purchase orders Production control Production setup Purchasing Quality control Sales order processing Number of sales orders Number of setups
Rupert’s Appliance Warehouse (RAW) delivers appliances to retailers throughout the city. The firm adds 6 percent to the cost of the appliances to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. The finance team at RAW has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow: Activity Cost Driver Activity Cost Cost Driver Volume Processing order Number of orders $ 70,000 5,000 orders Loading truck Number of items 105,000 75,000 items Delivering order Number of orders 85,000 5,000 orders Billing Number of invoices 68,000 4,000 invoices Total overhead $ 328,000 Two of Rupert's customers are McLean Designs and Neveux Appliances. Data for orders and deliveries to these two customers follow: McLean Designs Neveux Appliances Order value (total) $ 72,000 $ 82,000 Number of orders 52 96 Total number of items 510 1,200 Number of invoices 12 90…
Figure Four is a distributor of pharmaceutical products. Its activity-based costing system has five activity areas: Activity Area Cost Driver and Rate Order processing $40 per order Line item ordering $3 per line item Store deliveries $50 per store delivery Carton deliveries $1 per carton Shelf-stocking $16 per stocking-hour Rick Flair, the controller of Figure Four, wants to use this activity-based costing system to examine individual customer profitability within each distribution market. Two customers are used to exemplify the insights available with the activity-based costing approach. Data pertaining to these two customers in August are as follows: Charleston Pharmacy Chapel Hill Pharmacy Total orders 12 10 Average line items per order 10 18 Total store deliveries 6 10 Average cartons shipped per store delivery 24 20 Average hours of shelf-stocking per store delivery 0 0.5 Average…
Allocating Selling and Administrative Expenses using Activity-Based CostingShrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price$1,110per unitCost of goods sold682 Gross profit$428per unit In addition, the company incurs selling and administrative expenses of $414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: ActivityBudgeted Activity Cost Activity BaseCustomer service$76,860Number of service requestsSales order processing25,920Number of sales…
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 VolumeActivityCost DriverCostDriver VolumeProcessing orderNumber of orders$104,0008,000ordersLoading truckNumber of items312,000195,000itemsDelivering merchandiseNumber of orders128,0008,000ordersProcessing invoiceNumber of invoices112,0007,000invoicesTotal overhead$656,000 Two of Marvin's customers are City Diner and Le Chien Chaud. Data for orders and deliveries to these two customers follow. City DinerLe Chien ChaudOrder value$88,000$98,000Number of orders68300Number of items5501,800Number of invoices12200 Required: a. What would the delivery charge for each customer be under the current policy of 10 percent of…
Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Total Cost Total Activity Customer deliveries (Number of deliveries) $ 400,000 8,000 deliveries Manual order processing (Number of manual orders) $ 280,000 5,000 manual orders Electronic order processing (Number of electronic orders) $ 150,000 15,000 electronic orders Line item picking (Number of line items picked) $ 450,000 375,000 line items Other organization-sustaining costs (None) $ 300,000 The company serves numerous customers, two of which include Hospital A and Hospital B. The activity demands pertaining to these two customers are as follows: Activity Measure Activity Hospital A Hospital B Number of deliveries 10 25 Number of manual orders 0 31 Number of electronic orders 15 0 Number of line items picked 120 250 How much cost would be assigned from the Manual Order Processing activity to…
Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Total Cost Total Activity Customer deliveries (Number of deliveries) $ 400,000 8,000 deliveries Manual order processing (Number of manual orders) $ 280,000 5,000 manual orders Electronic order processing (Number of electronic orders) $ 150,000 15,000 electronic orders Line item picking (Number of line items picked) $ 450,000 375,000 line items Other organization-sustaining costs (None) $ 300,000 The company serves numerous customers, two of which include Hospital A and Hospital B. The activity demands pertaining to these two customers are as follows: Activity Measure Activity Hospital A Hospital B Number of deliveries 10 25 Number of manual orders 0 30 Number of electronic orders 15 0 Number of line items picked 125 250 How much total activity cost should be assigned to Hospital A for internal…
Metroid Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $420 per request Shipment Number of shipments $90 per shipment Support standard items Number of standard items ordered $30 per std. item Support nonstandard items Number of nonstandard items ordered $180 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $130,000 $210,000 $180,000 Cost of goods sold (81,900) (113,400) (90,000) Gross profit $48,100 $96,600 $90,000 Gross profit…
Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $80 per shipment Support standard items Number of standard items ordered $25 per standard item Support nonstandard items Number of nonstandard items ordered $150 per nonstandard item Assume that the company had the following gross profit information for three representative customers: Income Statement Item Customer 1 Customer 2 Customer 3 Revenue $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…
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…