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.
Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter7: The Master Budget And Flexible Budgeting
Section: Chapter Questions
Problem 5P: Selling and administrative expense budget and budgeted income statement Budgeted selling and...
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
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College