I am not able to figure this out is is dealing with Traditional Costing and Activity Based Costing. I have uploaded the file with all the information. Thanks

Tracy

Analysis for Towels & More Common costs refer to the cost of resources used by multiple divisions, departments, or another type of grouping. These types of overhead costs are not only incurred within a profit center, but in many other parts of the organization. One example is overhead or common fixed costs for distribution and client support. We're using the latter for some hands-on experience in allocating common costs and analyzing the implications for T&M. Information follows below. Towels & More (T&M) is a small family company that produces and sells towels. T&M sells the towels to three types of stores: major retailers, specialty retailers and gift shops. The company is doing well and the CEO wants to expand the business. The contribution margin ratio is the highest for the small gift shops, so the CEO feels that those are the type of retail outlets to pursue. Below find T&M's income statement for last year. Towels & More For the year ended 12-31-XX Sales $600,000 Variable Production Costs 180,000 Contribution Margin $420,000 Fixed Costs: Production Overhead Selling & Distribution Costs Net Operating Income $120,000 240,000 $360,000 $60,000 ====== Customer support & distribution costs are pretty high at T&M. The total amount was $240,000 last year. The marketing manager has recently been to a seminar and learned about applying ABC to analyze customer and distribution costs. He suggests that the company analyze overhead costs associated with supporting different types of customers before proceeding with an expansion. The marketing manager knows that the small shops require a lot of attention and is somewhat dubious about the CEO's proposed strategy. The CEO accepts the suggestion and you are brought in as a consultant to prepare the analysis. The table below provides some information that may be pertinent for the analysis. Department Customer Support Description Level Level $200,000 $100,000 $300,000 50% 80% 80% 5 45 250 $40,000 10 90 900 $80,000 5 195 800 $120,000 20 480 1,000 No. of customers of shipments Activity 5,000 margin ratio Total costs/No. Activity 5,000 Contribution of sales calls Gift Shops 10,000 Revenues Total costs/No. Shops Activity Level Sales (units) of orders places Stores & Distribution Costs Total costs/No. Specialty Note that the contribution margin ratio varies due to different quality of towels sold to the stores. Required: Computations (use Excel). 1. Calculate the customer support and distribution costs associated with the three types of customers. 2. Use a simple strategy first and allocate the costs based on revenues. 3. Recalculate the allocations using activity based costing (ABC) based on the information in the table above. 4. Determine contribution margin less customer support and distribution costs for both approaches above