Forum Discussion
Production schedule
Hey everyone,
I'm trying to make a production schedule that will allow me to enter an item number and a quantity of raw material (for the factory), which will calculate the quantity of product that will be produced (for the warehouse). There are many different products that require different quantities of raw materials and will create different quantities of finished product so, if my columns are; Item no., Raw QTY (tubs), Product QTY (boxes), I'll need boxes to be the calculation of tubs multiplied by a specific value which is determined by the Item no.
I assume there will need to be a hidden column that will host the conversion rate and a master sheet containing all the product details and conversion rates for the schedule to refer to. How do I make the conversion rate column reference the Item no. column and give me the correct conversion rate for each product?
Thanks in advance.
1 Reply
You're asking us to visualize a lot here....is it possible for you to post a copy or a mock-up of what you are trying to describe. Not a picture, an Excel workbook with samples of the data you're going to be working with. If the actuals are confidential, then a mock-up without reference to reality except in the layout.
That aside, if you want to do a little research on your own, Excel offers several ways to access a table with data on any given entity. So check out VLOOKUP, INDEX and MATCH used together, and/or XLOOKUP. Here's a link to a website that describes how XLOOKUP works. It might be what you're looking for.
https://exceljet.net/excel-functions/excel-xlookup-function
