Required: 1. Prepare a Sales Budget, Production Budget, Direct Materials Budget, Direct Labour Budget, Manufacturing Overhead Budget and Sales and Administration Budget. 2. Prepare Schedules of Expected Cash Collections and Expected Cash Disbursements for Materials as well as a Cash Budget. 3. Prepare a Budgeted Income Statement for the Quarter Ended June 30th. 4. Prepare a Budgeted Balance Sheet at June 30th. This is an individual assignment. Every student must complete and submit their own work All schedules and statements should be labelled clearly and easy to follow. Use excel to do your work. Use cell references and formulas in your schedules. If you're having difficulty you can email me a copy of your excel file and I'll point you in the right direction. Upload your excel file to the dropbox in the Chapter 7 Folder on Moodle prior to midnight on October