How To Calculate GMAU in Deltek Vision | Arithmix

Calculating GMAU in Deltek Vision can be a complex process, but it's an important one for businesses to understand. GMAU stands for Gross Margin Analysis Unit, and it's a metric used to measure the profitability of a project or service. By calculating GMAU, businesses can determine how much profit they're making on a particular project or service, and use that information to make informed decisions about future investments and pricing strategies.

What Is GMAU?

GMAU is a measure of profitability that takes into account both the revenue generated by a project or service, as well as the costs associated with delivering it. To calculate GMAU, you need to subtract the direct costs of a project or service from the revenue it generates, and then divide that number by the number of units sold. The resulting figure represents the profit margin per unit, and can be used to compare the profitability of different projects or services.

For example, let's say you run a small web design business. You have two clients, each of whom wants a website designed. Client A is willing to pay $5,000 for their website, and it will take you 50 hours to complete. Client B is willing to pay $10,000 for their website, but it will take you 100 hours to complete. To calculate the GMAU for each project, you would subtract the direct costs (i.e. your time) from the revenue generated, and then divide that number by the number of units sold (i.e. the number of websites designed). The GMAU for Client A would be $50 per hour, while the GMAU for Client B would be $50 per hour as well. This means that both projects are equally profitable, despite the difference in revenue generated.

When Is It Valuable To Calculate GMAU?

Calculating GMAU is valuable for businesses in a variety of situations. For example, if you're considering investing in a new project or service, calculating the GMAU can help you determine whether it's likely to be profitable. Similarly, if you're trying to decide on pricing for a particular product or service, knowing the GMAU can help you set a price that will allow you to make a reasonable profit.

Additionally, calculating GMAU can be useful for identifying areas where you can improve efficiency and reduce costs. By analyzing the direct costs associated with a particular project or service, you can identify areas where you're spending too much money, and look for ways to streamline your processes and reduce those costs. This can help you increase your profit margins and make your business more competitive.

In conclusion, calculating GMAU is an important tool for businesses looking to measure profitability and make informed decisions about investments and pricing strategies. By understanding what GMAU is and when it's valuable to calculate it, businesses can use this metric to improve their bottom line and stay competitive in their industry.

How Do You Calculate GMAU in Deltek Vision

Deltek Vision itself isn’t naturally geared towards letting you calculate complex metrics like GMAU. As an alternative, teams typically use products like Arithmix to import data from Deltek Vision and build out dashboards.

What is Arithmix?

Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers that’s powerful yet easy to use. With Arithmix you can import data from systems like Deltek Vision, combine it with data from other systems, and create calculations like GMAU.

In Arithmix, data is organized into Tables and referenced by name, not by cell location like a spreadsheet, simplifying calculation creation. Data and calculations can be shared with others and re-used like building blocks, vastly streamlining analysis, model building, and reporting in a highly scalable and easy to maintain platform. Data can be edited, categorized (by dimensions) and freely pivoted. Calculations are automatically copied across a dimension - eliminating copy and paste of formulas.

Arithmix is fully collaborative, giving your entire team access to your numbers and the ability to work together seamlessly.

Calculating GMAU in Arithmix

Calculating metrics like GMAU is simple in Arithmix. Once you've created your free account, you’ll be able to import your Deltek Vision data, and use it to create natural language formulas for metrics like GMAU.

Arithmix is designed to give you the power to build any calculations you want on top of your Deltek Vision data, while also being easy to use and collaborate on. You can share your dashboards with users inside and outside of your organisation, making it easy to empower your whole team.