Elite Souvenirs provides high-end souvenir items to tourists visiting San Pedro Town. Elite Souvenirs shows the following sales projections in units by quarter for the upcoming year.

Quarter	T-Shirts	Key Holders	Caps	Miscellaneous
1st	1,580	260	520	620
2nd	890	110	380	510
3rd.	1,790	280	870	800
4th.	610	160	560	450

The average price of an item in each of the departments is as follows:

	Average sales per unit
T-Shirts.	$84
Key Holders	$19
Caps.	$23
Miscellaneous	$8

Requirement:

Prepare a sales budget for the upcoming year by quarter for Elite Souvenirs, with sales categorized by the four product groupings (t-shirts, key holders, caps, and miscellaneous) and all final totals reflected.( show all formulas and working Out )