Referencing Styles : Not Selected Introduction: Addresses the report to the person(s) concernedPurpose: Describes the problem, identifies the issue or questions to be answered; completely covers the problem requirements.Quantitative AnalysisOrganization: Proceed logically though the development of quantitative analysis. Separate worksheets. Calculations & output linked by complex formulas Excel Sheets: Named properly; in sequence; one sheet for each analysis of data Each Data sheet: All data properly defined … View More Introduction: Addresses the report to the person(s) concerned Purpose: Describes the problem, identifies the issue or questions to be answered; completely covers the problem requirements. Quantitative Analysis Organization: Proceed logically though the development of quantitative analysis. Separate worksheets. Calculations & output linked by complex formulas Excel Sheets: Named properly; in sequence; one sheet for each analysis of data Each Data sheet: All data properly defined; Organized in an easy manner to follow. No hard-coded values. Sheet 1 Calculate the amounts for each cost pool 245,750, 502,038, 438,565, 1,909,252, & 699,550 Calculate the rate per cost driver. 2.92,7.72.2.78.0.19 & 0.74 Sheet 2 – Calculate the total cost for each product. 59,38,24,19 & 8 Sheet 3 – Evaluate the cost and profitability of the cheque account product Compute the average annual profitability for the four categories of accounts. Calculations and formulas are: Accurate and Logical Results – Loss 23, 6 &19 profit 41 Qualitative Analysis Describes in general the development of the Activity Based Model. Brief explanation of the content of each excel sheet – reference to appendix or exhibit. Summarizes the rates for each cost pool, the rates per activity and the cost of each product. Addresses the cost and profitability of the four categories of the cheque account product. Are all categories profitable? Ranks products by profitability Identifies the product(s) (or categories) that could be dropped/cancelled Make a number of recommendations to increase the profitability of the cheque account product. Recommendations follows logically from analysis Discuss the advantages of adopting an Activity Based Costing system for the activities of the bank. Conclusion(s) Concluding remarks addresses once again the problem/issue. Makes recommendations regarding overall product profitability; the cheque account profitability. Concludes with overall recommendation (s) Professionalism Well organized; Spell checked; Appendices (Exhibits), numbered and placed at the end of the report Report written in a direct and concise manner. Read Less