Reference no: EM132631543
Assignment - Project Brief for Sunrise Super Market Procure to Pay
Project Definition -
Client: Sunrise Super Market
Indian Grocery
Parramatta
Background - Sunrise Super Market is an independent Asian grocery store located in the heart of Western Sydney, catering thousands of households with their day-to-day needs such as grocery, vegetables, fruits, frozen packed food and hot food. We also maintain a large warehouse to replenish our stock every day to minimise customer disruption. We provide the best customer service and experience for all walk-in customers and attract them to visit again with our fantastic offers changing every week.
Due to the tremendous turnover in the business with online shopping, Mobile shopping, and walk-in customers, there is a need to maintain our stock levels in the warehouse and on the shelves for efficient sales. The need for a full-fledged software has emerged to meet our customer requirements and balance the suppliers.
Project Objective - This Project aim is to build an online procure to pay system enabling the store to place orders with the suppliers based on the schedule of agreement rates while acknowledging the lead times to deliver, Goods receipt, Invoice receipt, and process the invoice based on the payment conditions which may vary for each supplier. Weekly trend analysis from the store on consumption is the basis for materials requirements planning (MRP) to raise a purchase order with the supplier.
Desired Outcomes -
1. Based on the Trend analysis and forecast for materials procurement MRP generated.
2. Provision for the Store manager to approve or reject all or few items on list.
3. Generate a PO once the store manager has approved the list.
4. Automation of emailing a PDF copy of the purchase order to the supplier email address
5. Send email and SMS reminders to the supplier of the outstanding orders.
6. Goods receipting the materials to the warehouse goods holding area.
7. Quality check Pass from goods holding area to warehouse or return to supplier.
8. Stocking the quality checked materials in the respective bins.
9. Verify and approve the supplier invoice.
10. Process payment button to link to the bank portal.
11. Process online payment (Offline), Generate payment receipt and store against Invoice and PO.
12. Track picklist from warehouse to store.
13. Generate cycle stocktake list weekly, wall to wall stocktake monthly
14. Run report for stock, Provide stock adjustment ability only for Store Manager.
LIST OF ALL THE PAGES/SCREENS WITH ALL THE FEATURES -
1. Main page
- Logo
- Sign in: Access control with 2 step- verification for sign-on
- Main menu
1. Suppliers → Materials
2. Goods Receipt
3. Invoice Receipt
4. Process Payment
5. Material by Bin location
6. Pick list from warehouse to Store to record staff details
7. Stocktake
1. Cycle count
2. Wall-to-wall count
3. Stock adjustment
Project Scope
1. Create end-to-end process maps using a BPMN tool explaining the details of each step in the process using RASCI model, agree with Client on process, and follow through the blue print on development.
2. Design of the system should ensure that the developed system can be scaled for future enhancements
3. Maintain Stock data within the database linked each product
4. Implement a notification mechanism that sends email alerts and SMS notifications to store manager and supplier.
Administration
- Maintain Stock quantity details
- Maintain updated price details on schedule of agreement
- Maintain Inbound Delivery Schedule and send reminders SMS to supplier
- Password change option for all users
Improve Scheduling & Tracking Data
- Track orders
- Track Delivery Schedules
- Generate daily / weekly / fortnightly/ monthly reports for Orders and Delivery Schedules along with non-conformances/ missed target times.
Constraints and Assumptions
- Agile Methodology will be practiced to understand the business requirements better to deliver quality product
- Penetration and or security recommendations will be provided at the end of the project
Key Users
- Store Manager
- Warehouse Manager
- Store Assistants
Interface
- Provision to integrate the newly developed system with any future enhancements.
Project Structure
- Project team should determine the structure and internal roles according to Agile Methodology.
Project Testing by Dev team and signoff by Store Manager
- Perform User acceptance testing
- Perform system access testing with 2 way verification
- Conduct performance testing
- Conduct Product verification testing
Attachment:- Sunrise Super Market Project Assignment Files.rar