Question

Срочно!!!!!!!!!!!!. Определите количество выпускаемых комплектов мебели трех видов, обеспечивающее получение максимальной прибыли. Комплект мебели «Свирель» включает 1 кровать, 2 комода, трюмо, 2 шкафа. Комплект мебели «Поэма» включает 2 кровати, 1 комод, 2 трюмо, 1 шкаф. Комплект мебели «Соцветие» состоит из 2 кроватей, 2 комодов и 1 трюмо. Количество комплектов мебели «Свирель» должно быть не менее 4 и не более 10. Предпочтительно выпускать комплекты мебели «Поэма» и «Соцветие» в соотношении 1/1. Прибыль от реализации комплектов мебели каждого вида составляет: «Свирель» – 35000, «Поэма» – 40000, «Соцветие» – 20000. Выпуск кроватей, комодов, трюмо и шкафов не должен превышать соответственно 50, 30, 30, 30 штук. Используя границы и форматирование символов, выделите искомые значения.

Answer 1

Количество комплектов 4, 7, 7
Прибыль 560000
Вариант в Excel 2003
Сервис поиск решения.
Для того, чтобы включить: поставить галочку Сервис/надстройки/поиск решения.

Answer 2

To determine the number of furniture sets of each type that will yield maximum profit, we need to consider the constraints and preferences given in the question.

The three types of furniture sets are: 1. "Свирель" (Sviriel) set: includes 1 bed, 2 dressers, 1 chest of drawers, and 2 wardrobes. 2. "Поэма" (Poema) set: includes 2 beds, 1 dresser, 2 chests of drawers, and 1 wardrobe. 3. "Соцветие" (Sotsvetie) set: includes 2 beds, 2 dressers, and 1 chest of drawers.

The constraints and preferences are as follows: - The number of "Свирель" sets should be between 4 and 10. - The preferred ratio of "Поэма" and "Соцветие" sets is 1:1. - The profit from selling each type of furniture set is as follows: - "Свирель" set: 35,000 units - "Поэма" set: 40,000 units - "Соцветие" set: 20,000 units. - The maximum number of beds, dressers, chests of drawers, and wardrobes that can be produced are: - Beds: 50 units - Dressers: 30 units - Chests of drawers: 30 units - Wardrobes: 30 units.

To find the optimal number of sets to produce for each type, we can use linear programming techniques. However, since the question asks for a detailed response, we can manually calculate the maximum profit by considering different scenarios.

Let's consider the following scenarios:

Scenario 1: Producing the maximum number of "Свирель" sets (10 sets): - Number of beds: 10 x 1 = 10 - Number of dressers: 10 x 2 = 20 - Number of chests of drawers: 10 x 1 = 10 - Number of wardrobes: 10 x 2 = 20 - Total profit: 10 x 35,000 = 350,000 units

Scenario 2: Producing the maximum number of "Поэма" and "Соцветие" sets in a 1:1 ratio (equal number of sets for both types): - Number of "Поэма" sets: (4 + 10) / 2 = 7 sets - Number of "Соцветие" sets: (4 + 10) / 2 = 7 sets - Number of beds: 7 x 2 + 7 x 2 = 28 - Number of dressers: 7 x 1 + 7 x 2 = 21 - Number of chests of drawers: 7 x 2 + 7 x 1 = 21 - Number of wardrobes: 7 x 1 + 7 x 0 = 7 - Total profit: (7 x 40,000) + (7 x 20,000) = 420,000 units

Comparing the two scenarios, we can see that producing the maximum number of "Поэма" and "Соцветие" sets in a 1:1 ratio yields a higher profit. Therefore, to obtain the maximum profit, it is preferable to produce 7 sets each of "Поэма" and "Соцветие" sets.

The values to be highlighted are as follows: - Number of "Поэма" sets: 7 - Number of "Соцветие" sets: 7 - Total profit: 420,000 units.

Please note that the calculations provided are based on the information given in the question.