Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prestige Press 1st Quarter Sales Report January February March Total Price Units Sold Sales Units Sold Sales Units Sold Sales Units Sold Sales Percent Sales
Prestige Press | |||||||||||
1st Quarter Sales Report | |||||||||||
January | February | March | Total | ||||||||
Price | Units Sold | Sales | Units Sold | Sales | Units Sold | Sales | Units Sold | Sales | Percent Sales | ||
Northeastern | 9.25 | 13,000 | $ 120,250 | 20,000 | $ 185,000 | 45,000 | $ 416,250 | 78,000 | $ 721,500 | 25% | |
Midwestern | 9.25 | 9,250 | $ 85,563 | 15,000 | $ 138,750 | 35,000 | $ 323,750 | 59,250 | $ 548,063 | 19% | |
Southeastern | 9.25 | 7,980 | $ 73,815 | 13,250 | $ 122,563 | 37,000 | $ 342,250 | 58,230 | $ 538,628 | 19% | |
Southern | 9.25 | 7,575 | $ 70,069 | 15,000 | $ 138,750 | 36,500 | $ 337,625 | 59,075 | $ 546,444 | 19% | |
Western | 9.25 | 6,250 | $ 57,813 | 15,000 | $ 138,750 | 35,000 | $ 323,750 | 56,250 | $ 520,313 | 18% | |
Total | 44,055 | $ 407,510 | 78,250 | $ 723,813 | 188,500 | $ 1,743,625 | 310,805 | $ 2,874,948 | 100% | ||
|
1. What is wrong with the sales for each month and in total, the percentage of sales breakdown, and the total row. 50words
2. Address one way that you can quickly look at any file your coworker creates and see visually every formula they entered in the file. Hint, try it on this one, and you'll immediately see where numbers were hard keyed. 50words
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started