a$)$ Karl$$s Coffee shop has had the following transactions during the Goods and Service Tax $($GST$)$ period of March to June $2022.$

In the TMP Excel spreadsheet calculate the GST paid and the GST collected in each of the following transactions. Use formulas to calculate your answers.

In your answers show your calculations.

i$.$ Bought goods for $$3,905$ GST inclusive

ii$.$ Sold goods for $$22,726$ GST inclusive

iii. Sold goods for $$1,420$ plus GST

iv$.$ Bought goods for $$6,390$ plus GST

b$)$ Following on from Question $1,$ for the period March to June $2022,$ calculate the amount payable to the Australian Taxation Office in the TMP Excel spreadsheet:

GST collected on sales

Less GST paid on purchases

Equals GST Payable to ATO