E9-17A (similar to) Question Help * Denver Bookstore is the bookstore on campus
ID: 2562955 • Letter: E
Question
E9-17A (similar to) Question Help * Denver 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: (Click the icon to view the average price information.) Requirement Prepare a sales budget for the upcoming year by quarter for the Denver Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous). (Click the icon to view the unit sales projections.) Complete the sales budget, one product at a time. Data Table Denver Bookstore Sales Budget For the Quarters in the Upcoming Year Quarter Books School Supplies Appare Miscellaneous 1,520 860 1,730 03 04 1st 600 170 200 120 300 3rd 800 890 Unit sales Multiply by: Unit price Book revenue 4th Print Done Data Table The average price of an item in each of the departments is as follows: Average sales price per unit $80 $18 $21 $6 School supplies Enter any number in the edit fields and then click Check AnswerExplanation / Answer
Sales Budget
Q1
Q2
Q3
Q4
Year
Books
Units Sales
1520
860
1730
640
4750
Multiply by: Unit Price
80
80
80
80
80
Book Revenue
121600
68800
138400
51200
380000
School Supplies
Units Sales
260
170
200
120
750
Multiply by: Unit Price
18
18
18
18
18
School Supplies Revenue
4680
3060
3600
2160
13500
Apparels
Units Sales
520
300
800
570
2190
Multiply by: Unit Price
21
21
21
21
21
Apparels Revenue
10920
6300
16800
11970
45990
Miscellaneous
Units Sales
600
520
890
450
2460
Multiply by: Unit Price
6
6
6
6
6
Miscellaneous Revenue
3600
3120
5340
2700
14760
Total Sales Revenue
140800
81280
164140
68030
454250
Sales Budget
Q1
Q2
Q3
Q4
Year
Books
Units Sales
1520
860
1730
640
4750
Multiply by: Unit Price
80
80
80
80
80
Book Revenue
121600
68800
138400
51200
380000
School Supplies
Units Sales
260
170
200
120
750
Multiply by: Unit Price
18
18
18
18
18
School Supplies Revenue
4680
3060
3600
2160
13500
Apparels
Units Sales
520
300
800
570
2190
Multiply by: Unit Price
21
21
21
21
21
Apparels Revenue
10920
6300
16800
11970
45990
Miscellaneous
Units Sales
600
520
890
450
2460
Multiply by: Unit Price
6
6
6
6
6
Miscellaneous Revenue
3600
3120
5340
2700
14760
Total Sales Revenue
140800
81280
164140
68030
454250
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.