Question: Assembling and packaging small electronic devices for U.S. households in two contracted manufacturing plants: Olympia, Washington and Houston, Texas, TBG Hometronics Company distributes finished products

Assembling and packaging small electronic devices for U.S. households in two contracted manufacturing plants: Olympia, Washington and Houston, Texas, TBG Hometronics Company distributes finished products to three TBG-owned regional distribution centers (DCs) - the West region DC located in Sacramento, California, the Central region DC located in Topeka, Kansas, and the East region DC in Richmond, Virginia. The regional DCs are supporting two major segments - eCity and Shop4Less simultaneously in each of the five regional markets in the U.S.: Northwest, Southwest, Central, Northeast and Southeast. TBG has long partnered with eCity, which has five retail stores in each regional market. To diversify its customer base, TBG developed a second distribution channel - Shop4Less, which has two mega- stores in each regional market. TBG does not own warehouses in regional markets and hence outsources local stocking and delivery-to-store services to a national 3PL firm - Aplus Logistics Co. According to the agreement, TBG ships products from its own regional DCs to one centralized Aplus warehouse located in each of those five markets and Aplus is responsible for local stocking and direct-to-store deliveries to eCity's stores and Shop4Less's stores with a flat charge of $800 per trip including stocking and delivery. James Smith, vice president of distribution for TBG, was preparing for the annual strategy review meeting conducted by the executive team. Smith needed to assess the company's logistics costs and profitability of its two distribution channels: eCity, a retail chain, and Shop4Less, a mass merchandiser. A quick review of the company's prior year financials and distribution information made Smith believe that transportation costs may be too high. Furthermore, Smith wondered whether the current inventory commitment with eCity and with Shop4Less may be re-negotiated given that inventory carrying cost is approximately 20% of inventory value. Smith was also concerned about the financing costs associated with payment terms for TBG's customers. From last year's shipment data, Smith was able to put together sales break-downs by market and by distribution channel (Table 1). Smith noted that each package contains 500 units of TBG products. 4,000 packages were shipped to eCity stores with 2,000 orders placed and 6,000 packages were shipped to Shop4Less with 500 orders placed. Average selling prices per unit were $25 when sold to eCity stores and $20 when sold to Shop4Less. Costs of goods sold per unit were $15 for all products. Table 1 Sales by Market and Distribution Channel (in Number of Packages) Channel NW Market SW Market eCity 900 Shop4Less 1100 500 800 Central Market 900 NE Market SE Market Total 800 900 1400 1600 1100 4000 6000 Smith broke down logistics costs by major activities (Table 2). Table 2 Logistics Costs Order Processing $ 1,000,000 Packaging $ 2,500,000 Transportation (from Plants to Regional $ 5,500,000 DCs) Local Stocking and Delivery Charges (3PL) $ 1,800,000 Total Logistics Costs $ 10,800,000 Per agreements, TBG maintained a 60-day inventory supply for eCity stores and provided weekly direct deliveries to each retail store. TBG maintained a 30-day inventory supply for Shop4Less and shipped directly to each of its stores twice a week. All sales were made on credit with net 60 days for eCity and net 45 days for Shop4Less in terms of accounts receivables. Smith understood that TBG's average financing cost was approximately 9%. For convenience of calculation, in this exercise please assume 360 business days and 50 delivery weeks in a year. Q1: Based on Activity-based Costing (ABC), what are the appropriate allocations of total logistics costs for each segment excluding inventory and sales financing costs (type numerical values only without the $ sign, use thousands separator, rounded to whole dollars. For example, 4,000,599)? eCity: Shop4Less

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!