I have already completed all of requirement 1. Requirements 2,3,4ab still need to be completed thank you.

EDIT*** close up of requirements and data table.

omework asps/homeworkld 444207878questionld 1aflushed fabedeld 463740back Dossignments.aspa Managerial Accounting F17 Homework: P9-62A Score: 1 61 of 4 pts & P9-62A (similar to) HYV Score: 4028%, 1 61 of 4 pts Question Hep * Tune Medical Supply has appled for a loan First National Bank has requested a budgeted balance sheet as of April 30, and a combined cash budgot for Apil As Tune Medical Supply's controller, you have avsembled the following Data Table -Requrements a. March 31 equipment balance $52,400, accumulated depreciation $41,500 b. Agril capital expenditures of $42.400 budgeted for cash purchase of equipment c. April depreciation expense $700 d, cost of goods sold 60% of sales e, other Agril operating expenses, in luding income tax, total $14200 25% of which wil be paid in cash 1. Prepare the budgeted balance sheet for Tune Medical Supply at April 30 Show separate computations for cash inventory, and owners'equity balances 2 Prepare the combined cash budget for Apl 3. Suppose Tuna Medicall Supply has become aware of more elficient (and more expensive equipment than budgeted for purchase in April what the total amount of cash avalable for equipment purchases in April, before financing, if the minimum desied ending cash balance is 19.0002 (F or this requrement, disregard the $42 400 initialy budgeted for equipment and the remainder accrued at April 30 f. March 31 owners' equity. $91800 g March 31 cash balance $40,100 h, Agri budgeted sales $87.00075% of which is for cash rhe "onaling 25%, haldbeelededin 4 Before granting a loan to Tune Medical Supply First National Bank asks for a sensiltiuity analysis assuming that April sales are only $58,000 sather than the $87 000 originally budgeted (While the cost of goods sold will change, assume that purchases, depreciation and the other operating April and hall in May i. Agrl cash collections on March sales $29 200 i April cash payments of March 31 Sabilities incurred for Manch punchases of inventory $17,700 k. March 31 inventary balance. 529 300 L. Agil purchases of inventory 510.200 for cash and 536,800 on aredi Half of the credit purchases w Prepare a revised budgeted balance sheet for Tune Medical Supply showing separate computations for cash, inventory. and owners equity balances a. b. Suppose Tune Medical Supply has a minimum desired cash balance of $19 000 Wlthe company need to bonew cash in Apln be paid in April and half in May Prit Done OP esdts