Excel Master It$!$ Problem Heidi Pedersen, the treasurer for Wood Products, Inc., has just been asked by Justin Wood, the company's president, to prepare a memo detailing the company's ending cash balance for the next three months. Following, you will see the relevant estimates for this period. Excel Master coverage online July August September Credit sales $$1,275,800$ $$1,483,500$ $$1,096,300$ Credit purchases $765,480890,160657,780$ Cash disbursements Wages, taxes, and expenses $348,600395,620337,150$ Interest $29,90029,90029,900$ Equipment $0158,90096,300$ Credit sales collections: Collected in month of sale $35\%$ Collected month after sale $60\%$ Never collected $5\%$ June credit sales $$1,135,020$ June credit purchases $ $681,012$ Beginning cash balance $ $425,000$ All credit purchases are paid in the month after the purchase. a$.$ Complete the cash budget for Wood Products for the next three months. $\backslash ($ a $\backslash ).$ Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and other expenses Interest Equipment purchases Total cash disbursements Ending cash balance Cash Receipts$/$Collections Sales Collections: Month of Sale CollectionsMonth After Sale Not Collected