Tulsa Bookstore is the bookstore on campus for students and faculty. The bookstore shows the following sales projections in units by quarter for the upcoming year:

$($Click the icon to view the unit sales projections.$)$

$($Click the icon to view the average price information.$)$

Requirement

Prepare a sales budget for the upcoming year by quarter for the Tulsa Bookstore, with sales categorized by the four product groupings $($books$,$ school supplies, apparel, and miscellaneous$).$

Complete the sales budget, one product at a time.

Tulsa Bookstore

Sales Budget

For the Quarters in the Upcoming Year

$\backslash$table$[[$For the Quarters in the Upcoming Year$],[$Books:$],[$Q$1$ sales$],[$Multiply by: Unit price$],[$Book revenue$]]$

Data table

$\backslash$table$[[$Quarter$,$Books,School Supplies,Apparel,Miscellaneous$],[1$st dots...,$1,500,220,560,690],[2$nd$......,890,120,320,560],[3$rd dotsdots.,$1,710,230,860,800],[4$th dots...,$600,130,510,450]]$

Data table

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

$\backslash$table$[[$Books$,\backslash$table$[[$Average sales price$],[$per unit$]]],[$$$,86],[$School supplies,$$,18],[$Apparel$.,$$$,24],[$Miscellaneous $.,.$$$,5]]$