Top Sdn Bhd had cash of RM13,000 on hand together with trade debtors outstandingbalance of RM55,000 as at January 1. During the year, the company expected thefollowing sales to customers by quarter, with collection terms of 50% in cash and 50% incredit receivable in the next quarter:FirstSecondThirdFourthSales (RM)110,000245,000122,400149,600Direct materials purchases in metric tons (MT) costing RM 50.00 per MT payable in thesame quarter are as follows:FirstSecondThirdFourthDirect MaterialsPurchases (MT)1,3001,5001,1001,000The production budget showed the following unit production by quarter with an averagelabour wage rate of RM40.00 payable in the same quarter:FirstSecondThirdFourthUnits to be produced1,5002,0001,7001,500Top Sdu Bhd planned to pay dividends of RM10,000 per quarter during the year. In July,a new equipment costing RM60,000 will be purchased. An additional cost of RM16,000was planned for its installation during the fourth quarter.The company was required to maintain a minimum cash balance of RM15,000. A line ofcredit was available for short-term borrowings in increments of RM1,000. Allborrowings will be made at the beginning of a quarter and repaid at the end of thequarter. Interest on the short-term borrowings will be paid at 0.5% per quarter on theamount repaid in any quarter when a loan repayment is made. All other interest expensewill be accrued each quarter.Required:(a)Prepare a cash budget for Top Sdn Bhd by quarter and for the year in total.(b)Cash budget plays a critical role to a business particularly during a financial crisisperiod with slow-down in the economic activities.Advise Top Sdn Bhd what liquidity problems in a business are, how a cashbudget preparation is able to solve these problems and the challenges in workingout a reliable and realistic cash budget.(c)Top Sdu Bhd is considering establishing a sound and effective budgetaryplanning and control system to assist in managing the business with greateefficiency.State THREE (3) main objectives of establishing a budgetary planning andcontrol system in a business organization.

What is meant by Budgeting? It is the process of estimating the future revenues and outflows on the…

Top Sdn Bhd had cash of RM13,000 on hand together with trade debtors outstanding balance of RM55,000 as at January 1. During the year, the company expected the following sales to customers by quarter, with collection terms of 50% in cash and 50% in credit receivable in the next quarter: First Second Third Fourth Sales (RM) 110,000 245,000 122,400 149,600 Direct materials purchases in metric tons (MT) costing RM 50.00 per MT payable in the same quarter are as follows: First Second Third Fourth Direct Materials Purchases (MT) 1 300 500 1 100 1.000

Top Sdn Bhd had cash of RM13,000 on hand together with trade debtors outstanding balance of RM55,000 as at January 1. During the year, the company expected the following sales to customers by quarter, with collection terms of 50% in cash and 50% in credit receivable in the next quarter: First Second Third Fourth Sales (RM) 110,000 245,000 122,400 149,600 Direct materials purchases in metric tons (MT) costing RM 50.00 per MT payable in the same quarter are as follows: First Second Third Fourth Direct Materials Purchases (MT) 1 300 500 1 100 1.000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A company has a turnover of SEK 15,000,000. The supplier credit period is on average 28 days. The annual purchases of goods etc. amounts to SEK 9,000,000. Accounts receivable amount to SEK 1,250,000 on average. Cash and cash equivalents account for 6% of sales. The inventory averages SEK 1,500,000. The management's goal is to reduce the working capital requirement by SEK 250,000. The finance department believes that the goal can be achieved by reducing inventory to an average of SEK 1,400,000, extending the average supplier credit period by two days and shortening the average customer credit period by 3 days. Is it true? Points require both motivation and that all calculations are reported.
The following information is an extract of the statement of profit or loss of Palladium Ltd for the current financial year: The average accounts receivable collection period is 45 days. The average payment supplier period is 50 days and the cash conversion cycle has been calculated as 55 days. REQUIRED: Annual sales (20% cash) R625 000 Cost of Sales R125 000 Purchases (50% on credit) R200 000 Calculate the total average investment in the cash conversion cycle (CCC) for Palladium Ltd.Assume that there are 365 days in a year.Round to the nearest Rand.
Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $30 million minimum balance. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can Invest any excess funds in short-term marketable securities at a rate of 2 percent per…
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september 195,000 october 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. vi) the company plans to pay rm 6,500 in cash for a brand-new computer in august. vii) a quarterly dividend of rm 10,000 will be paid to ABC…
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
Vijay
Sales in December were $960,000. Projected sales for the first quarter of next year are: January $1,080,000 February $1,300,000 March $1,280,000 Sales are 20% cash and 80% on credit. Debtors pay in the month following the sale. Calculate the total cash sales for the three months, January, February and March. Select one: O a. $732,000 O b. $256,000 O c. $960,000 O d. $2,848,000 O e. none of these
Ait Limited has annual credit sales of Ghc5 million and cost of sales of GHC1.8 million. The company’s current assets consist of inventory and trade receivables. Current liabilities consist of accounts payables and an overdraft facility with an average interest rate of 10% per annum. The company gives 60 days credit to its customers and is allowed an average of 30 days credit by trade suppliers. The company has an operating cycle of 90 days. Current ratio of Ait Ltd 1.5:1 and the Cost of long-term finance to Ait Ltd is 12% per annum. Calculate the Size of the overdraft of Ait Ltd, Net working capital of the company and Total cost of financing its current assets?
JoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750