HELP ME TO FIX A EXCEL SHEET FORMULA FOR A FASHION DESIGN COSTING SHEET
- or -
Post a project like this2533
£10(approx. $13)
- Posted:
- Proposals: 5
- Remote
- #1559450
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Hello, I'm looking for someone whom can look over a EXCEL Design (Fashion) Costing Sheet for me. Ive found online a Design Costing Sheet and had it changed to look like the way id prefer it too. However the final formula does not seem to calculate plus theres a few other things on it that need looking at and I'm also no good with numbers !! HELP.
This is what needs doing (on my original file-not the one attached)
-There is a formula in the "FABRIC WIDTH" column (highlighted in yellow) which needs to be removed. This column needs only be there for reference.
-The formula should function between the PRICE/ METRE column and the GROSS YIELD column to give me a total (please refer to the original EXCEL file found online)
-The "MANUFACTURER" box at the top of the page (highlighted in yellow) also needs to be a little wider.
-The "SKETCH FRONT" & "SKETCH BACK" (highlighted in yellow) boxes need to be equal sizes.
-Everything then from the "TOTAL LABOUR COST" does not seem to add up plus the formulas need to be put into the sheet based on the below information (THIS INFORMATION WAS FOUND ON THE ORIGINAL EXCEL FILE FROM ONLINE):
(1) This value can be changed but the standard is about 5%
(2)Enter your desired wholesale price here
This number will be used to calculate your estimated factor fee and the sales person commission fee.
Those fees are typically based on the actual wholesale price, but since you shouldn't set your actual wholesale price without taking those fees into consideration, this worksheet estimates the fees based on your desired wholesale price.
(3)Enter your desired retail mark up
(4) DO NOT CHANGE THE DATA IN THIS BOX
The gross margin is calculated using the suggested wholesale price
(5)The retail price is calculated using the suggested wholesale price and the retail mark up
DO NOT CHANGE THE DATA IN THIS BOX
**PLEASE NOTE I WILL ADD THE ORIGINAL EXCEL FILE ONCE IVE ACCEPTED THE PERSON WITH WHOM I WILL LIKE TO WORK, FOR NOW IVE ADDED THE ORIGINAL FILE FROM ONLINE SO YOU GET A IDEA OF WHAT IM LOOKING FOR**
To put what I'm after simply, I would like a copy of the original file with the correct functioning formulas onto my my new file : )
the link for where i got the file from :
https://startupfashion.com/wp-content/uploads/2015/03/StUF-Cost-Sheet.pdf
https://docs.google.com/spreadsheets/d/1Q8DlBmS4rNCXBG9YYH3WnhexXWe6c5NzVyjPneOoCFo/edit#gid=0
PLEASE ALSO NOTE THAT I HAVE MY OWN NDA WHICH WOULD NEED SIGNING.
I most likely won't get back to any requests for work until the end of the weekend. FYI.
This is what needs doing (on my original file-not the one attached)
-There is a formula in the "FABRIC WIDTH" column (highlighted in yellow) which needs to be removed. This column needs only be there for reference.
-The formula should function between the PRICE/ METRE column and the GROSS YIELD column to give me a total (please refer to the original EXCEL file found online)
-The "MANUFACTURER" box at the top of the page (highlighted in yellow) also needs to be a little wider.
-The "SKETCH FRONT" & "SKETCH BACK" (highlighted in yellow) boxes need to be equal sizes.
-Everything then from the "TOTAL LABOUR COST" does not seem to add up plus the formulas need to be put into the sheet based on the below information (THIS INFORMATION WAS FOUND ON THE ORIGINAL EXCEL FILE FROM ONLINE):
(1) This value can be changed but the standard is about 5%
(2)Enter your desired wholesale price here
This number will be used to calculate your estimated factor fee and the sales person commission fee.
Those fees are typically based on the actual wholesale price, but since you shouldn't set your actual wholesale price without taking those fees into consideration, this worksheet estimates the fees based on your desired wholesale price.
(3)Enter your desired retail mark up
(4) DO NOT CHANGE THE DATA IN THIS BOX
The gross margin is calculated using the suggested wholesale price
(5)The retail price is calculated using the suggested wholesale price and the retail mark up
DO NOT CHANGE THE DATA IN THIS BOX
**PLEASE NOTE I WILL ADD THE ORIGINAL EXCEL FILE ONCE IVE ACCEPTED THE PERSON WITH WHOM I WILL LIKE TO WORK, FOR NOW IVE ADDED THE ORIGINAL FILE FROM ONLINE SO YOU GET A IDEA OF WHAT IM LOOKING FOR**
To put what I'm after simply, I would like a copy of the original file with the correct functioning formulas onto my my new file : )
the link for where i got the file from :
https://startupfashion.com/wp-content/uploads/2015/03/StUF-Cost-Sheet.pdf
https://docs.google.com/spreadsheets/d/1Q8DlBmS4rNCXBG9YYH3WnhexXWe6c5NzVyjPneOoCFo/edit#gid=0
PLEASE ALSO NOTE THAT I HAVE MY OWN NDA WHICH WOULD NEED SIGNING.
I most likely won't get back to any requests for work until the end of the weekend. FYI.
DEEPAK S.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
8 May 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies