Are there any sign or type restrictions in your formulation

Assignment Help Operation Management
Reference no: EM131723029

The Eaglego Arts designs, produces, and sells packaged lego pieces to build replicas of world-famous art sculptures. Each “lego sculpture pack” contains instructions on how to build the sculpture and the lego bricks required for sculpting. The most popular designs are Model A and Model B. Each of these models requires black and white lego bricks. The company has a total of 15,000 pieces of black and 4,000 pieces of white lego bricks in stock. Each Model A requires 50 black and 12 white pieces, and yields a profit of $40 per pack. Each Model B requires 75 black and 25 white pieces and can be sold for a profit of $65 per pack. The company has to determine the optimal product mix (i.e., determine the production quantities that maximize profits). You will formulate a linear programming model for this optimization problem. Do NOT solve the optimization problem.

Q: Are there any sign or type restrictions in your formulation? Why or Why not? Clearly explain the sign and type restrictions (if any). Prepare a spreadsheet to determine the optimal production mix using Excel solver. Provide a screenshot of your spreadsheet model. The screenshot should show all the cells involved in formulating the optimization problem. Provide a screenshot of your spreadsheet with the formula view. Prepare the solver model by logging all the information to the solver parameters window in Excel. Provide a Screenshot of the solver parameters wndow in Excel. Solve the optimization problem using Excel solver. What is the optimal solution i.e. the optimal cost and the optimal values of decision variables?

Reference no: EM131723029

Questions Cloud

Three degrees of negligence recognized in tort law : Distinguish between the three degrees of negligence recognized in tort law and give examples of each.
The main difference between purchasing and procurement : The main difference between purchasing and procurement is:
Explain the structure of in-transit merge supply networks : Why achieving strategic fit is important for supply chain companies? Explain the structure of in-transit merge supply networks.
Advantage in the global construction machinery industry : How did Caterpillar, a heavy equipment manufacturer, regain a competitive advantage in the global construction machinery industry?
Are there any sign or type restrictions in your formulation : Are there any sign or type restrictions in your formulation? Why or Why not? Clearly explain the sign and type restrictions (if any).
Present the various measures for message effectiveness : Present the various measures for message effectiveness. In each explain what is measured and how it is related to any particular stage of persuasion process.
Master production scheduled quantity : Firm XYZ has a master production scheduled quantity of 60 units due in weeks 2 and 4 Ending inventory in week 1 is 10 units.
The most basic type of operation process : The most basic type of operation process is. All are the following are true regarding business except. Operations can include all except.
When offering high-boutique services into retail platform : Identify the risk assessment factors when offering high end boutique services into a retail platform.

Reviews

Write a Review

Operation Management Questions & Answers

  Draw time management matrix and estimate

Draw a time management matrix and estimate what percentage of your time (non-sleeping) you spend in each quadrant. Then log your time for three days in 15-minute intervals.

  What reasons might there be for using multiple criterions

llustrate what reasons might there be for using a single measure also illustrates what reasons might there be for using multiple criterions.

  Demand is also a variable and normally distributed

Gainesville Cigar stocks Cuban cigars that have variable lead times because of the difficulty in importing the product: Lead time is normally distributed with an average of 7 weeks and a standard deviation of 1 week. Demand is also a variable and nor..

  Consequences of the organizational behavior modification

Describe and explain the four types of consequences of the Organizational Behavior Modification, otherwise referred to as the OB Mod, which offers useful ways to understand how workplace events can influence employee learning and motivation.

  Is marketing really a universal concept

Is marketing really a universal concept? Defend your reasoning. How does the Bill of Rights, mainly the 1st Amendment both limit and protect business in general? What are the characteristics of effective project teams?Describe the four things that ar..

  Elucidate how can janet plan for also avoid these risks

Elucidate how can Janet plan for also avoid these risks. Does likelihood of these risks affect Janet's actions. Elucidate how.

  Determine the total cost of quality

The costs of quality are given by the following equations, Determine the total cost of quality when there are no defectives. D= 0 and product quality is perfect.

  Case study describing one specific issue at the organization

1. Develop the final project as a case study describing an  organization of your choice/OR an organization you researched using various content from (example: diversity, culture, motivation, leadership).

  Find economies of scope

Find economies of scope. Provide examples of specific actions Harley-Davidson's managers could take to reduce expenses or share activities.

  About the strategic decision-making process

After reading about the Strategic Decision-Making Process in the chapter discuss which of the eight steps you feel is the most important of the process to achieve competitive success for a firm. Please provide at least 200 words in your written discu..

  Leadership and influence processes

Leadership and Influence Processes The Struggle for Power at Ramsey Electronics A vice president’s position is about to open up at Ramsey Electronics,

  Does the court have jurisdiction

A class-action suit was filed in federal court seeking $18,000 damages. Does the court have jurisdiction? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd