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...
-
Discuss whether the Sarbanes-Oxley act protects whistle-blowers enough (or perhaps too much). What changes would you make to improve the effectiveness of the law?
-
Bucky's Boxes makes boxes for moving. It sells its boxes to major national moving companies. Because of the simple nature of the production process, Bucky's uses standard costing. The following...
-
For testing H0 : 1 = 2 versus H1: 1 2, we observe s1 = 9.3, s2 = 2.1, n1 = 6, and n2 = 13. Test at the significance level = 0.05. a. Find the critical value. b. Do you reject H0?
-
a. Based on the data in Exercise 20-11, determine the following: 1. Cost of beginning work in process inventory completed this period. 2. Cost of units transferred to finished goods during the...
-
FORMATIVE ASSESSMENT 1 [100 Marks] BUILDING A WORLD-CLASS GLOBAL PROCUREMENT ORGANISATION The $20 billion industrial company was big and far-reachinga global market leader with a presence in more...
-
Jordan and Julianne Marra both work. Julianne is a part-time environmental lawyer whose W-2 provided the following information. Wages, tips, other compensation: $51,122.00 Social Security wages:...
-
Suppose that you are asked to convert the C standard library function strcpy into object-oriented form. Which prototype below is the nearest to that definition? a. const Cstring...
-
On January 1 , 2 0 2 0 Jewelry Center purchased 3 0 , 0 0 0 of the outstanding 1 0 0 , 0 0 0 shares of Moon Co . at a cost of 1 2 a share.For the year 2 0 2 0 Moon reported net income of $ 4 0 0 , 0...
-
During 2026, Colorado Co. stock was sold for $9,650. The fair value of the stock on December 31, 2026, was Clemson Corp. stock- $21,010; Buffaloes Co. stock-$22,380. None of the equity investments...
-
lim h0 Suppose f(x)=-3x + 4. Evaluate the following limit. f(-4+ h)-f(-4) h = Note: Input DNE, infinity, -infinity for does not exist, , and -, respectively.
-
15. Nichrome wire of cross-sectional radius 0.791 mm is to be used in winding a heating coil. If the coil must carry a current of 9.25 A when a voltage of 1.20 x 10 V is applied across its ends, find...
-
Suppose you purchased 9 5 shares of ABC, Inc for $ 4 0 . 9 9 per share. The company paid a dividend of $ 1 . 3 per share during the year, and had an ending share price of $ 7 4 . 1 2 . What is the...
-
Give a summary of the podcast or lecture you selected. You should quickly discuss who was interviewed or who spoke, the subjects they discussed, and some of the suggestions they made. Try to keep...
-
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....
-
Use Table A.2 to find the area to the right of z = 2.31. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 -0.8 -0.7 .2119 .2090 .2420 2389 -0.6 .2743 .2061 .2033 2358 .2327 .2709 .2676 .2643 .2611...
-
Use any method to find the z-score with an area of 0.09 to its right.
-
If X is a continuous random variable, then P(X = a) = ___________________ for any number a. In Exercises 914, fill in each blank with the appropriate word or phrase.
Study smarter with the SolutionInn App