IAN Ltd produces both interior and exterior paints from two raw materials, X and Y. The following table provides the basic data of the problem: Page 1 of 4 Tons of raw material per ton of Maximum daily availability(tons) Exterior paint interior paint Raw materials 4 24 Y 1 6. Profit per ton (in $1000 ) A market survey indicates that the daily demand for interior paint cannot exceed that of 4 exterior paint by more than 1 ton. Also, the maximum daily demand of interior paint is 2 tons.

IAN Ltd produces both interior and exterior paints from two raw materials, X and Y. The following table provides the basic data of the problem: Page 1 of 4 Tons of raw material per ton of Maximum daily availability(tons) Exterior paint interior paint Raw materials 4 24 Y 1 6. Profit per ton (in $1000 ) A market survey indicates that the daily demand for interior paint cannot exceed that of 4 exterior paint by more than 1 ton. Also, the maximum daily demand of interior paint is 2 tons.

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

Show that, simplex method provides a better solution in each iteration compared to its previous iteration in terms of optimization.
The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. Room rates include breakfast and are the same for one or two guests; however, any additional guests must pay an extra $20 per person per day for breakfast. Parties staying for seven days or more receive a 10% discount on the room rate as well as any additional breakfast fees. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 123 L+ 139 S 18 L 11 S≤ 3000 5 L+9 S≤2500 L≥ 0 and S≥ 0 (Availability of component A) (Availability of component B) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and possible profit, SpeedBuster models. This solution gives the which is $ (Type integers or decimals…
We Buy Clothing is an online store catering for both men and ladies clothing. The company has been in business for 4 years and makes a profit from the online sales. In order to compete with its competition, the marketing manager, Vernon Cross, has decided to improve the marketing information system. He decides that the shop should send out catalogues to its customers and keep track of its customer’s buying habits, perform target marketing and provide a more specialised experience for its customers. The company has approximately 350 clients on their current system. This record keeping system is merely an excel spreadsheet with all the necessary client details The company projects to grow this client base to 1500 clients by the end of the next financial year in 12 month’s time. The company is embarking on a huge investment drive. Token cards provide two factor authentication, Explain this concept [3]
WhAt is Integer Linear Optimization and how it is solved?
(Linear Objective Function and Optimization Application) On a special occasion, renowned electronic giant retailer Best Buy sold a variety of TVs at a discounted prices or on huge sales. Task-1: Write down an appropriate equation for the net profit function, P in order to account for the net profit made by Best Buy after selling: (i) x-number of televisions (TVs) that made $250 profit on the sale of each SONY TVs (ii) y-number of televisions that made $10,500 profit on the sale of each PHILIP TVs respectively, in that event. Task-2: Profit margin, P as discussed in Task-1 was subject to the following constraints applied to the products. a. Maximum cost price was $5000 to manufacture each piece of SONY TVs and $10,000 to manufacture each piece of PHILIP TVs respectively. All TVs were manufactured at a maximum cost of $10 x106 as given in Plot No 1: Plot No. 1: ($5000 x + $ 10000y) ≤ $10 million; Graph the Plot No. 1 up to the scale in a paper. b. 10 and 150 employees worked to…
How would you write the optimal solution for these?
Ensemble Theatre of Cincinnati D. Lynn Meyers has been Producing Artistic Director of the nationally renowned Ensemble Theatre of Cincinnati (ETC) since 1995. The nonprofit ETC, recently celebrating its 25th anniversary, is dedicated to the production and development of new plays and of works new to the region. Lynn values the opinions of each member of her small staff when hiring. She usually interviews four or five people for a staff position and conducts two interviews. After the preliminary interview determines that an applicant is suitable, she says, “We invite the person back to meet the staff they would have contact with on a daily basis.” She has passed on qualified candidates who did not interact well with their prospective coworkers or who did not convince her that they had a strong desire for the job. Lynn researches job applicants online and on social media sites. “Frankly, if we find unprofessional behavior, we take that into consideration,” she says. “We always check…
Discuss a situation where constrained optimization is used?
Daniel works as a programmer for a large software company. He writes and tests utility programs such as compilers. His company operates two computing shifts: during the day for program development and online applications are running at night batch production jobs. Daniel has access to workload data and learns that the evening batch runs are complementary to daytime programming tasks; that is, adding programming work during the night shift would not adversely affect the performance of the computer to other users. Daniel comes back after normal hours to develop a program to manage his own stock portfolio. His drain on the system is minimal, and he uses very few expendable supplies, such as printer paper. Discuss the ethical principles that Daniel violated as an IT Professional.
What is the difference between the analysis space and design space in an optimization process?