assignment #2: Excel Budget (20%)

This assignment relates to the following Course Learning Requirement: CLR 6 - Prepare the master budget in a for-profit business

Objective of this Assignment:

To complete the Master Budget using Excel.

Instructions:

Open the Excel Template document. Using the Company Background provided on the first sheet of the workbook entitled Background, prepare the following company budgets:

For the First quarter of the 2016 fiscal year (January to March)

1. Sales Budget

2. Schedule of Cash Collections for the quarter

3. Production Budget

4. Direct Material Budget

5. Cash Disbursements Budget

6. Direct Labour Budget

Submission:

A professional-looking document, free of spelling and grammar errors is expected. This assignment is to be an individual effort and must be submitted online by the time indicated. This assignment must also include a title page. When you structure your assignment, please do the following:

first page is to be a cover page and you should indicate assignment #, title, course name, course code, course facilitator, student name and ID, and date

the last page should list any applicable references;

name the file with your last name, the # of the paper, and course code (i.e., if it were your first

paper, the file would be Smith_01_ACC2222.doc);

number the pages in the header;

keep text double space and an easily readable font (Times New Roman 12pt); and

include your name in the footer of each page.

The referencing format must follow the Publication Manual of the American Psychological Association (APA).