E9-18A Sales budget for a retail organization (Learning Objective 2) Johnston 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: Books School Supplies Appare Miscellaneous Quarter 1st. 2nd 3rd 4th 1,570 800 1,790 670 200 190 240 180 580 330 880 540 690 540 890 440 The average price of an item in each of the departments is as follows: Books School supplies Apparel Average sales price per unit $85 $18 $29 S 6 Requirement Prepare a sales budget for the upcoming year by quarter for the Johnston Bookstore with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous)