Complete the table. Please show/explain formulas used. See supporting info below

	Q*	Ddlt	SS	Avg Inv	Inv cost	Ord Cost	Tot Cost
Albany
Buffalo
California
Delaware
Louisiana
	Total cost of the distribution system

Supporting info:

90% service level and 2 week lead time

Inbound TRANSPORTATION COSTS PER UNIT PRODUCT
Warehouse	Inbound	Outbound
Albany	$ 12.00	$ 13.00
Buffalo	$ 11.50	$ 13.00
California	$ 11.00	$ 13.00
Delaware	$ 9.00	$ 13.00
Louisiana	$ 7.00	$ 13.00
Table 3: Outbound Transportation Costs per Unit in Single Centralized System
Warehouse	Albany	Buffalo	California	Delaware	Louisiana
Atlanta	$ 13.00
Boston	$ 16.00	$ 13.00
Chicago	$ 16.00	$ 10.00	$ 13.00
Dallas	$ 17.00	$ 17.00	$ 17.00	$ 13.00
Los Angels	$ 19.00	$ 19.00	$ 18.00	$ 10.00	$ 13.00

Table 4: Ordering Cost and Holding Costs (per unit per week)
	cost at	ordering cost	holding cost
current system	regional warehouse	$ 5,550.00	$ 1.25
central warehouse	central warehouse	$ 5,550.00	$ 1.25
mixed model	central warehouse	$ 3,000.00	$ 1.00
regional warehouse	$ 3,000.00	$ 1.25

HISTORICAL demand for 12 weeks
Week	1	2	3	4	5	6	7	8	9	10	11	12
Albany	33	45	37	38	55	30	18	58	47	37	23	55
Buffalo	26	35	41	40	46	48	55	18	62	44	30	45
California	44	34	22	55	48	72	62	28	27	95	35	45
Delaware	27	42	35	40	51	64	70	65	55	43	38	47
Louisiana	32	43	54	40	46	74	40	35	45	38	48	56