Please solve using excel solver Shivani founded a company that specializes in hand-crafted wooden furniture. She is planning to devotetheir production capacity this week to producing up to three different products: a dining table, a diningchair, and a sleigh bed. The machine-hours required for each unit of the respective products, along withthe available capacity of the machines, are summarized in the table below. The unit profits would be $250,$100, and $350 for the table, chair, and bed, respectively. How many of each product should Shivaniproduce so as to maximize profits? Build a linear programming spreadsheet model, and solve it usingSolver.Machine-Hours Required per UnitAvailable TimeDining TableDining ChairSleigh Bed (machine-hours per week)Milling MachineLathe157542000Grinder2900

Decision Variable: Suppose-T be the no. of the dining tables to be producedC be the no. of the…

Answered: Shivani founded a company that…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section: Chapter Questions

Problem 80P

See similar textbooks

Similar questions

Solve Problem 1 with the extra assumption that the investments can be grouped naturally as follows: 14, 58, 912, 1316, and 1720. a. Find the optimal investments when at most one investment from each group can be selected. b. Find the optimal investments when at least one investment from each group must be selected. (If the budget isnt large enough to permit this, increase the budget to a larger value.)
The following information relates to Questions 10-11: The production planner for Rienzo, Inc. produces two chemicals: Alpha (A) and Delta (D). Two of his resources are constrained: Jaya, of which he can get at most 8,400 litres per week; and Sanga, of which he can get at most 4,600 litres per week. Each unit of Alpha chemical requires 16 litres of Jaya and 7 litres of Sanga, while a unit of Delta chemical uses 8 litres of each type of raw material. Profits for the Alpha blend are £3.00 per unit, and profits for the Delta blend are £5.00 per unit. Question 10 What is the objective function? A £1 A + £5 D = Z B £8 A + £16 D = Z C I do not wish to answer this question. D £3 A + £5 D = Z E £16 A + £8 D = Z F £7 A + £8 D = Z
XYZ Corporation operates two plants, each of which has a capacity of 140 units per day. Each day, XYZ must ship their product to each of four customers. Customers A, B, and C each have a demand of 11 units per day while customer D has a demand of 247 units per day. The cost of shipping one unit of each product from each of the two plants to each of the customers is shown in the table below. Customer A Customer B Customer C Customer D Plant 1 12 18 21 10 Plant 2 16 14 18 20 How many units should XYZ ship from each plant to each customer? Customer A Customer B Customer C Customer D Plant 1 Plant 2 What is the least XYZ will spend on shipping each day?
Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for nurses to make sure there are enough of them on duty throughout the day. During the day, the demand for nurses varies. Maureen has broken the day into twelve 2-hour periods. The slowest time of the day encompasses the three periods from 12:00 A.M. to 6:00 A.M., which, beginning at midnight, require a minimum of 30, 20, and 40 nurses, respectively. The demand for nurses steadily increases during the next four daytime periods. Beginning with the 6:00 A.M.8:00 A.M. period, a minimum of 50, 60, 80, and 80 nurses are required for these four periods, respectively. After 2:00 P.M. the demand for nurses decreases during the afternoon and evening hours. For the five 2-hour periods beginning at 2:00 P.M. and ending at midnight, 70, 70, 60, 50, and 50 nurses are required, respectively. A nurse reports for duty at the beginning of one of the 2-hour periods and works 8 consecutive hours…
Hoosier Power needs to determine a capacity expansion plan to meet Bloomington’s power needs for the next 20 years. The current capacity is 5000 kwh. The demand for the current year is 4000 kwh, and demand is expected to increase by 1000 kwh in each succeeding year. At the beginning of each year, Hoosier Power must determine the amount of capacity to add, given the following inputs: ■ Any year in which capacity is added, a fixed cost of $120,000 is incurred plus a cost of $120 per kwh of capacity. ■ At most 10,000 kwh of capacity can be added in a single year. ■ It costs $25 per year to maintain a unit of capacity. ■ It costs $12 per year to produce a kwh. ■ If production does not meet demand, a shortage cost of $80 per kwh short is incurred. Develop a linear integer model to help Hoosier Power minimize its costs for the next 20 years.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS