BioGrow 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 1st 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: Details RM Debtors 23,000 Bank 55,000 Fixed asset at cost 698,000 Accumulated depreciation 98,000 Creditors 48,000 Operating expenses for December 60,000 Sales for December 400,000 Ending inventory 20,000 Retained earnings 120,000 The following additional information was also provided 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 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. vii) Creditors value for the three months are expected to be as follows: January - RM50,000; February – RM46,000; March – RM52,000 REQUIRED: Prepare the following three-months (January to March 2021) budget as required by the bankers. The Schedule of Cash Collection The Schedule of Cash Payment The Budgeted Income Statement The Cash Budget The Budgeted Statement of Financial Position Identify and Explain TWO (2) possible risks that may cause the company not achieving their targeted profit for the first quarter of 2021.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
BioGrow 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
As a freelance accounting service provider, you have been approached by the management as a consultant to prepare the 1st 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:
Details |
RM |
Debtors |
23,000 |
Bank |
55,000 |
Fixed asset at cost |
698,000 |
|
98,000 |
Creditors |
48,000 |
Operating expenses for December |
60,000 |
Sales for December |
400,000 |
Ending inventory |
20,000 |
|
120,000 |
The following additional information was also provided 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 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.
vii) Creditors value for the three months are expected to be as follows:
January - RM50,000; February – RM46,000; March – RM52,000
REQUIRED:
Prepare the following three-months (January to March 2021) budget as required by the bankers.
- The Schedule of Cash Collection
- The Schedule of Cash Payment
- The
Budgeted Income Statement - The
Cash Budget - The Budgeted
Statement of Financial Position - Identify and Explain TWO (2) possible risks that may cause the company not achieving their targeted profit for the first quarter of 2021.
Step by step
Solved in 4 steps with 3 images