Google Sheets Automation for Discounts

I need help on Google Sheets to automate quotations, calculations, specifically for discount, gst applications.

Requirements:
- Set up and implement automated quotations, discount application
- Utilize formulas, functions, and possibly macros

Ideal Skills:
- Proficiency in Google Sheets
- Experience with formulas, functions, and automation
- Attention to detail and accuracy