Margin Excel Dashboard

Description
In this model was used:
Data tables;
Function: Procv;
Form Control: Spin Button and Group Box.
Association of images with cells;
Graphical binding of the Data Table.
Graphing used conditional color formatting in the cell to give edge effect.

The purpose of margins is "to determine the value of incremental sales, and to guide pricing and promotion decision.

Margin on sales represents a key factor behind many of the most fundamental business considerations, including budgets and forecasts. All managers should, and generally do, know their approximate business margins. Managers differ widely, however, in the assumptions they use in calculating margins and in the ways, they analyze and communicate these important figures.

Gross margin can be expressed as a percentage or in total financial terms. If the latter, it can be reported on a per-unit basis or on a per-period basis for a company.

"Margin (on sales) is the difference between selling price and cost. This difference is typically expressed either as a percentage of selling price or on a per-unit basis. Managers need to know margins for all marketing decisions.

Author: L a u r o J o r g e P r a d o
Brazil
Dashboard Excel

For support questions, please use the direct messaging system on our Eloquens channel.