From the Open Inventory table, try to get the TOTAL # of open parts for each of the ROWs below:

Using excel (Show formulas)

Open Inventory Tabe:

	On Hand	Rail Yard	On Boat	In Quality	Mfg Qty
G3572	2	12	18	28	38
D5904	9	19	29	39	49
D1476	18	28	38	48	58
D0557	41	51	61	71	81
C9208	82	92	102	112	122
C1319	169	179	189	199	209
W0933	338	348	358	368	378
W6415	169	179	189	199	209
W1051	338	348	358	368	378
W1117	169	179	189	199	209

	Total
G3572	?
D5904	?
D1476	?
D0557	?
C9208	?
C1319	?
W0933	?
W6415	?
W1117	?
W1051	?

Solutions

Expert Solution

these are two pictures one contains formulas and other one has actual values.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Create new Deck object Run testDeck( ) Should get four columns (13 rows each), each column...

Create new Deck object Run testDeck( ) Should get four columns (13 rows each), each column with a unique suit and ranked ace to king Run shuffle( ) then run testDeck( ) again Should get four NEAT columns,(13 rows each) with random numbers and suits in each column Create another Deck object Run testDeal( ) with a parameter of 5 Should get Ace, 2, 3, 4, 5 of spades as the “hand” Now run shuffle( ) then run testDeal( )...

How do borderline clients try to get attention from the staff?

For each cases listed below, try to apply concepts from the following theoretical perspectives to understand...

For each cases listed below, try to apply concepts from the following theoretical perspectives to understand the behavior: situational pressures, Social Exchange Theory, Social Cognition, Self-Esteem. Situation 1: Allen is a junior in college and is vice-president of his fraternity. He is very bright, but spends little time studying and barely squeaks by. He spends most of his days and nights at the fraternity house talking, goofing off, or partying. Explain Allen's behavior. Situation 2 Kim and Steve have been...

Insert at least three rows of data to each table. Make sure you keep the primary...

Insert at least three rows of data to each table. Make sure you keep the primary key and foreign key constraints. Tables: Cust Table: cid, -- customer id cname, --- customer name cphone, --- customer phone cemail, --- customer email Category table: ctid, --- category id ctname, --- category name parent, --- parent category id since category has a hierarchy structure, power washers, electric power washers, gas power washers. You can assume that there are only two levels. Tool: tid,...

I try to add the table content work, they will not allow me.. see below in...

I try to add the table content work, they will not allow me.. see below in another post pls One question pls i need help with this, kindly show your work as well so that i can learn. I WILL RATE IT AND LEAVE A COMMENT. THANKS Tidal Wave is considering purchasing a water park in San Diego comma California, for $ 1 950 000. The new facility will generate annual net cash inflows of $ 500 000 for eight...

For each of the procedures described in the table below, select from the list provided the...

For each of the procedures described in the table below, select from the list provided the audit procedure that the auditor performed. Then, indicate if the procedure was a substantive procedure or a test of controls. Possible Audit Procedure: 1. Analytical Procedures 2. Confirmation 3. Inquiry 4. Inspection 5. Observation 6. Recalculation 7. Reperformance Description of Procedure Audit Procedure Performed (1-7 from list above) Classification of Audit Procedure (Substantive or Test of Controls) 1) Requested the bank to respond to...

data to the right to complete parts (a) through (d) below. Percentage Who Won't Try Sushi...

data to the right to complete parts (a) through (d) below. Percentage Who Won't Try Sushi (x) Don't Approve of Marriage Equality (y) Generation x y Millennials 46 44 Gen X 49 44 Boomers 58 56 Silent/Greatest Generation 77 75 a. Determine the correlation coefficient between the percentage of people who won't try sushi and the percentage who do not approve of marriage equality. r = ? (Do not round until the final answer. Then round to two decimal places...

The table below gives the annual total returns on Global Balanced Index Fund from 1999 to...

The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions: Table 1: Global Balanced Index Fund Total Returns, 1999-2008 Year Return 1999 50.21% 2000 -2.18% 2001 12.04% 2002 26.87% 2003 49.90% 2004 24.32% 2005 45.20% 2006 -5.53% 2007 -13.75% 2008 -39.06% a. Calculate the mean absolute deviation (MAD). Calculation of MAD for Germany Index Total...

The table below gives the annual total returns on Global Balanced Index Fund from 1999 to...

The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions: Table 1: Global Balanced Index Fund Total Returns, 1999-2008 Year Return 1999 50.21% 2000 -2.18% 2001 12.04% 2002 26.87% 2003 49.90% 2004 24.32% 2005 45.20% 2006 -5.53% 2007 -13.75% 2008 -39.06% (5.0 pts) Calculate the mean absolute deviation (MAD). Calculation of MAD for Germany Index...

Are there any parts of the human body that get oxygen directly from the air and not from the blood?

Subjects