accounting test

jessicarabbit.xlsx

Home >Business & Finance homework help >Accounting homework help >accounting test

Instructions

Instructions:
	DOWNLOAD THE "Jessica Rabbit TEMPLATE" TO YOUR PERSONAL COMPUTER.
	1. Sales Budget including a schedule of expected cash collection.
	2. Production Budget
	3. Direct Materials budget including a schedule of expected cash disbursements.
	4. Direct Labor Budget
	5. MOH Budget including cash disbursements for overhead
	6. S&A budget including cash disbursements for S&A
	7. Budgeted Income Statement.
	a. When calculating COGS please illustrate how you computed the COGs per unit.
	8. Cash Budget
Each of your budgets must display the budgeted cost data for the two products, Backyard and Master Grills. In other words, you will NOT COMBINE THE TWO PRODUCTS IN ANY OF YOUR BUDGETS. If rounding is necessary, please round to two decimals.
ALL WORK MUST BE SUBMITTED USING THE PROVIDED EXCEL WORKSHEETS IN THE FILE. CHANGES TO THE FORMATTING OF THE EXCEL FILE IS PROHIBITED AND WILL IMPACT
THE GRADING OF THE ASSIGNMENT.
Submission Instructions:
1. Only one file submitted per team
2. File must be the original excel document, completed. ANY ALTERATIONS TO THE FILE (FORMATTING, COPYING SHEETS, ETC) WILL NOT BE GRADED.
3. Save Files as (Last Name of Team Mate 1, Last Name of Team Mate 2, Last Name of Team Mate 3)
4. File must be uploaded via link under "Assignments" on Blackboard by 11:59PM, 12/07/2015. LATE SUBMISSIONS WILL NOT BE ACCEPTED
Words of Wisdom for this Project:
1. Allow plenty of time to complete this assignments. Typically time required is around 10-15 hours.
2. Feel free to email me with questions as you are working on the assignment.
3. Do not wait until the night or day before to begin this assignment. The grade will not be favorable.
4. Email Sheila your file as it progresses to ensure the budgets are correct. For example, if a mistake occurs in the Sales Budget, all other budgets will be incorrect.

Names

Jessica Rabbit Case Project

Team Member Names

Sales Budget

INSTRUCTIONS: Please use this worksheet to complete the respective budget displayed on the Tab. The following boxes in red must be filled-in with the appropraite data from your budget. Failure to show show a budget will result in a score of zero for this section.
	Backyard	Master
Total Sales in Units
Total Sales in Dollars
Total Schedule of Expected Cash Collections

Production Budget

INSTRUCTIONS: Please use this worksheet to complete the respective budget displayed on the Tab. The following boxes in red must be filled-in with the appropraite data from your budget. Failure to show show a budget will result in a score of zero for this section.
	Backyard	Master
Units to Produce

Direct Material Budget

INSTRUCTIONS: Please use this worksheet to complete the respective budget displayed on the Tab. The following boxes in red must be filled-in with the appropraite data from your budget. Failure to show show a budget will result in a score of zero for this section.

Raw Materials to Purchase

Cash Disbursement for Raw Materials

DL Budget

INSTRUCTIONS: Please use this worksheet to complete the respective budget displayed on the Tab. The following boxes in red must be filled-in with the appropraite data from your budget. Failure to show show a budget will result in a score of zero for this section.
	Backyard	Master	Total
DL Cost

MOH Budget

Total MOH Budgeted Expenses

Total Cash Disbursements for MOH

S&A Budget

Total S&A Budgeted Expenses

Total Cash Disbursements for S&A

Income Statement

Backyard Cost Per Unit

Master Cost Per Unit

Total COGS

S&A Expense

Taxes

Net Income

Cash Flow Budget

Excess (deficiency) of cash