·

Cursos Gerais ·

Excel Avançado

Send your question to AI and receive an answer instantly

Ask Question

Preview text

Take dollars as main currency Heads up Create some sort of table or template that shows the memory of calculus and dont forget that a clear and objective communication is key 1 How much is in execution how much did we lost as job out and how much we won in PLT per month and year 2 Who are the top 3 clients when looking at Revenue 3 Which type of client was most profitable for Pacifica 4 After charging the client in line 18 they asked How was the final amount calculated How would you explain it to them 5 The payment term agreed on contract with the client is 30 days after the invoice was sent The client is asking for a total of 90 days to pay How would you handle it How could this impact the companys finance 6 The invoice due date was on May 16th 2016 but the payment is already 15 days past due Your boss has asked you about this debt the company has not received yet How would you report its status Dont forget to point out the actions you took so far BONUS QUESTION Create a forecast vision of Revenue based on jobs still in execution Make a view with total forecast and the reduced forecast For the reduced forecast take into consideration that we have a conversion rate of 40 of the jobs in execution This project will be executed by a Recruiter from the recruitment team and will find the best candidate for the position If the client accepts our candidate we will charge a fee commission agreed in the contract and after that we will issue a invoice to the client if we have some problem during the process and we close the partnership with the client we call it by Job Out If the client does not accept our client we will keep seaching for new ones we keep the job in Execution If he accepts and closes with the candidate we call this Placement PLT which is the moment when we can charge our fee to the client