Hello everyone!
I have been using the attached formula and it works perfectly for managing my inventory. It looks at the [price list inc competitor worksheet]. It looks for specific length, and markup. I add new products on the [inventory worksheet], the formula looks at the variables typed from the [price list inc competitor worksheet] calculates the price based on pattern/type, length and total weight.
Now that I'm launching new products, I need to revise the formula. I have new hair origins and a new type of product.
I would like the new formula to look at the origin worksheet. Calculate the price based on the origin, length, weight and markup and wig type.
Example: On the inventory spreadsheet, if I enter the following, the cost should be 871.15.
Weft 1 Pattern: Cambodian D Curly
Weft 1 Length: 18
Weft 1 Weight: 3
Weft 2 Pattern: Cambodian D Curly
Weft 2 Length: 20
Weft 2 Weight: 7
Wig Type: Upart w vent
$871.15
I have been using the attached formula and it works perfectly for managing my inventory. It looks at the [price list inc competitor worksheet]. It looks for specific length, and markup. I add new products on the [inventory worksheet], the formula looks at the variables typed from the [price list inc competitor worksheet] calculates the price based on pattern/type, length and total weight.
Now that I'm launching new products, I need to revise the formula. I have new hair origins and a new type of product.
I would like the new formula to look at the origin worksheet. Calculate the price based on the origin, length, weight and markup and wig type.
Example: On the inventory spreadsheet, if I enter the following, the cost should be 871.15.
Weft 1 Pattern: Cambodian D Curly
Weft 1 Length: 18
Weft 1 Weight: 3
Weft 2 Pattern: Cambodian D Curly
Weft 2 Length: 20
Weft 2 Weight: 7
Wig Type: Upart w vent
$871.15
