Determine the cash flow budget - monthly cash disbursement, Financial Management

Assignment Help:

Your friend Peter is planning to set up a new business which will manufacture and sell wooden tables. The parts that make up the table consist of a wooden table top measuring 1m by 0.5m, four legs and 3m of trim. The wooden table top supplied by the vendor measures 1m by 1m and has to be cut into two halves before assembly. The legs are also supplied by the same vendor. The trim is supplied by another supplier and comes in rolls of 30m. Peter knows you are a management accountant and has asked you to help him prepare a budget for his new business so that he knows whether he can make any profit in the first six months. The following is Peter's plan and estimates: The new business will begin operations on 1 Jan 2013. Peter will put in $65,000 of his personal funds into the business and he has obtained a loan of $50,000 from a bank to be available on 1 Jan 2013. The loan interest is 5% per annum on the loan outstanding and interest is to be paid on the last day of each month. A principal payment of $1,000 will also be made at the end of each month. Plant and machinery will be purchased on 1 Jan at a cost of $36,000, to be paid in three equal monthly installments interest free. The plant and machinery is to be depreciated on a straight line basis over 5 years. Office equipment will be purchased on 1 Jan at a cost of $30,000 to be paid in full in Feb. The office equipment will be depreciated on a straight line basis over 3 years. Sales will start in Feb and Peter estimates that sales volume will be 400 units in Feb, increasing by 100 units every month until it reaches the production capacity of 1,000 units per month. Selling price is set at $145 per unit. 75% of the sales is expected to be on credit and the rest for cash. For the credit sales, Peter predicts that 60% will pay in the month following the sale, 30% in the second month following the sale and 10% in the third month of the sale.

Unit costs for the parts are:-

Table top (1m by 1m)                     $50

Leg (each)                                   $4

Trim (30m roll)                              $100

Labour costs are:-

Direct labour                                1.5 hours per table

Direct labour rate                          $30 per hour

Peter wishes to have an ending finished goods inventory equal to 20% of the sales requirements of the following month. The ending inventory for table top and legs should equal 30% of the production requirement of the next month. As for trims, it should be 10% of the production requirement of the next month rounded down to the nearest roll. There are no WIP inventories. Terms on purchases are 40% cash on delivery (COD) and 60% payable in the next month. A 2% discount is available for COD payments. Discounts received are reported as "Other Income" in the income statement. The company follows the terms of payment to take advantage of the COD discount. Direct labour cost is paid one month in arrears. Variable manufacturing overhead is estimated to be $2 per table. Fixed manufacturing overhead (excluding depreciation) is expected to be $6,000 per month. Variable selling & administration expenses are expected to be 5% of sales. Fixed selling & administration expenses (excluding depreciation) are budgeted to be $3,000 per month. All manufacturing overhead and selling & administration expenses are paid in the month incurred. The company uses absorption costing to determine its product cost.

Required  

Based on the information given, and ignoring GST and taxation, prepare the following from Jan to June 2013 for Peter's company:  

a)  A monthly sales budget     

b)  A monthly production budget    

c)  A monthly purchase budget    

d)  A monthly cash receipts budget   

e)  A monthly cash disbursement budget for material purchases

f)  A monthly cash disbursement budget for other items including the payment of long term loan principal and interest 

g)  A cash flow budget     

h)  A budgeted income statement for the six months from 1 Jan to 30 June 2013    

i)  A budgeted balance sheet as of 30 June 2013 

j)  A budgeted movement of owner's equity for the six months


Related Discussions:- Determine the cash flow budget - monthly cash disbursement

Explain life insurance in detail, Question 1 Insurance is protection again...

Question 1 Insurance is protection against possible financial loss. Explain life insurance in detail Question 2 Mutual funds are a composite of stocks, bonds, and securities,

Illustrating a straddle, Options Traded on Legal and General August 14  200...

Options Traded on Legal and General August 14  2009 Share   Price         Exercise      Price    Calls       Puts                                 Sep        Dec        Mar

Profitability index (pi), Profitability Index (PI) : It is a ratio of t...

Profitability Index (PI) : It is a ratio of the present value of the total cash benefits to the present value of the net cash outlay.  The higher the PI, the higher the return.

Financial Management, BigGardens Ltd (BigGardens) is a private company that...

BigGardens Ltd (BigGardens) is a private company that owns and operates a chain of garden centres in the Bristol area. The company has expanded rapidly over recent years, opening

What are the benefits as well as costs of holding inventory, Q. What are th...

Q. What are the benefits as well as costs of holding inventory? What is Inventory? What are the benefits as well as costs of holding inventory? Ans. Inventory: - Every enter

What is sinking fund, What is Sinking Fund A provision which requires t...

What is Sinking Fund A provision which requires the corporation to set aside a fixed amount every year to help provide for orderly repayment of the debt issue.

How financial system works, Question: Part A  The financial syste...

Question: Part A  The financial system is complex in structure and function throughout the world. There are many different types of institutions: banks, insurance compani

The need and analyse different savings instruments, Question 1 Financial p...

Question 1 Financial planning is a process of assessing the goals of an investor. Discuss the meaning, need and scope of Financial planning Question 2 Money management is the

Scope of finance function, SCOPE OF FINANCE FUNCTION In several busine...

SCOPE OF FINANCE FUNCTION In several businesses, based on the complexity and size of financial decision-making, the scope of finance function may be categorized into incidenta

Benefits of conducting a cost and benefit analysis, Question 1: i) What...

Question 1: i) What is meant by Cost and Benefit Analysis? Illustrate your answer with the use of empirical and hypothetical examples. ii) What are the benefits of conductin

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