Commercial Proposal Constructor

#Proposal Builder #Constructor #Calculator

The following functionality has been implemented:
1. An interface for generating a Commercial Proposal from a set of company services has been implemented, as well as a Menu for navigating between program windows.
2. A selection of services necessary for the client is made from a multi-level set of company Services.
3. The cost of the selected services in the proposal is automatically calculated taking into account many criteria: selected services, service package, amount and term of prepayment, and provided discounts.
4. A Commercial Proposal for the client is automatically generated in both Summary and detailed forms for each category of services.
5. An Efficiency Monitor for the commercial proposal has been developed, which provides summary analytics for analyzing financial efficiency broken down by each type of service:
- cost price;
- basic markup considering discounts;
- commissions for managers, marketing department;
- agency fees;
- total markup;
- selling price

#Google sheets #API #Google Sheets
#Financial model #Financial model #Accounting #Warehouse #Warehouse accounting #Wildberries #Estimate #Estimates #Calculator #Analytics
#Summary #Summary #Tables
https://docs.google.com/spreadsheets/d/1qS05KWGovZOaK4Ondffrw5Z6djfiZJrzfFfQucsYrCc/edit#gid=1411192660