A company considers opening distribution centers in (1) New Brunswick, (2) Waterloo, (3) Montreal, (4) Ottawa, and (5) Toronto. The cost of building the five terminals (in millions of dollars) would be 10 in New Brunswick, 14 in Waterloo, 18 in Montreal, 17 in Ottawa, and 24 in Toronto. No more than two terminals may be built. If a terminal is built in Ottawa, then one must be built in New Brunswick. At least one terminal must be built in Montreal, Ottawa, or Toronto. a) Formulate this location problem as an integer problem (i. e. define the variables and write down the objective function and all constraints in algebraic form).
b) Create a spreadsheet model for this problem and solve it with Solver.
c) What is the optimal solution? What is the optimal value?
d) How much would the company save without this requirement: "If a terminal is built in Ottawa, then one must be built in New Brunswick"?

Gyou plan to deposit $1,700 per year for 5 years into a money market account with an annual return of 2%. you plan to make your first deposit one year from today. what amount will be in your account at the end of 5 years? round your answer to the nearest cent. do not round intermediate calculations. $ assume that your deposits will begin today. what amount will be in your account after 5 years? round your answer to the nearest cent. do not round intermediate calculations.

Assume that all of thurmond company’s sales are credit sales. it has been the practice of thurmond company to provide for uncollectible accounts expense at the rate of one-half of one percent of net credit sales. for the year 20x1 the company had net credit sales of $2,021,000 and the allowance for doubtful accounts account had a credit balance, before adjustments, of $630 as of december 31, 20x1. during 20x2, the following selected transactions occurred: jan. 20 the account of h. scott, a deceased customer who owed $325, was determined to be uncollectible and was therefore written off. mar. 16 informed that a. nettles, a customer, had been declared bankrupt. his account for $898 was written off. apr. 23 the $906 account of j. kenney & sons was written off as uncollectible. aug. 3 wrote off as uncollectible the $750 account of clarke company. oct. 20 wrote off as uncollectible the $1,130 account of g. michael associates. oct. 27 received a check for $325 from the estate of h. scott. this amount had been written off on january 20 of the current year. dec. 20 cater company paid $7,000 of the $7,500 it owed thurmond company. since cater company was going out of business, the $500 balance it still owed was deemed uncollectible and written off. required: prepare journal entries for the december 31, 20x1, and the seven 20x2 transactions on the work sheets provided at the back of this unit. then answer questions 8 and 9 on the answer sheet. t-accounts are also provided for your use in answering these questions. 8. which one of the following entries should have been made on december 31, 20x1?

After much consideration, you have chosen cancun over ft. lauderdale as your spring break destination this year. however, spring break is still months away, and you may reverse this decision. which of the following events would prompt you to reverse this decision? a. the marginal cost of going to cancun decreases.b. the marginal cost of going to ft. lauderdale decreases.c. the marginal benefit of going to cancun increases.d. the marginal benefit of going to ft. lauderdale decreases.