I have everything completed, but my numbers messed up somewhere on the disbursements, cash budget, and balance sheet but I don't know where (and Chegg won't allow me to post my work here).

Any help would be appreciated!

Chris Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of the master budget for the second quarter of 2019: a. Actual sales for March and budgeted sales for the next four months are as follows: March April May June July $120,000 180,000 190,000 130,000 110,000 b. The company's gross profit rate is 44 percent of sales. c. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month; advertising, $15,000 per month; utilities, 2 percent of sales; depreciation, $8,000 per month; other expense, 3 percent of sales; and rent, $17,000 per month. d. At the end of each month, inventory is to be on hand equal to 25 percent of the following month's sales needs, stated at cost. e. Seventy percent of a month's inventory purchases are paid for in the month of purchase; the rest is paid for in the following month. f. Sales are 40 percent for cash and the rest on account. All sales on account are collected the month following sale. The accounts receivable on March 31 are a result of March credit sales. g. As of March 31, 2019 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Debits $25,000 75,000 50,000 100,000 Cash Accounts Receivable Inventory Plant and Equip (net) Accounts Payable Short-term Notes Payable Capital Stock Retained earnings $60,000 20,000 125,000 45,000 $250.000 $250.000 h. During May, the company will purchase a new copy machine for $25,000 in cash. During June, other equipment will be purchased for cash at a cost of $20,000. Assume there will be no equipment purchases in April 2019. i. During April and May, the company will declare and pay $14,000 in cash dividends per month. Assume no dividends will be paid in June of 2019. j. The company must maintain a minimum cash balance of $7,500. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of a month, and all repayments are made at the end. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid at the end of each month. The interest rate is 12 percent per annum. (Figure interest in whole months, e.g., 1/12, 2/12.) Required: Prepare an interactive budgeting spreadsheet. It should automatically update when changes are made to the input data, such as changes in sales forecasts, equipment purchases, etc. Spreadsheets Hints 1. Create a worksheet for inputs that includes all potential variables that can be changed. Label the worksheet tab as "inputs." 2. Create a worksheet for each of the different budgets. Label the tabs appropriately. The following budgets should be included: a. Sales Budget b. Inventory Purchases Budget c. Selling and Administrative Budget d. Cash Collections from Customers Schedule e. Cash Paid for Inventory Purchases Schedule f. Cash Budget g. Budgeted Income Statement h. Budgeted Balance Sheet databa