It was a task given by my lecturer when I was at Management Accounting Class. The problem is taken from my class’s reference book: Management Accounting by Hansen/Mowen. At that time, i did not know what modeling is, I just used basic excel formulas and referring cell in one sheet to another. these are my…