1 SAP Assignment (Individual) ACCT2019 Accounting for Management Decisions Semester 1, 2025 Weightage: 10% Objectives: To assess student’s understanding and skills to map the business scenario of the case study in SAP, perform appropriate cost allocations and produce reports Due date: 17 October 2025, Friday, 11.59 PM Client: 216 SAP Username: learn-### assigned to you in workshops. Initial password: You will find it in the announcement on assignment Submission requirements: • Your submission should have: • Your SAP User account, i.e., learn-### and student SID in every page header. • A first page that includes your name, student ID, learn-### number, and a table of master data elements (G/L accounts, cost centres, cost elements, activity types, statistical key figures etc.), document numbers and/or allocation cycle numbers generated by the system and codes for your allocation cycles (No need for a separate cover page). • Appropriate screen shots of: i) Actual distribution/assessment basic list that shows document number, and assessment/distribution line items display for each of the allocation ii) direct activity allocation document display screen with details of document number, cost centres and allocated values (both quantities and costs) clearly shown (for all the secondary costs), and iii) actual/plan/variance cost centre reports for your cost centre group GC### and for each of your cost centres in the group (that shows values for activity types and statistical key figures) for the current month. Please do not capture excel reports. These reports must be captured as screen shots from SAP. • You can place up to two screenshots in each page, and make sure they are visible (you must crop out unnecessary areas of the screenshots for better visibility). • One single PDF document with pages not exceeding 20 (including cover page) must be submitted. Penalties apply if the screenshots are illegible or missing, the values are incorrect, and if the assignment does not have identifying information. Please see the marking criteria available in Canvas. Further Instructions and hints: • You must first decide which master data, which transactions, and which allocation methods (for specific costs) are required to reflect the scenario and determine the reports required, execute them in the system, capture required screen shots on to word document, convert that into PDF and submit. • You are using SAP configured for Global Business Bikes company in client 216 and therefore map and work within that firm as you have done in SAP exercises. • You must use the learn-### assigned to you in workshops. Using wrong account attract heavy penalties. If you are not sure, please go to Canvas and check your learn number again. • Please remember to charge the costs (planned and actual) to appropriate cost centres as described in the business scenario. Incorrect charging will show the reports as erroneous and may attract penalties. 2 • Your allocations must be based on ‘allocation basis or ‘statistical key figures’ (as demanded by the business scenario) you setup in SAP for the system to compute the costs and allocate to individual cost centres. Using incorrect method may attract penalties. • SAP is a real-time accounting system, so you must use the default date options available (month/date/year) for creating all your master data, today’s date for all postings, and current year for all your allocations. • Caution: I strongly recommend you do your postings and reports in the same month. If you do your postings in September and do the reports in October, then you won’t be able to see all your values in the report when you try to produce the report for the current month. In that instance, you may have to produce report for the entire year ‘FROM period 1 TO period 12’ • Considering the limits on authorisations, complexity of the software, focus on user perspective in workshops, and the real-time nature of the accounting system, it is easier and efficient to create new master data and transactions if mistakes are made, rather than correcting the errors. Please note, if errors are made either in the creation of master data or in performing transactions, they CANNOT simply be deleted, and the errors will therefore carry into the final cost centre reports. Marks are proportionate and depends on correct mapping of the scenario in SAP including creation of relevant master data, evidence of transactions and reports, correctness of the methods employed for allocations, accuracy of the values in the reports and overall presentation (i.e., visibility of screen shots, submission of required screen shots & identifying information). Please see the marking guide and criteria posted in Canvas for more details. • Appendix 1 provides a list of master data codes and Appendix 2 provides a list of generic field values to be used while creating master records and executing transactions in the SAP system. Failing to use the assigned codes will attract penalties. For all the other codes not mentioned in table 2, please use the codes you have used in SAP Exercises. 3 Business Scenario: Your company (GBI) offers application development services through cloud. It purchases internet cloud space from DigitalCloud (###digicloud), a cloud services company using an annual contract. For the current month, management received an invoice from Digital Cloud (###digicloud) for an amount of $500,000. This amount is initially charged to Finance (F###) division, which is a part of the Global Advisory Group (GA###). At the end of the period, your management wants this cost to be allocated to other revenue generating divisions – Audit (A###), Tax (T###), Digital transformation (D###) & Consulting (C###) divisions - based on the actual cloud space used by each of the divisions. For the current month, the Audit, Tax, Digital transformation and Consulting services divisions - all of them in the Global Advisory group (GA###), used 1000, 2000, 4000 and 3000 units of the cloud space respectively. Budgeted space for these divisions, however, is 1100, 1800, 3600 & 2900 units for Audit, Tax, Digital transformation and Consulting services respectively. While allocating the actual cloud space to all the cost centres in its Global Advisory group (GA###), your firm wants the identity of the costs to be clearly shown in the receiver cost centre reports. Budgeted/planned costs towards salaries are $1300,000, 700,000, 500,000 and 600,000 while actual salaries costs are $1200,000, $600,000, $450,000 and $500,000 for Audit, Tax, Digital transformation & Consulting services respectively. While planned costs are recorded in the system for each cost centre, actual costs are posted directly in the general ledger every month and charged to the individual departments (cost centres). Its Finance division (F###) provides information technology services to other departments in the Global Advisory group (GA###). As a controlling measure, management would like to measure these IT service activity (TS###) delivered to other departments in their cost centre group (GA###) in hours and allocate those internal costs to them. In the current month, it has provided 400, 500, 800 and 600 hours of information technology services (TS###) to Audit, Tax, Digital Transformation and Consulting divisions respectively at a rate of $300 per hour. Total planned activity for the information Technology services is 2000 hours per month. You are required to map the entire business scenario as explained above in the SAP accounting system by first determining the master data, transactions, allocations, and reports required, and then by creating the master data, executing the transactions and allocations, and producing the reports in SAP. You must submit appropriate screen shots of: i) Actual distribution/assessment basic list that shows document number or assessment/distribution line items display for the allocation along with the document number details in the screen ii) direct activity allocation document display screen with details including the document number, cost centres and allocated values (both quantities and costs) clearly shown, and iii) actual/plan/variance cost centre reports for your cost centre group GC### and for each of your cost centres in the group (including the display of values for activity types and statistical key figures if any in the report) for the current year. 4 Appendix 1: Master data codes: Details of master data/ transactions Field values 1 Bank G/L Accounts 1800###, 1801###, 1802### etc. 2 A/P Reconciliation accounts 3300###, 3301###, 3302### etc. 4 Expense G/L accounts 5000###,5001###, 5002### etc. 5100###, 5101###, 5102### etc. 5500###, 5501###, 5502### etc. 6000###, 6001###, 6002### etc. 5 Secondary cost elements 8000###, 8001###, 8002### etc. 6 Technology Service activity type TS###, TS1### etc. 7 Cost centres As mentioned in the scenario 8 Cost centre group GA###, GA1### GA2### etc. 9 Statistical key figures CS###, CS1### etc. or EM###, EM1### etc. 10 Assessment cycles A###, A1### etc. 11 Distribution cycles D###, D1### etc. Appendix 2: Details of the Values for various fields in exercises: Details of field Field values Account currency USD Account group for vendor (int. number assignment) KRED Assessment Cele Assessed Costs AType category – manual entry, manual allocation 1 Activity Unit HR Chart of Accounts GL00 CElem category Primary costs/Cost reducing revenues Company code US00 Controlling area NA00 Cost centre category H Country (vendor record) US Payment Terms – Payable immediately due net 0001 Price Indicator – plan price automatically based on activity 1 Receiver Cost centre group To be determined Receiver Rule To be determined Sender Rule Posted amounts Sorting key (posting date) 001 Stat. Key figure unit measure (to be determined – one of three) AU or M2 or HR --oOo--
学霸联盟