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

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 10:00, kimmmmmmy333

According to alisa miller foreign news bureaus

Answers: 3

continue

Computers and Technology, 22.06.2019 14:20, babyrocks7300

Consider a byte-addressable computer with 16mb of main memory, a cache capable of storing a total of 64kb of data and block size of 32 bytes. (a) how many bits in the memory address? (b) how many blocks are in the cache? (c) specify the format of the memory address, including names and sizes, when the cache is: 1. direct-mapped 2. 4-way set associative 3. fully associative

Answers: 2

continue

Computers and Technology, 23.06.2019 11:00, abdulbasharee99

In the context of the box model, what is the difference between a margin and a padding? a. a padding lies outside a box border, while a margin lies inside it. b. a padding lies inside a box border, while a margin lies outside it. c. a padding can be adjusted independently, while a margin depends on the size of its box. d. a padding depends on the size of its box, while a margin can be adjusted independently.

Answers: 3

continue

Computers and Technology, 23.06.2019 19:00, nayo2006

Acompany is hiring professionals for web designing. the firm is small with few resources. they want employees who possess problem-solving skills and can independently carry out responsibilities. which kind of employee should they select?

Answers: 2

continue

Do you know the correct answer?

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