E9-17A (similar to): Sales Budget Houston 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: Quarter Books School Supplies Apparel Miscellaneous 1st 1,550 270 540 630 2nd 830 130 340 570 3rd 1,740 | 260 820 810 4th 640 100 510 450 The average price of an item in each of the departments is as follows: Average sales price per unit Books School Supplies $17 Apparel $23 Miscellaneous $6 Requirement: Prepare a sales budget for the upcoming year by quarter for the Houston Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous). $85