plz he7p- one problem with 4 requirements.

Garden Sales, incorporated, sels garden supplies. Management is planning its cash needs for the second quarter. The company. usually has to borrow money during this quarter to support peak sales of lawin care equipment, which occur duming May. The following information has been assembled to ascist in prepaning a cash budget for the quarter a. Budgeted monthly absorpton costing income statements for April-July are b. Sales are 20% for cash and 80% on account c. Sales on account are coliected over a three month penod with sox collected in the month of sale, 80 s cobected in the first month following the month of sale; and the remaining 10Fs collected in the second month following the month of sale. February's sales: totoled \$185,000, and March's saies totaled \$2.25,000 a inventory puichases are pald for within 15 days. Therefore, 50 s of a month's inventory purchases are paid for in the month of purchase The remaining 50 sis paid in the following month. Accounts payable at March 3 for inventory purchases during Morch total 5105.700 e. Each month's ending imventory must equal 20 s, of the cost of the metchandise to be sold in the following month. The merchandise inventory ot March 3 is $79,800 f. Omdenas of $27000 win be declared and poid in Apnt 9. Land cosing $35,000 wili be purchated for coth in Moy A. The cash balance at March 31 is 549,000 , the compony must maintain a cash balance of at least $40,000 at the end of each month. the compory has on agreement with a local bonk thot allows the company to borrow in increments of 51,000 at the beginning of esch monh, up to a total ioan bolance of $200,000. The interest rate on these losns is thy per month and for simpliciy we wiil astume that interest is not cempounded The company would, as far as it is able, repay the ioan plus accumulated interest at the end of the cuarter Required: 1. Prepate a scheouie of expected cash colvections for Aprit, May, and June, and for the quarter in total 2. Prepare the folloming for me chandise inventoor a. A merchonaise purchases budget for Apri, Moy, and June 0. A senedule of expected cash olsburtements for merchandise purchases for Aprit, May, and June, and for the quarter in total. 3. Prepare in cash bivaget for Apnt May and June mw wea as in total for the quartec Required: 1. Prepare a schedule of expected cash collections for April. May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for Apn, May, and June as well as in totai for the quartet Complete this question by entering your answers in the tabs below. Prepare a schedule of expected cash callectors for April, May, and June, and for the quarter in total. 1. Prepare o schedule of expected cash collections for Apri, May, and June, and for the quarter in total. Requlred: 2. Prepare the following for merchandise inventory: b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. a. A merchandise purchases budget for Aprit, May, and June. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter. Complete this question by entering your answers in the tabs below. Prepare the following for merchandise inventory, a merchandise purchases budget for April, May, and June. 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. Required: 2 Prepare the following for merchandise inventory b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in tota a. A merchandise purchases budget for April, May, and june. 3. Prepare a cash budget for Aprit. May, and June as well as in total for the quarter. Complete this question by entering your answers in the tabs below. Prepare the following for merchandise inventory, a schedule of expected cash disbursements for merchandise purchases for Apnl, May, and June, and for the quarter in total. A metchandise purchases budget for Apri, May, and June. A schedule of expected cash disbursements for merchandise purchases for April, May, and June; and for the quarter in total. Prepare a cosh budget for April, May, and June as well as in total for the quarter. Complete this question by entering your answers in the tabs below. Frepare a cash budget for Apri, May, and June as well as in total for the quarter. (Cash defioency, repayments and interest should he inticated by a ininus sign.)