3. 1234Scost50080020050700cost2.000.503.005.001.00Production3000O0100Production15001200800anyanyPollution863a2Develop an integer program to help Alpha manufacturing decide which machines to use for panel production andhow many panels need to be produced under each machine to minimize total cost. (Define the decision variables,objective function, and all the constraints to receive full credit.) Alpha manufacturing must decide on a production plan to produce 1650 units of control panels. They have fivemachines. If machine 1 is used, its production will be between 300 and 1500 units. If machine 2 or machine 3 areused, they can produce up to 1200 and 800 units, respectively. Machine 4 can be used with no restrictions and ifwe use machine 5, there is a minimum production of 100 units due to its high fixed cost. Machine 1 and 4 cannotbe used together due to their high pollution rates. In addition, the total pollution generated by selected machinescannot exceed 20 units. There is a fixed cost associated with setting up each machine and a maximum budget of1700 on the total fixed cost is set. The fixed cost along with the variable cost per panel are shown in the followingtable:13Machine24Fixedcost50080020050700Variablecost2.000.503.005.001.00MinimumProduction3000lo0100MaximumProduction15001200800anyanyPollution863Develop an integer program to help Alpha manufacturing decide which machines to use for panel production andhow many panels need to be produced under each machine to minimize total cost. (Define the decision variables.

ANSWER : Here is an integer program that Alpha Manufacturing can use to decide which machines to use…

Answered: 3 Aipha ufacturing must decide on a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
Q.2.2 Compare and contrast between the grassroots forecasting technique and the Delphi method. Q.2.2 Explain integrated service providers in logistics management. Q.2.3 Explain how distribution requirements planning (DRP) is used. Q.2.4 An organisation produces customised wooden furniture. In your opinion, can the organisation utilise triple bottom line (3BL) to improve its production of wooden furniture? Justify your answer by discussing at least 3 key points.
Q1. An LMN sugar mill company, department stores wish to purchase 10,000 handbags of which 2,000 are of style A, 2,000 are of style B, 3,000 of style C and 3,000 are of style D. Four manufacturers P, Q, R and S bid to supply not more than the following quantities, all styles combined. P= 1,500, Q = 2,600, R = 3,500 and S = 3,000. The following table gives the cost per handbag of each style of the bidders in RO. per handbag: Style Manufacturers P Q R S A 9 12 10 8 B 10 11 9 7 C 8 10 7 10 D 10 9 9 8 Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? Compare transportation cost by both models(NWCR and LCM)
D & R A1 10 - 6 Question 10. Minimum Variance Commodity Hedge Choc Full of Good Inc., a producer of powdered hot chocolate, has just received a large order that will require the purchase of 800 metric tons of cocoa in 3 months. The current spot price of cocoa is US $3,055 per metric ton. The standard deviation of the change in spot cocoa price is 0.2. Mr. Dulce, the CFO of Choc Full, is considering a minimum-variance hedge of this future cocoa purchase using the three-month cocoa futures contract. The contract size is 10 metric tons. The standard deviation of the change in cocoa futures price is 0.25. The covariance between the change in the spot and futures cocoa price is 0.035. The annually compounded interest rate faced by the company is 5%, the three-month storage cost is $2.5 per metric ton, and the convenience yield is $0.5 per metric ton. What is the estimated effectiveness of this minimum variance hedge?
Question 10.6 Storage Limited operates a 50-week working year. It produces a product called "GENERAL' for which demand any week in the year is described by the probability distribution below: Demand 2 3 4. 7 8. 9 Probability 0.07 0.10 0.11 0.13 0.15 0.17 0.13 0.08 0.04 0.02 Demand can only be satisfied (if at all) from stocks. The stockholding costs are N4 per item per year. Fixed costs per re-order are N16 and the variable, re-order costs are N30 per unit Lead time is one week. The costs of being out of stock are N12 per unit short. You are required to calculate: (i) The average weekly demand; [i] The Economic Order Quantity; [iv] The number of ordering cycles in the year; and [v] State briefly the main reason for holding inventory, and explain why good inventory management is a very important aspect of overall company management. [ii The average annual demand;
Need help, thanksss
Q1. Dallas Mavericks’ owner Mark Cuban proved his business intelligence once again with the acquisition of star player Kristaps Porzingis. To benefit from this blockbuster trade even further, Cuban plans to sell one-time-only special edition Porzingis jerseys at a price of $380 each during the first month of the season (i.e., during October 2019 only). The production cost for each of these jerseys would be $100 thanks to their golden details, and any unsold jersey during October will be sold for $80 during November 2019. Knowing the fan base for years, Cuban estimates demand for these special edition jerseys to follow a normal distribution with a mean of 10,000 units and a standard deviation of 2,000. partc. Cuban also plans to sell these special edition jerseys in his vacation resort. Knowing that people are wealthier in the resort, he sets a price of $500 for each jersey (although production cost stays the same). This time however, he cannot sell any unsold jerseys outside the…
SUBJECT: Fundamentals of Business Analytics How does analytics be useful in the sector of: A. TourismB. AgricultureC. Economics
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
Question 1 16 p A person places Php 75,000 in a savings account which pays 12 percent interest per annum, compounded continuously. Find the amount (in Php) in the account after four years, presuming no withdrawals and no additional deposits. Note: Input numerical values only, do not the units, space or comma. Next DII F9 F8 F7 80 F 6 F5 F4 F3
N-2
3. If the fiscally break-even value for a home is $300,000, and the land price is $350,000 per acre, the minimum lot size would be а. 1/4 аcre b. 1/3 асre c. 1/5 acre d. 1/6 acre

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS