A: One favorite story was in media. A major television network wanted a way to track the costs for producing pilot programs and programs that became shows. They were doing a lot of cost recording on spreadsheets. I used projects and created a couple of different shows as sets of data.
In their business, they want to track costs and revenue by show, by season, and by episode. I was able to demonstrate how each show could be a project broken out by season (sub-project) and by episode within each season (sub-sub-project). They could then record the expense of producing a show – talent, props, sets, wardrobe, etc. against each episode. They could then summarize all the episode expenses at the season level and summarize all the seasons at the show level. They could even use the project to bill the advertising agencies for the commercials to record the revenue. It is a very complex process and there was a way to do it.
Another fav is how a home construction company can use projects to track the cost and revenue of each house built. In this case, the development is the project with each phase a sub-project and each lot within a phase a sub-project of the phase. The costs associated with building each house are recorded on the appropriate lot number (sub-project of the appropriate phase). And as often happens when building homes, there are multiple change orders which are configured as sub-projects of the lot number. With this structure, they were able to see the cost of the change orders, the cost of the house with and without change orders, the cost of each phase, and the cost of the entire development. The revenue was recorded by generating the bill to the homeowner for the selling price of the house (including add-ons/ change orders) against the lot number sub-project.
Almost every project manager has the same questions: How do you track the changes and what do they cost you? Are you making money on the change order? Do you know how much free work you did? What percent was change request and how close was our estimate to our actuals?
Lack of a project accounting system means they do not have the answers to these questions. In addition, the embedded Microsoft Power BI analytics provides project KPIs where the answers are available within the project accounting solution.