·
Cursos Gerais ·
Excel Avançado
Send your question to AI and receive an answer instantly
Recommended for you
6
Atividade no Excel
Excel Avançado
UMG
1
Relatorio de Saldo Banco de Horas CRV Industrial - Janeiro 2023
Excel Avançado
UMG
1
Analise Financeira e Relatorio de Desempenho Pacifica - Calculo de Receita e Estrategias de Negociacao
Excel Avançado
UMG
1
Planilha de Compras e Controle de Estoque
Excel Avançado
UMG
1
Planilha de Controle Estoque e Compra
Excel Avançado
UMG
3
Alocação de Ativos em Ações - Cenários Conservador Moderado e Agressivo
Excel Avançado
UMG
1
FAAP Plano de Aulas Laboratorio de Tecnologia da Informacao 2022-2
Excel Avançado
UMG
1
Plano de Aulas - Laboratório de Tecnologia da Informação - Turma 24K
Excel Avançado
UMG
7
Guia Rapido Excel 2021 - Atalhos Funcoes e Dicas Essenciais
Excel Avançado
UMG
1
Planilha de Horas Extras
Excel Avançado
UMG
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
Send your question to AI and receive an answer instantly
Recommended for you
6
Atividade no Excel
Excel Avançado
UMG
1
Relatorio de Saldo Banco de Horas CRV Industrial - Janeiro 2023
Excel Avançado
UMG
1
Analise Financeira e Relatorio de Desempenho Pacifica - Calculo de Receita e Estrategias de Negociacao
Excel Avançado
UMG
1
Planilha de Compras e Controle de Estoque
Excel Avançado
UMG
1
Planilha de Controle Estoque e Compra
Excel Avançado
UMG
3
Alocação de Ativos em Ações - Cenários Conservador Moderado e Agressivo
Excel Avançado
UMG
1
FAAP Plano de Aulas Laboratorio de Tecnologia da Informacao 2022-2
Excel Avançado
UMG
1
Plano de Aulas - Laboratório de Tecnologia da Informação - Turma 24K
Excel Avançado
UMG
7
Guia Rapido Excel 2021 - Atalhos Funcoes e Dicas Essenciais
Excel Avançado
UMG
1
Planilha de Horas Extras
Excel Avançado
UMG
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