Biobrow Sdn, Bhd is a retail fertilizer to farmers in Jitra, The company has approached its Bankers to provide funding for next year's operations., In considering their funding application, a three - month master budget has been requested for review by the bankers. As a freelance accounting service provider, you have been approached by the management as a consultant to prepare the Ist quarter budget for the banker's consideration for its next year's (2021) operations. Below is the information as at the end of accounting year of December 2020: Detalls RM Debtors 23,000 55,000 G98,000 Bank Fixed asset at cost Accumulated depreciation 98,000 48,000 60,000 400,000 20,000 120,000 Creditors Operating expenses for December Sales for December Ending inventory Retained ear nings The foliowing additlonal information was also provlded to assist your work. 1) Depreciation is provided at the rate of 5% on cost of non-current assets per month. I) Closing Inventory is expected to increase by RM2000 in January from December levels. This is expected to increase by the same figure in February from the projected figure in January. It is expected that in March closing inventory is desired to be RM26,000 i) The company makes a profit of 25% on its sales. iv) Operating expenses is expected to increase by 10% from that of December in January and this is projected to Increase at the same growth rate until March. v) Sales is projected to grow by 15% per month from December until March. vi) Debtors figure at the end of the month is desired to be proportional to the sales values. vil) Creditors value for the three months are expected to be as folows: January - RMS0,000; February - RMA6,000; March - RM52,000 REQUIRED; Prepare the following three-months (January to March 2021) budget as required by the bankers. a) The Schedule of Cash Collection b) The Schedule of Cash Payment c) The Budgeted Income Statement d) The Cash Budget e) The Budgeted Statement of Financial Position f) Identify and Explain TWO (2) possible risks that may cause the company not achleving their targeted profit for the first quarter of 2021,

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 7E: Professional foes earned budget for a service company LundquistFret well. CPAs, offer three types of...
icon
Related questions
Question
100%
How to do (a) to (f)?
QUESTION
Biobrow Sdn. Bhd is a retail fertilizer to farmers in Jitra, The company has approached its
Bankers to provide funding for next year's operations. In considering their funding application, a
three - month master budget has been requested for review by the bankers.
As a freelance accounting service provider, you have been approached by the management as a
consultant to prepare the Ist quarter budget for the banker's consideration for its next year's
(2021) operations.
Below is the information as at the end of accounting year of December 2020:
Detalls
RM
23,000
55,000
G98,000
98,000
48,000
Debtors
Bank
Fixed asset at cost
Accumulated depreciation
Creditors
Operating expenses for December
Sales for December
G0,000
400,000
20,000
120,000
Ending inventory
Retained earnings
The following additional informatilon was also provlded to assist your work,
i) Depreciation is provided at the rate of 5% on cost of non-current assets per month.
Ii) Closing inventory is expected to increase by RM2000 in January from December levels. This is
expected to increase by the same figure in February from the projected figure in January. It
is expected that in March closing inventory is desired to be RM26,000
iii) The company makes a profit of 25% on its sales.
iv) Operating expenses is expected to increase by 10% from that of December in January and this
is projected to increase at the same growth rate until March.
v) Sales is projected to grow by 1S% per month from December until March.
vi) Debtors figure at the end of the month is desired to be proportional to the sales values.
vii) Creditors value for the three months are expected to be as foliows:
January - RM50,000; February - RMA6,000; March - RM52,000
REQUIRED:
Prepare the following three-months (January to March 2021) budget as required by the bankers.
a) The Schedule of Cash Collection
b) The Schedule of Cash Payment
c) The Budgeted Income Statement
d) The Cash Budget
e) The Budgeted Statement of Financial Position
f) Identify and Explain TWO (2) possible risks that may cause the company not achleving
their targeted profit for the first quarter of 2021.
Transcribed Image Text:QUESTION Biobrow Sdn. Bhd is a retail fertilizer to farmers in Jitra, The company has approached its Bankers to provide funding for next year's operations. In considering their funding application, a three - month master budget has been requested for review by the bankers. As a freelance accounting service provider, you have been approached by the management as a consultant to prepare the Ist quarter budget for the banker's consideration for its next year's (2021) operations. Below is the information as at the end of accounting year of December 2020: Detalls RM 23,000 55,000 G98,000 98,000 48,000 Debtors Bank Fixed asset at cost Accumulated depreciation Creditors Operating expenses for December Sales for December G0,000 400,000 20,000 120,000 Ending inventory Retained earnings The following additional informatilon was also provlded to assist your work, i) Depreciation is provided at the rate of 5% on cost of non-current assets per month. Ii) Closing inventory is expected to increase by RM2000 in January from December levels. This is expected to increase by the same figure in February from the projected figure in January. It is expected that in March closing inventory is desired to be RM26,000 iii) The company makes a profit of 25% on its sales. iv) Operating expenses is expected to increase by 10% from that of December in January and this is projected to increase at the same growth rate until March. v) Sales is projected to grow by 1S% per month from December until March. vi) Debtors figure at the end of the month is desired to be proportional to the sales values. vii) Creditors value for the three months are expected to be as foliows: January - RM50,000; February - RMA6,000; March - RM52,000 REQUIRED: Prepare the following three-months (January to March 2021) budget as required by the bankers. a) The Schedule of Cash Collection b) The Schedule of Cash Payment c) The Budgeted Income Statement d) The Cash Budget e) The Budgeted Statement of Financial Position f) Identify and Explain TWO (2) possible risks that may cause the company not achleving their targeted profit for the first quarter of 2021.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory Management
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning