please enlarge to view

The blue boxes are included in the data boxes

Conestoga College Bookstore, a campus bookstore, shows the following sales projections in units by quarter for the upcoming year. E (Click the icon to view the unit sales projections.) E: (Click the icon to view the average price information.) Requirement 1. Prepare a sales budget for the upcoming year by quarter for Conestoga College Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous). Requirement 1. Prepare a sales budget for the upcoming year by quarter for Conestoga College Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous). Complete the sales budget, one product at a time Conestoga College Bookstore Sales Budget For the upcoming Year Q1 Q3 Year Books: Unit sales Unit price Book revenue School supplies Unit sales Unit price School supplies revenue Apparel Unit sales Unit price Apparel revenue Miscellaneous Unit sales Unit price Miscellaneous revenue Total sales revenue hits by qu . i 0 Data Table Data Table -X The average price of an item in each of the departments is as follows: Quarter Books be Books 1st School Supplies Apparel Miscellaneous 270 510 680 180 320 580 250 880 810 1,580 810 1,710 2nd Average sales per unit $87 $11 3rd 4th 640 160 520 440 Books School Supplies Apparel Miscellaneous $24 $5 Print Done lar