Looking for a VBA flowchart
2. Zamco's Discounts. Assume you have been asked to develop an algorithm to calculate the discounts that apply to retail customer purchases from Zamco's Department Stores. An example spreadsheet is given and described below. There are two types of discounts: (1) when a storewide sale is in effect for all customers and (2) when a customer 1 signs up for a Zamco credit card. In each case, a check is placed in the appropriate box in the spreadsheet to the right. When a discount-status box is checked, it reflects that that discount applies (is True, in Boolean terms). When a discount-status box is not checked, it reflects that that discount does not apply (is False, in Boolean terms).7 Zamco Discount Calculator Variable Inputs Names Amounts PDT 1000.00 CDStatus 4 Pre-discount total Credit-card discount status 5 6 Calculate Outputs 8 Storewide discount amount SDA CDA Net 100.00 180.00 720.00 9 Credit-card sign-up discount amount One or both discounts can be selected Assume that your algorithm will only be used when at least one of the discounts apply. So assume that at least one discount will apply when this process is used. The Storewide Discount Rate (SDR) and the Credit Card Signup Discount Rate (CDR) are also stored in the setup section. 10 Net sale amount 12 Setup SDStatus SDR CDR Storewide discount status 13 14 Storewide discount rate 10% 20% 15 Credit-card sign-up discount rate The Pre-discount Total Amount (PDT) is input for each sale. The manager adds a checkmark to the Setup section for the storewide discount for days when the discount applies before the store opens, so it only needs to be done once for the entire day; that way, the clerk does not have to do this. The clerk adds a check mark if the customer has signed up for a store credit card. The table below shows which discounts apply in three different discount scenarios: Scenario Discount Type Variable Name 1 2 3 True True True False Storewide discount status SDStatus Credit card discount status |CDStatus False True 2. Zamco's Discounts. Assume you have been asked to develop an algorithm to calculate the discounts that apply to retail customer purchases from Zamco's Department Stores. An example spreadsheet is given and described below. There are two types of discounts: (1) when a storewide sale is in effect for all customers and (2) when a customer 1 signs up for a Zamco credit card. In each case, a check is placed in the appropriate box in the spreadsheet to the right. When a discount-status box is checked, it reflects that that discount applies (is True, in Boolean terms). When a discount-status box is not checked, it reflects that that discount does not apply (is False, in Boolean terms).7 Zamco Discount Calculator Variable Inputs Names Amounts PDT 1000.00 CDStatus 4 Pre-discount total Credit-card discount status 5 6 Calculate Outputs 8 Storewide discount amount SDA CDA Net 100.00 180.00 720.00 9 Credit-card sign-up discount amount One or both discounts can be selected Assume that your algorithm will only be used when at least one of the discounts apply. So assume that at least one discount will apply when this process is used. The Storewide Discount Rate (SDR) and the Credit Card Signup Discount Rate (CDR) are also stored in the setup section. 10 Net sale amount 12 Setup SDStatus SDR CDR Storewide discount status 13 14 Storewide discount rate 10% 20% 15 Credit-card sign-up discount rate The Pre-discount Total Amount (PDT) is input for each sale. The manager adds a checkmark to the Setup section for the storewide discount for days when the discount applies before the store opens, so it only needs to be done once for the entire day; that way, the clerk does not have to do this. The clerk adds a check mark if the customer has signed up for a store credit card. The table below shows which discounts apply in three different discount scenarios: Scenario Discount Type Variable Name 1 2 3 True True True False Storewide discount status SDStatus Credit card discount status |CDStatus False True
