Implement the linear optimization model

Assignment Help Operation Management

Reference no: EM132257232

A marketing company needs to decide how much time to allocate between radio and television advertising during the next month. The manager has determined that at least 80% of the time should be allocated to TV. Each minute of Ad on radio costs $400, and provide 300 units of exposure. Each minuite of Ad on TV costs $1500, and provide 800 units of exposure. How much time should the manager allocate between radio and television advertising to achieve 35,000 units of exposure at the minimum cost? Please complete in excel and show steps.

Part A. Very clearly define appropriate decision variables.

Part B. Define the objective function. List the function. Do we want to maximize or minimize?

Part C. Formulate all needed constraints.

Part D. Implement the linear optimization model in excel and use solver to find an optimal solution.

Reference no: EM132257232

Questions Cloud

What potential ethical and legal liabilities are there : What potential ethical and legal liabilities are there for the hospital and employees in the case presented above? In 2007, Harvard University rescinded.

Downs three-stage model of the life cycle of organization : Explain Downs’s three-stage model of the life cycle of an organization.

Determine the retail market strategy : Describe the current climate and situation that your retailer finds itself in as it attempts to compete. Describe what's occurring in the industry

Perspective on the top three intelligence priority issues : Discuss your perspective on the top three Intelligence priority issues facing the Intelligence Community over the next 25 years.

Implement the linear optimization model : Implement the linear optimization model in excel and use solver to find an optimal solution.

Define how the theory applies to current practice : Provide 3 examples of how the theory applies to current practice. Provide 3 positive patient outcomes resulting from utilizing the theory.

Analyze business communication situations : The leaders of an organization know they have to downsize (that is, fire) a large number of employees but do not effectively communicate the situation.

Describe the potential barriers to plan implementation : In this assignment, students will pull together the change proposal project components they have been working on throughout the course to create a proposal.

How does theory determine or influence each recommendation : How does the theory determine or influence each of their recommendations for action? What theory do you agree with? Why? How would that theory determine.

User Account

All Pages