User Account

All Pages

Formulate a linear programming model

Assignment Help Business Management
Reference no: EM131696915

Costal Cup Company wants to determine how many cases of large and small cups should be produced per day in order to maximize profit given the labor and material constraints. The unit profit value for large cups is $30 per case, for small cups the unit profit value is $25 per case. There are 120 hours of labor and 2000 units of resin material available per day. Each case of large cups requires .75 hours of labor and 15 units of resin material to produce, each case of small cups requires 1 hour of labor and 12 units of resin material to produce. 

  1. Formulate a linear programming model for this problem to determine how many cases of small cups and how many cases of large cups should be produced in order to maximize the total profit.

Let large cups be X, and Let small cups be Y. Given Maximize total = 30x+25y

  1. Solve this problem by using the graphing method OR by using Excel Solver.
  2. What is the optimal solution?
  3. Which constraints are binding?

Note: Instructions for how to add and use the Solver Add-in are located in the Week 1 Instructional Materials: Lecture: Linear Programming Modeling Using Excel.

Reference no: EM131696915

Questions Cloud

Regulate the dissemination of technology worldwide : Analyze the need for a "Trans-National" organization to encourage and regulate the dissemination of technology worldwide.
What type of advertising methods do they use : Schedule a meeting with the business owner or a company employee knowledgeable on their business operations to discuss their advertising methods.
Background and reasoning for the change : First identify the change, the background and reasoning for the change. Second, as a health service manager discuss how you would scan.
Show positions of proprietary dealers using position diagram : In contrast, Euro BBA LIBOR will be calculated from quotes from just 16 institutions. (From Thomson Reuters IFR, December 18, 1998).
Formulate a linear programming model : Formulate a linear programming model for this problem to determine how many cases of small cups and how many cases of large cups.
How can you design a plan that will prevent terrorist attack : How can you design a plan that will prevent terrorist attacks or at least provide the best response to these attacks?
How to determine shear stress deflection : Write notes on close-coiled springs ,open-coiled springs semi elliptical leaf springs, quarter elliptical leaf springs- how to determine shear stress deflection
Computer hardware and computer software : Describe the difference between computer hardware and computer software.
Construct a synthetic equivalent of the bond : You have a 4-year coupon bond that pays semiannual interest. The coupon rate is 8% and the par value is 100.

Reviews

Write a Review

Business Management Questions & Answers

  Alternative approaches to managing resistances

Assess alternative approaches to managing resistances. Consider how to deal with toxic players.

  Explain carpal tunnel syndrome

Explain carpal tunnel syndrome. What structures are involved, and what pathology exists here? Recommend prevention tips and treatments for this syndrome.

  Analyze internal and external factor related to the business

Analyze internal and external factors related to the business environment of Starbucks. Based on your analysis, describe the trends in corporate social responsibility, sustainability, and business ethics that will impact Starbucks.

  Explain multiple aspects of managerial planning process

Use technology and information resources to research issues in management concepts and write clearly and concisely about management concepts using proper writing mechanics.

  What are some potential returns on investment opportunities

What are some potential returns on investment opportunities a business may have as a result of investing in analytics?

  Management conflict with the interests of shareholders

Do you think the self interests of management conflict with the interests of shareholders - Self interests of management conflict with the interests of shareholders?

  Can organizational learning play a role in improving value

Discuss the concept of "value" as it relates to social, environmental, and economic inputs. How is value perceived differently from different stakeholders?

  Second one targets consumers

The difference between these two types of marketing strategies is that the first one targets consumers who are __________ and the second one targets consumers who are __________.

  Determine whether hardware virtualization helps businesses

Determine whether hardware virtualization helps businesses and organizations in terms of, Determine whether software virtualization helps businesses and organizations in terms of

  Teaching entrepreneurship

What strategic plans could the college or university at which you took management course adopt to compete for students in marketplace? Would this plan depend on schools goals?

  List the steps of the redirection process

To avoid shutting down a website when changing the server of the website, redirecting traffic to an intermittent subdomain is required? List the steps of the redirection process?

  What is the average number of people in line

What is the average number of people in line?  - Mehmet raises the price to $5 per cup and takes 60 seconds off the service time.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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