inventory

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory. for example main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

Hello All Not sure what direction to go or how to phrase but looking for the following. When a quantity is inputted into worksheet 1 (labeled: product), that quantity and item description will auto populate onto worksheet 2 (labeled: totals). Worksheet 2 should not have any quantities if...

I want to identify my inventory level (days) based on actual/forecasted pull-out and not the average. The desired result can be achieved thru this formula: =IF(F9>J9,1,F9/J9)+IF((F9-J9)>O9,1,(F9-J9)/O9)… But it would be a very long equation if I apply it to day 1 to 31. Can anyone help me...

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

I have a master Inventory with 3 sheets for all the end users of a client of mine. This client of mine from time to time requests that I prepare to them an inventory exactly with the same look, but only for one certain end user. Sheet 1 is overview for the prices per quarter that each End User...

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

When I put a date range in cell A1 (1/12/18) and cell A2 (5/12/18) I want to add the dates 1 2 3 4 5 to separate cells like, cell A3(1) cell A4(1) cell A5(1).... the idea is when i enter start date and end date, to add in between dates to a separate cells I need to make a room inventory chart...

Hi Everyone, I am looking for a formula to bring in the first two values in a row. Here is my data set: My desired outcome is the inventory during request 1 and 2 <tbody> Inventory during request 1 Inventory during request 2 12/8/2018 12/9/2018 12/10/2018 12/11/2018 12/12/2018 12/13/2018...

My question is rather complicated to explain via typing it out. If I could do a bit of show-and-tell then the answer I receive will likely I be more accurate and result in less back-and-forth trying to clarify things. So it is in that spirit that I took the time to create a short video that does...

I have an inventory worksheet and I would like to do the following: 1. I would like the current inventory quantity (on hand) (Column E) to increase when inventory is received (Column J) and decrease when inventory is issued (Column L) by item code (Column B). 2. I would like a vlookup...

Hi, The objective is to come up with the formula in F4 that give you the number of months in takes to deplete the current inventory (F3) based on your current sales forecast (G2:02) (I put the expected results the formula should obtain) I included the expected results in row 4. Note that the...

Hello all. Here is the scenario. I am using Excel to track the inventory of desk phones(among other things) This screenshot is row 8. Here is what I currently have for the H Column =IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"") The phones are assigned to a particular seat or...

Hi Everyone, I am looking for a way to build a formula to look at Customer Requests by date compared to inventory. My customer requested are already added into my ending inventory on my report*. So if there is a customer request I need a formula to check if our inventory was positive during...

Hello! I would like to ask you for help programming inventory management system in excel using VBA and userform. I would like to form one easy excell file, which gives you information about stock level (I am starting with small business for parents and my 2 parents besides me will pack...

Hello All, I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem. My dataset is as follows; <tbody> Model Region Configuration Measure Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19...

Hello, I am not sure if what I want to create is possible but any assistance or guidance in the right direction will be very much appreciated. I am trying to create a spreadsheet that will allow me to track the aluminum and drywall needed in the fabrication of certain frames that we make. The...

Hello wonderfully smart people! Can someone help or point me in the right direction... I would like to have a list of tasks, say A2:D15 would be a list of things to do. Then F:J would be days of the week. So, for example, A2 is "Inventory Parts" and H7 is "Inventory Parts". As H7 is filled...

Hello, New to this forum and thanking you in advance for any assistance you can offer. This is what I am attempting to do: Me and my husband recently opened a small shop to fabricate aluminum frames. The orders are starting to come in and I am trying to come up with a system that will allow me...

Hello all! This is my first time posting so please forgive the lack of detail. . . I am trying to create a table with a summary of items that need to be Restocked across 4 different sheets. I am relatively new to Excel and while I've been able to puzzle other issues out thanks to the help I've...

Everything I input into Solver is giving me a not feasible solution. How should I be setting up a linear regression to find optimal production with the following data? I'm also unsure of how to add a promotion, any tips? <colgroup><col width="157" style="width: 118pt;"><col width="65"...