Big Red Bicycle Pty Ltd is a bicycle manufacturer based

Big Red Bicycle Pty Ltd is a bicycle manufacturer based in Bendigo, Victoria. The company produces bicycles which it sells to retailers in the domestic Australian market.

The senior management structure of the company appears below.

According to company strategic plans, the company aims to achieve a net profit before tax of $1,000,000. The chief risks to this goal are:

• poor sales due to economic downturn
• increases in expenses such as wage expenses.

In addition to Australian operations, the company is considering manufacturing overseas to take advantage of reduced costs. The company is also considering diversifying its product range to reduce exposure to poor sales of one product.

Role

You are the manager of Sales Team A. You manage a small team of sales team members. Your duties include accessing budget information for your team, explaining relevant aspects of budgets and features of budget documents to your team, and supporting team members to achieve performance goals.

Task B

You have determined that one team member, Bill Goodale, will be responsible for tracking expenses and petty cash throughout the financial year. To meet organizational needs, this duty will need to be performed in accordance with policies and procedures.

You have determined that expenses will need to be divided equally and tracked by quarter. Bill will need to develop a spreadsheet to keep track of actual expenditure by account. To help control expenses, the spreadsheet will need to provide an ongoing tally of expense by account.

Bill’s skills include basic accounting. Bill needs to be informed of Big Red Bicycle policies and procedures for petty cash. Bill is familiar with Microsoft Excel but does not know how to use formulas and functions to sum columns or rows of figures.