Reference no: EM132905112
CIVN 2014A Engineering Computing - School of Civil and Environmental Engineering
PROGRAMMING PROJECT
Task:
Design a 1 page (maximum) algorithm (Project Part A) (pdf, jpeg) and Microsoft Excel Macro-Enabled file of the Vending Machine described below (Project Part B). The Microsoft Excel Macro-Enabled file containing worksheets and VBA code would dispense products (Table 1) whose prices are specified in Table 2.
Table 1. Products and product codes
|
|
1
|
2
|
3
|
4
|
|
1
|
Simba cheese and onion Product code: 11
|
Simba Nik Naks Product code: 12
|
Fritos corn chips Product code: 13
|
Lays Product code: 14
|
|
2
|
Doritos Product code: 21
|
Eet sum mor Product code: 22
|
Diddle Daddle Product code: 23
|
Oreo Product code: 24
|
|
3
|
Snickers Product code: 31
|
Bar One Product code: 32
|
Kit Kat Product code: 33
|
Lunch Bar Product code: 34
|
|
4
|
Coca-Cola Product code: 41
|
BonAqua Product code: 42
|
Fanta Grape Product code: 43
|
Twist Product code: 44
|
Table 2. Prices
|
|
1
|
2
|
3
|
4
|
|
1
|
R 10.00
|
R 10.00
|
R 10.00
|
R 10.00
|
|
2
|
R 10.00
|
R 5.00
|
R 5.00
|
R 10.00
|
|
3
|
R 10.00
|
R 10.00
|
R 10.00
|
R 10.00
|
|
4
|
R 15.00
|
R 10.00
|
R 15.00
|
R 15.00
|
Project Part A
Project Part B
- Structure of VBA code
- Use of comments
- Innovative and user-friendly
Your developed VBA code would undertake the following tasks after the customer clicks the ‘Purchase a product' button located on the customer's worksheet:
a. Worksheet for the Customer:
i. Receive the customer's selected product code. Confirm and display the customer's selected product and the price of the product.
ii. Receive the customer's money, which may be input in one or more of the denominations shown in Table 3. The vending machine will only accept the following denominations: R20, R10, R5, R2 and R1
iii. Flag any input error.
iv. Flag any processing error.
v. Inform the customer if the selected product is unavailable. If unavailable, another product may be selected.
vi. Inform the customer if money change for the selected product is unavailable. If unavailable, another product may be selected.
vii. Monies accepted for purchases will not be added to the monies allocated for change.
viii. Prevent (and inform) the customer from receiving a product if the total of the monies input by the customer is less than the selected product price.
ix. Dispense the selected product without change if the total of the monies input by the customer is equal to the product price OR dispense the product with the correct change in specified denominations should the total of the monies input by the customer be more than the product price.
b. Worksheet for the Owner of the vending machine:
x. After each transaction, calculate and display the change in the different monetary denominations remaining in the machine.
xi. After each transaction, calculate and display the quantity of each product remaining in the machine.
xii. Include a button on this worksheet that permits refreshing. Immediately after refreshing, there are 10 number of each product within the vending machine. Also, immediately after refreshing, the vending machine has the following quantities of each monetary denomination allocated for change (Table 3).
Table 3. Monies allocated for change in the vending machine immediately after refreshing
|
Denomination
|
R20
|
R 10.00
|
R 5.00
|
R 2.00
|
R 1.00
|
|
Total number
|
50
|
50
|
50
|
75
|
100
|
Attachment:- Engineering Computing.rar