Question: Open the file Accounting Allocations xls on the book web site
Open the file Accounting Allocations.xls (on the book web site) to see a list of sample accounts that a firm has for their various plants. Your team has already gone through these accounts and has determined whether the costs are fixed or variable. What are the fixed and variable costs you should load into the model based on this analysis? Which plant has the highest overall fixed cost? Which plant has the lowest per-unit variable cost? How would you rank the competitiveness of these plants?
Answer to relevant QuestionsOpen the file from Chapter 3, "Locating Facilities Using a Distance-Based Approach," called MIP for 9-City Example.xls. Assume that the baseline had St. Louis serving itself, Chicago, and Cincinnati, while Boston served all ...Based on the results seen previously in this chapter, as well as your running of these scenarios on your own through the model and PowerPoint referenced previously, review the new locations selected as the model solves for ...What is the value if all plants could make all four products? How much better of a solution could you derive? If two large companies merge, why might you want to run a multi-objective optimization to trade off the total cost of company one versus the total cost to company two? That is, why might this be better than running with just ...Why shouldn’t your model be an exact one-to-one replica of the supply chain?
Post your question