Enterprise Resource Planning
Assignment
The assignment requires students to vary the setup of their Dynamics AX application to meet different business reporting and process requirements to those established in the laboratory exercises.
Learning outcome/s and Graduate Attributes
Completing this assignment will help you achieve the following learning outcome/s and ECU Graduate Attributes: Apply the navigation and systems operation features of Microsoft Dynamics AX as an example of enterprise software
- Model the business components and major modules in ERP applications to business processes.
- Appraise how enterprise software is used in organisations.
- Explain the finance functions of general ledger, purchase ledger, sales ledger and how they integrate.
Assignment instructions
For this assignment you are required to establish the following in Dynamics AX:
Assignment instructions
For this assignment you are required to:
Post to the following General Ledger Accounts.
|
14000
|
Sales printers
|
|
24000
|
COGS Printers
|
|
63180
|
Inventory Printers
|
|
64300
|
Accounts receivable Euro
|
|
73300
|
Supplier Assignment 1
|
- Create a new Australian supplier called Assignment1 and link the supplier to the Australian vendor group.
- Establish a Euro currency with a conversion factor of .68 Euros to an Australian dollar.
- Create a new customer called Assignment1 as an organisation based in France and link to a new customer group called French and the currency called Euro.
- Create a new item of Printer and establish the purchase price at $220 and sales price at $400
- Purchase printers from supplier Assignment1.
- When the printers are purchased the GL Inventory Printers account should be debited and the GL Supplier Assignment 1 account credited.
- When a printer is sold to Assignment1 the Accounts Receivables Euro account should be debited, the inventory printers credited, COGS Printers debited and sales printers credited.
- Process at least one purchase and sales order.
Assignment 2
The assignment requires students to vary the setup of their Dynamics AX application to meet different business reporting and process requirements to those established in the laboratory exercises.
- Construct an MRP, just in time and MRPII schedule.
- Distinguish how ERP applications support logistics planning.
Preparation
Before starting this assignment, you should have finished all labs
Assignment instructions
For this assignment you are required to establish the following in Dynamics AX:
Materials Requirement Planning
Create the following BOM for laptop.V.1024.19
Laptop Keyboard
Laptop Case
Laptop Battery LED2
Processor2
Ribbon Cable
RAMGB2
The BOM has a quantity of 1 of each item.
Please set up the system to represent the following:
- The Laptop case stock should be maintained with a minimum stock level of 300 and a maximum stock level of 500.
- The batteries should be purchase forecast at 200 a week for 3 months.
- Processor2 should be purchase forecast over 3 months for a quantity of 2000 with a breakdown of weeks from 1 - 13 with the following percentages: 7%, 6%, 6%, 7%, 8%, 8%, 8%, 9%, 8%, 9%, 9%, 8%
,7%.
- The laptop should have a sales forecast of 100 per fortnight for 2 months.
- The planned supplier orders for the RAM16GB should be grouped into four weekly intervals.
You can identify your own purchase and sales prices.
Your system at the time of assessment should be set so that when an order of 50 laptops is taken the Forecast Schedule and the Master Production Schedule will create a requirement of 50 plus the correct output for the above.
Materials Resource Planning
The Laptop should have the following production route.
|
Operation
|
Work Centre Group
|
Work centre
|
Qty per hour
|
Cost Per Hour
|
|
Components
|
Human
|
Component
|
14
|
As lab.
|
|
Plug
|
Human
|
Cable
|
10
|
As lab.
|
|
FitLap
|
Human
|
Final Fit
|
8
|
As lab.
|
|
InstallScreen (New)
|
Human
|
LaptopScreen (New)
|
20
|
140
|
|
TestLap
|
Human
|
Test
|
6
|
As lab.
|
|
PackLap
|
Human
|
Pack
|
14
|
As lab.
|
The LaptopScreen work centre works 8 hours a day Monday to Friday and does not operate Saturday and Sunday. A new calendar will need to be created and linked to the LaptopScreen Work Centre.
The production should be standard costed at $1200 with a variance posted to a GL account. The actually accounts that are posted to in the GL will not be marked - they do not have to be correct.
When the laptop is manufactured each finished product should be given a unique serial number from a number group of Lap.