Can someone please do this for me or tell me how to do it step by step and can you answer the questions at the end in the way you would answer them

Allocation of indirect costs to various departments can alter the departmental profit. Jacobs Company manufactures plates for drum brakes. To make the brake plate, three departments are required: stamping, plating, and packaging. At Jacobs, each department manager is eligible for a bonus based on departmental profit. You are the manager of the stamping department. Top management has given you the responsibility of assigning the indirect costs to each department. Stamping has higher material costs whereas plating has higher labor costs. You are to propose an allocation methodology that is fair to all department managers.

In order to understand the financial impact on each department, management will create a spreadsheet that assigns indirect expenses to the various departments (in this case: (A) Stamping (B) Plating (C) Packaging), based upon an accepted allocation methodology.

The first step in the process is to complete the worksheet for Jacobs Company by entering the percentage allocations and subsequently preparing the corresponding Excel formulas to ensure all expenses are allocated. Click here

to open the spreadsheet.

In addition, as the manager of the Stamping Department you will also need to support your approach / logic. Within the Discussion Board please provide insight / reasoning as to why you allocated each expense in the manner you did.

NEW ENGLAND COLLEGE OF BUSINESS AND FINANCE Jacobs Company Allocation Worksheet 12 Set-Up The Appropriate Formula Enter Percentage Allocation Plating Packagi 14 15 16 Insurance Expense 17 Rent Expense 18 Utilities Expense 19 Office Salaries Expense 20 Other Office Expense 21 Uncollectible Accounts Expense 22 Depreciation Expense-Funiture&Fixtures 23 Depreciation Expense Office Equipment 24 25 26 Directions: 27 1) Enter the % Allocation in Columns: "E"-"G" 28 . 2) Set-Up the Appropriate Excel Formula in Columns! "K"-"M" 29 (3) Validate that all costs are 100% allocated TOTAL Stam TOTAL Stam Plati Packagin TOTAL $8,118 $2,160 $4,056 $82,825 $18,000 $1,300 $1,000 $500 0% 0% 0% 0% 0% 0% 0% 0% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Variance $8,118 $2,160 $4,056 $82,825 $18,000 $1,300 $1,000 $500 S0$117,959 0% 0% 0% Your Allocation is 30 4) Within the Discussion Board, provide your logic reasoning /justification for the allocation percentages you assigned to each department 31 32 Column equals $0.00 34 35 36 37 38 NEW ENGLAND COLLEGE OF BUSINESS AND FINANCE Jacobs Company Allocation Worksheet 12 Set-Up The Appropriate Formula Enter Percentage Allocation Plating Packagi 14 15 16 Insurance Expense 17 Rent Expense 18 Utilities Expense 19 Office Salaries Expense 20 Other Office Expense 21 Uncollectible Accounts Expense 22 Depreciation Expense-Funiture&Fixtures 23 Depreciation Expense Office Equipment 24 25 26 Directions: 27 1) Enter the % Allocation in Columns: "E"-"G" 28 . 2) Set-Up the Appropriate Excel Formula in Columns! "K"-"M" 29 (3) Validate that all costs are 100% allocated TOTAL Stam TOTAL Stam Plati Packagin TOTAL $8,118 $2,160 $4,056 $82,825 $18,000 $1,300 $1,000 $500 0% 0% 0% 0% 0% 0% 0% 0% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Variance $8,118 $2,160 $4,056 $82,825 $18,000 $1,300 $1,000 $500 S0$117,959 0% 0% 0% Your Allocation is 30 4) Within the Discussion Board, provide your logic reasoning /justification for the allocation percentages you assigned to each department 31 32 Column equals $0.00 34 35 36 37 38