Provide an analysis of the results from the original cash budget created during step 1. The analysis will include a discussion of the anticipated sales in relation to the estimated labor and materials, as well as the overall month to month surplus cash or loan needed and what appears to be attributing to the surplus or need. The analysis should also include a discussion of the implications for the business as presented in the results. ?You need to answer with the data in the table.?

Monthly Cash Budget Example Input Data 16 - May 16 - Jun 16 - Jul 16 - Aug 16 - SER 16 - Oct 16 - NOV 16 - Dec 17 - Jan 17 - Feb 17 - Mar 17 - Apr 17 - May 17 - Jun 17 - Jul Anticipated level of sales $15 , 000 . 00 $ 20, 000. 00 $30, 000. 00 $50, 000. 00 $40 , 000. 00 $20, 000. 00 $10 , 000 .00 $5, 000. 00 $15, 000. 00 $25, 000. 00 $40, 000. 00 $35, 000. 00 $15, 000. 09 Estimated labor and raw materials $3 , 000 . 00 $ 25, 000. 00 $38 , 000. 00 $30 , 000 . 00 $10 , 000 . 00 $5 , 000. 00 $3 , 000. 00 $12, 000 . 00 $14 , 000 . 00 $31 , 000 . 00 $ 29 , 000 . 00 $14, 000 . 00 $7 , 000 . 00 Cash sales 30 % Collections during month after sale 90 % Collections during second month after sale* 10% Other cash receipt - Treasuries ( Jun - 16 ) $10 , 000 Other cash receipt - Tax refund ( Dec - 16 ) $1 , 000 Target cash balance ( May thru Jan ) $10 , 000 Target cash balance ( Feb thru April ) $6, 000 Interest , rent and administrative expenses $3, 000 Other cash disbursement - income tax payments ( Sep - 16 ) $2 , 500 Other cash disbursement - retire debt issue ( Aug - 16 ) $1, 000 Other cash disbursement - retire loan ( Jan - 17 ) $25, 00 Cash on hand ( May 1 , 2016 ) $12 , 000 Prepare a monthly cash budget for the next thirteen months Anticipated Sales 16 - May 16 - Jun 16 - Jul 16 - Aug 16 - SER 16 - Oct 16 - NOV 16 - Dec 17 - Jan 17 - Feb $20 , 01 17 - Mar 17 - Apr 17 - May 17 - Jun 17 - Jul Sales ( gross )\\ $15, 000 $20, 000 $30, 000 $50 , 000 $40, 000 $10 . 000 $5, 000 $75 , 000 $ 25, 000 $40, 000 $35, 000 $75, 000 Cash sales $4, 500. 00 $6, 000 . 00 $9, 000. 00 $15, 000. 00 $12, 000. 00 $6, 000. 00 $3, 000. 00 $1, 500. 00 $4, 500. 00 $7, 500. 00 $12, 000. 00 $10, 500. 00 $4, 500. 00 Collections During 1 st month after sale $9 , 450. 00 $12, 600. 00 $18 , 900. 00 $31, 500. 00 $25, 200. 00 $12, 600. 00 $6 , 300. 00 $3 , 150. 00 $9, 450. 00 $15, 750. 00 $25, 200. 00 $22, 050. 00 $9 , 450. 00 $0. 00 During 2 nd month after sale* $1, 050. 00 $1 , 400 . 00 $2 , 100. 00 $3, 500. 00 $2, 800. 00 $1 , 400. 00 $700. 00 $350. 00 $1 , 050. 00 $1 , 750. 00 $2 , 800. 00| $2 , 450. 00 $1 , 050 . 00 Other cash receipts $10, 000 $1 , 000 Total Cash Receipts $4 , 500. 00 $25 , 450. 00 $22 , 650. 00 $35, 300. 00 $45 , 600. 00 $34 , 700. 00 $18 , 400. 00 $10 , 200. 00 $8 , 350. 00 $17 , 300. 00 $28, 800. 00 $37 , 450. 00 $29 , 350. 00 Disbursements Variable : Labor and raw materials $3, 000 . 00 $ 25, 000 . 00 $38 , 000. 00 $30, 000 . 00 $10 , 000 . 00 $5 , 000 . 00 $3, 000 . 00 $12 , 000 . 00 $14 , 000 . 00 $31 , 000 . 00 $29, 000. 00 $14 , 000 . 00 $7 , 000 . 00 Fixed : inteerst , rent , and admin expenses $3, 000 $3, 000 $3, 000 $3, 000 $3 , 000 $3, 000 $3, 000 $3 , 000 $3, 000 $3, 000 $3, 000 $3, 000 $3, 000 Other cash disbursements $ 1 , 000 $2. 500 $25, 000 Total cash disbursements $6, 000. 00\\ $28, 000. 00 $41, 000. 00 $34, 000. 00 $15 , 500.00 $8 , 000. 00 $6, 000. 00 $15 , 000. 00 $ 42 , 000 . 00 $34 , 000. 00 $32, 000. 00 $17 , 000 . 00 $10, 000.00 Cash Surplus ( or Loan Requirement ) Cash gain ( or loss ) during the month ( $1 , 500.00 ) ( $2 , 550. 00 ) ( $18 , 350. 00 ) $1 , 300 . 00 $30, 100. 00 $26 , 700 . 00 $12, 400. 00 ( $4 , 800. 00 ) $33, 650.00 ) ($76 , 700. 00 ) $3, 200.00 ) $20 , 450. 00 $19, 350. 00 Cash position at beginning of month $12 , 000 $10 , 500 . 00 $7 , 950. 00 ( $10 , 400 .00 ) (59, 100.00) $21, 000. 00 $47 , 700 . 00 $60 , 100. 00 $55 , 300. 00 $21 , 650. 00 $4, 950. 00 $1 , 750. 00 $22 , 200. 00 Cash position at end of month $10 , 500. 00 $7, 950. 00 ( $10, 400.00 ) ($9 , 100.00 ) $ 21 , 000. 00 $47 , 700 . 00 $60 , 100. 00 $55, 300. 00 $ 2 1 , 650. 00 $4 , 950. 00 $1 , 750.00 $22 , 200. 00 $41 , 550. 00 J arget cash balance $10 , 000 $10 , 000 $10, 000 $10 , 000 $10 , 000 $70, 000 $70 , 000 $10, 000 $10 , 000 $6 , 000 $6 , 000 $6, 000 $10 , 000 Surplus cash or loan needed $500 . 00 ( $2 , 050.00 ) ( $20, 400.00 )| ( $79 , 100.00 ) $71 , 000.00 $37 , 700.00 $50 , 100 . 00 $45 , 300 . 00 $71 , 650. 00 ( $1, 050.00 ) ( $4 , 250.00 )| $16 , 200.00 $31 , 550.00Monthly Cash Budget Example Input Data 16-May 16-Jun 16-Jul 16-Aug 16-Sep 16-Oct 16-Nov 16-Dec 17-Jan 17-Feb 17-Mar 17-Apr 17-May 17-Jun 17-Jul Anticipated level of sales $15,000.00 $20,000.00 $30,000.00 $50,000.00 $40,000.00 $20,000.00 $10,000.00 $5,000.00 $15,000.00 $25,000.00 $40,000.00 $35,000.00 $15,000.00 Estimated labor and raw materials $3,000.00 $25,000.00 $38,000.00 $30,000.00 $10,000.00 $5,000.00 $3,000.00 $12,000.00 $14,000.00 $31,000.00 $29,000.00 $14,000.00 $7,000.00 Cash sales 60% Collections during month after sale 90% Collections during second month after sale 10% Other cash receipt - Treasuries (Jun-16) $10,000 Other cash receipt - Tax refund (Dec-16) $1,000 Target cash balance (May thru Jan) $4,000 Target cash balance (Feb thru April) $4,000 Interest, rent and administrative expenses $3,000 Other cash disbursement - income tax payments (Sep-16) $2,500 Other cash disbursement - nt - retire debt issue (Aug-16) $1,000 Other cash disbursement - retire loan (Jan-17) $25,000 Cash on hand (May 1, 2016) $12,000 Prepare a monthly cash budget for the next thirteen months. Anticipated Sales 16-May 16-Jun 16-Jul 16-Aug 16-Sep 16-Oct 16-Nov 16-Dec 17-Jan 17-Feb 17-Mar 17-Apr 17-May 17-Jun 17-Jul Sales (gross) $15,000 $20,000 $30,000 $50,000 $40,000 $20,000 $10,000 $5,000 $15,000 $25,000 $40,000 $35,000 $15,000 Cash sales $9,000.00 $12,000.00 $18,000.00 $30,000.00 $24,000.00 $12,000.00 $6,000.00 $3,000.00 $9,000.00 $15,000.00 $24,000.00 $21,000.00 $9,000.00 Collections During 1st month after sale $5,400.00 $7,200.00 $10,800.00 $18,000.00 $14,400.00 $7,200.00 $3,600.00 $1,800.00 $5,400.00 $9,000.00 $14,400.00 $12,600.00 $5,400.00 $0.00 During 2nd month after sale $600.00 $800.00 $1,200.00 $2,000.00 $1,600.00 $800.00 $400. $200.00 $600.00 $1,000.00 $1,600.00 $1,400.00 $600.00 Other cash receipts $10,000 $1,000 Total Cash Receipts $9,000.00 $27,400.00 $25,800.00 $41,600.00 $43,200.00 $28,400.00 $14,800.00 $8,400.00 $11,200.00 $20,600.00 $33,600.00 $36,400.00 $23,200.00 Disbursements Variable: Labor and raw materials $3,000.00 $25,000.00 $38,000.00 $30,000.00 $10,000.00 $5,000.00 $3,000.00 $12,000.00 $14,000.00 $31,000.00 $29,000.00 $14,000.00 $7,000.00 Fixed: inteerst, rent, and admin expenses $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 Other cash disbursements $1,000 $2,500 $25,000 Total cash disbursements $6,000.00 $28,000.00 $41,000.00 $34,000.0 $15,500.00 $8,000.00 $6,000.00 $15,000.00 $42,000.00 $34,000.00 $32,000.00 $17,000.00 $10,000.00 Cash Surplus (or Loan Requirement) Cash gain (or loss) during the month $3,000.00 ($600.00) ($15,200.00) 7,600.00 $27,700.00 $20,400.00 $8,800.00 ($6,600.00) ($30,800.00) ($13,400.00) $1,600.00 $19,400.00 $13,200.00 Cash position at beginning of month $12,000 $15,000.00 $14,400.00 ($800.00) $6,800.00 $34,500.00 $54,900.00 $63,700.00 $57, 100.00 $26,300.00 $12,900.00 $14,500.00 $33,900.00 Cash position at end of month $15,000.00 $14,400.00 $800.00) $6,800.00 $34,500.00 $54,900.00 $63,700.00 $57,100.00 $26,300.00 $12,900.00 $14,500.00 $33,900.00 $47, 100.00 Target cash balance $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 Surplus cash or loan needed $11,000.00 $10,400.00 ($4,800.00) $2,800.00 $30,500.00 $50,900.00 $59,700.00 $53,100.00 $22,300.00 $8,900.00 $10,500.00 $29,900.00 $43, 100.00