Question

In: Accounting

Question A CASH budget is required to enable the General Manager to decide what internal finances...

Question

A CASH budget is required to enable the General Manager to decide what internal finances are available towards the purchase of a new machine, and when to pay dividends. He also needs to determine whether bank accommodation (overdraft) is required around Christmas to meet the needs of January holiday salaries paid in advance in December.

Further it is necessary to check the effect of lack of production in January on the expected cash flow for the following March and April.

The current profit and loss projection is as follows:

Sales (as detailed below)                                            $7,200,000

Expenditure

Materials                                  $2,215,000

Wages                                      $2,673,000

Factory O/H                            $1,380,000 (incl. depreciation $30,000)

Administration                         $ 430,000

-----------

$6,698,000

-----------

$502,000

Budgeted sales in successive months in thousands of dollars are:

July 2018              640                          January 2019       160

August                  530                          February              600

September             520                          March                  700

October                 600                          April                    750

November             650                          May                     650

December              650                          June                     750

NOTES:

Terms of Trade

Sales are received in cash two months after the month in which they are invoiced. Materials are paid two months after delivery of the goods.

Wages                            - prompt pay (i.e. treat as though paid in moth in which obligation incurred)

Factory overheads          - one month in arrears Administration                - one month in arrears

Expected sales prior to the beginning of the budget year are:

1 month before the beginning of the year (June 2018)            $550,000 2 months before the beginning of the year (May 2018)                           $580,000

Expected materials and direct purchases prior to the beginning of the year are: 1 month before the beginning of the year (June 2018)                          $112,000 2 months before the beginning of the year (May 2018)                           $122,000

Other expenses prior to the beginning of the year may be taken as the projected monthly average of the first three months of the year.

Capital Movements

Capital expenditure, initial overdraft and loan movements are as follows: Opening overdraft                           $40,000

Loans to the company total $84,000 and repayments are received at the rate of $4,000 per month for each month of the year.

Past expenses due in July 2018 consist for group tax of $60,000 Removal costs of $30,000 are to be budgeted for September

New machinery is planned, represented by a deposit of $40,000 in October with additional interest and capital payments of $10,000 per month starting in the following month and continuing (i.e. it is being bought through hire purchase). Development and R&D costs additional to the operating budget totalling $90,000 should be spread over the months of March, April and May.

January wages are paid in December.

Allow for a contingent legal action and liability over a product complaint of $5,000 in April.

Draw up a cash budget for the forward financial year and determine the net overdraft requirement for the budget period if no further share or loan assistance is obtained. Show on the same table or graph the effect on overdraft requirements if sales turn out to be 10% below the budget estimate due to pressure on prices and total monthly operating expenses are 5% below the budget estimate. New equipment expenditure is unchanged.

A suggested format for the items of the cash budget to be filled in for each month of the financial year starting from 1st July 2018 is as follows:

Beginning of month overdraft Income from sales

Loans shares into company Subtotal – inwards cash

Materials Wages

Hire purchase payments Factory overheads Administration

Other cash outgoings, including capital expenditure Subtotal – net outgoings

End of month overdraft

*             Do not forget to add back depreciation as it contributes to cash flow.

Solutions

Expert Solution

Sl. No.

Particulars

July

2018

August

2018

Sept 2018

Oct

2018

Nov

2018

Dec

2018

Jan

2019

Feb

2019

Mar

2019

Apr

2019

May

2019

June

2019

1.

Opening balance

(40000)

45417

200834

83668

6502

(40664)

(230580)

75004

157838

(279328)

(281494)

(178660)

2.

Receipts from sales

580000

640000

530000

520000

520000

600000

650000

650000

160000

600000

700000

7500000

3.

Depreciation

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

4.

Total receipts(A)

542500

687917

733334

606168

529002

561836

421920

727504

320338

323172

421006

573840

5.

Materials

122000

112000

184583

184583

184583

184583

184583

184583

184583

184583

184583

184583

6.

Wages

222750

222750

222750

222750

222750

445500

0

222750

222750

222750

222750

222750

7.

Factory OH

112500

112500

112500

112500

112500

112500

112500

112500

112500

112500

112500

112500

8.

Administration

35833

35833

35833

35833

35833

35833

35833

35833

35833

35833

35833

35833

9.

Past Expenses

0

0

90000

0

0

