Cash Budget Project Instruction: Please submit an electronic copy of your homework solution for this project to the Blackboard under Assignment. The due date is December 11. Your solution should be in an Excel file. Please read the Cash Budget slides before doing the assignment below Andrea 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 3 months. Below, you will see the relevant estimates for this period July 1,275,800 August September Credit sales Credit purchases Cash disbursements 1,483,500 $ 890,160 1,096,300 657,780 765,480 Wages, taxes, and expenses Interest Equipment 348,600 29,900 395,620 29,900 158,900 337,150 29,900 96,300 Credit sales collections Collected in month of sale Collected month after sale: Never collected 35% 60% 5% June credit sales June credit purchases: Beginning cash balance $1,135,020 681,012 425,000