Company manufactures and markets microwave ovens

Assignment Help Operation Management

Reference no: EM132164497

The Magnetron Company manufactures and markets microwave ovens. Currently, the company produces two models: full-size and compact. Production is limited by the amount of labor available in the general assembly and electronic assembly departments, as well as by the demand for each model. Each full-size oven requires 2 hours of general assembly and 2 hours of electronic assembly, whereas each compact oven requires 1 hour of general assembly and 3 hours of electronic assembly. In the current production period, there are 500 hours of general assembly labor available and 800 hours of electronic assembly labor available.

In addition, the company estimates that it can sell at most 220 full-size ovens and 180 compact ovens in the current production period. The earnings contribution per oven is $120 for a full-size oven and $130 for a compact oven. The company would like to find an earnings-maximizing production plan for the current production period.

Formulate the above problem as a linear optimization model and solve via Excel’s solver. Please turn in both a written formulation and an Excel file with the solution.

Reference no: EM132164497

Questions Cloud

Persuasion-powerful speech delivered : You hear a very powerful speech delivered by a member of a community-based activist group that advocates for the less fortunate in your town.

Diversified with internal new venture : Give an example of a firm that has diversified with an internal new venture. Was the strategy successful? Why or why not?

Discipline awareness paper business related : Discipline Awareness paper Business related asks you to look closely at the field to which you belong through the lens of an academic conference.

Your ability to reduce employee benefit costs : You are the HR manager for Crangle Fixtures, and your bonus for this year is based on your ability to reduce employee benefit costs.

Company manufactures and markets microwave ovens : The Magnetron Company manufactures and markets microwave ovens. Currently, the company produces two models: full-size and compact.

Discuss five benefits of supplying to low-cost producer : Discuss 3 challenges associated with supplying to low-cost producers? Discuss 5 benefits of supplying to low-cost producer?

Number of complaints regarding health care service quality : Management Dilemma: The firm is experiencing an increasing number of complaints regarding health care service quality.

What aspects of the experience were positive : What aspects of the experience were positive? What aspects of the experience were negative?

Federal government department has high levels of absenteeism : A federal government department has high levels of absenteeism among the office staff.

User Account

All Pages