1. Create a Payment Tracker
Scenario:
○ You need to maintain a payment tracker for the creators. Assume you have received
Task:
invoices from the 10 different creators and have made some payments at various times
and phases (Writing, Pre production, Production, post-production, final delivery)
○ Develop a simple payment tracker in Google Sheets.
○ Briefly explain how you would update this tracker regularly and ensure accuracy.
2. Invoice Management
Scenario:
Task:
Task:
factors such as type of format(web series, film, short film etc), based on the production
plan of the quarter, keep in mind that we have limited access of the overall year budget.
○ Outline a budget plan template.
○ Explain your approach to ensure that the budget aligns with the overall financial strategy
of the STAGE.
○ You are provided with a list of five creators, each working on different projects. Each
creator has specific payment terms (e.g., milestone-based payments, retainers, or
revenue share).
○ Each project has unique deadlines for deliverables.
○ Create a sample invoice for each creator based on the provided payment terms.
○ Include details such as creator name, project name, payment terms, invoice number, due
date, and itemized breakdown of services rendered.
3. Budget Planning
Scenario:
○ You need to plan the budget for the upcoming quarter for content projects, considering
4. Creator onboarding form
Task: You have to create a template to onboard a new creator, and create a list of details required to
onboard the creator.
Upload your resume, increase your shortlisting chances by 80%
Get notifed when new similar jobs are uploaded
Get notifed when new similar jobs are uploaded
Get notifed when new similar jobs are uploaded
Get notifed when new similar jobs are uploaded