ERP012- Project: One Month, All Processes In A Pizza Making Factory

Part 1–Accounting / Treasury / Asset / HR / Attendance / Payroll / Inventory / Production –6 Sessions

1.Accounting System Initializing

  • Chart OF Accounts & Unique-ID Definition
  • Base Tables & References Definition
  • Opening Journal: Including Capital/Bank/ 3 Stockholders/ Loans
  • Treasury System Initializing
  • Receive Checks & Cash from Investors
  • Deposit Due Checks to Banks

2.Asset System Initializing

  • Purchase Headquartered Office Building & Equipment & Furniture & Computer Stuffs
  • Purchase Factory Ground & Ready for Operation Plant Including
    • Office Building, Production Hall, Material & Product Stores
    • Machinery, Installation, Equipment, Vehicles  From many Vendors
  • Pay 10% Cash & 3×30% AP to all Vendors
  • Report Assets & Compare with Balance Sheet

3.HR & Attendance System Initializing

  • Hire 3 Full time & 7 Part time Employee
  • 3 Months Contract with Employees, 4 for HQ (1F,3P) and 7(2F,4P) for Factory
  • Define 4 Different Shifts & Schedules & Assign Employees to the Shifts
  • Enter 2 Weeks Attendance For Them
  • View & Generate Attendance Report

4.Payroll System Initializing

  • Pay Advance & Loan to 4 Employees
  • Calculate & Print Monthly Payroll list
  • Print Pay stubs with Pictures
  • Enter Payroll Accounting Journal in Detail of Cost-Centers & Employees
  • Print & Deposit Payroll list & Pay a Check to Bank for It
  • Enter Payment Accounting Journal

5.Inventory System Initializing

  • Define Code Patterns for Raw Material & Products
  • Generate Non-FIFO Codes For 10 R.M & 4 Products
  • Define BOM for Products with Consumption Factors & Person/ Seconds in 3 Cost-Centers
  • Purchase Multi Costs Raw Materials From 4 Suppliers
  • Return Some Defective Items to 2 Suppliers
  • Auto Move R.M to P.H Via BOM Report for 4 Products

6.Production System Initializing

  • 4 Contracts With Production Hall, 4 Products Each a Week with Twice Per Week Delivery Scheduling
  • 8 Entry of Products in Production Hall
  • 4 Quality Control Audit Forms
  • 8 Receipted of Products with Cost & Corresponding Consumption Stock Issues With R.M Fees in P.H
  • 4 Move From P.H to Product Store
  • Stock & Store Validity Balance Test

Part 2–Sale / Accounting Common & End of Month Journals / Managerial Reports’ Booklet –6 Sessions

7.Sales System Initializing

  • 2 Contracts With 2 Customers, 4 Products With Monthly Delivery Scheduling
  • 2 Bank Deposit 10% Pre Receive Each Customer
  • 2 Kanban: 2 Customer/Delivery Every 2 Days Each
  • 30 Daily Ship From Deliver Product to Customers
  • 30 Daily Invoice Auto Tax & Price from Contracts
  • 30 Journal Accounts for Invoices

8.Invoice Collection Analyze

  • Receive 10 Checks & 10 Cash & 10 Bank Deposit, Each With Different Dates During A Month From Customers & Assign Each to Invoices
  • Collection Report: Invoice by Invoice Balance
  • Customer Transaction Report from Accounting Group by Invoice# and Compare both Results
  • Integrity Balance Test & Reconciliation : Accounting & Inventory & Invoices & AR & AP

9.Journal Accounts: Daily & Monthly

  • Pay Utility Bills: Tel & Internet & Electric & Gas & Trash in Various Dates By Bank
  • Pay Cash for Purchase: Foods & Tea & Coffee & Office Supplies  & Post
  • Depreciation Journal at End of Month
  • Monthly Cost/Save Adjusting Auto-Journal
  • Balance Test & Confirm All Journals

10.Managerial Reports’ Booklet 1

  • 1-Colmnu & 2-Colomns  Balance Sheet
  • 12 Month Comparative M-L-F Balance Sheet
  • Briefing Reports: Multi-Level Balance Summary Reports For Each Amount in both Balance Sheets
  • Multi-Level 4 Columns Trial Balance
  • Unique-ID Balance-Summary Report
  • Referential-Summary Balance Report
  • Journal’s Control Codes Report

11.Managerial Reports’ Booklet 2

  • Monthly & Yearly: Cost of Goods Sold Table
  • Comparative AR/AP/Cash Report
  • 3,6,12 Months Lack & Surplus Cash Report
  • Inventory List Reports: Instant & Transaction
  • Buy/Sell Comprehensive Periodic Report
  • Contract: Balance & Extension Report
  • Asset Comprehensive Reports Group by Place & Category

12.Managerial Reports’ Booklet 3

  • HR Organizational Chart/Unit Cost
  • Attendance Conditional & Periodic Reports
  • Attendance Sum Report (Absent / Present / Overtime  / Operational ) / Group By Person
  • BOM: R.M Deficit/Surplus Stock Analyze Report
  • Comparative Monthly Graphs for Each Product’s Unit Including
    • No of Production, No of Sales, Amount of Sale
    • Material, Labor, Overhead, Cost of Goods Sold, Profit/Lose