hello,

attached to this message is an excel file that I am needing assistance with

Managerial Accounting Show all your work! Problem 1 20 points Variable and Absorption costing and Income Statements We manufacture and sell Dinner Tables. Manufacturing costs: Fixed overhead Variable overhead Direct labor Direct materials $300,000 $5 per table $10 per table $20 per table Beginning inventory Tables produced Tables Sold 0 Tables 100,000 95,000 Selling and administrative costs: Fixed Variable The table sells for $500,000 $15 Per table sold $100 The company uses absorption costing, calculate the manufacturing cost per unit. Absorption Manufacturing Costs Per Table Prepare an absorption costing income statement. Tables R US Income Statement For the Month Ended July 31, 20XX Absorption Costing Sales The company uses variable costing, calculate the manufacturing cost per unit. Variable Manufacturing Costs Per Table Prepare an variable costing income statement. Tables R US Income Statement For the Month Ended July 31, 20XX Variable Costing Sales Net income Problem 2 20 points Use the following data: Activity Cost Pool Purchasing Receiving Assembling Testing Finishing Packing and shipping Estimated Overhead $60,000 40,000 200,000 50,000 100,000 70,000 $520,000 Number of Units Curlers Expected Use of Drivers 200 700 5,000 2,000 70,000 2,000 Dryers Expected Use of Drivers Total Activity 300 500 Orders 900 1,600 Pounds 15,000 20,000 Number of Parts 3,000 5,000 Number of Tests 30,000 100,000 D. L. Hours 5,000 7,000 Cartons 50,000 40,000 Part 1 - Plantwide MOH and Unit cost A. Based on the estimated 100,000 direct labor hours and the estimated MOH of $520,000, what would the plantwide application rate be per direct labor hour? B. Get a cost PER UNIT for the Curler and Dryer. Apply MOH based on your application rate above, and assume it takes 1 Direct Labor hour for the Curler, and 2 Direct Labor hours for the Dryer. Products Manufacturing Costs Direct Materials per unit Direct Labor per unit MOH per unit Total Unit Cost Curler $5.00 $8.00 Dryer $9.00 $16.00 Part 2 - Activity based MOH and Unit Cost A. Determine the MOH rate per unit for the Curler and Dryer Activity Cost Pool Purchasing Receiving Assembling Testing Finishing Packing and shipping Activity Cost Pool Estimated Overhead Expected Use of Drivers Expected Use of Drivers in total Orders Pounds Number of Parts Number of Tests D.L. hours Cartons Activity-Based Overhead Rate = = = = = = = Orders Pounds Number of Parts Number of Tests D. L. Hours Cartons Curler Dryer ActivityBased Overhead Rates ActivityBased Overhead Rates Expected Use of Drivers Cost Assigned Purchasing Receiving Assembling Testing Finishing Packing and shipping Total costs assigned Units produced Overhead cost per unit B. Get a cost PER UNIT for the Curler and Dryer. Products Manufacturing Costs Direct Materials per unit Direct Labor per unit MOH per unit Total Unit Cost Curler $5.00 $8.00 Dryer $9.00 $16.00 Cost Assigned Problem 3 Use the following data: Produced & Sold Variable expense per unit Selling price per unit 10 points Blenders Coffee Makers 50,000 20,000 units $10 $20 $18 $50 Fixed costs = $120,000 of which $40,000 can be avoided if the blenders are not produced and $50,000 avoided if the coffee makers are not produced. 1. Prepare segmented Income statement separating direct and common fixed costs Blenders Sales Less: Variable cost of goods sold Contribution margin Less: Direct fixed expenses Segment margin Less: Common fixed expenses Operating income Coffee Makers Total