Decide the daily production quantity of certain product

Assignment Help Operation Management

Reference no: EM132216554

As a supervisor of a production department, you must decide the daily production quantity of a certain product that has two models, the Deluxe and the Special, to maximize the total profit. The company sells the Deluxe model for $18 per unit and the Special model for $15 per unit. It costs $6 and $5 to produce each Deluxe model and Special model, respectively.

Each model goes through two phases in the production process, and there are only 100 hours available daily at the construction stage and only 80 hours available at the finishing and inspection stage. Each Deluxe model requires 20 minutes of construction time and 10 minutes of finishing and inspection time. Each Special model requires 15 minutes of construction time and 15 minutes of finishing and inspection time. The company has also decided that the Special model must comprise at least 40 percent of the production total.`

Input and solve the profit-maximization model using Excel Solver. After running Solver, generate sensitivity report.

Your Excel file must be executable. If your excel model is ran, it should provide the same results you submit.

That means the spreadsheet has correct embedded formulae and Solver dialog boxes have all the inputs. If ‘Solve’ is clicked and your spreadsheet does not produce the reported results, a zero score will be assigned.

Reference no: EM132216554

Questions Cloud

Core competency made nike highly successful : Although this core competency made Nike highly successful, it has not been without considerable risks.

Biblical scriptures relating to the topic of lean concept : Provide three (3) biblical scriptures relating to the topic of the "lean" concept.

Impact on institution viability : Health care reform will have an impact on an institution’s viability but it won’t be known until it is actually in effect.

What do you think of the lockheed kill chain : What do you think of the Lockheed Kill Chain? Why has this model caught on within the information security field?

Decide the daily production quantity of certain product : As a supervisor of a production department, you must decide the daily production quantity of a certain product that has two models, th

Personal selling has become very expensive marketing tactic : Although personal selling has become a very expensive marketing tactic, it still can make sense in certain very specialized situations.

Develop detailed object-oriented design models : identify four most important use cases for the system and develop communication diagrams or sequence diagrams for these use cases

Estimate the time it takes to deliver all packets : Now suppose you have a file that needs 1.000 same-size packers to be delivered and you have just delivered the first 499 packets.

Write a verilog that applies six directed test patterns : Write a Verilog testbench that applies six directed test patterns to a 32-bit 2's complement adder. Explain what each of your patterns is checking for.

User Account

All Pages