Pixel Studio, Incorporated, is a small company that creates computer-generated animations for films and television. Much of the company's work consists of short commercials for television, but the company also does realistic computer animations for special effects in movies. The young founders of the company have become increasingly concerned with the economics of the business-particularly since many competitors have sprung up recently in the local area. To help understand the company's cost structure, an activity-based costing system has been designed. Three major activities are carried out in the company: animation concept, animation production. and contract administration. The animation concept activity is carried out at the contract proposal stage when the company bids on projects. This is an intensive activity that involves individuals from all parts of the company in creating story boards and prototype stills to be shown to the prospective client. Once a project is accepted by the client, the animation goes into production and contract administration begins. Almost all of the work involved in animation production is done by the technical staff, whereas the administrative staff is largely responsible for contract administration. The activity cost pools and their activity measures are listed below: Activity Cost Pool Activity Rate Animation concept Animation production Contract administration Activity Measure Number of proposals $ 5,200 per proposal Minutes of completed animation Number of contracts $8,700 per minute $7,500 per contract These activity rates include all of the company's costs, except for its organization-sustaining costs and idle capacity costs. There are no direct labor or direct materials costs. Preliminary analysis using these activity rates has indicated that the local commercial segment of the market may be unprofitable. This segment is highly competitive. Producers of local commercials may ask three or four companies like Pixel Studio to bid, which results in an unusually low ratio of accepted contracts to bids. Furthermore, the animation sequences tend to be much shorter for local commercials than for other work. Since animation work is billed at fairly standard rates according to the running time of the completed animation, this means that the revenues from these short projects tend to be below average. Data concerning activity in the local commercial market appear below: Activity Heasure Local Commercials Activity Measure. Number of proposals Minutes of completed animation Number of contracts Local Commercials 22 13 5 The total sales from the 5 contracts for local commercials was $240,000. Required: 1. Calculate the cost of serving the local commercial market. 2. Calculate the margin earned serving the local commercial market. (Remember, this company has no direct materials or direct labor costs.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the margin earned serving the local commercial market. (Remember, this company has no direct materials or direct labor costs.) Profitability Analysis Costs: Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Xtreme $ 115.00 Pathfinder $ 85.00 Direct materials per unit Direct labor per unit $ Direct labor-hours per unit Estimated annual production and sales $ 63.90 12.00 1.2 DLHS 28,000 units $ 51.00 $ 10.00 1.0 DLHS 75,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below: Estimated total manufacturing overhead Estimated total direct labor-hours Required: $ 2,063,400 108,600 DLH 1. Compute the product margins for the Xtreme and the Pathfinder products under the company's traditional costing system. 2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing overhead to the following four activity cost pools (the Other cost pool includes organization-sustaining costs and idle capacity costs): Activities and (Activity Measures). Supporting direct labor (direct labor-hours) Batch setups (setups) Product sustaining (number of products) Other Total manufacturing overhead cost Estimated Overhead Cost Xtreme Expected Activity Pathfinder Total. 33,600 75,000 108,600 280 240 520 1 1 2 80,080 NA NA NA $ 673,320 520,000 790,000 $ 2,063,400 Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. 2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing overhead to the following four activity cost pools (the Other cost pool includes organization-sustaining costs and idle capacity costs): Activities and (Activity Measures) Supporting direct labor (direct labor-hours) Batch setups (setups) Product sustaining (number of products) Other Total manufacturing overhead cost Estimated Overhead Cost Expected Activity Xtreme Pathfinder Total 33,600 75,000 280 240 1 1 108,600 520 2 NA NA NA $ 673,320 520,000 790,000 80,080 $ 2,063,400 Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the product margins for the Xtreme and the Pathfinder products under the company's traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) Xtreme Pathfinder Total Product margin