I own a kitchen cabinet company and I have many suppliers. I need a spreadsheet that has three columns, one for 30" uppers, one for 36" uppers, and one for 42" uppers.
Under these three columns I want to be able to put a list of cabinet sizes and to the right, next to the sizes, I want the LIST price. When I complete the list of cabinets I need for it to give me a total LIST price. Right under the LIST price I need to have a multiplier [that I can change] so that it will show me my cost for that list. Right under that, I need a divider [that I can change] that will show me my resale price to the customer. Right under that I need sales tax that will multiply the retail price by a percentage [iE. 7%] Right under that I need shipping charges [that I can change] and add to the subtotal and under that I want assembly charges [that I can change], and add to the subtotal. Under that I need a line called Installation that would total the subtotal above and give me Installed price. This total will be named 10' x 10' = Right under that I need for it to divide that total by 20 LF and this line would be called Cost per LF