May Nov. Jan. 960 June July Aug Sept. Oct Dec. Part 1 1 Anticipated sales $13,000 $17,000 $28,000 $53,000 $35,000 $17,000 $8,000 2 Cash sales 5,200 6,800 11.200 21,200 14,000 6,800 3,200 3 Accounts collected (one-month lag) 6,240 8,160 13,440 25,440 16,800 8,160 3,840 4 Accounts collected (two-month lag) 1,560 2,040 3,360 6,360 4,200 2,040 5. Other cash receipts 11,000 6 Total cash receipts 5,200 24,040 20,920 36,680 42,800 29,960 15,560 Part 2 7 Variable cash disbursements 2.000 21.000 37,000 26,000 6.000 6,000 2,000 8 Fixed cash disbursements 4.000 4,000 4,000 4,000 4,000 4,000 4,000 9 Other cash disbursements 1,000 2,000 10 Total cash disbursements 6,000 25,000 41,000 31,000 12,000 10,000 6,000 Part 3 11 Cash gain (or loss) during the month (800) (960) (20,080) 5,600 30,300 19,960 9,560 (line 6 minus line 10) 12 Cash position at beginning of month 14,000 13,200 12,240 (7.840) (2.160) 28,640 48,600 13 Cash position at end of month 13.200 12,240 (7,840) (2.160) 20,640 43,600 58,160 (line 12 plus line 11) 14 Less desired level of cash (9,000) (9.000) (9,000) (9,000) (9.000) (9.000) (9.000) 15 Cumulative excess (or shortage) 4,200 3,240 (16,840) (11,160) 19,640 39,600 49,160 of cash (line 13 plus line 14) 4PE (10 pts-5 prob-3 tries) $ 5 5 3 3 5 $ 5 a. Assume that the desired minimum level of cash is $4,000 instead of $9,000. What is the change in the firm's need for hunds? Round your answers to the nearest dollar. Enter the disbursements values in Part 2 as positive values. Use a minus sign to enter cash outflows, subtraction of the desired level of cash, shortage of cash values, negative Beginning and ending cash positions in Part 3. If any. Do not leave any cells blank. If the answer is zero, entero Part 1 May June July August September October Anticipated sales November $ $ Cash sales $ 5 5 5 5 5 1 Accounts collected (one-month lag) s 5 5 $ Accounts collected (two-month lag) 5 $ $ $ $ Other cash receipts $ Total cash receipts $ $ $ 5 5 Part 2 Variable cash disbursements $ $ 5 3 Fixed cash disbursements $ 5 Other cash disbursements $ $ 5 Total cash disbursements $ 5 5 $ Part Cash gain (or loss during the $ 3 month Cath position at beginning of months 5 3 $ $ Cash position at end of month 5 5 $ Less desired level of cash $ $ 5 Cumulative excess for shortage of 5 5 cash b. Assume that 50 percent of sales are for cash instead of 40 percent and the pattern of collections remainstream (80 percent after one month and 20 percent after the months) What is the change in the firm's need for funds Round your answers to the nearest do Enter the disbursements values in Part 2 a positive valut. Use assign to enter cash outflows, subtraction of the desired level of cash, shortage of cash values negative beginning and ending cash positions in Part 3, any. Do not leave any culls blank. If the answer is pero, entero 5 $ 5 5 3 $ 1 S 5 S cash b. Assume that 50 percent of sales are for cash instead of 40 percent and the pattern of collections remains the same (0 percent after one month and 20 percent after two months) What is the change in the firm's need for funds? Round your answers to the nearest doar Enter the disbursements values in Part 2 as positive values. Use a minus sign to enter cash outflows, subtraction of the desired level of cash, shortage of cash vetve beginning and ending cash positions in Part 3, tany. Do not leave any cells blank. If the answer zero, entero Part 1 May June Joly August September October November Anticipated sales 1 $ Cash sales 5 $ Accounts collected one months 1 $ 1 $ Accounts collected (two-month lag) 5 5 Other cash receipts Total cash receipts $ Part 2 Variable cash disbursements Fixed cash disbursements 5 5 Other cash disbursements 5 Total cash disbursements Part 3 Cash gain (or loss during the S month Cash position at beginning of months Cash position at end of month Lets desired level of cash 5 $ $ 5 Cumulative excess (or shortage of 5 + 1 cash Assume that both the desired minimum level of cash and is changes in parts and what is the revised cash budget's bottomina Round your answers to the nato Uminus sign to enter shortage values. If any 5 5 5 $ Cash sales 5 $ Accounts collected (one-month lag) $ $ $ Accounts collected (two-month lag) 5 S $ Other cash receipts 5 $ $ 5 5 Total cash receipts 5 $ $ $ Part 2 Variable cash disbursements $ 5 $ 5 Fived cash disbursements $ $ $ $ $ Other cash disbursements $ 5 5 5 5 $ $ Total cash disbursements $ 5 Part 3 Cash gain for loss) during the $ $ 5 $ month Cash position at beginning of months S 5 Cash position at end of month $ 5 $ s Less desired level of cash $ 5 5 $ $ $ Cumulative excess (or shortage of 3 1 $ 3 $ 5 cash c. Assume that both the desired minimum level of cash and sales change as in parts and D. What is the red cash budgets "bottom line Round your answers to the nearest dollar Use a minus sign to enter shortage values of any May June July August September October November Cumulative eco (or shortage of 5 $ 5 cash