Evaluate if the caf should charge a fee of $0.25 per transaction for credit card purchases under $1.25, considering the gain from fees, assuming a profit margin of 40% of total sales and an estimated 30% in lost sales (for items $1.25 or less). Is there any potential gain worth the possibility of loss of customers?

Would need to see how this would be done on Excel too please.