Question

In: Accounting

eBook Show Me How Calculator Print Item Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute...

eBook

Show Me How

Calculator

Print Item

Allocating Selling and Administrative Expenses using Activity-Based Costing

Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows:

Price $750 per unit
Cost of goods sold 450
Gross profit $300 per unit

In addition, the company incurs selling and administrative expenses of $226,700. 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:

Activity Budgeted Activity Cost Activity Base
Customer service $39,000 Number of service requests
Sales order processing 24,500 Number of sales orders
Advertising support 163,200 Number of ads placed
Total activity cost $226,700

Activity-base usage and unit volume information for the three customers is as follows:

The Warehouse Kosmo Co. Supply Universe Total
Number of service requests 50 10 190 250
Number of sales orders 270 120 590 980
Number of ads placed 20 10 90 120
Unit volume 630 630 630 1,890

Required:

1. Determine the activity rates for each of the three nonmanufacturing activities. Round to the nearest whole dollar.

Activity Rate
Customer Service $ per serv. req.
Sales Order Processing $ per bid
Advertising Support $ per customer design change

2. Determine the activity costs allocated to the three customers, using the activity rates in (1).

Activity Costs
The Warehouse $
Kosmo Co. $
Supply Universe $

3. Construct customer profitability reports for the three customers, dated for the year ended December 31, 2016, using the activity costs in (2). The reports should disclose the gross profit and income from operations associated with each customer. Enter all amounts as positive numbers, except for a negative income from operations.

Shrute Inc.
Customer Profitability Report
For the Year Ended December 31
The Warehouse Kosmo Co. Supply Universe
Revenues $ $ $
Cost of goods sold
Gross profit $ $ $
Selling and administrative activities:
Customer service $ $ $
Sales order processing
Advertising support
Total selling and administrative activities $
Income (loss) from operations $ $ $

Solutions

Expert Solution


Related Solutions

Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $730 per unit Cost of goods sold 440 Gross profit $290 per unit In addition, the company incurs selling and administrative expenses of $232,160. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price$690 per unit Cost of goods sold(410) Gross profit$280 per unit In addition, the company incurs selling and administrative expenses of $263,410. 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...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $650 per unit Cost of goods sold 390 Gross profit $260 per unit In addition, the company incurs selling and administrative expenses of $276,980. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $720 per unit Cost of goods sold (430) Gross profit $290 per unit In addition, the company incurs selling and administrative expenses of $226,570. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $700 per unit Cost of goods sold 420 Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $270,510. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
eBook Show Me How Calculator Print Item Determine the amount of sales (units) that would be...
eBook Show Me How Calculator Print Item Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 91,800 units at a price of $129 per unit during the current year. Its income statement for the current year is as follows: Sales $11,842,200 Cost of goods sold 5,848,000 Gross profit $5,994,200 Expenses: Selling expenses $2,924,000 Administrative expenses 2,924,000 Total expenses 5,848,000 Income from operations $146,200 The...
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial...
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Price $60,000 per unit Cost of goods sold (28,000) Gross profit $32,000 per unit In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to...
eBook Show Me How Calculator Print Item Sales-Related Transactions using Perpetual Inventory System The following selected...
eBook Show Me How Calculator Print Item Sales-Related Transactions using Perpetual Inventory System The following selected transactions were completed by Green Lawn Supplies Co., which sells irrigation supplies primarily to wholesalers and occasionally to retail customers: July 1. Sold merchandise on account to Landscapes Co., $33,450, terms FOB shipping point, n/eom. The cost of merchandise sold was $20,000. 2. Sold merchandise for $86,000 plus 8% sales tax to retail cash customers. The cost of merchandise sold was $51,600. 5. Sold...
eBook Calculator Print Item Activity-Based Costing and Product Cost Distortion Digital Storage Concept Inc. is considering...
eBook Calculator Print Item Activity-Based Costing and Product Cost Distortion Digital Storage Concept 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 4,000 direct labor hours. The total indirect labor is budgeted to be $386,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time...
eBook Show Me How Calculator Print Item (Appendix 6A) FIFO; Production Report Aztec Inc. produces soft...
eBook Show Me How Calculator Print Item (Appendix 6A) FIFO; Production Report Aztec Inc. produces soft drinks. Mixing is the first department, and its output is measured in gallons. Aztec uses the FIFO method. All manufacturing costs are added uniformly. For July, the mixing department provided the following information: Production: Units in process, July 1, 60% complete 18,000 gallons Units completed and transferred out 141,000 gallons Units in process, July 31, 45% complete 16,000 gallons Costs: Work in process, July...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT