Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating costs
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating costs
Hi AJ, Can you clarify the last paragraph?
It's not totaly clear what your intention is. Maybe a pivot table is a solution for you to total the costs where return reason = Not needed. On Wed, 4 Feb 2009 12:08:16 -0800, AJ wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating costs
The last paragraph, there are certain items that I will not get credit from
the vendor for. The items that I do get credit from the vendor for, I get cost plus 5% of cost. so for an item that is eligible for credit that costs 100.00 the credit i will received will be $105 so. So my actual cost for this order is 100.00 + 25.00 processing cost - $105.00 = $20.00. Not sure if a pivot table would work, because I have over 40 return reasons, and over 1500 products, some of which i get credit for some of which i do not. "Erik Haartmans" wrote: Hi AJ, Can you clarify the last paragraph? It's not totaly clear what your intention is. Maybe a pivot table is a solution for you to total the costs where return reason = Not needed. On Wed, 4 Feb 2009 12:08:16 -0800, AJ wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating energy costs per month | Excel Discussion (Misc queries) | |||
COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
Problem calculating weekly costs | Excel Worksheet Functions | |||
Calculating shipping costs | New Users to Excel | |||
Simple Calculating Costs | Excel Discussion (Misc queries) |