Budgeting in TARGETTY

Planning forms

TARGETTY creates forms in Excel that take advantage of all its features, such as formulas, charts, filters, conditional formatting, scripts, and more. Excel forms are intuitive and familiar to users who can fill them out quickly and accurately. Excel forms are also flexible and customizable, so you can administrate them according to your business needs.

All form data is securely stored in database systems that ensure high speed and reliability when processing large amounts of data. The data in the database is also protected against loss or misuse and is accessible only to authorized persons.

Intuitive TARGETTY forms are templates in Excel that allow you to enter financial and non-financial values for various aspects of business activity and automatically calculate costs, revenues and cash flows from them.

Revenue Planning: This form is used to plan the revenue and margins of the business by various segments such as products, customers, regions, channels and others. It allows you to set prices, discounts, volumes and cost of sales and analyze their impact on business performance.
Variable Cost Plan: This form is used to plan costs that change depending on the volume of production or sales, such as material, energy, wages, transportation, and more. It allows you to set unit costs, consumption coefficients, rates and other parameters and monitor their effect on the company’s margins and profitability.
Center cost plan – OPEX: This form is used to plan costs that are not directly related to production or sales, but to the operation of the business, such as rent, maintenance, marketing, administration and others. It allows you to divide costs according to centers, accounts, projects and other criteria and optimize them in accordance with the company’s goals.
Personnel cost plan: This form is used to plan the costs of the company’s employees, such as wages, bonuses, social and health insurance, training and more. It allows you to define the structure, number, qualifications and remuneration of employees and manage their motivation and performance.
Investment plan – CAPEX: This form is used to plan investments in fixed assets of the business, such as machinery, equipment, buildings, vehicles and others. It makes it possible to evaluate the return, efficiency and risks of investments and manage their financing and operation.
Funding plan: This form is used to plan sources of funding for the business, such as bank loans, bonds, leasing, shares and others. It allows you to compare the terms, costs and benefits of different financing sources and manage their repayment and interest.
Calculation of tax liability: This form is used to calculate the tax liability of the company, such as income tax, value added tax, real estate tax and others. It allows you to apply tax rates, discounts, deductions and other rules and optimize the tax burden of the company.
Customer models: Excel forms or groups of forms for calculations of a customer’s specific business activity. The customer model sets the standard for planning across the entire organization, making it possible to compare the partial values of the plans with each other.
Custom models include:
- hotel chains
- energy production
- metallurgical production
- animal husbandry
- growing and harvesting crops
- and more.

Targetty form

The Targetty form uses all the features of Excel, which makes it possible to prepare forms for entering values as efficiently as possible. Forms prepared in Excel can be modified by the administrator and thus respond to changes in the customer’s business.
Excel forms are saved as templates without data. When opened, the form data is updated according to user permissions.

The forms work with the following areas:
Filters for selecting an element for loading and inserting values. The basic filters are Scenario and Center. Filters have a hierarchical structure for better orientation.
Plans – a table for entering financial and non-financial values of plans. By default, the table contains fields intended for writing and fields calculated. All values are stored in the database for further processing.
The summary table is an area for a quick evaluation of the entered values of the plan from an absolute point of view, or in comparison of the development over time.