This is a question I was given to work on for a previous assignment-- it is a fake utility, but reasonable data. 
                               
The ACDCProblem.docx file explains the situation and what information I was required to determine.

In ACDC Data.xlsx, the bulk of my work was in column I where I determined a series of logic test to appropriately calculate cost, based on the load factor.

I wrote up my findings in a series of powerpoint slides, which I exported to a PDF ACDC Slides.pdf 