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 reworked master budget modeling since I did not applied good modeling practices in my first work. I used blue and yellow Corporate Finance Institute Excel Color Theme.
- Different font color for input, output, and data which is taken from other sheet(s)
- Consistent color theme
- All budget modeling was built in one sheet, the dashboard and supporting calculation have their own sheet
- Add: One page simple dashboard with a basic chart and graph