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.三Cost Driver VolumeActivityProcessing orderLoading truckDelivering merchandiseProcessing invoiceCost$ 60,000266,00072,000Driver Volume4,000 orders140,000 items4,000 orders3,000 invoicesCost DriverNumber of ordersNumber of itemsNumber of ordersNumber of invoices54,000Total overhead$452,000Two of Marvin's customers are City Diner and Le Chien Chaud. Data for orders and deliveries to these two customers follow.City Diner$77,000Le Chien ChaudOrder value$87,000Number of orders57190Number of itemsNumber of invoices4502,30011230Required: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

a) Calculation of delivery charges is as follows: Resultant table:

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 Driver Volume Activity Processing order Loading truck Delivering merchandise Processing invoice Cost Driver Cost $ 60,000 266,000 72,000 54,000 Number of orders 4,000 orders 140,000 items 4,000 orders 3,000 invoices Number of items Number of orders Number of invoices Total overhead $452,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 $77,000 Order value Number of orders Number of items $87,000 57 190 2,300 230 450 Number of invoices 11 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

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 Driver Volume Activity Processing order Loading truck Delivering merchandise Processing invoice Cost Driver Cost $ 60,000 266,000 72,000 54,000 Number of orders 4,000 orders 140,000 items 4,000 orders 3,000 invoices Number of items Number of orders Number of invoices Total overhead $452,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 $77,000 Order value Number of orders Number of items $87,000 57 190 2,300 230 450 Number of invoices 11 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

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

Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?
Roper Furniture manufactures office furniture and tracks cost data across their process. The following are some of the costs that they incur. Classify these costs as fixed or variable costs, and as product costs or period costs. Wood used to produce desks ($125,00 per desk) Production labor used to produce desks ($15 per hour) Production supervisor salary ($45,000 per year) Depreciation on factory equipment ($60,000 per year) Selling and administrative expenses ($45,000 per year) Rent on corporate office ($44,000 per year) Nails, glue, and other materials required to produce desks (varies per desk) Utilities expenses for production facility Sales staff commission (5% of gross sales)
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next months sales are in the finished goods inventory. Ingles also purchases sufficient materials to ensure that materials inventory is 60 percent of the following months scheduled production. Ingless sales budget in units for the next quarter is as follows: Ingless ending inventories in units for July 31 are as follows: Required: 1. Calculate the number of tables to be produced during August. 2. Disregarding your response to Requirement 1, assume the required production units for August and September are 2,100 and 1,900, respectively, and the July 31 materials inventory is 4,000 units. Compute the number of table legs to be purchased in August. 3. Assume that Ingles Corporation will produce 2,340 units in September. How many employees will be required for the Assembly Department in September? (Fractional employees are acceptable since employees can be hired on a part-time basis. Assume a 40-hour week and a 4-week month.) (CMA adapted)
Mott Company recently implemented a JIT manufacturing system. After one year of operation, Heidi Burrows, president of the company, wanted to compare product cost under the JIT system with product cost under the old system. Motts two products are weed eaters and lawn edgers. The unit prime costs under the old system are as follows: Under the old manufacturing system, the company operated three service centers and two production departments. Overhead was applied using departmental overhead rates. The direct overhead costs associated with each department for the year preceding the installation of JIT are as follows: Under the old system, the overhead costs of the service departments were allocated directly to the producing departments and then to the products passing through them. (Both products passed through each producing department.) The overhead rate for the Machining Department was based on machine hours, and the overhead rate for assembly was based on direct labor hours. During the last year of operations for the old system, the Machining Department used 80,000 machine hours, and the Assembly Department used 20,000 direct labor hours. Each weed eater required 1.0 machine hour in Machining and 0.25 direct labor hour in Assembly. Each lawn edger required 2.0 machine hours in Machining and 0.5 hour in Assembly. Bases for allocation of the service costs are as follows: Upon implementing JIT, a manufacturing cell for each product was created to replace the departmental structure. Each cell occupied 40,000 square feet. Maintenance and materials handling were both decentralized to the cell level. Essentially, cell workers were trained to operate the machines in each cell, assemble the components, maintain the machines, and move the partially completed units from one point to the next within the cell. During the first year of the JIT system, the company produced and sold 20,000 weed eaters and 30,000 lawn edgers. This output was identical to that for the last year of operations under the old system. The following costs have been assigned to the manufacturing cells: Required: 1. Compute the unit cost for each product under the old manufacturing system. 2. Compute the unit cost for each product under the JIT system. 3. Which of the unit costs is more accurate? Explain. Include in your explanation a discussion of how the computational approaches differ. 4. Calculate the decrease in overhead costs under JIT, and provide some possible reasons that explain the decrease.
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?
One of the tennis rackets that Ace Sporting Goods manufactures is a titanium model (Slam) that sells for 149. The cost of each Slam consists of: Job 100 produced 100 Slams, of which six were spoiled and classified as seconds. Seconds are sold to discount stores for 50 each. Required: 1. Under the assumption that the loss from spoilage will be distributed to all jobs produced during the current period, use general journal entries to (a) record the costs of production, (b) put spoiled goods into inventory, and (c) record the cash sale of spoiled units. 2. Under the assumption that the loss due to spoilage will be charged to Job 100, use general journal entries to (a) record the costs of production, (b) put spoiled goods into inventory, and (c) record the cash sale of spoiled units.
Pinter Company had the following environmental activities and product information: 1. Environmental activity costs 2. Driver data 3. Other production data Required: 1. Calculate the activity rates that will be used to assign environmental costs to products. 2. Determine the unit environmental and unit costs of each product using ABC. 3. What if the design costs increased to 360,000 and the cost of toxic waste decreased to 750,000? Assume that Solvent Y uses 6,000 out of 12,000 design hours. Also assume that waste is cut by 50 percent and that Solvent Y is responsible for 14,250 of 15,000 pounds of toxic waste. What is the new environmental cost for Solvent Y?
Salley is developing material and labor standards for her company. She finds that it costs $0.55 per pound of material per widget. Each widget requires 6 pounds of material per widget. Salley is also working with the operations manager to determine what the standard labor cost is for a widget. Upon observation, Salley notes that it takes 3 hours in the assembly department and 1 hour in the finishing department to complete one widget. All employees are paid $10.50 per hour. A. What is the standard materials cost per unit for a widget? 8. What is the standard labor cost per unit for a widget?
Box Springs. Inc., makes two sizes of box springs: queen and king. The direct material for the queen is $35 per unit and $55 is used in direct labor, while the direct material for the king is $55 per unit, and the labor cost is $70 per unit. Box Springs estimates it will make 4,300 queens and 3,000 kings in the next year. It estimates the overhead for each cost pool and cost driver activities as follows: How much does each unit cost to manufacture?
Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)
Brody Company makes industrial cleaning solvents. Various chemicals, detergent, and water are mixed together and then bottled in 10-gallon drums. Brody provided the following information for last year: Last year, Brody completed 100,000 units. Sales revenue equaled 1,200,000, and Brody paid a sales commission of 5 percent of sales. Required: 1. Calculate the direct materials used in production for last year. 2. Calculate total prime cost. 3. Calculate total conversion cost. 4. Prepare a cost of goods manufactured statement for last year. Calculate the unit product cost. 5. Prepare a cost of goods sold statement for last year. 6. Prepare an income statement for last year. Show the percentage of sales that each line item represents.
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 2,000 direct labor hours. The total indirect labor is budgeted to be 200,000. Time records from indirect labor employees revealed that they spent 30% of their time setting up production runs and 70% of their time supporting actual production. The following information about cell phones and tablet PCs was determined from the corporate records: a. Determine the indirect labor cost per unit allocated to cell phones and tablet PCs under a single plantwide factory overhead rate system using the direct labor hours as the allocation base. b. Determine the budgeted activity costs and activity rates for the indirect labor under activity-based costing. Assume two activitiesone for setup and the other for production support. c. Determine the activity cost per unit for indirect labor allocated to each product under activity-based costing. d. Why are the per-unit allocated costs in (a) different from the per-unit activity cost assigned to the products in (c)?