EARRINGS UNLIMITEDMinimum ending cash balance $50000Selling price $10Recent and

EARRINGS UNLIMITEDMinimum ending cash balance $50000Selling price $10Recent
and forecast sales: January (actual) 20000 February
(actual) 26000 March (actual) 40000 April 65000 May
100000 June 50000 July 30000 August 28000
September 25000AND SO ONRequired:Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:1. a. A sales budget by month and in total.b. A schedule of expected cash collections from sales by month and in total.c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.d. A schedule of expected cash disbursements for merchandise purchase by month and in total.2.
A cash budget. Show the budget by month and in total. Determine
any borrowing that would be needed to maintain the minimum cash
balance of $50000.3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.4. A budgeted balance sheet as of June 30.XX