can u please post the ans part 1 b

on the q2 can u post ans only req part 1b and req part 2B

The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company's cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formula. The production superintendent disagrees; she thinks that direct labor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information: Direct Labor. Utilities Quarter Tons Mined Hours Cost Year 1: First 27,000 6,200 $ 62,000 Second 18,000 4,200 $ 57,000 Third 32,800 $ 72,000 Fourth 24,000 7,200 $ 87,000 Year 2: First 30,000 12,800 $120,000 Second 37,000 11,800 $133,000 10,000 $ 97,000 Fourth 40,000 13,000 $136,000 5,200 Third 42,000 Required: 1-0. Using tons mined as the independent variable, prepare a scattergraph that plots tons mined on the horizontal axis and utilities cost on the vertical axis Instructions: 1. On the graph below, use the point tool (Year fot quarter to plot tons mined on the horizontal axis and utilities cost on the Vertical axis 2. Repeat the same process for the poster tools (Year 1-2nd quarter to Year 2.4th quarter) 3. To enter exact coordinates.click on the point and enter the values of Xandy Utilities Cost 740000 120000 Year 1 - 1st ql Year 1 - 2nd 100000 80000 0 Year 1 - 3rd q Year 1. 4th qu 60000 40000 Year 2- 1st a Year 22nd 20000 . 10000 30000 50000 20000 40000 60000 Tons Mined 1-b. Using the least squares regression method, estimate the variable utilities cost per ton mined and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bx (Round the Variable cost per unit to 2 decimal places and Fixed Cost to the nearest whole dollar amount.) Answer is complete but not entirely correct. 18.926 251 x S Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: $ Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses 25 15 $ NU $ 250,000 5 80,000 During its first year of operations. Walsh produced 50.000 units and sold 40,000 units. During its second year of operations, it produced 40,000 units and sold 50,000 units. The selling price of the company's product is $60 per unit Required: 1. Assume the company uses variable costing a. Compute the unit product cost for Year 1 and Year 2 b. Prepare an income statement for Year 1 and Year 2 2. Assume the company uses absorption costing Compute the unit product cost for Year 1 ond Year 2 b. Prepare an income statement for Year 1 ond Year 2 3. Reconcile the difference between variable costing and absorption costing net operating income in Year1 Cat Assume the company uses variable costing. Prepare an income statement for Year 1 and Year 2. Walsh Company Income Statement Year 1 Year 2 $ 50,000 $ 40,000 0 0 50.000 40,000 Net operating income doss) 0 50.000 $ S 0 40.000 Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Req 2A Req 2B Reg 3 Assume the company uses absorption costing. Prepare an income statement for Year 1 and Year 2. (Round your intermediate calculations to 2 decimal places.) Walsh Company Income Statement Year 1 Year 2 $ 25 s 25 Net operating income (loss) S 0$ 0