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 accept-reject criteria, Q. Explain Accept-Reject Criteria? Acce...

Q. Explain Accept-Reject Criteria? Accept-Reject Criteria:- If actual ARR is elevated than the predetermined rate of return .......................Project would be accep

LEVERAGE, Evaluate the importance of leverage in financial management of a ...

Evaluate the importance of leverage in financial management of a small scale company

Name two patterns of cash flows for a share of common stock, Name two patte...

Name two patterns of cash flows for a share of common stock. How does the market define the value of the most common cash flow pattern for common stock? Cash flows for a share

Why the term objective is used for, Why the term objective is used for ...

Why the term objective is used for The term is used in a rather narrow sense of what a firm must attempt to achieve with its financing, investment and dividend policy decisions

Evaluate the profitability and sales, a) Stockpiles refers to the accumulat...

a) Stockpiles refers to the accumulated (or excess level of) supply Ford motor vehicles, i.e. too much production given the level of demand. The purpose is to prevent possible shor

Explain economic exposure to exchange risk, How would you explain economic ...

How would you explain economic exposure to exchange risk? Answer: Economic exposure can be illustrated as the opportunity that the firm’s cash flows and so its market value may

The oasis report, The Oasis Report Amidst all these problems, the Minis...

The Oasis Report Amidst all these problems, the Ministry of Social Justice and Empowerment constituted a committee with a view to improve old-age social security in the country

What is accumulated depreciation?, What is accumulated depreciation? De...

What is accumulated depreciation? Depreciation is the provision of an asset's initial cost over time.  Accumulated depreciation is the sum of all the depreciation expense that

Define in- order-driven according to trade intermediation, Define the in- o...

Define the in- order-driven according to trade intermediation. In- order-driven markets: In order-driven markets, buyers and sellers trade unswervingly without any intermedi

Expalin npv decision rule in basril plc, The NPV decision rule needs that a...

The NPV decision rule needs that a company invest in all projects that have a positive net present value. This presumes that sufficient funds are available for all incremental proj

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