Following information are taken from adele Sdn Bhd (ASB): wwwm a w a) The cash balance at 1 st August 2018 was estimated to be RM 40,000 b) ASBnd budgeted sales revenue as follows: June RM Jul RM August 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 c) Credit sales are collected over a two-month period. With 80% being collected in the! first month after the sales occurred and the remainder being collected in the second month also after the sales occurred. d) Inventory purchased are expected to be RM200,000 in August. The company pays for inventory purchases in the month following purchase. The balance of July's purchase is RM250,000. e) Selling and administrative expenses are budgeted to be RM18,000 for August. Of that amount 30% is depreciation. f) Two lorries which cost RM50,000 will be purchased in August through cash. g) The company wishes to maintain a minimum cash balance of RM10,000 at the end of each month. The company borrows money from the bank at 10% interest rate per annum if necessary to maintain the minimum cash balance. Required: a) Prepare a schedule of collections for the month of August 2018. b) Prepare cash budget for the month of August 2018. c) Explain any THREE (3) benefit of budgeting.
Following information are taken from adele Sdn Bhd (ASB): wwwm a w a) The cash balance at 1 st August 2018 was estimated to be RM 40,000 b) ASBnd budgeted sales revenue as follows: June RM Jul RM August 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 c) Credit sales are collected over a two-month period. With 80% being collected in the! first month after the sales occurred and the remainder being collected in the second month also after the sales occurred. d) Inventory purchased are expected to be RM200,000 in August. The company pays for inventory purchases in the month following purchase. The balance of July's purchase is RM250,000. e) Selling and administrative expenses are budgeted to be RM18,000 for August. Of that amount 30% is depreciation. f) Two lorries which cost RM50,000 will be purchased in August through cash. g) The company wishes to maintain a minimum cash balance of RM10,000 at the end of each month. The company borrows money from the bank at 10% interest rate per annum if necessary to maintain the minimum cash balance. Required: a) Prepare a schedule of collections for the month of August 2018. b) Prepare cash budget for the month of August 2018. c) Explain any THREE (3) benefit of budgeting.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Requirement
Show your working
Transcribed Image Text:Following information are taken from adele Sdn Bhd (ASB):
wwwm a w
a) The cash balance at 1 st August 2018 was estimated to be RM 40,000
b) ASBnd budgeted sales revenue as follows:
June RM
Jul RM
August 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
c) Credit sales are collected over a two-month period. With 80% being collected in the!
first month after the sales occurred and the remainder being collected in the second
month also after the sales occurred.
d) Inventory purchased are expected to be RM200,000 in August. The company pays for
inventory purchases in the month following purchase. The balance of July's purchase is
RM250,000.
e) Selling and administrative expenses are budgeted to be RM18,000 for August. Of that
amount 30% is depreciation.
f) Two lorries which cost RM50,000 will be purchased in August through cash.
g) The company wishes to maintain a minimum cash balance of RM10,000 at the end of
each month. The company borrows money from the bank at 10% interest rate per annum
if necessary to maintain the minimum cash balance.
Required:
a) Prepare a schedule of collections for the month of August 2018.
b) Prepare cash budget for the month of August 2018.
c) Explain any THREE (3) benefit of budgeting.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education