sorry the pictures are in the wrong order but where is the question ^^

and this is what I have to do for the question, sorry for the bad pictures had to transfer photos from phone to computer

Schedule of expected cash disbursements - Merchandise purchases: 3. Complete the following cash budget: 4. Prepare an absorption costing income statement, similar to the one shown in Schedule 9, for the quarter ended June 30. 5. Prepare a balance sheet as of June 30 . The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: a. The gross margin is 25% of nales. b. Actual and budgeted sales data are as follows: c. Sales are 60% for eash and 40% on eredit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are the result of March credit snles. 1. Each month's ending inventory should equat s0\% of the following montb's budigeted cost of goveds noid. c. One-half of a month's inventory purchases is paid for in the month of purchase; the other one-half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. 7. Monthly expenses are as follows: commissions, 12% of sales; rent, $2.500; other expences (excluding depreciation), 6 fof of salos. Assume that these expenses are paid monthly. Depreciation is $900 per month and includes depreciation on new assets. g. Equipment will be acquired for eash: $1.500 in April. h. Management woula like to maintain a minimum cach balance of $4,000 at the end of each monih. The eompany has an agreement with a towal bank that allows the company to borrow as needed at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these louns is 18 per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: trag the preceding data, complete the following: 1. Schodule of expected cash collections: Developing your own Financial Planning Model for Sensitivity Analysis- Practicing What you Learnt! Chapter 9: Developing a Master Budget in Excel with linked formulas Textbook: Managerial Accounting by Garrison, Libby and Webb, McGrawhill 2021. 12 th Edition. For the master budget problem from your textbook (see Problem 9-24) listed below, you are required to develop a Microsoft Excel based Financial Planning model. You will be only required to do the following budget schedules with linked Excel formulas (i.e. the set of budgets I did as the in-class problem in class). My handwritten notes are on Bright Space if you missed that class. Instructions: - In the Excel spreadsheet keep the problem data (budget assumptions) separate in one section of the spreadsheet. This is to be able to link the budget formulas so that the master budgets do not have to be recreated when the data is manipulated. - Then link the data using Excel formulas to develop the following budgets and schedules for the three months (April, May, June) and in total for Quarter 2 (Q2). You may have to keep an extra column for March and July as I did in class. 1. Schedule 1: Sales budget for (April, May, June) and Total for Q2. Also show how much is cash sales and how much are credit sales 2. Schedule 2: Merchandise Purchase Budget (April, May, June) and Total for Q2 3. Schedule 3: Selling and Administration Budget (April, May, June) and Total for Q2 4. Budgeted Income Statement in total for the quarter (Total for Q2) 5. Sensitivity Analysis 5(a) Change the Gross Margin from 25\% to 30\%. Print the Budgeted Income Statement in total for the quarter (Total for Q2) 5(b) Change the gross margin from 25% to 35% and increase sales commission from 12% to 15% and other expenses from 6% to 10%. Print the Budgeted Income Statement in total for the quarter (Total for Q2) Printouts to be submitted for grading 1. For questions 1 through 4 , printout Schedule1, Schedule 2 Schedule 3 and the quarterly income statement. 2. For 5(a) Print the Budgeted Income Statement in total for the quarter (Total for Q2) 3. For 5(b) Print the Budgeted Income Statement in total for the quarter (Total for Q2)