MSI has several reporting requirements for different areas in the company. Different management levels are interested in reporting on profitability, profit center, cost centers, and internal orders. Test the following scenarios.
Create two cost center reports, one for the Human Resources department and one for the Procurement department. (Both belong to the Finance and Administration business unit). Record the actual costs for the salaries-base wages for each department.
MENU PATH
Accounting>Controlling>Cost centers>Information system>Choose report
Double click on "Cost Ctr: Act/Plan/Variance
Enter the following information to view the Human Resources cost center report:
| Field Name | Input Data |
| Controlling area | 2000 |
| Cost Center | 2200 (Human Resources) |
| Fiscal year | 1997 |
| From period | 01 |
| To period | 01 |
| Plan version | 0 |
Select the following path to verify the Cost Element Group OASC is selected. OASC (object analysis sheet) provides a format with more detailed levels.
MENU PATH
Extras>Cost element selectn>Cost element group
Double click on the cost element group "OASC"
Select the enter icon to close the window
Select the Execute icon to run the cost center report.
Document the actual costs for salaries-base wages.
RESULTS
__________________________________________
Create the cost center report for the Purchasing department using the following data:
| Field Name | Input data |
| Cost center | 2300 |
| Fiscal year | 1997 |
| From period | 01 |
| To period | 01 |
| Plan version | 0 |
Select the Execute icon
Document the actual costs for salaries-base wages.
RESULTS
__________________________________
Create a cost center report for the entire Finance and Administration business unit using the data listed below. Document the actual salaries-base wages for this business unit.
MENU PATH
Accounting>Controlling>Cost centers>Information system>Choose report
Select Plan/actual comparisons
Double click on "Cost Ctr: Act/Plan/Variance
| Field Name | Input Data |
| Controlling area | 2000 (may default) |
| Cost center | blank |
| Cost center group | H3200 |
| Fiscal year | 1997 |
| From period | 01 |
| To period | 01 |
| Plan version | 0 |
Select the Execute icon.
RESULTS
Total salaries-base wages_______________________________________
Analyze the profitability of MSI's motorcycle product lines by creating a profitability analysis report and using the data below.
MENU PATH
Accounting>Controlling>Profit. analysis>Information system>Execute report
Enter the following data:
Set Operating Concern
| Field Name | Input data |
| Operating concern | IDEA |
| Type of profit analysis | costing based |
Select the Enter icon to continue
| Field Name | Input Data |
| Report | IDES-950 |
Select the Execute icon
| Field Name | Input Data |
| Product number | 1600-150 |
| Product number | 1600-250 |
| Product number | 1600-350 |
Select the Enter icon
Note you may receive a system message indicating "No summarization level available". Execute the report anyway.
Document the gross profit % for the 2500cc motorcycle
RESULTS
________________________________
Chart of Accounts
The accounting manager at MSI has determined that the operating chart of accounts used at MSI must include several new general ledger accounts. Verify that the general ledger used by the U.S. company has the necessary G/L accounts.
View the G/L accounts maintained the United States chart of accounts for MSI.
MENU PATH
Information system>Accounting>Financial Accounting>General ledger>Chart of account
Enter the following data:
| Field Name | Input Data |
| Chart of Accounts | CAUS |
Select the Execute Icon
Record the G/L account # for the Prepayment -loan fees account
RESULTS
__________________________
Create a G/L account for the common stock using the data below.
MENU PATH
Accounting>Financial accounting>General ledger>Master records>Create
| Field Name | Input data |
| Account number | 700XX |
| Company code | 3000 |
| Reference account number | 70000 |
| Reference company code | 3000 |
Select the enter icon.
| Field Name | Input Data |
| Short text | Common stock XX |
| G/L account long text | Common stock for group XX |
Select the Save icon
RESULTS
_______________________________________________
Post a document to the common stock account you created to test the document posting function.
MENU PATH
Accounting>Financial accounting>General ledger>Document entry>G/L account posting
| Field Name | Input Data |
| Document date | Today's date |
| Company code | 3000 |
| PstKy (Posting key) | 40 (debit entry) |
| Account | 113100 |
Select Enter icon
| Field Namw | Input Data |
| Amount | 2000000 |
| PstKy (Posting key) | 50(credit entry) |
| Account | 700XX |
Select the Enter icon
| Field Name | Input Data |
| Amount | 2000000 |
MENU PATH
Goto>Document Overview
Select the Save icon to post the document
RESULTS
Document #_________________________________
View the vendors assigned to the reconciliation account and determine if the master record you created appears there.
MENU PATH
Information system>Accounting>Financial accounting>Accounts payable>Account list
| Field Name | Input Data |
| Company code | 3000 |
Select the Dynamic Selections button
Enter the reconciliation account number 160000
Select the Save icon
Select the execute icon.
Scroll down and locate the vendor you created in the Procurement exercise.
G/L Posting Features and Analysis
MSI's controller performs a weekly review of general ledger account balances to find, research and correct any errors before month-end closing. The controller needs to be able to create account-level reports and access journal entries and line-item detail for each general ledger account.
Review the G/L Account Balances report using the data below. Record the account number and debit balance of the Office and Building Rent account
MENU PATH:
Information systems>Accounting>Financial Accounting>General ledger>Account balances
Enter the following data
| Field Name | Input data |
| Chart of accounts | CAUS |
| G/L account | 470000 to 470100 |
| Company code | 3000 |
| Fiscal year | 1997 |
| Reporting periods | 01-05 |
| Summarization level | 0 |
Select the Execute icon.
RESULTS
Account# for the Office and Building________________________________________
Debit Balance________________________________________
Review the individual posting of the Office and Building Rent account using the data below. Identify the line item that is inconsistent with the other month-end postings/ Record the document number, cost center, allocation field and amount in the space provided below.
MENU PATH:
Accounting>Financial accounting>General ledger>Account>Display line items
Enter the following data
| Field Name | Input Data |
| G/L account | Refer to the exercise immediately above |
| Company code | 3000 |
| Open items | X |
| Cleared items | X |
Click on the Selection criteria button and select Posting date
Select the Enter icon to continue
Enter 01/01/1995 to 05/31/1995 in the posting date fields
Select Enter two times
Place your cursor on the column heading "Doc No"
Select the Total icon
Look for the inconsisten amount and record your answer. You many have to drill down on that particular document for some of your answers.
RESULTS
Allocation ___________
Document number _____________
Amount _________________
Cost center _______________
From the line item display, drill down on the document you identified in the previous step. Display all line items for this document. Note the account number and account description for the off-set to the Office and Building account.
Drill down (double click) on the Document Number. You can display all line items by selecting the Overview icon.
Note the off-set to the Office and Building account. Document the account number and account description.
RESULTS
Vendor account # _________________
Vendor Account description ____________________________