E9-18A Sales budget for a retail organization (Learning Objective 2) Johnston Bo
ID: 2542061 • Letter: E
Question
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)Explanation / Answer
Sales Budget for Johnson Bookstore:
Quarter Product Quantity Price Value
1st Books 1570 85 133450
School Supplies 200 18 3600
Apparel 580 29 16820
Miscellaneous 690 6 4140
Total 3040 158010
2nd Books 800 85 68000
School supplies 190 18 3420
Apparel 330 29 9570
Miscellaneous 540 6 3240
Total 1860 84230
3rd Books 1790 85 152150
School Supplies 240 18 4320
Apparel 880 29 25520
Miscellaneous 890 6 5340
Total 3800 187330
4th Books 670 85 56950
School supplies 180 18 3240
Apparel 540 29 15660
Miscellaneous 440 6 2640
Total 1830 78490
Total budget for the year 10530 508060
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.