Please show how you got your numbers. I need step-by-step instructions. I am trying to check my work. If you cannot show how you got your numbers, please do not answer this question.

Crawford and Rodriguez expect sales to increase 4.5 percent next year, to $2,504,368. Credit sales account for 79 percent of total sales, and the company's collection pattern for credit sales is 11 percent in the same month in which the sale is generated, 63.5 percent in the first month after the sale is generated, and 22 percent in the second month after the sale is generated. The pharmacy's cost of goods sold is 77.4 percent, and vendors grant net 30" credit terms, which means the pharmacy pays for the goods it purchases every month in the following month. Crawford and Rodriguez have been working with their accountant to develop estimates for their expenses for the upcoming year (see the accompanying table on page 783). Actual sales for the last two months, November and December, were $272,357 and $315,458. The company's cash balance as of January 1 is $74,473. The interest rate on Bluffton Pharmacy's current line of credit is 8.25%, and whatever the pharmacy borrows must be repaid the following month (with interest), even if it must borrow again in that month. The entrepreneurs have established a minimum cash balance of $15,000. 1. Develop a monthly cash budget for Bluffton Pharmacy for the upcoming year. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales $2,30,402 $2,37,915 $2.15,376 $1,77,810 $1,75,306 $1,72,801 $1,62,784 $1,67,793 $1,97,845 $2,47,932 $2,55,445 $2,62,959 Other Cash 105 55 60 75 85 55 65 60 65 85 95 110 Receipts Rent 3,083 3,083 3,083 3,083 3,083 3,083 3,083 3,083 3,083 3,083 3,083 3,083 Utilities 1,049 1,083 980 809 798 787 741 764 901 1,129 1,163 1,197 Advertising 1,150 1,188 1,075 888 875 863 813 838 988 1,238 1,275 1,313 Insurance - 2.700 - 2,700 - 2,700 - 2.700 1 1 1 Salaries 27,404 27,515 27,182 26,627 26,590 26,553 26,405 26,479 26,923 27,663 27,774 27,885 Wages, and Benefits Computer 1,042 1,042 1,042 1,042 1,042 1,042 1,042 1.042 1,042 1,042 1,042 1,042 System and E-commerce Repairs and 2,000 2,000 2.000 2,000 2,000 2,000 2,000 2,000 2,000 2.000 2,000 2.000 Maintenance Travel 150 - 5,000 200 1 Professional - - - - - - - 3,900 ! ! Fees Supplies 644 665 602 497 490 483 455 469 553 693 714 735 Loan 2,073 2,073 2,073 2,073 2,073 2,073 2.073 2,073 2,073 2,073 2,073 2,073 Payments Other 50 50 50 40 40 40 40 45 50 50 50 50