Data Modella
  • Introduction
  • Concepts
    • Models
    • Calendar
    • Lists
    • Structure
    • Scenarios
    • Inputs
    • Variables
    • Capital
    • Elements
      • Fixed
      • Variable
      • Event
      • Matrix
    • Templates
    • Schedule
    • Pivot Views
    • Calculator
    • Actuals
  • Explanations
    • Tag Matching
    • MARC Costing
  • FAQs
    • Common FAQs
    • Support and Feedback
  • Blog
    • Improved Calculator and Variable System
    • New Inputs Page
  • Tutorials
    • Using the PowerBI Connector
    • The Building Blocks
    • Elements and the Rule of Four
Powered by GitBook
On this page

Was this helpful?

  1. Concepts
  2. Elements

Fixed

Fixed Rates are constants

PreviousElementsNextVariable

Last updated 7 months ago

Was this helpful?

A Fixed component calculates a rate that does not depend on any other variables. Common examples are a yearly lease, monthly office supplies or other fixed costs.

There are two inputs required for a fixed rate:

  • The Rate per Period

  • The Period Type

    • Period: The value is unmodified

    • Monthly: The value is a monthly rate and is adjusted to match the period length

    • Annual: The value is an annual rate and is adjusted to match the period length

Example

If we have an office lease for a fixed cost of $55,000 per year, and a Data Modella calendar for 12 months we can use a fixed component to model the cost.

Here we are configuring the component and because the first three periods are months in our Calendar the respective monthly amount is calculated.

Fixed Element Component