Hello, I need help with my assignment. I've attached an excel file with the questions. Thank you!

Exercise 4-10 Kragan Clothing Company manufactures its own designed and labeled athletic wear and sells its products through catalog sales and retail outlets. While Kragan has for years used activity-based costing in its manufacturing activities, it has always used traditional costing in assigning its selling costs to its product lines. Selling costs have traditionally been assigned to Kragan's product lines at a rate of 70% of direct materials costs. Its direct materials costs for the month of March for Kragan's \"high-intensity\" line of athletic wear are $390,000. The company has decided to extend activity-based costing to its selling costs. Data relating to the \"high-intensity\" line of products for the month of March are as follows. Overhead Activity Cost Pools Cost Drivers Rate Sales commissions Dollar sales AdvertisingTV Minutes AdvertisingInternet Column inches Catalogs Catalogs mailed Cost of catalog sales Catalog orders Credit and collection $0.05 per dollar sales Dollar sales $300 per minute $10 per column inch $2.50 per catalog $1 per catalog order $0.03 per dollar sales Number of Cost Drivers Used per Activity $935,000 240 1,900 58,800 8,550 935,000 QUESTION 1 Compute the selling costs to be assigned to the \"high-intensity\" line of athletic wear for the month of March (1) using the traditional product costing system (direct materials cost is the cost driver), and (2) using activity-based costing. Activitybased costing Traditional product costing Selling cost to be assigned $ $ QUESTION 2 By what amount does the traditional product costing system undercost or overcost the \"high-intensity\" product line? Exercise 4-11 Health 'R Us, Inc., uses a traditional product costing system to assign overhead costs uniformly to all its packaged multigrain products. To meet Food and Drug Administration requirements and to assure its customers of safe, sanitary, and nutritious food, Health 'R Us engages in a high level of quality control. Health 'R Us assigns its quality-control overhead costs to all products at a rate of 17% of direct labor costs. Its direct labor cost for the month of June for its low-calorie breakfast line is $71,500. In response to repeated requests from its financial vice president, Health 'R Us's management agrees to adopt activity-based costing. Data relating to the low-calorie breakfast line for the month of June are as follows. Activity Cost Pools Overhead Number of Cost Drivers Rate Cost Drivers Used per Activity Inspections of material received Number of pounds $0.90 per pound 5,600 pounds In-process inspections Number of servings $0.33 per serving 11,000 servings FDA certification Customer orders $12.00 per order 500 orders QUESTION 1 Compute the quality-control overhead cost to be assigned to the low-calorie breakfast product line for the month of June (1) using the traditional product costing system (direct labor cost is the cost driver), and (2) using activity-based costing. Activitybased costing Traditional product costing Quality-control overhead cost to be assigned $ $ QUESTION 2 By what amount does the traditional product costing system undercost or overcost the low-calorie breakfast line? Problem 4-3A Shaker Stairs Co. designs and builds factory-made premium wooden stairways for homes. The manufactured stairway components (spindles, risers, hangers, hand rails) permit installation of stairways of varying lengths and widths. All are of white oak wood. Budgeted manufacturing overhead costs for the year 2017 are as follows. Overhead Cost Pools Amount Purchasing $75,600 Handling materials 82,720 Production (cutting, milling, finishing) 217,000 Setting up machines 97,500 Inspecting 120,000 Inventory control (raw materials and finished goods) 132,720 Utilities 450,000 Total budgeted overhead costs $1,175,540 For the last 4 years, Shaker Stairs Co. has been charging overhead to products on the basis of machine hours. For the year 2017, 100,000 machine hours are budgeted. Jeremy Nolan, owner-manager of Shaker Stairs Co., recently directed his accountant, Bill Seagren, to implement the activity-based costing system that he has repeatedly proposed. At Jeremy Nolan's request, Bill and the production foreman identify the following cost drivers and their usage for the previously budgeted overhead cost pools. Activity Cost Pools Expected Use of Cost Drivers Cost Drivers Purchasing Number of orders 600 Handling materials Number of moves 8,000 Production (cutting, milling, finishing) Direct labor hours 100,000 Setting up machines Number of setups 1,250 Inspecting Number of inspections 6,000 Inventory control (raw materials and finished goods) Number of components Utilities Square feet occupied 168,000 90,000 Steve Hannon, sales manager, has received an order for 250 stairways from Community Builders, Inc., a large housing development contractor. At Steve's request, Bill prepares cost estimates for producing components for 250 stairways so Steve can submit a contract price per stairway to Community Builders. He accumulates the following data for the production of 250 stairways. Direct materials $104,200 Direct labor $112,100 Machine hours Direct labor hours Number of purchase orders 15,000 5,200 60 Number of material moves 800 Number of machine setups 100 Number of inspections 450 Number of components Number of square feet occupied 16,000 8,000 QUESTION 1 Compute the predetermined overhead rate using traditional costing with machine hours as the basis. (Round answer to 2 decimal places, e.g. 12.25.) Predetermined overhead rate $ per machine hour QUESTION 2 What is the manufacturing cost per stairway under traditional costing? (Round answer to 2 decimal places, e.g. 12.25.) Cost per stairway $ QUESTION 3 Calculate activity-based overhead rate for each activity. (Round answers to 2 decimal places, e.g. 12.25.) Activity Overhead Rate Purchasing $ per order Handling materials $ per move Production $ per D/L hour Setting up machines $ per setup Inspecting $ per inspection Inventory control $ per component Utilities $ per sq. ft. QUESTION 4 Caluclate total overhead assigned under ABC. Total overhead assigned $ QUESTION 5 What is the manufacturing cost per stairway under the proposed activity-based costing? (Round answer to 2 decimal places, e.g. 12.25.) Total cost per stairway $ Problem 4-4A Benton Corporation produces two grades of non-alcoholic wine from grapes that it buys from California growers. It produces and sells roughly 3,000,000 liters per year of a low-cost, high-volume product called CoolDay. It sells this in 600,000 5-liter jugs. Benton also produces and sells roughly 300,000 liters per year of a low-volume, high-cost product called LiteMist. LiteMist is sold in 1-liter bottles. Based on recent data, the CoolDay product has not been as profitable as LiteMist. Management is considering dropping the inexpensive CoolDay line so it can focus more attention on the LiteMist product. The LiteMist product already demands considerably more attention than the CoolDay line. Jack Eller, president and founder of Benton, is skeptical about this idea. He points out that for many decades the company produced only the CoolDay line and that it was always quite profitable. It wasn't until the company started producing the more complicated LiteMist wine that the profitability of CoolDay declined. Prior to the introduction of LiteMist, the company had basic equipment, simple growing and production procedures, and virtually no need for quality control. Because LiteMist is bottled in 1-liter bottles, it requires considerably more time and effort, both to bottle and to label and box than does CoolDay. The company must bottle and handle 5 times as many bottles of LiteMist to sell the same quantity as CoolDay. CoolDay requires 1 month of aging; LiteMist requires 1 year. CoolDay requires cleaning and inspection of equipment every 10,000 liters; LiteMist requires such maintenance every 600 liters. Jack has asked the accounting department to prepare an analysis of the cost per liter using the traditional costing approach and using activity-based costing. The following information was collected. CoolDay Direct materials per liter Direct labor cost per liter Direct labor hours per liter LiteMist $0.40 $1.20 $0.50 $0.90 0.05 150,000 Total direct labor hours 0.07 21,000 Expected Use of Cost Drivers per Product Activity Cost Pools Estimated Overhead Cost Drivers Grape processing Cart of grapes Aging Total months Bottling and corking Expected Use of Cost Drivers $146,672 CoolDay LiteMist 6,600 6,000 600 574,200 6,600,000 3,000,000 3,600,000 Number of bottles 280,800 900,000 600,000 300,000 Labeling and boxing Number of bottles 198,900 900,000 600,000 300,000 Maintain and inspect equipment Number of inspections 244,800 800 350 450 $1,445,372 QUESTION 1 Under traditional product costing using direct labor hours, compute the total manufacturing cost per liter of both products. (Round answers to 3 decimal places, e.g. 12.250.) CoolDay Manufacturing cost per liter LiteMist $ $ QUESTION 2 Under ABC, prepare a schedule showing the computation of the activity-based overhead rates. (Round overhead rates to 3 decimal places, e.g. 12.250.) Expected Use of Cost Drivers Estimated Activity Cost Pools Overhead Grape processing $ Activity-Based Overhead Rates $ per cart Aging $ per month Bottling and corking $ per bottle Labeling and boxing $ per bottle Maintain and inspect equipment $ per inspection $ QUESTION 3 Prepare a schedule assigning each activity's overhead cost pool to each product, based on the use of cost drivers. Include a computation of overhead cost per liter. (Round overhead rate, cost per liter to 3 decimal places, e.g. 12.250 and cost assigned to 0 decimal places, e.g. 12,250.) CoolDay Expected Use of Cost Drivers ListMist ActivityBased Overhead Rates Activity Cost Pool Cost Assigned Expected Use of ActivityBased Cost Drivers Overhead Rates Grape processing $ Aging $ $ Bottling and corking $ $ Labeling and boxing $ $ Maintain and inspect equipment $ $ Total costs assigned $ $ Cost Assigned $ $ $ $ $ Liters produced Overhead cost per liter QUESTION 4 Compute the total manufacturing cost per liter for both products under ABC. (Round overhead cost per liter to 3 decimal places, e.g. 1.225.) CoolDay Manufacturing cost per liter LiteMist $ $