Solve Using Excel solver in Linear Optimization Problems. Must present the excel solver output including (answer report sensitivity report and limits report)1. A calculator company produces two models of calculators at two different factories. Factory A can produce 130 scientific calculators and 25 graphing calculators per day. Factory B can produce 70 scientific and 90 graphing calculators per day. It cost $1200 per day to operate Factory A and $900 per day to operate Factory B. If the company needs to produce 460 scientific calculators and 340 graphing calculators for a big order, find the minimum cost to produce the order.(please help) 1. A calculator company produces two models of calculators at two different factories. Factory Acan produce 130 scientific calculators and 25 graphing calculators per day. Factory B canproduce 70 scientific and 90 graphing calculators per day. It cost $1200 per day to operateFactory A and $900 per day to operate Factory B. If the company needs to produce 460scientific calculators and 340 graphing calculators for a big order, find the minimum cost toproduce the order. SET 3Solve Using Excel solver in Linear Optimization Problems. Must present the excel solver outputincluding (answer report sensitivity report and limits report)

Given data is Cost to operate factory A = $1200 Production of scientific calculators in factory A =…

Answered: Solve Using Excel solver in Linear…

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

Related questions

Question

100%

Solve Using Excel solver in Linear Optimization Problems. Must present the excel solver output including (answer report sensitivity report and limits report) 1. A calculator company produces two models of calculators at two different factories. Factory A can produce 130 scientific calculators and 25 graphing calculators per day. Factory B can produce 70 scientific and 90 graphing calculators per day. It cost $1200 per day to operate Factory A and $900 per day to operate Factory B. If the company needs to produce 460 scientific calculators and 340 graphing calculators for a big order, find the minimum cost to produce the order.(please help)