Computers and Technology, 24.05.2021 23:20 jace9926

A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits. Production requirements for the products are shown in the following table. Product Material 1 (lbs.) Material 2 (lbs.) Labor (hours)
A 3 2 4
B 1 4 2
C 5 none 3.5
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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 00:30

Jenny wants to look at row 345 and compare it to row 17. what can she do if she wanted to easily adjust to see both at once?

Answers: 3

Answer

Computers and Technology, 22.06.2019 04:30

There is a simple pattern for determining if a binary number is odd. what is it and why does this pattern occur? how many bits would you need if you wanted to have the ability to count up to 1000? how high could you count in binary if you used all 10 of your fingers as bits? (finger up means 1, finger down means 0)

Answers: 3

Answer

Computers and Technology, 22.06.2019 10:30

You are almost finished updating a web site. as part of the update, you have converted all pages from html 4.0 to html5. the project is currently on schedule. however, your project manager has been asked by the marketing team manager to justify a day of time spent validating the site's html5 pages. the marketing team manager does not have technical knowledge of the internet or the web. which is the most appropriate explanation to provide to the marketing team manager?

Answers: 1

Answer

Computers and Technology, 23.06.2019 00:00

Which is the correct sequence of steps to set up a document in landscape orientation? a. select page setup from the file menu. then click the margins tab and select landscape. b. select page setup from the edit menu. then click the margins tab and select landscape. c. select page setup from the insert menu. then click the margins tab and select landscape. d. select page setup from the format menu. then click the margins tab and select landscape

Answers: 1

Answer

You know the right answer?

A production manager wants to determine how many units of each product to produce weekly to maximize...

Questions