ASE DO IN AN EADSHEET. THE SPREADSHEET IN CANVAS SHOWING YOUR WORK FOR EACH PROBLEM. Match Stick Fine Furniture is trying to develop a cost formula for its major manufacturing overhead activities. The company's manufacturing process is highly automated and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed. The costs must be separated into their fixed and variable components so that the cost behavior of the power usage activity can be better understood. Whenever needed, round your variable cost per hours to the nearest cent, and round your total fixed costs to the nearest dollar. Period Machine Hours Power Cost January 24,000 $32,500 February 30,000 $47,500 March 36,000 $53,125 April 26,400 $46,250 May 25,200 $42,500 June 21,600 $36,250 July 28,800 $45,000 August 33,600 $50,000 September 31,200 $40,000 TASK ONE: 4 points Using the High and Low Points (the High-Low Method) to develop and show the formula to predict yearly power cost. Your formula should be in the form: Y = A + b(x), when Y is the total predicted power cost for the nine months, "A" is the total fixed cost; "b" is the variable power cost per machine hour, and x is the number of machine hours. TASK TWO: 4 points Prepare a Scattergraph in Excel. As we did in class, graph the trend line and calculate the power cost formula. Post the Power Cost Formula AND the R square on your graph. TASK THREE: 2 points If Match Stick Fine Furniture estimates machine hours of 29,500 for October, compute power rate per machine hour using: a) High-Low Method formula