Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ANSWER FAST AND PROPERLY Nikey Wholesaler sells various sports attire at Pavilion Kuala Lumpur. The companys financial controller, Mr Fattah has requested you to

PLEASE ANSWER FAST AND PROPERLY Nikey Wholesaler sells various sports attire at Pavilion Kuala Lumpur. The companys financial controller, Mr Fattah has requested you to prepare a cash budget for the month of July 2020. Mr Fattah provided the following information for you:

  1. The cash balance at July 1 2020 was estimated to be RM50,000.
  2. Actual sales of May and June and budgeted sales for July are as follows:

May (RM)

June (RM)

July (RM)

Cash sales

66,000

62,000

70,000

Credit sales

120,000

160,000

200,000

Total sales

186,000

222,000

270,000

  1. Credit sales are collected over a two-month period. With 80% being collected in the first month after the sales incurred and the balances being collected in the second month after the sales incurred.
  2. Inventory purchased are expected to be RM120,000 in July. The company pays for inventory purchases in the month following purchase. The balance of Junes purchases is RM 130,000.
  3. Selling and administrative expenses are budgeted to be RM18,000 for July. Of that amount, 30% is depreciation.
  4. Motor vehicle costing RM50,000 will be purchased in July by cash.
  5. A new machinery costing RM 80,000 was purchased and installed in June. 30% of the cost is payable during installation and the balance will be paid in two equal installments starting July onwards.

Required:

(a) Prepare cash budget for the month of July 2020

(17 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensic Accounting

Authors: Greg Shields

1st Edition

1727480988, 978-1727480986

More Books

Students also viewed these Accounting questions

Question

Where can one find a set of looseleaf publications or topics?

Answered: 1 week ago

Question

To realize business outcomes before and after HRM adoption.

Answered: 1 week ago