please help question 2. i uploaded the cash budegt chart for question 1. thanks

Case 7 Bluffton Pharmacy, Part 2 How should the owners of a small of goods sold is 774 percent, and vendors print "net 30 pharmacy create a cash flow forecast credit terms, which means the pharmacy pays for the goods for their business? purchases every month in the following month. Crowford and Rodrigues have been working with their accountant to It has been a little more than two years since Angela Craw. see the accompanying table on page 783). dewelop estimates for their expenses for the upcoming your ford and Martin Rodriguez purchased the Bluthon Pharmacy Actual sales for the last two month November und from Prank White, the previous owner and founder, who had December, were $272,357 5315458. The company started the pharmacy in 1909. Although Crawford and Ro ch balances of Jawy 1 is 574473. The interest driguez have prepared budgets for Bluffon Pharmacy and have analyzed their financial statements using catto analysis whatever the pharmacy borrows must be repaid the follow on Bluthon Pharmacy's current line of conditis 83, they have not created a cash flow forecast. During a recent ing month(with interest.even if it must borrow gain in the meeting their banker explained the importance of reliable month. The entrepreneurs have established a minimum cash cash flow foreca, telling them that hanks traditionally balance of $15.000 are cath low lenders. Bankers appreciate trong balance sheets and income statements, but they are most interested in company's cash flow because they know that peritive cash Questions flow is required to pay a loan Develop a monthly cash belget for thon Pharmacy Crawford and Rodriguer expect sales to increase for the upcoming year 45 percent year, 10 52 504,36%. Credit sales account 2. What recommendations can you offer Angers for 79 percent of total sales and the company's collection and Martin Rodrigues to improve the tacy putter for credit sales is 11 peruent in the same month in cash flow which the sale is generated, 6.5 percent in the first month 3. If you were Bluthon Pharmacy but you be her the sale is generated, and 22 percent in the second comfortable extending a line of credit to the pharmacy! month her the sale is generated. The pharmacy's com Explain Cash Budget for the upcoming year Jan Feb March April May June July Aus Opening cach balance 74.473.00 65.910.01 89,979.59 88.295.45 86.795 21 85.943 35 80.83776 75,9 Cash Generated through sales 2,73,99151 241,044.73 2.23,339 06 2.02.184 79 178,679,09 1,70,150.25 165 484 37 1.61 105 55 60 75 85 55 . 65 60 Other Gash Receipts 9-19 COGS -244,164.49 1,78,33115-1,84.146.21 166,70102 -1.37,624.94-1.35,686,84 -1.33.74797 -1.2 Rent -3.083.00 -3.083.00 -3.083.00 -3,083.00 -3,083.00 -3,083.00 -3,083.00 -3.0 Utilities -1,049.00 -1,083.00 -980.00 809.00 -798.00 -78700 -74100 -76 Advertisement -1.150.00 1.188.00 -1.075.00 888.00 -875.00 -863 00 -813.00 -83 Insurance -2,700.00 -2,700.00 Salaries Wages & benefits 27.404.00 27,515.00 27.182.00 26,62700 26,590,00 26,553.00 -26.405.00 -26 Computer System & E Commerce -1042.00 -1,04200 1,042,00 -1,04200 -1,042,00 - 1,042.00 -1,04200 -10 Repall & Maintenance 2.000.00 -2,000.00 2000.00 2,000.00 -2,000.00 -2,000.00 -2.000.00 -20 . . Travel - 150.00 -5,000.00 Professional Fee Supplies -644.00 665.00 -602.00 497.00 490,00 -483.00 -455.00 46 Loan Payments -2,073.00 -2,073.00 2,073.00 -2,073.00 2,073.00 2,073.00 -2,073.00 -20 Other -50.00 50.00 -50.00 40.00 -40.00 40.00 40.00 -45 Ending Cash Balance 89.979.59 65.910.01 88.295.45 86,79521 85,943.35 80,83776 741 75,98716 June July August September October Noverober December Total 121 85.943.35 80.837.76 75.987.16 74.770.49 75,656,11 85,660,46 89.284.26 19.09 1.70.150.25 1,65,484 37 1,61,511 15 1.71,20540 2,02,02238 234,60217 249,30709 24,73,52198 55 65 60 65 85 95 110 915.00 2494-1,35,686.84-133,747.97 -1,25,994.82 -129,671.781,53,132,03 1,91,899.37 1.97714.43 -19,79,015.06 100 -3,083.00 -3,083.00 -3,083.00 -3,083.00 -3,06300 3,083.00 -3.083.00 - 36.996.00 0 -78700 -741.00 -764.00 -90100 -1,129.00 -1.163.00 -1.197.00 -11,401.00 0 -863.00 .813.00 -838.00 -988.00 1,238.00 - 1,275.00 -1.313.00 - 12,504.00 -2,700.00 2.700.00 2.700.00 -10,800.00 0.00 26.553.00 26,405.00 26.479.00 26,923.00 27.663.00 -27.774.00 27.885,00 -3.25.000,00 00 -1,04200 -1,042,00 1,042,00 1,042,00 -1,04200 -1,042,00 - 1,042,00 -12,504.00 1.00 2,000.00 2000.00 2,000.00 2.000.00 2,000.00 2,000.00 -2000.00 -24.000.00 100 200.00 -5.350.00 -3,900.00 3,900.00 463.00 455.00 469.00 -553.00 -693.00 -714.00 735.00 -7,000.00 00 2.073.00 2073.00 -2,073.00 -2,073.00 -2,073.00 -2,073.00 2.073.00 2487600 4000 -40.00 -45.00 -50.00 -50.00 -50.00 -50.00 55500 135 80.83776 75.967 16 74.770.49 75,656,11 85,660.46 89,284 26 95,00892