Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ITECH Technology is in a process of preparing a monthly cash budget for the upcoming 6- months starting from January to June. Below is the
ITECH Technology is in a process of preparing a monthly cash budget for the upcoming 6- months starting from January to June. Below is the projection of sales for ITECH Technology for 8-months of 2018 January February March June 200,000 350,000 300,000 450,000 500,000 400,000 April May The company's sales are highly seasonal peaking in the months of April and May. The purchase generally is equal 60 percent of sales, purchases are all made one month in advance of the anticipated sales. Ten percent of the payment to suppliers was made during the month of purchase, 60 percent in following month and the remaining 30 percent two months after the purchase. For example, for January purchases, 10 percent will be paid in January, 60 percent in February, and 30 percent in March. All sales are made on credit. 25 percent of the collections are made in the following one month after sales, and the remaining during the third month following sales. Besides these, ITECH has certain expenses that have to be paid on a monthly basis. Rent of warehouse is RM 20,000; the interest expense id RM 10,000; the salary is RM 5,000. ITECH company also expects to pay RM 25,000 at the end of March and RM 25,000 at the end of June as tax prepayments. ITECH tries to maintain a security balance, in cash, of RM 5,000. If this amount is below the figure mentioned, ITECH can borrow at 1 percent month Assuming ITECH will need to repay any accrual interest in June, create the cash budget for January-June 2017. The cash balance for January 1, 2017, is RM 45,000; the sales for November is RM 240.000, and in December the sales was RM 300,000. The expected sales in July are RM 350,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started