Below in the table you find the information about electricity costs in the particular months and the respective machine hours. Electricity costs in this case are mixed costs. Based on the information below calculate in Excel :

1. identify the month with the highest and the lowest electricity consumption
2. using high low method calculate variable cost per machine hour
3. calculate fixed and variable costs in ALL months
4. upload your file with solution

month electricity costs in USD machine hours

January 16000 100000

February. 16500 105000

March. 16800. 108000

April 17200 112000

May. 18000 120000

June 17500. 115000