+ Reply to Thread
Results 1 to 2 of 2

Reduce production cost based on the materials you have

  1. #1
    Registered User
    Join Date
    12-29-2019
    Location
    Cluj, Romania
    MS-Off Ver
    Google Spreadsheet
    Posts
    2

    Reduce production cost based on the materials you have

    Hello,

    You can check the attached sheet and see on the Info sheet there are the cells with Your Mats: SS,MS,SO,EO and to the right the amount of each material owned(which is editable and will change based on user and available materials at a give time). Now on the Testing Sheet i have the table with the data, what i need is that P.C.(G column) will change according to the materials you have(the initial cost is from B:E) so if i have all the materials that i need to craft that product the production will reduces the cost of those materials automatically, if i have just a part of the material then again reduces the cost of what i have and display the remaining amount i require. I hope i made myself clear on this and explained properly my problem. Thank you for your time.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-29-2019
    Location
    Cluj, Romania
    MS-Off Ver
    Google Spreadsheet
    Posts
    2

    Re: Reduce production cost based on the materials you have

    I wonder if it's possible .. i tried to think of different ways but well... Still if someone could help me out i would really appreciate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Labor and Materials Cost
    By Bart60 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2019, 06:45 AM
  2. Help with creating a formula to manage cost of materials per month
    By chris.gbrwn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2016, 09:47 AM
  3. Replies: 3
    Last Post: 12-18-2014, 07:20 AM
  4. production cost
    By Ashsyme in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-12-2006, 06:15 PM
  5. [SOLVED] How do I calculate cost of raw materials to final product?
    By just desserts in forum Excel General
    Replies: 2
    Last Post: 01-28-2006, 03:20 PM
  6. [SOLVED] i need template for my cost/profit on materials i sell
    By AMC Photo in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-29-2005, 01:05 AM
  7. Replies: 0
    Last Post: 03-25-2005, 01:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1