Question
a) Provide an analysis of the results from the original cash budget. The analysis will include a discussion of the anticipated sales in relation to
a) Provide an analysis of the results from the original cash budget. 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.(6 pts)
b) If management increases cash sales from 30% to 60%, what type of investment policy does this action typically reflect? What reasons would management have for increasing the anticipated cash sales? Explain and support your response to each question. (4 pts)
c) Using the data, explain how the changes to cash sales and target cash balance would impact the need for external funds each month. What are the potential advantages and disadvantages of implementing the actions without adjusting overall sales? Your response should include a discussion of the goals of cash management, the goal of each action individually, as well as the combined effect on the external funds needed. (4 pts)
Ma Nov 20,000 30,0050,0 $40,000 $ May $15,000 20,000 $10,000 $35,000 3,000 $12,000$14,000$31,000$29,000 $14,000 15,000 $25,0 0,000 Estimated labor and raw materials 3,000$25,000$38,000$30,000$10,000 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,000 Cash on hand (May 1, 2016) $12,000 Prepare a monthly cash budget for the next thirteen months 15,00 $20,000 $30,000 $ $50,000 40,000 $20,0 $20,000 $10,0 5,000$ 15,000 25,00040,000 $35,0 0$15 ,000 $15,000$12,000 7,500$12,000$10,500 During 1st month after sale During 2nd month after sale 9450 $12,600 $18,900 $31,500 $25,200 $12,600 9,450 $15,750 $25,200 $22,050 4,500 $25,450 $22,650 $35,300 $45,600$34,700 $18,400 $10,200 8,350 $17,300 $28,800 $37,450$29,350 Variable: Labor and raw materials Fixed: inteerst, rent, and admin expenses 3,000$25,000$38,000 $30,000$10,000 3,000 $12,000$14,000 $31,000 $29,000 $14,000 6,000 $28,000 $41,000$34,000 $15,500 6,000 $15,000 $42,000$34,000 $32,000$17,000 $10,000 Cash Surplus (or Loan Requirement Cash gain (or loss) during the month Cash position at beginning of month ($1,500) ($2,550) 18,350) $1,300 $30,100 $26,700 12.400 ($4,800) ($33,650) ($16,700) ($3,200) $20,450 $19,350 $12,000 $10,500 $7,950 ($10,400)(9,100) $21,000 47,700 60,100$55,300 $21,60 $4,950$1,750 $22,200 22,200 $41,550 10.000($10,000) ($10,000) (10,000($6,000)($6,000($6,000) ($10,000) Cash position at end of month 7,950 ($10,400) 9,100) $21,000 $47,700 $60,100 $55,300 $21,650 $10,000) ($10,000) ($10,000) (10,000) ($10,000) Surplus cash or loan needed 500($2,050)($20,400) (19,100) $11,000 37,700$50,100 45,300$11,650 $1,050 ($4,250) $16,200$31,550 Ma Nov 20,000 30,0050,0 $40,000 $ May $15,000 20,000 $10,000 $35,000 3,000 $12,000$14,000$31,000$29,000 $14,000 15,000 $25,0 0,000 Estimated labor and raw materials 3,000$25,000$38,000$30,000$10,000 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,000 Cash on hand (May 1, 2016) $12,000 Prepare a monthly cash budget for the next thirteen months 15,00 $20,000 $30,000 $ $50,000 40,000 $20,0 $20,000 $10,0 5,000$ 15,000 25,00040,000 $35,0 0$15 ,000 $15,000$12,000 7,500$12,000$10,500 During 1st month after sale During 2nd month after sale 9450 $12,600 $18,900 $31,500 $25,200 $12,600 9,450 $15,750 $25,200 $22,050 4,500 $25,450 $22,650 $35,300 $45,600$34,700 $18,400 $10,200 8,350 $17,300 $28,800 $37,450$29,350 Variable: Labor and raw materials Fixed: inteerst, rent, and admin expenses 3,000$25,000$38,000 $30,000$10,000 3,000 $12,000$14,000 $31,000 $29,000 $14,000 6,000 $28,000 $41,000$34,000 $15,500 6,000 $15,000 $42,000$34,000 $32,000$17,000 $10,000 Cash Surplus (or Loan Requirement Cash gain (or loss) during the month Cash position at beginning of month ($1,500) ($2,550) 18,350) $1,300 $30,100 $26,700 12.400 ($4,800) ($33,650) ($16,700) ($3,200) $20,450 $19,350 $12,000 $10,500 $7,950 ($10,400)(9,100) $21,000 47,700 60,100$55,300 $21,60 $4,950$1,750 $22,200 22,200 $41,550 10.000($10,000) ($10,000) (10,000($6,000)($6,000($6,000) ($10,000) Cash position at end of month 7,950 ($10,400) 9,100) $21,000 $47,700 $60,100 $55,300 $21,650 $10,000) ($10,000) ($10,000) (10,000) ($10,000) Surplus cash or loan needed 500($2,050)($20,400) (19,100) $11,000 37,700$50,100 45,300$11,650 $1,050 ($4,250) $16,200$31,550Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started