Question: This is strictly individual work, no teamwork allowed. Modify the order-placing program from today's class to implement the unit price schedule shown in Table 1


This is strictly individual work, no teamwork allowed. Modify the order-placing program from today's class to implement the unit price schedule shown in Table 1 below (the VBA code to be modified is on pages 22-23 from the DSS notes on Husky CT). Submit your answer via Husky CT in a module inside a Macro- Enabled Excel file. Order Size From To less than 0 50 50 Price per Unit $2.00 $1.50 $1.00 $0.50 $0.25 $0.20 100 100 500 1000 2000 Infinity 500 1000 2000 Table 1. Sub PlaceOrderi (). 'If order size price is $2 'If order size >=100 -> price is $1.50 Dim UnitPrice As Double Dim OrderSize As Double Dim Total Cost As Double = OrderSize = InputBox ("Enter order size") If OrderSize
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
