Month Cash disbursement Cash receipts January 100,000 100,000 February 110,000 90,000 March 110,000 80,000 April 150,000...

Month	Cash disbursement	Cash receipts
January	100,000	100,000
February	110,000	90,000
March	110,000	80,000
April	150,000	100,000
May	180,000	120,000
June	180,000	160,000
July	180,000	200,000
August	180,00	250,000
September	150,000	250,000
October	110,000	200,000
November	100,000	140,000
December	100,000	100,000

Below table shows the monthly estimates of cash disbursement and receipts from January to December 2019 for preparing the cash budgets for Bintang Sdn Bhd. Bintang Sdn Bhd has beginning cash on hand of RM10,000 and the company wishes to maintain this minimum cash level for 2019

Requirements: please step by step clear word typingg

(i) Calculate whether Bintang Sdn Bhd will face a cash need for 2019.

(ii) In which month Bintang Sdn Bhd will face a cash need? In which month the cash need is the maximum?

(iii) Determine whether the cash need (if any) can be repaid within the next year.

Expert Solution

ekkarill92 answered 2 years ago

Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...

Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000 $ 112,000 $ 132,000 Cash payments For inventory purchases 93,000 75,000 88,000 For S&A expenses 34,000 35,000 30,000 Newman Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent...

Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000...

Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000 $ 122,000 $ 142,000 Cash payments For inventory purchases 98,000 80,000 93,000 For S&A expenses 39,000 40,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 101,000...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 101,000 $ 107,000 $ 127,000 Cash payments For inventory purchases 90,500 72,500 85,500 For S&A expenses 31,500 32,500 27,500 Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...

Month: Radiology Tests: Total Costs: January 2,800 $133,500 February 2,600 $135,060 March 3,100 $175,000 April...

Month: Radiology Tests: Total Costs: January 2,800 $133,500 February 2,600 $135,060 March 3,100 $175,000 April 3,500 $170,600 May 3,400 $176,900 June 3,700 $186,600 July 3,840 $174,450 August 4,100 $195,510 September 3,450 $15,300 1. Compute the cost formula for radiology services using the method of least square 2. Using the formula computed in requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar) 3. What does the coefficient...

1- Suppose receipts of $20,000 are moved from March to April. (March receipts are now planned...

1- Suppose receipts of $20,000 are moved from March to April. (March receipts are now planned at $94,999 while April receipts are planned at $110,210.) - What change would this have on the total season’s receipt plan? - What change would this have on the total season’s average stock and turnover?

Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...

Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14 10 -Compute the RSFE, MAD and tracking signals for months January to April?

MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000...

MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000 $400,000 May 14,000 $434,000 June 9,000 $360,000 July 20,000 $550,000 August 21,000 $525,000 September 24,000 $605,000 October 23,000 $589,000 November 28,000 $702,000 December 18,000 $496,000 1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS) Fixed Costs = Variable Cost per Unit = 2) If I manufacture 35,000 units this month, what...

Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July...

Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July 543 August 550 September 546 October 540 November 535 December 529 Predict naïve forecast of patient days for February and June. Predict the patient days for January, using a four-period moving average. Predict the patient days for January, using the six-period moving average. Plot the actual data and the results of the four period and the six-period moving averages. Which is a better predictor?

Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...

Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...

Question