Forum Discussion
Need help with price effect calculation
Hi Anonymous ,
Thank you for your kind reply!
Could you please provide a screenshot of this if it is in excel?
Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The below table shows price calculation performed on the monthly and YTD sales. I am only doing a simulation in excel as I am unable to share my company's data model.
| Product A | SalesCY | UnitsCY | PriceCY | SalesPY | UnitsPY | PricePY | Price Impact |
| 1 | 5000 | 200 | 25.00 | 3060 | 180 | 17.00 | 1,600 |
| 2 | 4620 | 210 | 22.00 | 4180 | 190 | 22.00 | 0 |
| 3 | 5750 | 230 | 25.00 | 5040 | 210 | 24.00 | 230 |
| YTD | 15370 | 640 | 24.02 | 12280 | 580 | 21.17 | 1,820 |
Hi Anonymous ,
Thank you for your kind reply!
Could you please provide a screenshot of this if it is in excel?
Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.