Cash Budget The owner of a building supply company has requested a cash budget for lune. After examining the records of the company you find the following: 6. Cash balance on June 1 is $736. 6. Actual sales for April and May are as follows: April May Cash cales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40in the month of sale, 30% in the second month, ang 20% in the third month. The sales collected in the third month are subject to a 29 me fee, which is paid by the customers addition to what they owe. The remaining sales are uncollectible, 4. Inventory purchase average of a month's totalles. Of those purchases, 20% are phed for in the month of purchase. The remaining 80% are paid for in the following me o salaries and was tot 511,750 per month, secluding a $4,500 calory paid to the ownet Rent is $4,100 per month 9. Taxes to be paid in June are 56,780 The owner also tells you that he expects cash sales of $18,600 and credit sales of $54,000 for June. No minimum cash balance is required. The owner of the company doesn't have core to short-term loans 1. Prepare a cash budget for Jupe Indude supporting schedules for a colections and cash payments, Round calculations and final serta theatest dolar Be sure to enter Mess whicle burber Cashludget For 736 7 Besh balance Collection C 18,600 Create Current month $4,000 10 21,600 My cat 35,000 10 10,500 Aprantit este 5,096 Totalcach 57, undesbursement April credit sales 5,896 Total cash available 57,332 Less disbursements: Inventory purchases: Current month 52,272 X X 20 % 10,454 X Prior month 38,160 X X 80 % 30,528 x 11,750 Salaries and wages Rent 5,100 x Taxes 6,780 Total cash needs 64,612 X Excess of cash available over needs -4,165 X Feedback Check My Work Partially correct