I am doing a spreadsheet problem using the Quantity Sold and the Sales Amount and I have to figure the percent of sales. If I had 1587 as quanity sold and the sales amount is 47690.19 what is the perent of sales? I came up with 3.3%. Is this correct?? I would appreciate if you would email me. Thanks, Shirley. email shirley_raynor@yahoo.com
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Percent of Sales
- Thread starter Shirley
- Start date
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
WELCOME TO THE BOARD!
I'm afraid you need to offer more information. If 1587 is the number of units sold and you have $47,690.19 in revenue, the only thing you can really figure out is the average cost per unit. In this case, $30.05. What are you trying to figure as far as "percent of sales"?
I'm afraid you need to offer more information. If 1587 is the number of units sold and you have $47,690.19 in revenue, the only thing you can really figure out is the average cost per unit. In this case, $30.05. What are you trying to figure as far as "percent of sales"?
Upvote
0
Yogi Anand
MrExcel MVP
- Joined
- Mar 12, 2002
- Messages
- 11,454
Hi Shirley:
Phantom is right in that you need to clarify what percentage you are computing. However, please look at the following simulation -- which shows that the QtySoldAsPercent of Amount is what you have computed to be 3.3%
Is this what you are looking for?
Phantom is right in that you need to clarify what percentage you are computing. However, please look at the following simulation -- which shows that the QtySoldAsPercent of Amount is what you have computed to be 3.3%
| y030423h1.xls | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | QtySold | Amount | QtySoldAsPercentOfAmount | ||||
| 2 | 1587 | 47690.19 | 3.33% | ||||
Sheet3 | |||||||
Is this what you are looking for?
Upvote
0
More Clarfication of the Problem
The problem is:
Format the numbers in the Quantity Sold column with commas and no decimal places - format the numbers in the Sales Amount column as currency - and format the numbers in the Percent of Sales column as percentages with one decimal place.
By doing this, I came up with the Quantity Sold 1587 and the Sales Amount of 47690.19 with the Percent of Sales to be 3.3%
The problem is:
Format the numbers in the Quantity Sold column with commas and no decimal places - format the numbers in the Sales Amount column as currency - and format the numbers in the Percent of Sales column as percentages with one decimal place.
By doing this, I came up with the Quantity Sold 1587 and the Sales Amount of 47690.19 with the Percent of Sales to be 3.3%
Upvote
0
Yogi Anand
MrExcel MVP
- Joined
- Mar 12, 2002
- Messages
- 11,454
Re: More Clarfication of the Problem
Hi Shirley:
In the part that I have quoted above, I don't see a question -- however, if you are wondering whether you did it right the way you have described, from what I have seen so far, I would say YES, you have come up with the right answer (except keep in mind, only you know the background, or the context in which the calculation is being made, since the result of our computation might be right, but it may not necessarily be the right computation to make).
The following simulation shows the formating and the computation as you have described it ...
Shirley, I hope I have not misunderstood what you are after. So, please do post back, and advise if this is what you are looking for -- otherwise post back with a little more explanation and let us take it from there.
Shirley said:
Hi Shirley:
In the part that I have quoted above, I don't see a question -- however, if you are wondering whether you did it right the way you have described, from what I have seen so far, I would say YES, you have come up with the right answer (except keep in mind, only you know the background, or the context in which the calculation is being made, since the result of our computation might be right, but it may not necessarily be the right computation to make).
The following simulation shows the formating and the computation as you have described it ...
| y030423h1.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | QtySold | Amount | QtySoldAsPercentOfAmount | |||
| 2 | 1,587 | $47,690.19 | 3.3% | |||
Sheet3 | ||||||
Shirley, I hope I have not misunderstood what you are after. So, please do post back, and advise if this is what you are looking for -- otherwise post back with a little more explanation and let us take it from there.
Upvote
0
