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"?

The gilbert instrument corporation is considering replacing the wood steamer it currently uses to shape guitar sides. the steamer has 6 years of remaining life. if kept, the steamer will have depreciaiton expenses of $650 for five years and $325 for the sixthyear. its current book value is $3,575, and it can be sold on an internet auction site for$4,150 at this time. if the old steamer is not replaced, it can be sold for $800 at the endof its useful life. gilbert is considering purchasing the side steamer 3000, a higher-end steamer, whichcosts $12,000 and has an estimated useful life of 6 years with an estimated salvage value of$1,500. this steamer falls into the macrs 5-year class, so the applicable depreciationrates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. the new steamer is fasterand allows for an output expansion, so sales would rise by $2,000 per year; the newmachine's much greater efficiency would reduce operating expenses by $1,900 per year. to support the greater sales, the new machine would require that inventories increase by$2,900, but accounts payable would simultaneously increase by $700. gilbert's marginalfederal-plus-state tax rate is 40%, and its wacc is 15%.a. should it replace the old steamer? b. npv of replace = $2,083.51

What is inventory turnover? explain the effect of a high inventory turnover during the christmas shopping season.

Maria's family drove 140 mi to her grandparents' house and averaged 56 mi/h on the way thereon the return trip, they averaged 50 mi/hwhat was the total time maria's family spent driving to and from her grandparents' house? o2.5 ho 2.6 ho5.2 ho 53 hnext