I need to make a spreadsheet on excel which shows the production schedule of a product over 4 days.
Then I need to make a supply ordering sheet which shows how much supplies are needed to do the above task and how much each item in the supply list will cost and when the items would need to be ordered.
I have attahced an example of what I need to do. I need to project due dates for each of our 8 departments based on a ship date of the final product. Each of the 8 dept. have a number of operations (ops) and given number of hours for each op. These alocated hours change on every job plus I have 2 outside operations that may or maynot be added to the mix. I don't have a clue on where to even start with this formula.
View 2 Replies View RelatedI have created a daily schedule which has a number of factory variables taken into consideration which determine the date and time a particular product should, barring any mechanical problems, come off the machine. (see attached spreadsheet).
The date at the top will be editable by me only so that when I update the production quantities, the “date/time off” column automatically re-adjusts to the remaining quantities.
The formulas are a little long winded, but I have left them that way whilst I try and develop it. I should be able to figure out how to condense them later.
My problem is that the “date/time off” on the right works excellent, but over a 24 hr period.
Ordinarily, we work a 12 hour day (6am to 6pm) with overlapping shifts to cover breaks, and 20 mins warm up at the start of the day for the machine, thus maximising a 12 hour day.
Of course if demand exceeds the allotted time we put on overtime.
Is it possible to specify that normal days are only 12 hours so that if a product exceeds 6pm, it flows into the next day with the balance starting at 6:20am?
And, if the production for the week exceeds the time could I stipulate particular days which we deem are suitable for overtime? Ie, we decide Wednesday is a 14 hour day and not 12.
I had toyed with the idea of creating a 365 day table/calendar, on another worksheet which would have its individual allocated hours in an adjacent column and somehow link them to the date/time off, perhaps by way of a VLOOKUP, but I have been chasing my tail trying to figure out how to implement it.
I am looking for a template where I can have the Gap between Demand and Supply of Resources. This is to plan taking up new opportunities or not based on the supply.
View 2 Replies View RelatedI receive the following error whenever I try to run a macro in Excel: "System Error &H80040111 (-2147221231). classFactory cannot supply requested class." This is immediately followed by "Out of memory"
I was eventually able to stop the error from occurring by removing all forms containing a listview control in my macro file.
I have tried repairing my Office installation, uninstalling and reinstalling Office, and reregistering MSCOMCT2.OCX but nothing seems to work.
Maybe the title shouldn't be simple or I am missing something starring me in the face.
I am trying to make a supply and demand graph, with the following table,
wage supply demand
45,000 200,000 325,000
40,000 220,000 310,000
35,000 250,000 300,000
30,000 290,000 290,000
25,000 310,000 275,000
20,000 320,000 250,000
I can make either a supply or a demand graph without problems, however no matter where I place the vaules, ie wage first, demand, then supply or demand, wage, supply, the graph will not work or look right. The wage must be on the left had side so that the graph complies with standard Supply and Demand. I also need to be abble to make another graph showing what happens with a wage cap.
I can do it on graph paper, put I can not find a way to do it using Office 2007 Word and inserting a graph option and using Excel.
I am trying to calculate Inventory Months Supply.
I can calculate the months suppply as shown below in multiple cells, but I am looking for a formula to do in one cell..
The correct result in this example is: 2.26048
I have a spreadsheet which uses MS Query to import data from our MRP System. This Spreadsheet has all new orders and qtys required per sales order etc. Each Part number may have several sales orders and different qtys for each. I am looking for help to write a fomula which looks the required qty`s for each sales order & part and check another sheet which has all the avaliable stock to sell on it and populate a column next to the qty req`d with what if anything is available.
Both the orders sheet and the stock sheet are MS Queries which refresh at a given interval so cells may change position.
Cutdown Example of Orders Sheet.
Sales Order No. ¦ Part ¦ Qty Req`d ¦
--------------------------------------
1234 ¦ Apple ¦ 12 ¦
6777 ¦ Apple ¦ 16 ¦
7989 ¦ Pear ¦ 4 ¦
cutdown Example of Stock Sheet.
Part ¦Qty in Stock ¦
----------------------
Apple ¦ 12 ¦
Pear ¦ 3 ¦
Now the fomula should bring back the following
Sales Order No. ¦ Part ¦ Qty Req`d ¦ Qty Avaliable ¦
----------------------------------------------------
1234 ¦ Apple ¦ 12 ¦ 12 ¦
6777 ¦ Apple ¦ 16 ¦ 0 ¦
7989 ¦ Pear ¦ 4 ¦ 3 ¦
Once you have created the supply and demand numbers and have put them in a graph or on a chart, how do you find the equilibrium point? Also, how do you show the equilibrium point on a chart.
View 4 Replies View RelatedFor an economics assignment I would like to graph price elasticity with price on the 'y' axis and units on 'x'. I have not found a way to do this in Excel, can someone assist?
View 6 Replies View RelatedI am going to attempt to design a production spreadsheet which does the following:
1.Orders are put on one page of the spreadsheet (Order Tab) The order is put on listing, Customer, Sizes, Qty etc
2.The user is then able to select an order and if possible I would like a pop up calendar to appear in which the user can then select a production date.
3.One the production date has been selected I want it to open up a new tab if one doesn’t already exist and then cut the information from the order tab and then paste it into the production day.
I have provided a spreadsheet of what I want to achieve but I am unsure if this is possible.
I have two rows with years and production like below:
2009 2010 2011 2012 2013 2014
4 4 4 4 0 0
I want to find last year with production which is 2012. Do any of you know about any function I can use for this?
I am trying to do parts forecasting.
My customer makes 6 different widgets, all of which use a different number of the same parts (tabA ~ tabZ)
For example, model A has the following:
1 x tabA
2 x tabB
0 x tabC
4 x tabD.
I have a matrix which shows how many of the different parts are in each model. The part number goes down the rows and the model being produced goes across the columns. So this goes from A10:G:21
Now, I have to do a forecast for the next year and I trying to figure out the best way to do it and have each months totals of each part. My forecast has the model numbers going down the rows and the months going across the columns. This is from A1:G7
The way I used to do it is have a line for every part and manually multiply the monthly total by each models per unit and it ends up being a formula that gets longer and longer.
January needs for tabA are (B2*B11)+(B$3*C11)+(B$4*D11) ...
February needs for tabB are (B2*B12)+(B3*C12)+(B4*D12)...
When they have 20 distinct models it gets difficult. Also, there may be mid-season changes to the bill of materials that make it difficult to change.
I have a production schedule with start and finish dates for each project. To the right of this I have a matrix with "week starting" dates. What I am looking for is a formula that will indicate how many days in each week the project will take. Below are the cells filled in correctly. However, I did this manually. Any idea of a formula? I'm pretty new to this.
WEEK STARTINGSTARTFINISHUNITS PER DAY9/1/089/8/089/15/089/22/089/29/089/10/089/24/0813.4503530
I have about 45 worksheets in one file. Then all have been named. Is there any quick way to order them? I would prefer not to move each one.
View 2 Replies View Relatedwhat i want to do is have a formula set up that works out who has the best position and then re order the number rows to put the player in position 1 at the top. so just moving cells c-n
View 6 Replies View RelatedI need to ensure that a worksheet is ordered after another in a workbook. The macro that this code is in opens a selected file and carries out various operatins on it, so although I can do this fine when the worksheet needs to be created, there are scenarios where it already exists and I simply need to change the order. The sheet that must come in position 1 does not have a common name and so I cannot reference it via it's name in the code. The other sheet is named when it is created so it doesn't necesarilly have to be in position 2, it's just that the other one needs to be in position 1.
View 7 Replies View RelatedA number of columns (B to U) contain names, details and scores of players. The A column contains the ranking, e.g. 1 to 100.
If a player (row) is deleted, that ranking number is also gone. Is there a way to make the A column always maintain the integrity and completeness of the numbering, e.g. if rank (row) 16 is deleted, the range of B17:U100 moves one row up and the former 17 is now 16? And if a new row is inserted, the ranking numbers after the insertion move up one row and a new number is added at the end?
2. There are 6 columns of scores, P to U. But out of these 6 scores, only the best 4 count for the ranking. The two worst (highest) scores are dropped. Is there a way to automate the process by selecting only the 4 best (lowest) numbers to be summed into the Total column (C), which in turn determines the rankings in the A column?*
And then can the whole range B2:U100 automatically be sorted according to the ranking in column (A)?
*It is possible that there are 3 or 4 bad scores, all with the same value. In that case only 2 could be discarded, and 1 or 2 would be summed into the ranking cell.
How do you do a lookup without having to have a list in ascending order?
i have a 5 by 10 table (5 columns 10 rows)
values only equal 1 or blank
i want to re-order this table in another identical table so that no row will have more than one value (each row will have a maximum of one "1")
currently, the table looks something like this:
blank blank blank 1 1
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank blank
blank blank blank blank blank
what i would like the idential table to show is:
blank blank blank 1 blank
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank blank
I'm trying to use a Select Case to log production time-tables.
I've tried a couple angles - one being Select Case.
Every time I run the Macro I get the default ERROR "Wrong Model Entered...."
[Code] .....
I'm thinking the problem lies within
[Code] .....
but I'm not certain.
I work for a manufacturing plant where we manufacture one product which is then sold under different names.
The product is made from the same material.
I am looking for a way to match up production to the orders and then subtract the produced quantity from the orders.
Tab 1 - Orders: Column 1 has the items (A1, A2 and A3 are all produced from A), Column 2 has the date when the order has to ship and Column 3 has the ordered volume.
Tab 2 - Production: Column 1 has the raw material, Column 2 has the production date and Column 3 has the amount manufactured.
Tab -1: Orders
Item
Ship Date
Ordered Qty, KG
A-1
8/22/2012
16
[Code] ..........
Tab -2: Production
Item
Production Date
Quantity
A
8/13/2012
140
[Code] ........
if I want to look up a table named production in Access.
table:
Name: bob,jason,robbert,christy
Dept: bins,cars,cars,sewing
now if i wanted to be able to look up jason then have it populate which Dept he worked in, in cell A1 in my excel spread sheet what code could I use. Just want to look up one area in my access data table then show it in A1 one item at a time.
I have 320 rows of data, of which the date is in the first column. I need the data sorted into date order, ie. 04.05.12-->30.04.13 and all the dates in-between (note these are British laid out dates). I am aware, and have already done Format Cells --> Date --> 14.03.01, as this is how my dates are laid out.
I've tried sorting this column, ascending, descending etc etc etc, obviously it needs to be 'expanded' to ensure that the rest of the data in the row follows it to its new position. No joy. It only ever sorts the dates by the day ie. 02.04.13, 04.12.12, 06.06.12. Doing it by the day and not the month and the year also.
I don't want to order 320 data rows myself!
I have an enquiry where I'm trying to order error messages which occurs in if, ElseIf and Else Statements. The code I have works. However, I would like the error messages to be checked in a particular order. I tried rearranging the conditional statements but had no success. Here is my
View 5 Replies View RelatedI want to have them in order of shortest price (favourite) first with the relevant horse's name in the adjacent column. I have just discovered vlookup which seemed perfect - until I discovered that when there are two or more identical prices it only returns the 1st horses name.
Is there any way I can use vlookup to do this (with more than one identical value)
I have daily production sheets (Excel sheets) that I fill out every day indicating the day's production totals. The files are named by the day's date. For example today's sheet (4/24/13) would be 042413.xls. However, I would like to be able to pull certain pieces of information into another separate spreadsheet. For example, my boss asked me how many of a certain product we made over the last month. So, I'd like to pull the product info, the date made, and quantity made into another sheet. And I'd like to be able to do this automatically for a date range that I specify.
View 8 Replies View Relatedauto calculate end dates on production plan ...
View 9 Replies View RelatedI am trying to come up with a formula which would combine two groups of numbers, put them in numberial order and remove duplicate numbers:
3 6 10 22
1 3 5 9 10 13 19
The above two groups of numbers are in separate cells in two different rows.
the result would also be in a different row: 1 3 5 6 9 10 13 19 22
There should be a Login and Logout Button and a Start time end time button to record data to the next sheet in the workbook. Also it would be great if it includes a Break and EndBreak button so that the time taken in the breaks gets recorded in the next sheet in the Workbook.
Every Morning colleagues should click the LoginButton to start and click the logout button at the Day end to get the total production time recorded in the next sheet. (Total production time should be Total time taken minus breaks). We have a 9 hour shift.