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

Case study, credit limit decision bajaj electronics company

credit limit decision bajaj electronics company

Explain the competitive benchmarking, Explain the Competitive Benchmarking ...

Explain the Competitive Benchmarking Healthcare services or Hospital are compared to rival 'competition 'in the same industry for instance methods of patient care and levels o

Calculate total development cost, A developer has purchased a commercial of...

A developer has purchased a commercial office site in Melbourne and wishes to develop a building which will be sold to an institutional owner before completion of the building.

Explain the bird in the hand theory of cash dividends, Explain the bird in ...

Explain the bird in the hand theory of cash dividends. The bird in the hand dividends theory states that dividends received now are better as compared to a promise of future divi

SES, Scenario: You are still a consultant for the Excellent Consulting Grou...

Scenario: You are still a consultant for the Excellent Consulting Group. You have completed the first assignment, developing and testing a forecasting method based on linear regres

13 basic ratios, What its the net income? Total current assets, plant and e...

What its the net income? Total current assets, plant and equipment, net plant and equipment, our net account receivable?

What are the disclosure requirements, Disclosure requirements · Common...

Disclosure requirements · Common information about how operating segments were identified and types of products and services from which every operating segment derives its rev

Introduction to mortgage-backed securities, A mortgage may be defined as a ...

A mortgage may be defined as a pledge of property to secure payment of a debt. Depending upon the terms of mortgage agreed upon between the lender and the borrower, mor

Define the negative consequences of a company holding, What are the negativ...

What are the negative consequences of a company holding too much cash? A company holding so much cash would be giving up the opportunity to invest much more in income producing a

International finance problem, International Finance Problem Analyze th...

International Finance Problem Analyze the attached case, along the lines indicated by the Assignment questions listed at the end of the case.  Since you will have plenty of tim

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