[UAT Release] Profit Maximization Tool

Changelogs

• Tested by Group 4 (GoVLê) on June 8, 2022
• Added new sample file

The New sample files

• NewSampleFiles.zip

Profit Maximization Tool

Sprint 5

start date: May 2, 2022

end date: May 13, 2022

Use cases accomplished in sprint 5

• UC7-S1: Business owner views the profit chart

Changelog in sprint 5:

• Added search functionality for products, inventory, sales, and production table

• Changed font styles of new links

• New background for landing page

• Improved edit profile page

• Added ability to set profile picture

• Added chart in dashboard and profit tracker tab

• Inventory total and daily units is updated based on current day's production record

• New background

• Redesigned success and error prompts

• More UI change

Files used for testing

sprint-5-files.zip

Profit Maximization Tool

Sprint 4

start date: April 18, 2022
end date: April 29, 2022

Use cases accomplished in sprint 3

• UC6-S1: Business owner uses the profit optimizer tool

Changelog in sprint 4:

• Optimize profit button works now
• Quantity of products that must be produced (and sold) to obtain Optimal profit for the day is computed and displayed
• The suggested result of Profit Optimizer can be added to Production table if the user wants to
• Suggested quantity of products to be produced takes into account the top selling products according to Sales Table

Profit Maximization Tool

Sprint 3

start date: March 21, 2022

end date: April 1, 2022

Use cases accomplished in sprint 3

• UC3-S3: Business owner inputs existing sales database

• UC3-S4: Business owner inputs existing production database

• UC3-S7: Business owner tries to input existing sales database but uses the wrong file

• UC3-S8: Business owner tries to input existing production database but uses the wrong file

Changelog in sprint 3:

• Added ability to upload csv file for Sales database

• Added ability to upload csv file for Production database

• Added prompt for invalid Sales database file upload

• Added prompt for invalid Production database file upload

• Added ability to manually add, edit, and delete Sales record

• Added ability to manually add, edit, and delete Production record

• Sales record revenue is automatically computed based on Production table

• Production record Expenses is automatically computed based on Products and Inventory tables

• Improved the interface for adding/editing new or existing ingredients and their costs for Product records by adding dropdown box for ingredient names

• UI Improvements

  • submit buttons

  • tables

  • overlays

  • scrolling

• Code refactoring (less messy code)

• Revamped the format for Products database csv file

Test files

• productsdb.csv
• inventorydb.csv
• salesdb.csv
• productiondb.csv

Profit Maximization Tool

Sprint 2 release

start date: March 7, 2022

end date: March 18, 2022

Use cases accomplished in sprint 2

• UC3-S1: Business owner inputs existing products database

• UC3-S2: Business owner inputs existing inventory database

• UC3-S5: Business owner tries to input existing products database but uses the wrong file

• UC3-S6: Business owner tries to input existing inventory database but uses the wrong file

Changelog in sprint 2:

• New Dashboard with sidebar

• New Products Page

• New Inventory Page

• New Profile Page

• Ability to change Name and Business Name

• Ability to upload csv file for Products database

• Added prompt for successful uploading of file

• Added prompt for invalid type of file uploaded

• Ability to upload csv file for Ingredients database

• Contents of Products database are displayed in Products Page

• Contents of Ingredients database are displayed in Inventory page

• Added the ability to manually add, edit, or delete a Product record

• Added the ability to manually add, edit, or delete an Ingredient record

• A Product's cost to manufacture is automatically computed based on Ingredients database

Attached files

• inventory.csv (contains details about products of business)
• productsdb.csv (contains details about supplies or ingredients of the products)

Profit Maximization Tool

Sprint 1 release (started on Feb. 21, 2022)

Use cases accomplished:

• UC-1.0-S1: Business owner successfully signs up for an account
• UC-1.0-S2: Business owner successfully logs into account
• UC-1.0-S3: Invalid Username
• UC-1.0-S4: Invalid password
• UC-1.0-S5: Username not available

Features implemented so far:

• Users can sign up for an account and fill in asked information
• Users can login using registered account
• Upon successful sign up or login, users are redirected towards home page with logged in status
• Users are prompted with an error if the password they used for logging in is incorrect
• Users are prompted with an error if the username they input during sign up is already taken

Files attached

• Sprint 1 Testing.pdf (shows step by step run of the web application)
• Profit-Maximization-Tool-main-v1.zip (this contains the source code)
• requirements.txt (contains project's dependencies)