1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Vadim26 [7]
3 years ago
12

Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A sells for $101 a unit, product

B sells for $67 a unit, and product C sells for $97.50 a unit. Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. Also, there is a weekly demand of at least 10 units of product C each week. Formulate the given problem scenario as a linear program, and solve the problem using Microsoft Excel Solver. For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible. Also, the Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

Business
1 answer:
Umnica [9.8K]3 years ago
8 0

Answer:

Some answers are attached below

Explanation:

We need to maximize profit -

Selling prices for A,B,C are given; Costs of materials 1,2 and labor are given.

Also given is that 1 unit of each product A,B,C requires certain units of material 1, material 2 and labor based on the table provided.

Profit for 1 unit of A = Selling Price - Cost = 101 - [(7*3)+(5*2)+(15*4)] = 10 $

Profit for 1 unit of B = Selling Price - Cost = 67 - [(7*1)+(5*4)+(15*2)] = 10 $

Profit for 1 unit of C = Selling Price - Cost = 97.5 - [(7*5)+(5*0)+(15*3.5)] = 10 $

LP Formulation

Maximize profit Z = 10A+10B+10C

subject to Constraints

3A+B+5C<=300 ----> Material 1 constraint

2A+4B<=400 ---->Material 2 constraint

4A+2B+3.5C <=200 ----->Labor

C>=10 -----> Product C Demand constraint

A,B,C>=0

Below is the solver solution and formulation table from Excel -

Maximum profit = 925 $

You might be interested in
Paraguay’s economy is afflicted by poverty and an absence of opportunities and advantages. However, a positive aspect of this si
Art [367]

Paraguay's economy is afflicted by poverty and an absence of opportunities and advantages. However, a positive aspect of this situation is none.

The economy of Paraguay is a market financial system that is distinctly depending on agriculture products. In latest years, Paraguay's economic system has grown because of improved agricultural exports, especially soybeans. Paraguay has the monetary benefits of a young population and great hydroelectric energy.

Paraguay has been one of the poorest and most unequal nations at the continent for a long term. the total poverty rate — defined by using the world financial institution as those with an income of much less than $3.10 a day — in Paraguay rose in 2016 from 26.6 percent to 28.8 percent.

Learn more about economy here: brainly.com/question/2824360

#SPJ4

7 0
1 year ago
What is the practice of banks and mortgage lenders identifying high-risk areas (usually low-income or minority neighborhoods) an
Bogdan [553]

Answer:

redlining

Explanation:

Redlining is an illegal banking practice that focuses on neighborhoods that are mostly inhabited by minorities. The term redlining itself comes from the practice of marking neighborhoods on city maps with red lines to represent them as dangerous both for banking purposes and high crime rates.

Banks cannot directly deny a credit based on where you live, but they can charge very high interest rates that make them very difficult to pay, or simply ask for a lot of paperwork and more requirements than usual.

4 0
3 years ago
Gloria is a tax accountant who is very busy from january to april 15, which is the tax return filing deadline. she feels that sh
matrenka [14]
Gloria is encountering pressure. In spite of the fact that uneasiness might be an aftereffect of weight, Gloria is encountering weight subsequently of her need to work longer hours to meet a due date.

I hope the answer will help you. 
8 0
3 years ago
A university is trying to determine what price to charge for tickets to football games. at a price of ​$30 per​ ticket, attendan
sammy [17]

Xmax = -44545.45 / -363.63 = 122.50

^ are there any options or you have to type in the answer?

3 0
3 years ago
The first step a domestic firm takes when entering an international arena is usually to create an international division.
vodomira [7]

Answer:

The answer is: False

Explanation:

Whenever a company wants to go international it has a lot work to do before creating an international division. Several things must be done before, mostly research, for example:

  • Research if your product is know overseas, is there any possible market for it, are there any restraints for your products in those new markets.
  • Any legal constraint or logistical problem you have to consider.
  • Any local competition you have to worry about.
  • Does your product fit in a new culture.
  • And very many etceteras.

That should all be done before considering spending money on creating an international division.

Probably when the internet didn´t exist, communications were scarce, no Tv existed, people in one country didn´t know anything about other cultures, etc., a comp nay would have first created an international division to scout foreign markets but right now it doesn´t make sense.  

4 0
3 years ago
Other questions:
  • The money multiplier equals:________.
    10·2 answers
  • Which social networking platform is specifically for career networking?
    13·2 answers
  • What are implicit​ costs? an implicit cost is
    6·1 answer
  • In a small, closed economy, national income (GDP) is $350.00 million for the current month. Individuals have spent $100.00 milli
    15·1 answer
  • Alex is at the hardware store comparing different types of piping for a repair in his home kitchen. He can choose between copper
    6·2 answers
  • Money is to food as ________ is to ________.
    11·1 answer
  • Josh and Joe are opening a copy store. There are no competing copy stores in the area. They must decide how to organize the busi
    14·1 answer
  • Selling the rights to use your company's brand name in return for a lump-sum payment and a share of the profits generated is ref
    8·1 answer
  • Porter Resources Company acquired a tract of land containing an extractable natural resource. Porter is required by its purchase
    6·1 answer
  • Teresa wants to take her firm internationally but is concerned with the ________, which refers to the possibility of higher cost
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!