P4-13 Cash budget: Scenario analysis Markham Enterprises needs to plan its cash require- ments and short-term investment opportunities for the months of June, July, and August. The following data are available. The beginning balance is -$28,000 for June and the minimum required cash balance is $30,000. All amounts are shown in thousands of dollars. June July August Pessi- Most Opti- Pessi- Most Opti- Pessi- Most Opti- mistic likely mistic mistic likely mistic mistic likely mistic Total cash receipts $250 5370 $430 $245 $305 $395 $265 $335 $412 Total cash disbursements 260 310 405 255 285 375 280 300 396 a. Prepare a scenario analysis of Markham Enterprises. b. Identify the finance need/surplus for each month under the different scenarios. If needed, where could the funds be obtained? What should be done with a surplus of cash