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

Securities and exchange commission of usa, SECURITIES AND EXCHANGE COMMISSI...

SECURITIES AND EXCHANGE COMMISSION OF USA In the United States, securities industry is regulated by the United States Securities and Exchange Commission (SEC). It is the govern

Financial bootstrapping, Briefly describe the major differences between a s...

Briefly describe the major differences between a sole proprietorship and a corporation. Under which form would you choose for a business, and why? Describe the meaning of financi

Characteristics of hedge funds, Characteristics of Hedge Funds Hedge Fu...

Characteristics of Hedge Funds Hedge Funds are commonly referred to as "absolute return strategies", which means that many are designed to seek positive returns in most market

Debt ratio, What is the Debt Ratio? Describe please.

What is the Debt Ratio? Describe please.

How are libor, Q. How are LIBOR, TIBOR and EURIBOR determined? London I...

Q. How are LIBOR, TIBOR and EURIBOR determined? London Inter Bank Offered rate ( LIBOR) and is the rate of interest at which banks offer funds to other banks in marketable siz

Finance case study, This case has been framed in order to test the skills i...

This case has been framed in order to test the skills in evaluating a credit request and reaching a correct decision. Perluence International is large manufacturer

Non-interest rate indexes, Generally, an interest rate or an interest...

Generally, an interest rate or an interest rate index is used as a reference rate for However, through financial engineering, issuers have been able to construct

Describe a.i.g''s business model and structure, A.I.G. is often called the ...

A.I.G. is often called the largest insurance entity in the world. A.I.G.'s total assets were $860 billion on 12/31/2008 (dwarfing any other insurance entity) with 116,000 employees

Explain exchange rate affect the return from foreign market, Explain how ex...

Explain how exchange rate fluctuations influence the return from a foreign market measured in dollar terms. Discuss the empirical proof on the effect of exchange rate doubt on the

What is public finance, What is Public Finance Central, state as well...

What is Public Finance Central, state as well as local governments handle large sums ofmoney, which are received from several sources and should be utilized in accordancewith

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