Mini Project Specifications Semester 1/2018


Objective

To develop a machining cutter tools vending machining system using Python. Through the system, customers can view the tools menu, check the availability, tools details, and purchase tools through the systems. The following are the required specifications: –


Part 1 (70% of total marks)

1. Cutter tools are categorized by “End Mill Cutter”, “Bull Nose Cutter”, “Ball Nose Cutter”, “Twist Drill”. You should provide minimum 6 items for each category.


2. When customer select a tool, the system need to show the detail descriptions including price and available quantity to order. Customer are allow to place an order for the tools by providing the desired quantity or enter ‘0’ to return to the main menu.


3. Program should allow the customer to select multiple tools before confirming order. Once the customer completes adding the item to the shopping chart, customer will proceed to check out the shopping cart. Upon checked out, customer are allow to view the summary of shopping cart before confirm the order. The summary list should include the list of selected tools, order quantity, and total price. Upon viewing the summarized shopping cart, customer also allow to remove any of the item until the order is confirmed no changes are allowed.


4. After confirmed on the order list, customer will proceed to payment. Customer will be prompt whether customer has a member card. If yes, there will be a 15% off the total order amount (before GST). The customer will be presented with a formatted bill with summary list of all purchased tools, ordered tools and total price. The bill should also reflect the member discount if is applicable, 7% GST and final payable amount.


5. After every successful payment, the availably quantity for each tool should be updated, system admin must be able to run and show a system ‘Overview Report’ which should the latest available tools and quantity in the system


6. As an overview, the system should consist of the basic requirements of :


· Home page of 4 tools category

· List of tools in each category

· Detail of each tool upon selection (description, available quantity, and price)

· Shopping cart summary page with all selected item and order quantity

· Checkout formatted bill with member discount if applicable, 7% GST and final payable amount.

· System ‘Overview Report’ which should the latest available tools and quantity in the system.



Part 2 (30% of total marks)

1. (Arduino Integration)

· When customer added item(s) to the shopping cart in Part 1 (2), green LED perform a short blink for 5 seconds.

· When customer input ‘0’ to the order quantity (return to main menu) in Part 1(2), red LED perform a short blink for 5 seconds.

· When customer checked out the shopping cart, Green LED remain ON till the entire transaction is completed.

· After confirmation of payment, buzzer will buzz for 5 second.


2. (Data Analytics with Panda)

When customer confirmed order in Part 1 (4) above, each ordered item relevant details (tool category, tool name, order quantity, discount flag and billed amount) should be stored into a data/frame table. When user selects the “Customer Order Report” in the menu, you should do analytics to show the following:-

· Plot a chart to show the number of tools ordered in each category

· Plot a chart to show the total ordered value for all tools

· Plot a chart to show the proportion of discounted orders against total orders

Requirement and Assessment
Project Group

· You are required to work in a project group consisting of NOT more than 3 to 4 persons. No individual project. Members of the group MUST work together (and understand) all parts of the specification/solution. Individual member will also be accessed separately, and marks will be allocated based his/her on understanding of the delivered product.


Submission

· You need to submit a SHORT report (not more 5 pages) detailing the overall design and operation of your program. Include a copy of your program source code when submitting your report.

· Submission Deadline: Week 16/17.


Assessment

· This mini-project constitutes 30% of the overall marks for the module.

· Progress/Interim assessment will be held in Week 11 and 13. You should show substantial work done during these interim assessments. Marks may be deducted if the work done is deemed not sufficient.

· You are required to do a presentation of your program/product to the class. The schedule presentation is during the lab session in Week 16/17.

· Marks will be given based on the achieved functionality, ease of use, project presentation skills and report. Questions will be pose to individual member of the group to assess his/her understanding of the work.



End Mill Cutter


image.png




Name

Description

Price (SGD)

VC2JSD0600

Dia6, Length 60, FLength 20

40.00

VC2JSD0800

Dia8, Length 70, FLength 25

45.00

VC2JSD1000

Dia10, Length 90, FLength 30

47.00

VC2JSD1500

Dia15, Length 110, FLength 40

55.00

VC2JSD1800

Dia10, Length 110, FLength 50

58.00

VC2JSD2000

Dia20, Length 110, FLength 55

60.00

VC2JSD2200

Dia22, Length 140, FLength 65

65.00


Bull Nose Cutter


image.png





Name

Description

Price (SGD)

CSRARBD10000R100

Dia10,RE1, Length 75, Flength 12

38.00

CSRARBD10000R200

Dia10,RE2, Length 75, Flength 12

38.00

CSRARBD16000R200

Dia16,RE2, Length 100, Flength 18

42.00

CSRARBD16000R300

Dia16,RE3, Length 100, Flength 18

42.00

CSRARBD20000R200

Dia20,RE2, Length 125, Flength 25

55.00

CSRARBD20000R300

Dia20,RE3, Length 125, Flength 25

55.00

CSRARBD25000R500

Dia25,RE5, Length 125, Flength 30

72.00



Ball Nose Cutter

image.png



Name

Description

Price(SGD)

VF2SBR0200S04

Dia4, Length 60, FLength 4

42.00

VF2SBR0300S06

Dia6, Length 80, FLength 12

44.00

VF2SBR0400S08

Dia8, Length 90, FLength 14

48.00

VF2SBR0500S10

Dia10, Length 100, FLength 18

50.00

VF2SBR0600S12

Dia12, Length 110, FLength 22

52.00

VF2SBR0800S16

Dia16, Length 140, FLength 30

54.00

VF2SBR1000S20

Dia20, Length 160, FLength 38

60.00

image.png


Name

Description

Price(SGD)

S225OL55FL22D004

Dia4, Length 55, FLength 22

12.00

S225OL62FL26D005

Dia5, Length 62, FLength 26

13.00

S225OL66FL28D006

Dia6, Length 66, FLength 28

14.00

S225OL74FL34D007

Dia7, Length 74, FLength 34

16.00

S225OL79FL37D008

Dia8, Length 79, FLength 37

17.00

S225OL84FL40D009

Dia9, Length 84, FLength 40

18.00

S225OL89FL43D010

Dia10, Length 89, FLength 43

21.00