Builder 103.1 Exercise - Expenses and KPIs

Use sample exports of accounts and cost center structures to build your app dimensions. Then import your expenses in detail, along with sales and headcount data to build views of month and year to date expense by account and cost center (with their hierarchies) and metrics for Expense per head and Expenses as a % of Sales. This exercise is located in our learning center:

Checkout the video guide:

Want the answers?
Easy question - What is the YTD Expenses at the end of October 2023?
Answer: $1,414,900

Medium question - What is the Expenses per head for the administration cost centers for Q3?
Answer: $14,356

Hard question - What is the 2023 total year Total Personnel expense as a % of sales?
Answer: 33.7%

Want a a copy of the app?
Builder 103.1 Expenses and KPIs completed