Course Project A
For Project A, you will need to review the Course Project Instructions in Document Sharing. An Excel template file can be also found in Doc Sharing. Use it to do your master budget and supporting schedules. This project will help you learn and understand what a master budget is and how it is prepared. When you have completed Project A, upload it into the Dropbox. There will be a discussion thread area in Weeks 4 and 5 that you can use to ask questions about the project.
Grading Rubric for Course Project (Part A)
Category Points % Description
Documentation & Formatting 10 10% Project worksheets will be done in Excel and will contain formulas to receive maximum credit.
Organization & Cohesiveness 10 10% Calculations should be organized and correctly labeled.
Editing 10 10% Quality work will be free of any spelling, punctuation, or grammatical errors.
Content 70 70% A quality project will have all required work completed and will be correct.
Total 100 100% A quality paper will meet or exceed all of the above requirements.
Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:
• 1.
o a. A sales budget, by month and in total.
o b. A schedule of expected cash collections from sales, by month and in total.
o c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.
o d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
• 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000.
• 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.
• 4. A budgeted balance sheet as of June 30.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]