0

0

0

0

0

0

0

10.

New Machinery

0

0

0

40000

10000

10000

10000

10000

10000   

10000

10000

10000

11.

Contingent legal action

0

0

0

0

0

0

0

0

0

5000

0

0

12.

Repayment of Loan

4000

4000

4000

4000

4000

4000

4000

4000

4000

4000

4000

4000

13.

R&D Cost

0

0

0

0

0

0

0

0

30000

30000

30000

0

14.

Total Payments(B)

497083

487083

649666

599666

569666

792416

346916

569666

599666

604666

599666

569666

15.

Net Closing Balance (A-B)

45417

200834

83668

6502

(40664)

(230580)

75004

157838

(279328)

(281494)

(178660)

4174

Cash Budget for the period July, 2018 to June, 2019 is presented below:

Total Overdraft Required is $ 1010726 throughout the year.


Related Solutions

What are the disadvantages if the government expenditures are finances by budget deficits?
What are the disadvantages if the government expenditures are finances by budget deficits?
prepare a budget by analyzing a fictional character’s finances, using a cash flow chart. Answers need...
prepare a budget by analyzing a fictional character’s finances, using a cash flow chart. Answers need to be accurate to the nearest cent.
Question 1 Required: Forecasting is an important business process to enable planning and preparation. Describe THREE...
Question 1 Required: Forecasting is an important business process to enable planning and preparation. Describe THREE (3) techniques that could be used to forecast costs. Illustrate your answer with the use of simple numerical examples. Evaluate the usefulness of these three techniques. (maximum word count 500 words) Question 2 The Feathered Friends Company is a small business manufacturing products for domestic and wild birds. Its best-selling product is the ‘fat ball’ that can be hung or placed in a garden...
what type of document is the budget? Internal or external?
what type of document is the budget? Internal or external?
You are a purchasing manager for General Electric and need to decide whether you should buy...
You are a purchasing manager for General Electric and need to decide whether you should buy stainless steel from a supplier in China or source it from a foundry in Pittsburgh. If you buy it from the Pittsburgh foundry, you’ll pay $3,000 per metric ton. If you buy from China, you’ll pay 14,000 yuan per metric ton. Both prices include transportation costs. The nominal exchange rate is US$1 for 7 yuan. A.Calculate the real exchange rate—the price of domestic steel...
3). You are required to prepare a cash budget (by filling in the gaps in the...
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the month of July, August, and September 2019. The company’s cash receipts and cash disbursements are provided in the table based on the amount of projected sales and the purchase (expenses) payments respectively for the month of July, August, and September. Month July August September Cash receipts RM127,500 RM152,500 RM145,000 Cash disbursements RM133,000 RM142,404 RM114,000 The...
3). You are required to prepare a cash budget (by filling in the gaps in the...
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the month of July, August, and September 2019. The company’s cash receipts, and cash disbursements are provided in the table based on the amount of projected sales and the purchase (expenses) payments respectively for the month of July, August, and September. Month July August September Cash receipts RM127,500 RM152,500 RM145,000 Cash disbursements RM133,000 RM142,404 RM114,000 The...
Critical Thinking: Nebraska is required to balance its state budget. The primary internal sources of revenue...
Critical Thinking: Nebraska is required to balance its state budget. The primary internal sources of revenue for Nebraska are income tax and sales tax. Externally, Nebraska, like all states, also receives a block grant from the Federal Government, but this might end. If the country goes into a recession and people both earn and spend less money, the state will receive less revenue. How can the state then maintain a balanced budget?
On this topic, you are required to prepare your monthly cash budget for the month of...
On this topic, you are required to prepare your monthly cash budget for the month of June 2020, if (assuming) there are 4 different sources of income and 12 different expenses and debt repayments. “Preparing monthly cash budget is an indicator for your personal financial growth’’. In reference to this statement, you are required to provide the reasons/importance of preparing your monthly cash budget. (1200 words) Note: Please write 1200 words
Question 4: People decide how to “budget” their time in much the same way that they...
Question 4: People decide how to “budget” their time in much the same way that they decide how to budget for different goods. Each person decides how much they “value” their leisure time versus their work time. The more people work, the more they tend to value their remaining leisure time. This is the justification for paying overtime to people working over 40 hours per week. How might we model this trade-off economically using the basic labor supply model by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT