Question

In: Finance

Cash disbursements schedule   Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April,...

Cash disbursements schedule   Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here

and the following information in its preparation.

​Sales:

February $505,000​;

March $518,000​;

April $572,000​;

May $617,000​;

June $670,000​;

July $665,000

​Purchases: Purchases are calculated as

55%

of the next​ month's sales,

9%

of purchases are made in​ cash, 52% of purchases are paid for 1 month after​ purchase, and the remaining 39% of purchases are paid for 2 months after purchase.

​Rent: The firm pays rent of $8,030 per month.

Wages and​ salaries: Base wage and salary costs are fixed at

$6,200 per month plus a variable cost of

6.9%of the current​ month's sales.

​Taxes: A tax payment of $54,300 is due in June.

Fixed asset​ outlays: New equipment costing $74,800 will be bought and paid for in April.

Interest​ payments: An interest payment of $30,100is due in June.

Cash​ dividends: Dividends of $12,000 will be paid in April.

Principal repayments and​ retirements: No principal repayments or retirements are due during these months.

Feb    Mar Apr May Jun Jul

Sales Disbursements

Purchases

Cash

1 month delay

2 month delay

Rent

Wages and salary

Fixed

Variable

Taxes

Fixed assets

Interest

Cash dividends

Total
Disbursements

( Please explain how you got the answer )

Solutions

Expert Solution


Related Solutions

 Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June....
 Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here and the following information in its preparation.​ Sales: February $514,000​; March $489,000​; April $550,000​; May $586,000​; June $663,000​; July $668,000​Purchases: Purchases are calculated as 57% of the next​ month's sales, 11% of purchases are made in​ cash, 46% of purchases are paid for 1 month after​ purchase, and the remaining 43% of purchases are paid for 2 months after...
Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June....
Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here LOADING... and the following information in its preparation. ​Sales: February $ 514 comma 000 $514,000​; March $ 514 comma 000 $514,000​; April $ 555 comma 000 $555,000​; May $ 595 comma 000 $595,000​; June $ 648 comma 000 $648,000​; July $ 655 comma 000 $655,000 ​Purchases: Purchases are calculated as 57 % 57% of the next​ month's sales, 9...
Cash disbursements scheduleMaris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May,...
Cash disbursements scheduleMaris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June and the following information in its preparation.​Sales:February March $481,000​; April $535,000​; May $588,000​; June $656,000​; July $625,000​ Purchases are calculated as 57% of the next​ month's sales,12% of purchases are made in​ cash, 48% of purchases are paid for 1 month after​ purchase, and the remaining 40% of purchases are paid for 2 months after purchase.​Rent: The firm pays rent of $7,970...
P4-9 (similar to) Cash disbursements schedule   Maris​ Brothers, Inc., needs a cash disbursement schedule for the...
P4-9 (similar to) Cash disbursements schedule   Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here LOADING... and the following information in its preparation.​Sales: February $ 520 comma 000 ​; March $ 508 comma 000 ​; April $ 555 comma 000 ​; May $ 586 comma 000 ​; June $ 651 comma 000 ​; July $ 648 comma 000​Purchases: Purchases are calculated as 61 % of the next​ month's...
XYZ Enterprises needs to schedule operations for the next six months. Create a Master Schedule including...
XYZ Enterprises needs to schedule operations for the next six months. Create a Master Schedule including calculating Available-to-Promise (ATP) Inventory for each time period in the scheduling horizon using the following information: Beginning Inventory of 60 units; Forecasted Demand of 40 units per period; Standard Production Quantity of 50 units, and confirmed Customer Orders of 42 units for Month 1, 35 units for Month 2, 10 units for Month 3, and 5 units for Month 4.
1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which...
1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which of the following items should be included? I.Borrowing funds from a bank on a note payable taken out in August Year 4 and agreeing co pay the principal and interest in July Year 5 II.Dividends declared in October Year 4 co be paid in January Year 5 co shareholders of record as of December Year 4 (A)I only, (B)II only ,(C)Both I and II,...
The financial analyst for Sportif, Inc. has compiled sales and disbursement estimates for the coming months...
The financial analyst for Sportif, Inc. has compiled sales and disbursement estimates for the coming months of January through May. Historically, 75 percent of sales are for cash with the remaining 25 percent collected in the following month. The ending cash balance in January is $3,000. Month Sportif, Inc., Sales Disbursements January $5,000 $6,000 February 6,000 7,000 March 10,000 4,000 April 10,000 5,000 May 10,000 5,000 The total cash receipts for April are ________. The net cash flow for February...
text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...
text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $290,000 $310,000 $280,000 Cash disbursements 270,000 350,000 290,000 The expected cash balance at January 1, 2016, is $72,000. Brewster wants to maintain a cash balance at the end of each month of at least $70,000. Short-term borrowings at...
Part #1: K Company is planning its cash disbursements for the upcoming months. In June, it...
Part #1: K Company is planning its cash disbursements for the upcoming months. In June, it anticipates $72,000 in Purchases, $130,000 in Payroll, and $40,000 in Loan Payments. In July, it anticipates $77,000 in Purchases, $140,000 in Payroll, and $35,000 in Loan Payments. In August, it anticipates $84,000 in Purchases, $150,000 in Payroll, and $30,000 in Loan Payments. Purchases are usually paid half in the current month and half in the following month. Payroll is paid 70 percent in the...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT