Prepare a monthly cash budget, Financial Management

Assignment Help:

Citilink will start a new business line on 1st July, 2011 to make and sell bus souvenirs. The target sales and production volume are 525,000 in next year. The following projected data is available.

Total costs $1,428,000

Costs as percentage of sales

Raw materials 15%

Direct labour 20%

Variable production overheads 11%

Fixed production overheads 10%

Other costs 12%

Working capital statistics

Average raw material holding period 4 weeks

Average finished goods holding period 4 weeks

Average debtors' collection period 6 weeks

Average creditors' payment period on:

- Raw materials 4 weeks

- Direct labour 1 week

- Variable production overheads 8 weeks

- Fixed production overheads 5 weeks

- Other costs 12 weeks

Other relevant information

- Assume all operation will start at 1st July, 2011.

- Assume sales are the same every month once the souvenirs are available for sales.

- All finished goods inventory values include raw materials, direct labour, variable production overheads and apportioned fixed production overhead costs.

- Assume there are 52 weeks in one year.

- Assume that production and sales volumes are the same.

As an accountant of the new business line, you have to write a BUDGET PROPOSAL to the Finance Director of Citilink. The proposal should include the following issues:

(a) Identify who might be involved in the working capital decision making of the new business line and assess the information needs of them individually.

(b) Calculate with explanation the unit costs of the souvenirs. You should state your assumption, if any.

(c) Determine the price of the souvenirs and explain any other information that might be relevant for deciding the price.

(d) Discuss how sensitivity analysis will help the cost and pricing decision of the new business line

(e) Estimate average working capital required by the new business line for the year. Explain overtrading and analyse whether there is any overtrading problem if the new business line only reserves $150,000 working capital.

(f) Prepare a monthly cash budget for the new business line for the year ended 30th June, 2012. Identify the timing of cash surplus and shortage by assuming zero cash at 1st July, 2011. You should clearly state your assumption, if any.

(g) Identify other budgets that may be helpful to analyse and monitor the new business line.


Related Discussions:- Prepare a monthly cash budget

Explain about working capital funding policy, When considering how working ...

When considering how working capital is funding it is useful to divide assets into permanent current assets, noncurrent assets and fluctuating current assets. Permanent current ass

Project budgets and reporting systems, Project Budgets and Reporting System...

Project Budgets and Reporting Systems: In many cases, where a project is initiated and a budget allocated, a separate account is created to ensure costs attributable to that pr

Define how do mergers affect small businesses, How do mergers affect small ...

How do mergers affect small businesses? A: As per to a recent study by Federal Reserve and Wharton Financial Institutions Center economists, not a big deal. Their analysis reve

What is the meaning of statement- earn out arrangements, What is the meanin...

What is the meaning of statement- Earn out arrangements These arrangements take place during acquisition of another company. Parent company agrees to pay additional money if

Consequence of the cash operating cycle, Q. Consequence of the cash operati...

Q. Consequence of the cash operating cycle? The cash operating cycle is the length of time among paying trade payables and receiving cash from receivables. It is able to be cal

Accounting principles board, Q. Accounting Principles Board ? Accountin...

Q. Accounting Principles Board ? Accounting Principles Board (APB) -senior technical committee of AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS (AICPA) that issued pronoun

Historical differences in equity securities, Public Bourses The origin ...

Public Bourses The origin of this type of bourses can be found in the legislative work of Napoleon. These type of bourses are regulated by the government, brokers are appointed

What are the specefic control procedures of benchmarking, What are the spec...

What are the specefic control procedures of benchmarking Specific control procedures must be in place which include: O Organisational structure (clear lines of responsibilit

Types of firms in securities firms and investment banking, What are the typ...

What are the types of firms that securities firms and investment banking industry included? Into the USA, the securities firms and investment banking industry comprises several

Explain foreign equity ownership restrictions, Explain foreign equity owner...

Explain foreign equity ownership restrictions. Why do you think countries entail these restrictions? Several countries restrict the maximum fractional ownership of local organiza

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd