Company Background:

Sheridan Consultancy is a dynamic and growing project management firm that specializes in

providing consulting services to clients in diverse industries. The company is known for its

commitment to delivering high$-$quality projects on time and within budget.

Assignment Tasks:

$1.$ Project Identification $(5$ points$)$:

$$ Identify and describe a fictional project that Sheridan Consultancy will undertake. Include

details such as project name, objectives, scope, and duration.

$2.$ Sales Budget $(15$ points$)$:

$$ Estimate the sales revenue for the identified project. Consider factors such as project size,

pricing strategy, and any potential changes in scope.

$3.$ Production Budget $(15$ points$)$:

$$ Develop a production budget based on the sales budget. Consider resource allocation, labor,

and any other costs associated with delivering the project.

$4.$ Direct Cost Budget $(20$ points$)$:

$$ Identify and quantify direct costs associated with the project. Include costs such as materials,

labor, and any other project$-$specific expenses.

$5.$ Overhead Budget $(15$ points$)$:

$$ Develop an overhead budget, considering both variable and fixed overhead costs. Ensure that

overhead costs are allocated appropriately to the project.

$6.$ Selling and Administrative Expense Budget $(10$ points$)$:

$$ Estimate selling and administrative expenses related to the project. Include costs such as

marketing, administration, and any other relevant expenses.

$7.$ Cash Budget $(15$ points$)$:

$$ Prepare a cash budget outlining the expected cash inflows and outflows throughout the project

duration. Consider factors such as payment schedules, milestones, and potential fluctuations.

$8.$ Budgeted Income Statement $(15$ points$)$:

$$ Combine the sales budget, production budget, and other relevant budgets to create a budgeted

income statement for the project. Including revenue, expenses, and net income.

$9.$ Budgeted Balance Sheet $(10$ points$)$:

$$ Develop a budgeted balance sheet for Sheridan Consultancy at the end of the project. Consider

assets, liabilities, and equity.

Submission Guidelines:

$$ Format: Microsoft Excel or Google Sheets.

$$ Include explanations and assumptions for each budget component.

$$ Submit the completed master budget by the specified deadline.

Evaluation Criteria:

$$ Accuracy of budget calculations.

$$ Clarity of explanations and assumptions.

$$ Coherence and integration of different budget components.

$$ Realistic and thoughtful consideration of project$-$specific factors.