Project translated automatically. Log in or register, to view the original Hello to you!We have a simple table where we fill out sales details: The date My name is Seller. Number of Order Type of Service The amount of order Honorary Supplier Profit from a specific order. Here’s how it looks: HTTPS://prnt.sc/bDZMjgRHczrQ The task is to use the formulas to set up statistics according to the following parameters: income (column sum) for the selected period Profit (column Profit) for selected period Revenue and Revenue for the Selected Period of the Seller Total number of orders sold for the selected period The number of sales orders of the selected Seller for the selected period Example: Seller 1 = 80 The number of individual services sold for the selected period (there will be a specific list of these services as a selection) Example: Service A 50 pieces; Service B 70 pieces ..... The number of separate Selling Services of the Seller for the selected period; Example: Seller 1 = Service A 50 pieces; Service B 70 pieces ..... Income and Profit of Selected Services for Selected Period Example: Service A 50 pieces (Receipt 50 000 UAH / Profit 30 000 UAH) Total marginality (Procent ratio of income to income; If income is 100 000 UAH and income is 50 000 UAH, then marginality is 50%) Marginality of separate services for the selected period Total marginality of each Seller - Marginity of individual Services of each Seller - Total average check (We share the total income on the number of sold orders) The average check for a specific type of service Total average cheque of the Seller - The average cheque of the concrete service of the concrete seller Revenue and Revenue of the Selected Service of the Seller for the Selected Period ( an example of : The Seller 1 : Service A = Revenue 100 000 UAH / Revenue 60 000 UAH; Service B = Income 30 000 UAH / Income 13 000 UAH; And so on....)- You should also draw the data in graphs and tables: 1) The average number of orders sold per day for the selected period 2) Specific distribution of the number of orders each day 3) to show the dynamics of the number of sales of all Services on the schedule Example: 1 number of 10 sales; 2 number of 12 sales; 3 number of 15 sales; = schedule shows positive growth 4) to show the dynamics of the number of sales of all Services per week and month 5) to show the dynamics of the sales of a specific Service 6) on the schedule to show the sales dynamics of a specific Service per week and month 7) on the schedule to show the dynamics of growth or decline of Profit The example: 1 number 20 000 UAH 2 number Profit 22 000 UAH 3 number Profit 25 000 UAH The schedule shows a positive trend. 8) on the schedule to show the dynamics of growth or decline of profits for a week and month Percentage of services sales Examples: A total of 100 sales; Of them: Service A 20 pieces (20%) Service B 40 pieces (40%) The... 2) Percentage of sales of vendors Examples: A total of 100 sales; including: Seller 1 20 pieces (20% and td...3) the percentage of the distribution of the Services on the number of sold services and the amount of the specific Seller; The example: The Seller 1 : - All sold Services 50; From them Service A - 25 pieces; Service B - 5 pieces.Total Sales Revenue 100,000 UAH Total sales revenue of 60,000 UAH * from the Profit of 60,000 UAH Service A (25st; 30,000 UAH Profit) - takes 50% of the total number of sold Services of this seller, and 50% of the Profit from the sales of this seller I hope it’s clear :)

Proposals 13

Yuliya Karmazina

22 0

Projects 21
Rating -
Rating 340

Budget: 1500 UAH Deadline: 2 days

Hello to you. Ready to perform the task. I will be happy to cooperate. turn to

Alla Bobrova

17 1

Budget: 1500 UAH Deadline: 3 days

Good day ! Open to work, I will accomplish your task in a short time.

Oleksiy T.

0 0

Projects -
Rating -
Rating 412

Budget: 1500 UAH Deadline: 2 days

Good day
Ready to perform. I’m waiting for the bet and I’m going.

Yuliya Galetskaya

10 0

Projects 10
Rating -
Rating 291

Budget: 2000 UAH Deadline: 3 days

Good day . Interested in your project. Ready to perform. In accounting education, there is experience of working with a large scope of information.

Taras Mosiienko

4 0

Projects 4
Rating -
Rating 735

Budget: 1500 UAH Deadline: 3 days

How are services and orders related? Can there be a few services in one order? What is the type of order?

Maksim G.

7 0

Projects 7
Rating -
Rating 408

Budget: 1500 UAH Deadline: 4 days

Good day . I work as an analyst in an industrial enterprise, so I have great experience in doing similar works. A confident user of Excel. to turn.

Roman Kotik

19 2

Projects 19
Rating -
Rating 591

Budget: 1650 UAH Deadline: 5 days

Good day, we do this work cheap and quality for you. There will be no problems with the implementation. We do the work without any problems. I wait for answers.

Serhii D.

38 0

Projects 39
Rating -
Rating 1 134

Budget: 5000 UAH Deadline: 3 days

Good day .
I can do it in Excel or Power BI.

Bogdan Kovalevich

1 1

Projects -
Rating -
Rating 126

Budget: 2000 UAH Deadline: 7 days

Interested in your task.
I’ve created something, so I have experience.
I also have a few ideas about how to do it optimally and conveniently.

Nadiia G.

Winning proposal

19 0

Budget: 2000 UAH Deadline: 5 days

Good day . Ready to help, interested in your project.
The task is clear. In the course of the work may arise questions about the calculations (so that in the future everything was properly calculated).
We can also discuss sending reports through Telegram using a bot (when the corresponding words are entered, the bot will be able to send data from the tables for day, week, and month in a convenient format for you).
I recommend using Google tables. Comfortable access from any device with Internet connection

Katerina F.

2 0

Projects -
Rating -
Rating 226

Budget: 2000 UAH Deadline: 2 days

Good day . Interested in your project. I suggest to do this in the Google Table (There are more possibilities for visualization). This can also be done in Excel. For more detailed discussion, please write in a personal message.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Accounting Services

Tax consultation on RSU

Consulting 1 proposal 9:40

45 USD
Accountant or manager specialist with experience in 1C / BAS

Customer Support 6 proposals 24 July

Not specified
Private entrepreneur accountant

Legal Services 22 proposals 22 July

16 USD
Consultation on accounting and commerce

5 proposals 21 July

Not specified
Filing a zero final declaration for LLC in the USA (through IRS services)

Legal Services 2 proposals 20 July

85 USD

Den Writer
Kyiv, Ukraine
Writer Works

Projects 120
Rating 5.0
Rating 4 006

Den Writer

Nadiia G.

Yuliya Karmazina

Alla Bobrova

Oleksiy T.

Yuliya Galetskaya

Taras Mosiienko

Maksim G.

Roman Kotik

Serhii D.

Bogdan Kovalevich

Nadiia G.

Katerina F.

Proposals are currently absent

Current freelance projects in the category Accounting Services

Tax consultation on RSU

Accountant or manager specialist with experience in 1C / BAS

Private entrepreneur accountant

Consultation on accounting and commerce

Filing a zero final declaration for LLC in the USA (through IRS services)