Month Power Cost Factory Machine Hours January Php24, 400 13,900 February 30,300 17,600 March 29,000 16,800 April 22,340 13,200 May 19,900 11,600 June 14,900 6,600 July 600 8,000 August 25,680 14,150 September 14,900 6,660 October 150,000 17,000 November 26,000 14,300 December 25,900 14,250 January (current) 100,000 7,000 February 23,900 13,500 March 28,500 16,741 April 19,800 11,452 May 26,000 14,321 June 27,000 15,000 July 15,860 7,000 August 12,651 5,000 September 19,552 11,483 October 23,566 13,350 II. Using the least square method of analyzing costs, answer the following questions and show computations to support your answers. 1. What is the estimated variable portion of power costs per factory machine hour? 2. What is the estimated fixed power cost each month? Formulate the regression equation 3. If it is estimated that 12,000 factory machine hours will be run in November of the current year, what is the expected total power cost for November? TEST III. Herbart Company monitors its monthly usage of power and defined the relevant range of assumption to be 20 months. On the month of July last year, there was a consumer return of power cost by the electric cooperative which reduced the cost and that was just an isolated circumstance. On October the same year, there was a major increase in the cost paid for power due to illegal connections in their electric lines in the form of jumper connections, it was an unexpected occurrence and is outside the relevant range although it happened again January of the current year, the company assumes that these events are isolated. Regarding the company utilization of such resource, it gathered the following information on power costs and factory machine usage for the last 20 months: Month Power Cost Factory Machine Hours January Php24, 400 13,900 February 30,300 17,600 March 29,000 16,800 April 22,340 13,200 May 19,900 11,600 June 14,900 6,600 July 600 8,000 August 25,680 14,150