If you can put it into excel that would be great but if not then no worries. Thanks

Munoz Corporation uses ABC to determine product costs. At the beginning of the year, management made the following estimates of cost and activity in the company's five activity cost pools: Activity Cost Pool Activity Measure Estimated MOH Expected Activity Labor related DLhours $ 210,000 35,000 DLhrs Purchase orders #of orders $ 72,000 900 orders Product testing #of tests $ 168,000 1,400 tests Template etching # of templates $ 315,000 10,500 templates General factory Machine-hours $ 840,000 70,000 MHrs. During the year, actual MOH costs and activity were recorded as follows: Activity Cost Pool Actual MOH cost Actual Activity Labor related $ 205,000 32,000 DLhrs Purchase orders $ 74,000 950 orders Product testing $ 160,000 1,300 tests Template etching S 338,000 11,500 templates General factory S 825,000 68,000 MHrs. $ 1,602,000 1. Compute the activity rate for each of the activity cost pools. 2. Determine the amount of MOH applied to production during the year. 3. Determine the amount of over/under applied MoH for the year. Siegel Corporation Manufactures a product that is available in both a deluxe and regular model. Overhead is applied on the basis of direct labor hours. At the beginning of the year total MOH is estimated at $2,000,000 based on producing and selling 5,000 deluxe units and 40,000 regular units. The deluxe model requires 1.6 DL hours per unit and the regular requires 0.8 DL hours. Materials and labor costs per unit are given below: Deluxe Regular DM cost/unit $ 150 S 112 DLcost/units 16 $ 18 Management is considering adopting an ABC system using the following cost pools: Expected Activity Regular Total 800 1,200 orders 600 900 requests 11,000 15,000 tests 30,000 50,000 MHrs. Activity Cost Pool Activity Measure Estimated MOH De luxe Purchase orders #of orders $ 84,000 400 Rework requests #of requests $ 216,000 Product testing #of tests $ 450,000 4,000 Machine related Machine-hours S 1,250,000 20,000 $ 2,000,000 300 1. Compute the predetermined rate using traditional costing. 2. Compute the total unit cost for each product. 3. Calculate the MOH rate for each cost pool under ABC. 4. Calculate the total unit cost for each product under ABC. = Sunspot Beverages makes fruit drinks in two stages, blending and bottling. In the blending department all materials are added at the beginning of the process. Data for the blending department from June are shown below: Percent complete units Conversion WIP, beginning 20,000 75% Started into production 180,000 Completed &transferred out 160,000 WIP, ending 40,000 25% Materials Conversion WIP, beginning $ 25,200 $ 24,800 Costs added during June S 334,800 $ 238,700 1. Based on the above information, prepare a production report for June for the blending department. 2. Based on your production report, answer the following questions; a. What is the number of equivalent units produced in June with respect to direct materials? b. What is the cost per equivalent unit with respect to conversion costs for June? c. What is the balance of the WIP account for the blending department at the end of June