Question 40A production manager wants to determine how many units of each product to produce weekly to maximize weeklyprofits. Production requirements for the products are shown in the following table.TTITProductMaterial 1 Material 2Labor...(Ibs.)(Ibs.)(hours)A4B145none3.5Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. There is a standing orderof 10 units of product C each week.The following table shows the output of POMQM.VariableValue Reduced CostOriginal Val Lower Bound-In finityUpper BoundA101020B82.5105.7143InfinityC1010-In finity17.5Original Val Lower Bound300ConstraintDual Value Slack/SurplusUpper BoundConstraint 1167.5In finityIn finity235132.5Constraint 270400330Constraint 3520035Constraint 4-7.51057.1429Which constraints are binding?A All constraints are binding.B 1 and 23 and 4D 2 and 3E) 1 and 4

Answered: A production manager wants to determine…

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

Question 1 You may produce seven products by consuming three materials. The unit sales price and material consumption of each product are listed in Table 1. For each day, the supply of these three materials are limited. The supply limits are listed in Table 2. For each day, you need to determine the production quantity for each product. Product Price Material 1 Material 2 Material 3 1 100 0 3 10 2 120 5 10 10 3 135 5 3 9 4 90 4 6 3 5 125 8 2 8 6 110 5 2 10 7 105 3 2 7 Table 1: Product information for Problem 1 Material Supply limit 1 100 2 150 3 200 Table 2: Material information for Problem 1 Formulate a linear integer program that generates a feasible production plan to maximize the total profit (which is also the total revenue, as there is no cost in this problem). Then write a computer program…
Question 1 A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutes for cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution.b. Graph the feasible region.c. Determine the coordinates of each extreme point.
Question 3: A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Use Excel Solver to solve the problem (provide exact values for all variables and the optimal objective function).
QUESTION THREEa) Zambia Breweries has a backlog of 250 crates of Fanta drinks at the end of December. The demand of Fanta drinks is expected to be 400 crates in January, 500 crates in February and 550 crates in March. Each worker can produce 50 crates of drinks per month with regular wage costing the company K10 000 per worker per month. Hiring cost has been calculated to be K25 000 per. Hiring cost has also been calculated to be K50 000 per worker. Backlog cost have been determined to cost the company K250 per worker. There are no cost associated with carrying the inventory. Develop a level of production plan (aggregate plan) and determine the cost. b) Explain why aggregate planning is necessary in production and operation management.c) Define the meaning and what happens at each of these aggregate capacity planning;i) Matching Demand approachii) Level Capacity approach.
Multiple choice question 7. Lot sizing is selecting the _______ size of a batch of products to be manufactured to meet the ________ of the process. a) Smallest/demand b) Largest/supply c) Required/requirements d) Optimal/requirements e) None of the above 9. Identify the incorrect statement: a) Capacity is a critical resource b) Capacity is an infinite resource c) Capacity is never constant d) Capacity can be defined as a dimension of time e) None of the above are incorrect 10. The break-even point is where: a) Total income = Fixed cost + (variable costs x quantity produced). b) Total costs = Fixed costs. c) Variable costs x quantity produced = price per unit x quantity produced d) None of the above 10. Aggregate planning decisions are __________ decisions defining the parameters within which an organisation will operate. a) Strategic b) Tactical c) Top management d) Stakeholder
Question 1: A company that runs a chain of beauty parlours across India and also retails make-up, has defined its core competencies as value creation for the customer, commitment to product quality and professionalism. Identify at least 3 micro competencies under each of the above, which all employees need to exhibit and explain the relevance of each. Question: 2 Tarun is the Business Head for a hardware manufacturing company. Som is the Production Head, in the same salary band as Tarun. How do their roles differ? What are the similarities in their roles?
Question: Courtesy Calls makes telephone calls for businesses and charities. A profit of $0.50 is made for each business call and $0.40 for each charity call. It takes 4 min (on average) to make a business call and 6 min (on average) to make a charity call. If there are 240 min of calling time to be distributed each day, how should that time be spent so that Courtesy Calls makes a maximum profit? What changes, if any, occur in the maximum profit and optimal production policy if they must make at least 12 business and 10 charity calls every day?
question 2 Hiring workers A company payshis skilled workers S15 per hour in his departmentassembly tool. semi-skilled workersin that department they earn S9 per hour To the employeestwo of shipments are paid SIO per hour Because of aincrease in orders, the company needs to contractemploy a total of 70 workers in the departments ofassembly and shipping Will pay a total of $760 per hourto these employees. Because of a contract with the unionlaw, twice as many semi-semi-workers should be employed.lified than skilled workers. How manysemi-skilled workers, skilled workers and employees ofshipments should hire the company? Note: Solve by Inverse-Excel # OF SEMI-SKILLED WORKERS # OF SKILLED WORKERS # OF SHIPPING WORKERS
Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question 1 A A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutesfor cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution b. Graph the feasible region. c. Determine the coordinates of each extreme point. d. What is the optimal solution. e. Solve in excel.
Question #4 - Jerry Smith is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no shop at all. The profits will depend on the size of the shop and whether the market is favorable or unfavorable for his products. Because there will be a 5-year lease on the building that Jerry is thinking about using, he wants to make sure that he makes the correct decision. Jerry is also thinking about hiring his old marketing professor to conduct a marketing research study. If the study is conducted, the study could be favorable (i.e., predicting a favorable market) or unfavorable (i.e., predicting an unfavorable market). Develop a decision tree for Jerry.
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?

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