E2 Cont. Flashcards
contracts are driven by
INCOTerms
Free on Board/FOB Port
seller responsible for all costs until goods are on ship
Cost Insurance Freight, CIF
seller responsible for all costs
make to stock inventory is held in…
finished goods
assemble to order
ex. subway sandwich
components held in inventory ready to be assembled
make to order
ex. medium well steak
raw materials held waiting to be manufactured
engineer to order
ex. working w/ an architect to build a house
nothing held in inventory
why might a VLOOKUP function return “N/A”
number of reasons, could be that the text and values do not match up
thinking of Southeastern spreadsheet, what is the formula for the MATCH and why/how did we use it
- define column 2 of sheet 2, client letters (CC) as “Client Code”
- =MATCH(D8, Client Code, 0)
where D8 –> customer column in all data and 0 denotes an exact match - this returns a number indicating where in the column the client code is (ex. column # 29)
- NEW COLUMN
=INDEX(Client Name, MATCH(D8, Client Code, 0), 1)
where Client Name was the original defined area of customer description and client code in sheet 2,
1 denotes using the first column in Client Name
if an order has 1 line item/someone is only buying 1 thing, Line will spit out…
10
=DAYS([??], [??])
end date, start date
descending will give you
highest to lowest
ex. Remaining 35 States functionality
=B49-SUM(D1:D10)
where B49 is grand total
D1:D10 are top ten items
a cross tab creates a
matrix
drill-down is used when
too much info for cross tab
