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

6 KEY STAGES OF INVESTMENT DECISION WITH APPROPRIATE DIAGRAM, 6 KEY STAGES ...

6 KEY STAGES OF INVESTMENT DECISION WITH APPROPRIATE DIAGRAM

Perform appropriate ratio analyses on the balance sheet, Perform appropriat...

Perform appropriate ratio analyses on the balance sheet and income statements of your company using techniques discussed in chapter 2 of your textbook. Compare your company to a c

Declaration of auction results, Typically, there exist two type...

Typically, there exist two types of bids in the treasury auction process. They are: Competitive bid and non-competitive bid. A non-competitiv

Margin and marking to market, The collaterals used in the repo market...

The collaterals used in the repo market are high quality securities; but they are also not free from credit risk. In our earlier example, we see the dealer borrow

What is performance appraisal - cost of capital, What is Performance apprai...

What is Performance appraisal - cost of capital Performance appraisal further, cost of capital framework can be used to evaluate financial performance of top management. I

Define country’s economic well being enhanced, How is a country’s economic ...

How is a country’s economic well-being enhanced through free international trade in goods and services? As per to David Ricardo, with free international trade, it is mutually adv

Equity instruments, QUASI-INSTRUMENTS These instruments are considered ...

QUASI-INSTRUMENTS These instruments are considered as debt instruments for a time-frame and are converted into equity at the option of the investor (or at company's option) aft

International financial management - a European perspective , To whom it ma...

To whom it may concern, I wanna someone to help me to get prepared for my exam. is it possible to work together? 1. Managerial Aspects of the Market for Foreign Exchange

Credit analysis of non-corporate bonds, Like corporate bonds, non-cor...

Like corporate bonds, non-corporate bonds such as asset-backed securities, mortgage-backed securities, municipal bonds, sovereign bonds are also exposed to credit

Aggressive approach of financial management, Q. Aggressive Approach of fina...

Q. Aggressive Approach of financial management? A -firm may be aggressive in financing its assets. An aggressive policy is said to be followed by the firm when it uses short-te

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