There are several types of linear-programming models that exhibit a special structure which can be exploited in the construction of efficient algorithms for solutions to an organisation’s challenges. Efficient production planning is a key condition for a production system’s success, which considers the real-world resource limitations such as budget, time and labour. A study is being conducted to develop linear and goal programming models in an attempt to optimise the daily production outputs of your organisation in producing various product mixes. The three goals considered are: maximising the daily sales profits, minimising overtime, and maximising the utility of machines used in the production process. REQUIRED: You are required to develop an efficient solution through the application of linear and goal programming, to a concisely defined problem through examining a situation in a company of your choice to determine the optimal solution to be implemented. Generate a title of your choice within the boundaries of Operations management Techniques and write a full report. Displaying an overview of the relevant details on the problem at hand and the developed optimum solution to mitigate the problem

There are several types of linear-programming models that exhibit a special structure which can be exploited in the construction of efficient algorithms for solutions to an organisation’s challenges. Efficient production planning is a key condition for a production system’s success, which considers the real-world resource limitations such as budget, time and labour. A study is being conducted to develop linear and goal programming models in an attempt to optimise the daily production outputs of your organisation in producing various product mixes. The three goals considered are: maximising the daily sales profits, minimising overtime, and maximising the utility of machines used in the production process. REQUIRED: You are required to develop an efficient solution through the application of linear and goal programming, to a concisely defined problem through examining a situation in a company of your choice to determine the optimal solution to be implemented. Generate a title of your choice within the boundaries of Operations management Techniques and write a full report. Displaying an overview of the relevant details on the problem at hand and the developed optimum solution to mitigate the problem

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

There are several types of linear-programming models that exhibit a special structure which can be exploited in the construction of efficient algorithms for solutions to an organisation’s challenges Efficient production planning is a key condition for a production system’s success, which considers the real-world resource limitations such as budget, time and labour. A study is being conducted to develop linear and goal programming models in an attempt to optimise the daily production outputs of your organisation in producing various product mixes. The two goals considered are: Minimising overtime, and maximising the utility of machines used in the production process. please answer the two bolded ones
Digital Imaging has hired your Analytics Consulting Firm (SJU Analytics) to help determine how many units of each printer they should produce to maximize profit. Construct a Simple Linear Programing Analysis using Excel SOLVER Prepare a presentation to DI’s president presenting your findings and recommendations. Digital Imaging’s Leadership team has providing the following information: Digital Imaging (DI) produces color printers for both the professional and consumer markets. The DI consumer division recently introduced two new color printers. The DI-910 model can produce a borderless color print in approximately 37 seconds. The more sophisticated and faster DI-950 can even produce a borderless color print. Financial projections show profit contributions of $42 for each DI-910 and $87 for each DI-950. The printers are assembled, tested, and packaged at DI’s plant located in New Bern, North Carolina. This plant is highly automated and uses two manufacturing lines to produce the…
Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, a product focusand riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety.According to the service-profit chain, the high-value service offered by Sapphire Farm LLC should lead to: A. congruent market response B. positive framing C. customer autonomy D. customer satisfaction E. a product focus
Formulate an LP model for the following problems.1. A furniture company makes two products: book shelves selling for ₱5,000 and cabinetsselling for ₱8,000. The direct cost per unit is ₱3,000 and ₱4,000, respectively. Thecompany has no difficulty in selling all the products it can manufacture. The assemblydepartment has 60 hours available per week and the finishing department can handleup to 48 hours of work per week. Manufacturing one book shelf requires 4 hours inassembly and 2 hours in finishing. Each cabinet requires 2 hours in assembly and 4hours in finishing. How can the management allocate the limited man-hour of the twodepartments in a way which will secure the largest possible net return?
Tattle Tots makes a fiberglass tricycle for kids that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat, and frame unit, and rear wheels. The company has orders for 12,000 of these tricycles. The company does not have the resources available to manufacture everything needed for the completion of 12,000 tricycles so it has gathered purchase information for each component. The following table shows relevant information: Requirements Cost to Manufacture Cost to Purchase Component Plastic Time Space Front 3 10 2 8 12 Seat/Frame 4 6 2 6 9 Rear-wheel (each) .5 2 .1 1 3 Available 50,000 160,000 30,000 Develop a linear programming model to advise the operations manager of Tattle Tots how many of each component should be manufactured and how many should be purchased in order to provide 12,000 fully completed tricycles at the minimum cost. What is your best…
Give the logical sequence of steps for formulating and constructing a (structured) LP model.
Can you help me with these three review questions A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
A company that operates 10 hrs a day manufactures three products on three processes The following table summarizes the data of the problem: Minutes per unit Product Process 1 Process 2 Process 3 Unit price $4.50 $5.00 10 8 10 6 9 12 $4.00 (a) Determine the optimal product mix. (b) Use the dual prices to prioritize the three processes for possible expansion. (c) If additional production hours can be allocated, what would be a fair cost per additional hour for each process? 609 123
Lynette is interested in finding a sedan car for work. Below is the summary of her criteria and the choices that she has selected as potential cars that she may purchase. She wants you to find out the best alternative based on these data. Note: Calculate the data given below in the same way as the rating scale. There is no need to convert the data into the rating scale before the calculation. Criteria Weight Toyota Camry Volkswagen Passat Mazda 6 Hyundai Sonata Objective Drive-away price 8 $51,673 $57,399 $55,040 $55,692 Min Engine size (L) 3 2.5 2.0 2.5 2.5 Max Fuel tank capacity (L) 5 50 66 62 60 Max Power:Weight (W/kg) 5 97.3 108.3 104.8 130.2 Max Max torque (Nm) 4 221 350 420 422 Max Fuel consumption (L/100km) 7 4.7 6.9 7.6 8.1 Min Service cost (5 yr) 6 $1,940 $2,692 $2,310 $1,446 Min
How do non-linear system models differ from linear models, and what are the challenges associated with analyzing and controlling them?
Workshape Manufacturing has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors purchase the same product. The customer activities and costs for the previous quarter are as follows: Activity JIT distributors Non-JIT distributors Sales Orders 500 30 Sales Calls 30 30 Service Calls 200 90 Average Order Size 90 1,400 Manufacturing Cost/Unit $50 $50 Customer Costs: Processing Sales Orders $160,000 Selling Goods $155,000 Servicing Goods $195,000 Total $500,000 Calculate the activity rate for selling goods. (Note: Round answer to two decimal places.) a.$2,200.50 per sales call b.$9,400.60 per sales call c.$3,550.66 per sales call d.$2,583.33 per sales call e.$4,800.40 per sales call
Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, and riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety. If the farm unintentionally hired someone to teach riding who was unable to deal effectively with small children, then a _____ would occur. A. service divergence B. quality underperformance C. performance breakdown D. product variation E. customer aberration