Implement the linear optimization model

Assignment Help Operation Management

Reference no: EM132258535

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.

Please show formulas

Reference no: EM132258535

Questions Cloud

Total cost of ownership in supplier performance metric : What is meant by "Cost/Price, Quality, Delivery, Responsiveness and Flexibility, Technology , and Total cost of Ownership" in Supplier Performance Metric.

Manufacturer of lawn care equipment : Green Thumb, a manufacturer of lawn care equipment, has introduced a new product.

Difference in use of power between good and great leaders : What is the difference in how power is exercised by leaders at various levels? What might be the difference in the use of power between good and great leaders?

Check the internet to find information about safety culture : Check the Internet to find information about "safety culture." Examine a few Web sites related to a safety culture in health care.

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

Decision to move toward mass marketing campaign : Which of the following questions is NOT relevant to Cintab's decision to move toward a mass marketing campaign?

Is the experience of mercedes-benz in east london : Is the experience of Mercedes-Benz in East London relevant to other industries. What lessons does Mercedes-Benz East London plant hold for HR managers worldwide

Improvement manual for long-term care facilities : Review the Agency for Health Care Research and Quality site and the On-Time Quality Improvement Manual for Long-Term Care Facilities.

Value-based pricing methods focus on the overall value : Value-based pricing methods focus on the overall value of the product offering

User Account

All Pages