Worth 100 Points Save Templare on Ter objective: To understand and apply the basic concepts of profit planning. Due date: Tuesday, December 6, 11:00 pm. (submit the assignment in blackboard.) Grading: This project is worth 100 points. Required: You need to prepare a comprehensive 6-month budget, including supporting fictional report for the period January 1, 2010 to June 30, 2010 for Henron, Inc (a company). This project must include: 1. Sales Budget. 2. Cash Receipts (Collections) budget. 3. Purchase budget 4. Cash Disbursements budget 5. operating Expense budget...... 6. Summary Cash budget 7. Budgeted Income Statement..... 8. Budgeted Balance Sheet Notes and Hints 1. All 8 parts must be submitted before I grade the project. 2. The schedulesbudgets must be prepared on Excel. The templates Ihave prepared must be used as is. 3. Part of this project is demonstrating p use of Excel. You may only input a a "hard numbers into a All yellow cells must be formula based (no numbers included-use appropriate cell referencing). 4. I recommend constructing the formulas for one month and then copying the formulas over to the remaining months. 5. Rounding is encouraged and you may ignore interest and taxes 6. The budget templates and this instruction sheet are located on the course materials page. Make sure ou save the file to excel and then open the file through Excel (not Internet Explorer). 7. Check figures are also located on the course materials page. Page 1 of 3