Assessment 2 – SITXFIN005A Prepare and monitor budgets and SITXFIN004A Manage finances within a budget

What you have to do

This assessment consists of financial questions to be answered adequately to demonstrate your knowledge and understanding of the concepts of Preparing, monitoring and managing budgets in order to be deemed competent in this unit.

The following pages detail five (5) tasks required to be completed in order of Task 1 to 5.

TASK 1 – Prepare a source of information memo report – 10 marks

TASK 2 – Prepare profit and loss budget – 30 marks

TASK 3 – Prepare a cash flow budget – 20 marks

TASK 4 – Monitor budget & manage variances – 20 marks

TASK 5 – Reporting and keeping records – 20 marks

This is a graded unit. Your result is based on the evidence you provide to meet the criteria for competence as specified in the unit of competency and grading criteria.  You will receive a result of Achieved Competency (AC) or Not yet Competent (NC).

You may need to SAVE your work into a Zipped File with both Word and Excel documents.

Information on how to submit your assignment is located on the OLS OTEN website.

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN 

CASE STUDY SCENARIO

Places To Go Travel

The management of Places To Go Travel, a retail travel business, has planned to open a new branch, a second travel agency located in a large retail/office complex in a suburban residential and commercial hub. The new office will be known as ‘Places To Go Travel Huntington’

It is expected that the new agency will be selling both domestic and international leisure travel to local shoppers and residents. There are also a number of small corporate accounts who have signed agreements to book with the new agency, which will contribute much needed income for the short to long term. It is predicted that eventually additional various corporate accounts will be booking with the agency, once it has become well established.

You are one of Places To Go Travel’s top sales performers, and also a senior team leader in the parent travel office. You have been offered a promotion to Travel Manager and asked to run the new agency. This is an acknowledgment of your superb leadership & sales abilities.

The Travel Manager role also requires responsibility for preparing and managing the agency’s budgets. As part of your job role you will need to assist with staffing, as well as negotiating expenses and costs for the running of the new office. Staff for the new office will include you, the Travel Manager (selling role), another senior consultant, one junior corporate consultant and one junior leisure consultant. You will be able to liaise with Sally Morgan in HR in regards to wages, the financial controller Mary Tran in regards to some accounting/legal fees and coordinate negotiated rent with the landlords Ascot Holdings. Additionally, in the first 3 months you will have another experienced manager Peter Lee to assist with operational advice and canvassing for new corporate accounts, however he is only on loan from the parent company.

As you are new to managing, the operations manager, Howard Min, has provided you with the brief for planning and preparing the new office’s budgets to organisational standards as follows:

• Source information and data for use in preparing budgets
• Prepare budgets in accordance with organisations policies and procedures
• Monitor budgets evaluating performance
• Manage budget variances and make decisions for adjustments
• Report to management and staff regarding budget outcomes.

TASK 1 – Prepare a memo report – 10 marks

Prepare a memo report for the operations manager on ten (10) sources of information you have referred to in preparation for budgeting. Explain for each the reason you used these sources. You will need to consider how you will find information, data, figures and statistics that will have an effect on the running of the business; all income/revenue and operating costs. Where can you source information or whom can you consult to provide you with the information on; rent essential services, wages, superannuation, taxes, demographics for the area, tourism statistics, customer sales etc?

TASK 2 – Prepare operational budget – 30 marks

Using the information provided in the tables below prepare an operational budget for the next twelve months showing trading of the new agency office to commence in July 20XX. This budget should be formatted indicating monthly sales and income, as well as monthly expenses, and the forecasted profit or loss underneath.

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

The budget is to be prepared to show the following:

1. Income/revenue: as per the below table a per annum forecast for sales has been budgeted. We have also provided these per annum figures already proportioned out per month, over the twelve months. The per month values allow for lower sales in first months due to recent start up and no pre-existing bookings and higher sales and income values in the months prior to peak travel times (Christmas, Easter and school holidays etc), when customers will be making final payments for upcoming holidays.

A travel business’ ‘income’ is based upon earning commissions on sales of products. The commission percentages differ depending on the product sold, however can be averaged out between all products as shown on the sales/income document.

1. Expenses: to be listed alphabetically. For most expenses the per annum values are split by twelve and proportioned over the whole year evenly. However, some expenses have a payment due date and have been shown in the month due.

You will need to submit this budget formatted as either a Word table or Excel spreadsheet. An Excel spreadsheet, however will be the best option. An operational budget template document is provided on the OLS in the unit’s learning materials pages to assist you.

Note: International and Domestic (Australian travel) Income shown separately as 10% GST is payable only on Domestic products sales and only on the commissions earned. You may wish to show totals for both types of incomes and a grand total for all income. GST has already been included in the figures mentioned in the below table.

Fig 1.1 – Sales, income and expenses for budget preparation. Note: commission levels above are an indication only and may not be indicative of current market levels.

Fig 1.2 – Sales and income figures for use in preparation of operational budget

TASK 3 – Prepare Cash Flow Budget – 20 marks

Using the information from the operational budget you have prepared in Task 2, now create a cash flow budget to plot the cash inflows and outflows for the operations of the business. This is to determine your monthly working capital and cash requirements required to support this new business.

Additional funding for the new business (above sales income) is in the form of capital injection on a month to month basis required until the business has built up cash flow reserves. Show capital injection of funds to cover cash flow as follows:

• First month of trading – capital  injection $ 15,000
• Second month of trading – capital  injection $ 10,000
• Subsequent months of trading  until January – capital  injection $ 5,000
• From February onwards the business should have enough reserve cash flow.

This cash flow budget should be shown as month by month values for a twelve months period from July. As per the table in Task 2 the expenses need to be allocated in the month they are due or if an annual expense, split equally between all twelve months.

You will need to submit this budget formatted as either a Word table or Excel spreadsheet.

A cash flow forecast template document is provided on the OLS in the unit’s learning materials pages to assist you.

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN