EXCEL SPREADSHEET

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 2 years ago

Fixed Price

Delivery by November 16, 2012

$25.00

Budget

Details

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


About the Client

(4.00) 1 review

United States
Odessa 03:46 PM

2 Jobs Posted
50% Hire Rate, 1 Open Job

$6 Total Spent
1 Hire, 0 Active

Member Since Nov 10, 2012