Costing accounting project Jessica Rabbit
mcminnmo
Template1acct.xlsxNames
| 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
| 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. |
| Total MOH Budgeted Expenses |
| Total Cash Disbursements for MOH |
S&A 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. |
| Total S&A Budgeted Expenses |
| Total Cash Disbursements for S&A |
Income Statement
| 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 Cost Per Unit |
| Master Cost Per Unit |
| Total COGS |
| S&A Expense |
| Taxes |
| Net Income |
Cash Flow 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. |
| Excess (deficiency) of cash |
