Calculating costs

A

AJ

I am trying to calculate costs for product we have to reship to patient,
taking into consideration whether or not we can receive credit from the
vendor. Here is the data.
Worksheet = jan
A B C D E
F
1 Ship Loc Ship Date Cost Order # Item
Return Reason
2 1 12/30/08 60.00 54585 Baseball bat
Damage
3 28 1/23/09 1.00 54858 Gatorade
Not needed
4 28 2/3/09 1000.00 58975 Team Uniforms Not
needed
5 1 12/28/09 50.00 68748 Glove
unknown
6 4 11/25/09 100.00 58789 Baseball cleats
wrong size
7 5 2/4/09 25.00 89758 Football
not needed

Worksheet = Summary
I want to calculate the cost of all returns with a reason not needed, where
we will not get any credit from vendor for the gatorade and the team
uniforms, but the average cost of everything else is the MSRP price which is
5% higher than our actual cost.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top