Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ajinamoto Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of

Ajinamoto Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of planned cash receipts and disbursements:
The monthly sales for the year of 2023:
RM RM
April 550,000 August 680,000
May 660,000 September 565,000
June 700,000 October 620,000
July 650,000 November 650,000
a) The firm's sales of 80% is collected in the month of sale and the remaining balance will be collected equally in the following two months.
b) The raw materials are 50% of sales purchased two (2) months before the sales month. The supplier is paid in next month.
c) The wages and salaries are paid based on 8% of sales in the month.
d) The utilities for the firm are 3% of sales in the month of their incurrence.
e) Furthermore, the monthly rental expenses are RM10,000 and RM7,000 tax payments are to be made in the second month of each quarter.
f) A 5% annual interest on a RM500,000 term loan will be paid monthly.
g) Beginning cash balance for the budget period is RM120,000 with a minimum cash balance of RM45,000 and an increase to RM90,000 in August and RM135,000 in September.
Prepare a monthly cash budget for the three-month period ended 30th September.

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

Modern Auditing

Authors: William C. Boynton, Walter G. Kell

6th Edition

0471596876, 9780471596875

More Books

Students also viewed these Accounting questions