Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mahsuri Berhad sells high quality chocolates and flowers which it buys in bulk, packages and distributes tocustomers. The following is a table of estimated revenues

Mahsuri Berhad sells high quality chocolates and flowers which it buys in bulk, packages and distributes tocustomers. The following is a table of estimated revenues and costs for the period July 2021 to December2021. Other costs are included in the notes below: July Aug Sept Oct Nov Dec RM 000 RM'000 RM 000 RM 000 RM 000 RM 000 Sales of chocolatesand flowers 500 532 564 612 640 660 Purchases ofchocolates and flowers 250 266 282 306 320 330 Administrationexpenses 110 120 124 130 136 140 Packaging costs 4 6 6 6 8 8 Miscellaneousexpenses Loan repayments 12 100 12 14 14 16 16 100 - Notes: Stocks of chocolates and flowers (at cost) are estimated at RM500,000 at 1 July 2021 and RM340,000 at31 December 2021. Suppliers allow one month's credit. Purchases in June 2021 will total RM120,000. 30% of sales are paid for in the month of sale. The remainder are paid for in the month following themonth of sale. June 2021 sales are expected to be RM280,000. Delivery costs are 1% of sales revenue each month paid in the month in which they are incurred. Administration and miscellaneous expenses are also paid in the month incurred. Packaging costs are paid two months after they are incurred. These costs will be RM2,000 in May 2021 and are expected to be the same in June 2021. A bank overdraft of RM310,000 is expected on 1 July 2021. The bank charges interest of 1% per monthfor the overdraft, calculated on the closing balance each month, and payable the following month. Loan repayments refer to a bank loan which is interest free until January 2022. The business has no depreciable fixed assets. Required: Making all calculations to the nearest RM1000, prepare for Mahsuri Berhad, a monthly cash budget, in columnar form, for each of the five months to 30 November 2021. showing the cash balance at the end of each month. (23 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

Vba Advanced Advanced Techniques For Finance Pros

Authors: Hayden Van Der Post

1st Edition

979-8864994818

More Books

Students also viewed these Accounting questions

Question

Are my points each supported by at least two subpoints?

Answered: 1 week ago