A. Brilliant Marketing Sdn Bhd, a glove product marketing company, is developing a cash budget for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A. Brilliant Marketing Sdn Bhd, a glove product marketing company, is developing a cash budget for October, November, and December. Brilliant Marketing Sdn Bhd's sales in August and September were RM200,000 and RM100,000, respectively. Brilliant Marketing forecasts sales of RM400,000, RM300,000, and RM200,000 for October, November, and December, respectively. Historically, 20% of the firm's sales each month have been for cash, 50% have generated accounts receivable collected after one month, and the remaining 30% have generated accounts receivable collected after two months. Bad-debt expenses (uncollectible accounts) have been negligible. In December, the firm will receive an RM20,000 dividend from stock in a subsidiary. The beginning balance for October is RM100,000. Additional Information: In December, Brilliant Marketing earns net cash inflows of RM45,000, which it uses to repay some of its short-term borrowings, reducing the outstanding short-term debt from RM70,000 to RM40,000. In summary, the financial activities for each month would be as follows: - 1. Forecast sales: Brilliant Marketing expects sales to rise from August to October before falling slightly in November and December. 2. Cash sales: The cash sales shown for each month represent 20% of the total sales for that month. 3. Collections of A/R: These entries represent the collection of accounts receivable (A/R) resulting from sales in earlier months. 4. Lagged one month: These figures represent credit sales made in the preceding month that was collected in the current month. For example, because 50% of the current month's sales are collected one month later, the collections of A/R with a one-month lag shown for September represent 50% of the sales in August. 5. Lagged two months: These figures represent credit sales made two months earlier that was collected in the current month. Because 30% of sales are collected two months later, the collections with a two-month lag shown for October represent 30% of the sales in August, and so on. 6. Other cash receipts: Cash receipts not tied to sales could include interest, dividends, proceeds from the sale of equipment, and stock and bond sale proceeds. The only receipt in this category is the RM20,000 dividend they expect to receive in December. Brilliant Marketing has also gathered the following data needed for preparing cash disbursements scheduled for October, November, and December:- 1. Purchases: Purchases equal 70% of sales. Of this amount, Brilliant Marketing pays 10% in cash upfront. It pays 70% the month after purchase. The company pays the remaining 20% two months after purchase. 2. Rent payments: Brilliant Marketing will pay rent of RM2,000 each month. 3. Wages and salaries: Fixed salaries are RM7,000 per month, and variable wages equal 10% of monthly sales. 4. Tax payments: Brilliant Marketing must pay taxes of RM20,000 in December. 5. Fixed-asset outlays: Brilliant Marketing will pay RM100,000 for new machinery in November. 6. Interest payments: Brilliant Marketing must pay RM10,000 in interest in December. 7. Cash dividend payments: Brilliant Marketing will pay cash dividends of RM20,000 in October. 8. Principal payments (loans): A RM20,000 principal payment is due in December. Required: a. Estimate the end-of-month closing cash balances for each month, October to December. (7 marks) b. The directors decide that the cash balance should be maintained at RM20,00 each month. Determine the required total financing or excess cash balance for each month, October to December. (7 marks) c. Analyze the results and suggest action to be taken by the manager. Do you think that Brilliant Marketing will need an overdraft facility for the period from October to December? (2 marks) A. Brilliant Marketing Sdn Bhd, a glove product marketing company, is developing a cash budget for October, November, and December. Brilliant Marketing Sdn Bhd's sales in August and September were RM200,000 and RM100,000, respectively. Brilliant Marketing forecasts sales of RM400,000, RM300,000, and RM200,000 for October, November, and December, respectively. Historically, 20% of the firm's sales each month have been for cash, 50% have generated accounts receivable collected after one month, and the remaining 30% have generated accounts receivable collected after two months. Bad-debt expenses (uncollectible accounts) have been negligible. In December, the firm will receive an RM20,000 dividend from stock in a subsidiary. The beginning balance for October is RM100,000. Additional Information: In December, Brilliant Marketing earns net cash inflows of RM45,000, which it uses to repay some of its short-term borrowings, reducing the outstanding short-term debt from RM70,000 to RM40,000. In summary, the financial activities for each month would be as follows: - 1. Forecast sales: Brilliant Marketing expects sales to rise from August to October before falling slightly in November and December. 2. Cash sales: The cash sales shown for each month represent 20% of the total sales for that month. 3. Collections of A/R: These entries represent the collection of accounts receivable (A/R) resulting from sales in earlier months. 4. Lagged one month: These figures represent credit sales made in the preceding month that was collected in the current month. For example, because 50% of the current month's sales are collected one month later, the collections of A/R with a one-month lag shown for September represent 50% of the sales in August. 5. Lagged two months: These figures represent credit sales made two months earlier that was collected in the current month. Because 30% of sales are collected two months later, the collections with a two-month lag shown for October represent 30% of the sales in August, and so on. 6. Other cash receipts: Cash receipts not tied to sales could include interest, dividends, proceeds from the sale of equipment, and stock and bond sale proceeds. The only receipt in this category is the RM20,000 dividend they expect to receive in December. Brilliant Marketing has also gathered the following data needed for preparing cash disbursements scheduled for October, November, and December:- 1. Purchases: Purchases equal 70% of sales. Of this amount, Brilliant Marketing pays 10% in cash upfront. It pays 70% the month after purchase. The company pays the remaining 20% two months after purchase. 2. Rent payments: Brilliant Marketing will pay rent of RM2,000 each month. 3. Wages and salaries: Fixed salaries are RM7,000 per month, and variable wages equal 10% of monthly sales. 4. Tax payments: Brilliant Marketing must pay taxes of RM20,000 in December. 5. Fixed-asset outlays: Brilliant Marketing will pay RM100,000 for new machinery in November. 6. Interest payments: Brilliant Marketing must pay RM10,000 in interest in December. 7. Cash dividend payments: Brilliant Marketing will pay cash dividends of RM20,000 in October. 8. Principal payments (loans): A RM20,000 principal payment is due in December. Required: a. Estimate the end-of-month closing cash balances for each month, October to December. (7 marks) b. The directors decide that the cash balance should be maintained at RM20,00 each month. Determine the required total financing or excess cash balance for each month, October to December. (7 marks) c. Analyze the results and suggest action to be taken by the manager. Do you think that Brilliant Marketing will need an overdraft facility for the period from October to December? (2 marks)
Expert Answer:
Answer rating: 100% (QA)
a EndofOctober cash balance RM22000 EndofNovember cash balance RM11000 EndofDecember cash balance RM29000 b October Excess cash balance RM10000 November Deficit RM8000 December Excess cash balance RM9... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
sixty five percent of sales on credit On the basis of past experience 50 of the accounts receivable are collected the month after the sale and the remainder are collected two months after the sale...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
After their divorce, Brian Bermudez and Amanda Schmidt shared custody of their son. Schmidt suspected Bermudez of abusing the child, so she refused to let him visit. Bermudez filed a petition...
-
1. Search social media monitoring on a search engine to find companies specializing in monitoring social media. Many of these sites discuss examples of how businesses use their service. Discuss two...
-
According to Link Resources, 16% of the U.S. population is technology driven. However, these figures vary by region. For example, in the West the figure is 20% and in the Northeast the figure is 17%....
-
Home Value Stores operates 253 membership warehouse stores in the United States, Europe, and Asia. The company offers low prices on a limited selection of household and grocery products. In the past...
-
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2017. 1. Sales: quarter 1,...
-
On August 1, 2018, Burkina Corp. purchases a new machine. The company makes a $2,000 cash down payment, and agrees to pay four annual instalments of $3,000 each, starting August 1, 2019, signing a...
-
Ozone gas (O 3 , solute A) dissolved in high-purity water is commonly used in wet cleaning processes associated with semiconductor device fabrication. It is desired to produce a liquid water stream...
-
Hi tutor! Pl3ase answ3r the following in g00gle docs in a typ3written format and just shar3 me the link after I will rate the tutor HELPFUL (thumbs up) if answered ASAP in g00gle docs in a...
-
Yahoo Finance reports a beta of 1.2 for Fitbit. If the risk-free rate is 0.7% and the expected market risk premium is 5%, what is Fitbit's expected stock return according to the CAPM?
-
A company paid dividends to its shareholders in the amount $100,000. Briefly discuss why there might be a difference between IFRS and US GAAP in the reporting of this cash payment on the statement of...
-
Describe how the Operations Are Carried Out - Facility Selection/Design on the database company Oracle. 2. Describe How Operations Are Organized - Degree of Automation for the database company oracle
-
Explain what is meant by the purchase and expenditure cycle as a "mirror image" of the sales and revenue cycle.
-
What role does virtualization play in modern operating systems, and how do hypervisors facilitate the creation and management of virtual machines, enabling efficient resource sharing and isolation...
-
Consider the following discrete probability distribution. x 15 22 34 40 P(X = x) 0.08 0.41 0.28 0.23 a. Is this a valid probability distribution? Yes No c. What is the probability that the random...
-
If the annual fixed costs are 54,000 dinars, the occupation expense represents 20%, the contribution margin is 25%, and the unit selling price is 40 dinars. Required: Calculate the closing point of...
-
From the HeadlinesFoursquare: What ingredients would you need to conduct a traditional equity method valuation for Foursquare? If you had the necessary projections, do you think that Foursquare would...
-
Define the term EBITDA.
-
The PDC Company was described earlier in this chapter. Refer to the PDC Companys projected monthly operating schedules in Table 6.2. PDCs sales are projected to be $80,000 in September 2020. A....
-
The rules of conduct of CAs, CGAs, and CMAs require them to report a breach of the rules of conduct by a member to their profession's disciplinary body. What should they do before making such a...
-
The auditor's working papers usually can be pro vided to someone else only with the permission of the client. What is the rationale for such a rule?
-
Many people believe that a public accountant cannot be truly independent when payment of fees is dependent on the management of the client. Explain a way of reducing this appearance of lack of...
Study smarter with the SolutionInn App