How does the optimal profit change

Assignment Help Financial Management

Reference no: EM133662095

Assignment: Modeling Analytics

Problem I

In the LOGO Production Expanded problem, we have modeled the constraint that each product can only be produced in at most one plant in class. Now consider the alternative scenario where there are no restrictions in the number of plants to use for each product, but instead, there is a $100,000 fixed cost for setting up making each product at each plant. For example, if Santa's Grotto is only produced at Plant 1 but not Plant 2, a fixed cost of $100,000 is incurred; if it is produced at both Plant 1 and Plant 2 (regardless of actual quantities produced), a fixed cost of $200,000 is incurred; and if the product is not made at all (i.e., not sold), there are no fixed cost for this product.

Model this in your spreadsheet and solve for the optimal solution. Hint: this is related to the integer programming model.

Problem II

Refer to the Advertising Budget Optimization problem. Solve the problem with Excel Solver, and produce the sensitivity report. For the constraint on the advertising budget (currently $40,000):

1. Interpret the meaning of the Lagrangian multiplier.

2. Increase the advertising budget by $10. Resolve the problem - how does the optimal profit change? How does that compare to what the Lagrangian multiplier predicts?

3. Increase the advertising budget by $40,000. Resolve the problem - how does the optimal profit change? How does that compare to what the Lagrangian multiplier predicts?

Reference no: EM133662095

Questions Cloud

Continuing education recertification requirements : Which organization sets the continuing education recertification requirements in order to maintain a certification?

Discuss how conflict or potential conflict can impact : Provide leadership in the supervision of diverse work teams - Discuss how conflict or potential conflict can impact a team. Give examples of conflict situations

Who is critical to my leadership development : Who is critical to my leadership development, and to what extent? Who sustains me and to what extent? Who challenges me in my decisions, and to what extent?

What should they do to prepare for better communication : An American department manager is meeting with a department manager from another culture. What should they do to prepare for better communication?

How does the optimal profit change : Increase advertising budget by $10. Resolve the problem - how does the optimal profit change? How does that compare to what the Lagrangian multiplier predicts?

Analysis refers to numerical analysis of project risk : Quantitative risk analysis refers to the numerical analysis of project risk. Select the techniques and tools that apply to quantitative risk analysis.

Present a high-level example or scenario : Present a high-level example or scenario that illustrates your topic's practical implementation and strategic value in real-world project management.

Potential leader and collaborative team member : How would you assess your current skills as a potential leader and collaborative team member? Explain with reasoning and examples.

Candidates during selection process : This method helps recruiters decide which questions to ask candidates during a selection process.

User Account

All Pages