PLEASE ANSWER FULL QUESTION AND SHOW ALL STEPS PLEASE Hartford Bookstore is the
ID: 2520497 • Letter: P
Question
PLEASE ANSWER FULL QUESTION AND SHOW ALL STEPS PLEASE
Hartford Bookstore is the bookstore on campus for students and faculty. The bcokstore shows the following sales projections in units by quarter for the upcoming year EEB (Click the icon to view the average price information.) Requirement Prepare a sales budget for the upcoming year by quarter for the Hartford Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous). ?(click the icon to view the unit sales projections.) Data Table Data Table Quarter Books School Supplies Apparel Miscellaneous The average price of an item in each of the departments is as follows 1,550 840 1,760 600 510 350 800 630 540 820 430 1st 180 Year Average sales price per unit $87 $17 $24 3rd 4th 100 School supplies Miscellaneous Print Done Unit sales Multiply by: Unit price School supplies revenue PrintDoneExplanation / Answer
Answer
Q1
Q2
Q3
Q4
Year
Books:
Unit Sales
1550
840
1760
600
4750
Multiply by: unit Price
$ 87.00
$ 87.00
$ 87.00
$ 87.00
$ 87.00
Book Revenue
$ 1,34,850.00
$ 73,080.00
$ 1,53,120.00
$ 52,200.00
$ 4,13,250.00
School Supplies:
Unit Sales
280
180
240
100
800
Multiply by: unit Price
$ 17.00
$ 17.00
$ 17.00
$ 17.00
$ 17.00
School supplies Revenue
$ 4,760.00
$ 3,060.00
$ 4,080.00
$ 1,700.00
$ 13,600.00
Apparels:
Unit Sales
510
350
800
560
2220
Multiply by: unit Price
$ 24.00
$ 24.00
$ 24.00
$ 24.00
$ 24.00
Apparel Revenue
$ 12,240.00
$ 8,400.00
$ 19,200.00
$ 13,440.00
$ 53,280.00
Miscellaneous:
Unit Sales
630
540
820
430
2420
Multiply by: unit Price
$ 8.00
$ 8.00
$ 8.00
$ 8.00
$ 8.00
Miscellaneous revenue
$ 5,040.00
$ 4,320.00
$ 6,560.00
$ 3,440.00
$ 19,360.00
Total Sales Revenue
$ 1,56,890.00
$ 88,860.00
$ 1,82,960.00
$ 70,780.00
$ 4,99,490.00
Q1
Q2
Q3
Q4
Year
Books:
Unit Sales
1550
840
1760
600
4750
Multiply by: unit Price
$ 87.00
$ 87.00
$ 87.00
$ 87.00
$ 87.00
Book Revenue
$ 1,34,850.00
$ 73,080.00
$ 1,53,120.00
$ 52,200.00
$ 4,13,250.00
School Supplies:
Unit Sales
280
180
240
100
800
Multiply by: unit Price
$ 17.00
$ 17.00
$ 17.00
$ 17.00
$ 17.00
School supplies Revenue
$ 4,760.00
$ 3,060.00
$ 4,080.00
$ 1,700.00
$ 13,600.00
Apparels:
Unit Sales
510
350
800
560
2220
Multiply by: unit Price
$ 24.00
$ 24.00
$ 24.00
$ 24.00
$ 24.00
Apparel Revenue
$ 12,240.00
$ 8,400.00
$ 19,200.00
$ 13,440.00
$ 53,280.00
Miscellaneous:
Unit Sales
630
540
820
430
2420
Multiply by: unit Price
$ 8.00
$ 8.00
$ 8.00
$ 8.00
$ 8.00
Miscellaneous revenue
$ 5,040.00
$ 4,320.00
$ 6,560.00
$ 3,440.00
$ 19,360.00
Total Sales Revenue
$ 1,56,890.00
$ 88,860.00
$ 1,82,960.00
$ 70,780.00
$ 4,99,490.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.