Question:
Is it possible to create Excel model that will calculate the daily profit given any order quantity and any realized daily demand? I need order quantity in one cell, and the daily demand should be entered in a second cell, and the model should calculate the daily profit in a third cell.
Cost Price is $1.20 each and selling price is $2.40 apiece
Units demanded goes from 25 to 40.