Deacon Company is a merchandising omony that is preparing a budget for the second quarter of the Calendar year. The folowing Woman is available DEC Balans that March 15, ch Acos recebe net af deti 52. 10. T. Latin Shresulty table shares Bahan Totalt and share wity 303, sure S. 1. 10, C . 20.00 6. 1. 35.00 . $ 3.00 Dung Assumption Sexty percent of are cases and 40 percent of sales are crede sales Twenty percent of all credit sales are collected in the months and the remaining 80 percent we callected in the month subsequent to the budgeted sales for July are 5147000 orchery purchases are paid in cash at the time of the purchase. The reng go's of purchases are credit pache All purchases on creditare pad in the month subsequent to the purchase Each mom's ning mechandise vertory should equal to pluss of the next month's cost of goods sold Depren pens $1500 per month Anting and administrative expenses are paid in the month the expenses curred Required: 1. Calculate the expected cash collections for April, May, and June 2. Calculate the budgeted merchandise purchases for Apr May and June 3. Calculate the expected cash disbursements for merchandise purchases for April May, and June 4. Prepare a budgeted balance sheet at June 30. (Hint You need to calculate the cash paid for selling and administrative expenses during April May, and June to determine the cash balance in your June 30 balance sheet) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate the expected cash collections for April, May, and June April May June Quarter Total cash collection Rent Required 2 > Required 1. Calculate the expected cash collection for April May, and June 2. Calculate the budgeted merchandise purchases for April May and June 3. Calculate the expected cash disbursements for merchandise purches for April May, and one 4. Prepare a budgeted balance sheet tune in You need to calculate the cathed for ving and traves during Roel Mwand un to determine the cash balance in your June 30 balance sheet) Complete thesion by entering your answers in the tabs below | | Calculate the time has for April May and luna Apr My Q May, and une 3. Calculate the expected cash disbursements for merchandise purchases for April May, and une 4. Prepare a budgeted balance sheet at June 30 Hint You need to calculate the cash paid for sing and administrative expenses during April May, and June to determine the cash balance in your lune 30 balance sheet) Complete this question by entering your answers in the tabs below. Word Required Required Calitate the expected cash disbursements for merchandise purchases for April, Hay, and Jone April May June Budget cash den for merchande portes Complete this question by entering your answers in the tabs below. Hequired Required Required Required Prepare a budgeted balance sheet at June 30. Cont: You need to calculate the hold for wing and strative penses during April May, and on to determine the cash balance in your une balance shot) Decon Company June Ass Liabilities and Sharwhale Tuwid holders.com Required 1. Calculate the expected cash collection for April May, and June 2. Calculate the budgeted merchandise purchases for April May and June 3. Calculate the expected cash disbursements for merchandise purches for April May, and one 4. Prepare a budgeted balance sheet tune in You need to calculate the cathed for ving and traves during Roel Mwand un to determine the cash balance in your June 30 balance sheet) Complete thesion by entering your answers in the tabs below | | Calculate the time has for April May and luna Apr My Q May, and une 3. Calculate the expected cash disbursements for merchandise purchases for April May, and une 4. Prepare a budgeted balance sheet at June 30 Hint You need to calculate the cash paid for sing and administrative expenses during April May, and June to determine the cash balance in your lune 30 balance sheet) Complete this question by entering your answers in the tabs below. Word Required Required Calitate the expected cash disbursements for merchandise purchases for April, Hay, and Jone April May June Budget cash den for merchande portes Complete this question by entering your answers in the tabs below. Hequired Required Required Required Prepare a budgeted balance sheet at June 30. Cont: You need to calculate the hold for wing and strative penses during April May, and on to determine the cash balance in your une balance shot) Decon Company June Ass Liabilities and Sharwhale Tuwid holders.com