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 and the remainder in the following month. Wages are expected to be 25% of the month’s sales, plus commissions to sales associates estimated to be 10% of collectable sales. A major capital expenditure of $22,000 is expected in April and a quarterly dividend of $10,000 will be paid to shareholders in March and June. Monthly rent is $2,500 and other maintenance expenses are estimated at 15% of sales. The firm has an ending cash balance of $20,000 for December 2018.

Required:

prepare a cash budget based on the information above.

Expert Solution

ekkarill92 answered 2 years ago

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?

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...

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...

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?

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, 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 Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...

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, Chris Coffee, 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 Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...

Need answers 1-4! Projected unit sales: June sales 120,000, July sales 130,000, August 140,000, September 150,000...

Need answers 1-4! Projected unit sales: June sales 120,000, July sales 130,000, August 140,000, September 150,000 and October sales 170,000. Sales price per unit, $15.00 Units in ending inventory each month should equal 10% of next month sales. Raw material required per unit is 2 pounds; cost is $3.00 per lb. Ending inventory required at the end of each month is 5% of next month needs. Direct labor required to produce one units is .25 direct labor hour. The hourly...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May 24 June 23 a. Using a weighted moving average with weights of 0.40 (June), 0.40 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast c. Using single exponential smoothing with ? = 0.30 and a June...

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May...

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May 17 June 16 a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with ? = 0.30 and a June forecast = 11, find...

Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000;...

Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000; respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75%of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78%in the following month. What are the cash collections...

Question