Solution-Manufacturer makes two lines of bathtubs

Manufacturer makes two lines of bathtubs

Assignment Help Basic Computer Science

Reference no: EM131349001

2-34 A plumbing manufacturer makes two lines of bathtubs, model A and model B. Every tub requires blending a certain amount of steel and zinc; the company has available a total of 24,500 pounds of steel and 6,000 pounds of zinc. Each model A bathtub requires a mixture of 120 pounds of steel and 20 pounds of zinc, and each yields a profit of $90. Each model B tub produced can be sold for a profit of $70; it requires 100 pounds of steel and 30 pounds of zinc. To maintain an adequate supply of both models, the manufacturer would like the number of model A tubs made to be no more than 5 times the number of model B tubs. Find the best product mix of bathtubs.

NEED IT DONE IN EXCEL WITH BOTH LP MODEL AND SOLVER MODEL.

Reference no: EM131349001

Questions Cloud

Does unstructured data model need special hardware : Does unstructured data model need special hardware to store the database, or does it have some unique feature to the way it stores data (essentially how does it interact with hardware). Include a discussion about the physical interactions with har..

Unstructured data modeling approach : 1) What is the benefit of using unstructured data modeling approach? Why is that benefit important?

Code to run while a condition is true or false : What is the method called when you want a code to run while a condition is true or false?

Run for a fixed amount of times : What is the method called when you want a code to run for a fixed amount of times?

Manufacturer makes two lines of bathtubs : A plumbing manufacturer makes two lines of bathtubs, model A and model B. Every tub requires blending a certain amount of steel and zinc; the company has available a total of 24,500 pounds of steel and 6,000 pounds of zinc

Briefly describe the threat : Locate an article that describes a recent security threat (or attack) on an e-commerce site. Choose a threat or attack that occurred within the last 10 years. Read the article, and then draft a two-page paper to address each of the following:

Which version you consider to be more artistic and why : Discuss the plot points. What is the dramatic premise? What is our main character's dramatic need? Compare and contrast the two versions of the film. Discuss which version you consider to be more "artistic" and why.

Events in the conversion process : 1. Describe attribute conflict in view integration. How it is resolved? 2. List and describe three logical level implementation compromises. 3. Identify the resources and agents associated with each of the following events in the conversion process:

What did you agree with and disagree with why : What did you agree with and disagree with, why? Which insights were surprising to you? Which insights confirmed what you already believed about yourself? What are your strengths, as shown in the quizzes?

User Account

All Pages

Manufacturer makes two lines of bathtubs

Reference no: EM131349001

Reference no: EM131349001

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT