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)

Answer 1

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