I need to prepare a budget one product at a time for the following:

the last photo is an example of what i am expected to answer and what format.

books

school supplies

apparel

Miscellaneous

Data Table The average price of an item in each of the departments is as follows: Average sales price per unit Books.... School supplies $89 $12 $26 Apparel ..... Miscellaneous $8 A Data Table Quarter Books School Supplies Apparel Miscellaneous 250 520 1st 2nd 3rd 670 590 170 380 1,560 870 1,750 600 290 830 870 500 4th 190 420 (Click the icon to view the average price information) Boise 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) Requirement Prepare a sales budget for the upcoming year by quarter for the Boise Bookstore with sales categorized by the four product groupings (books, school supplies, apparel and miscellaneous) Complete the sales budget one product at a time Boise Bookstore Sales Budget For the Quarters in the upcoming Year 01 02 03 04 Year Books Unit sales Multiply by Unit price Book revenue Enter any number in the edit fields and then click Check