Please create an excel sheet from scratch for all tables. You can choose any numbers to estimate costs for the production of any product (ex: purse, notebook, food)
Cost Basis Table 1: Material cost per unit Table 2: Labor cost per unit Table 3: Assets (Equipment and their annual straight-line depreciation) Table 4: Overhead Table 5: Selling and Administrative Variable costs Fixed costs Table 6: Fix and Variable Costs (Combine Table 4 and 5; remember to add DM and. DL to the calculation of the variable cost) Variable Costs DM (From Table 1) DL (From Table 2) Variable OH (From Table 4) Variable S\&A (From Table 5) Fixed Costs Fixed OH (From Table 4) Fixed S\&A (From Table 5) Total Fixed Costs (This will be used for CVP analysis) SET 2: Cost Volume Profit Analysis (50 pts.) Estimated Selling Price Contribution Margin Break-Even Points in Dollars and Units Profit Planning (Target sales in Dollars and Units, to be used in sales budget) (Note: Target income should be almost equal to the net income in the Budgeted Income Statement) Margin of Safety SET 3: The Master Budget for four quarters (100 pts.) Sales Budget Production Budget Ending Inventory Budget Selling \& Administrative Expense Budget DM Budget DL Budget MOH Budget Cash Budget Budgeted Income Statement Budgeted Balance Sheet Here is a Sample Memo so you can have an idea about how a memo looks like. You can not copy from my provided samples. The Excel project of "Your Company Name" must be submitted with a Business Memorandum. A memorandum-usually known as a memo-is a document that is most commonly used for internal communication between coworkers or members of a department. In our case, the Board of Directors is concerned about the project's budgeted year profitability. Each issue in a memorandum needs one paragraph. You should start with one introduction at the beginning and finish with one conclusion at the end of the memorandum. You do not write unnecessary information in the memorandum. You should write only about requested issues and use a profitability ratio to emphasize your point. You need to write a memo to the Chair of the Board of Directors about their concern based on your prepared budgeted Income Statment results and the proposed product profitability. How to contact your group member for the group project using INBOX 3 Cost Basis Table 1: Material cost per unit Table 2: Labor cost per unit Table 3: Assets (Equipment and their annual straight-line depreciation) Table 4: Overhead Table 5: Selling and Administrative Variable costs Fixed costs Table 6: Fix and Variable Costs (Combine Table 4 and 5; remember to add DM and. DL to the calculation of the variable cost) Variable Costs DM (From Table 1) DL (From Table 2) Variable OH (From Table 4) Variable S\&A (From Table 5) Fixed Costs Fixed OH (From Table 4) Fixed S\&A (From Table 5) Total Fixed Costs (This will be used for CVP analysis) SET 2: Cost Volume Profit Analysis (50 pts.) Estimated Selling Price Contribution Margin Break-Even Points in Dollars and Units Profit Planning (Target sales in Dollars and Units, to be used in sales budget) (Note: Target income should be almost equal to the net income in the Budgeted Income Statement) Margin of Safety SET 3: The Master Budget for four quarters (100 pts.) Sales Budget Production Budget Ending Inventory Budget Selling \& Administrative Expense Budget DM Budget DL Budget MOH Budget Cash Budget Budgeted Income Statement Budgeted Balance Sheet Here is a Sample Memo so you can have an idea about how a memo looks like. You can not copy from my provided samples. The Excel project of "Your Company Name" must be submitted with a Business Memorandum. A memorandum-usually known as a memo-is a document that is most commonly used for internal communication between coworkers or members of a department. In our case, the Board of Directors is concerned about the project's budgeted year profitability. Each issue in a memorandum needs one paragraph. You should start with one introduction at the beginning and finish with one conclusion at the end of the memorandum. You do not write unnecessary information in the memorandum. You should write only about requested issues and use a profitability ratio to emphasize your point. You need to write a memo to the Chair of the Board of Directors about their concern based on your prepared budgeted Income Statment results and the proposed product profitability. How to contact your group member for the group project using INBOX 3
