The third annual mini bazaar at the Golf Tournament was a tremendous success! There were three booths for the event: a booth that sold t-shirts for 10.00 each, a booth that sold souvenir items at 3.00 each, and a booth that sold caps and hats for 6.50 each.

Cost of the items sold amounts to 5.00 for the t-shirts, 2.00 for souvenir items and 4.50 for the caps and hats.

Total quantities sold for each item are as follows: t-shirts at 280 pcs, souvenir items at 558 pcs, caps and hats at 320 pcs. A rental fee of 450.00 was paid to the Golf Club where the event was held. Six (6) personnel were assigned to man the booths who reimbursed 15.00 each for snacks.

Create a spreadsheet with the appropriate labels, data, formulas and formatting for the details stated above.

Then, please answer the following questions below:

1. How much profit and gross margin based on sales did each item make?

2. What was the total sale of the mini bazaar?

3. How much was the total net earnings of the fund raiser?