Prepare a monthly cash budget, Financial Management

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.

Posted Date: 5/7/2013 2:55:41 AM | Location : United States

Related Discussions:- Prepare a monthly cash budget, Assignment Help, Ask Question on Prepare a monthly cash budget, Get Answer, Expert's Help, Prepare a monthly cash budget Discussions

Write discussion on Prepare a monthly cash budget
Your posts are moderated
Related Questions
Call-Put Parity P + S = C + E * [1/(1+i)] ^n     where:      P = the market price of the put    S = the market price of the stock    C = the market price of the call

I need assistance with 4 questions. How do I know someone can help me and have some idea of what it would cost before submitting the information? Also, how fast is the turnaround

Procedure of measurement of Future Value If we are getting a return of 10 % in one year then what is the return we are going to get in two years? 20 %, right. What about return

#questionoperating cycle in vegetable growing business in uganda..

Fund of hedge Funds The universe of Fund of Funds (FoFs), often referred to as Fund of Hedge Funds, continues to grow from Year 2000, both in absolute terms and as a relative c

what is the annual tax shield to a firm that has total assets of $80 million and a net worth of $55 million,if the average interest rate on debt is 8.5% and the marginal tax rate i

Dividend cover Dividend cover measures the relationship among earnings per share and net dividends per share. The higher the altitude of dividends for any given level of EPS t

Formation of Board of AMC and Restrictions on Directors Having regard to the significant role of the Board of Directors of the AMC in rendering the company's operations efficie

Q. Describes the Certainty Equivalent Coefficient Method? Introduction: - Certainty equivalent coefficient process which makes adjustment against risk in the estimates of futur

Consider a world with two assets: a riskless asset paying a zero interest rate, and a risky asset whose return r can take values +10% or -8% with equal probability. An individual h