Question: please use LINGO and Excel solver Problem 2: Bicycle factories A small business makes 3-speed and 10-speed bicycles at two different factories. Factory A produces

please use LINGO and Excel solver

Problem 2: Bicycle factories A small business makes 3-speed and 10-speed bicycles at two different factories. Factory A produces 163 -speed and 2010 -speed bikes in one day while factory B produces 123 -speed and 2010 -speed bikes daily. It costs $1000 /day to operate factory A and $800 /day to operate factory B. An order for 963 -speed bikes and 14010 -speed bikes has just arrived. How many days should each factory be operated in order to fill this order at a minimum cost? What is the minimum cost? Please answer the questions graphically, using LINGO and using Excel solver. (Please take screenshots for LINGO results and Excel solver)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

soloution with the graph please Problem 2: Bicycle factories A small business makes 3-speed and 10-speed bicycles at two different factories. Factory A produces 16 3-speed and 20 10-speed bikes in...

Bicycle factories A small business makes 3-speed and 10-speed bicycles at two different factories. Factory A produces 16 3-speed and 20 10-speed bikes in one day while factory B produces 12 3-speed...

please help me with this assignment A small business makes 3-speed and 10-speed bicycles at two different factories. Factory A produces 163 -speed and 20 10-speed bikes in 'one day while factory B...

A small business makes 3-speed and 10 -speed bicycles at two different factories. Factory A produces 163 -speed and 20 10-speed bikes in one day while factory B produces 123 -speed and 2010 -speed...

Problem 1: Designing a diet A dietitian wants to design a breakfast menu for certain hospital patients. The menu is to include two items A and B. Suppose that each ounce of A provides 2 units of...

A small business makes 3 -speed and 10 -speed bicycles at two different factories. Factory A produces 163 -speed and 2010 -speed bikes in one day while factory B produces 12 3 -speed and 2010 -speed...

Problem 1: Designing a diet A dietitian wants to design a breakfast menu for certain hospital patients. The menu is to include two items A and B. Suppose that each ounce of A provides 2 units of...

Read the case scenario and use the text provided to support your answer and only used the text provided Case Scenario Dion is an engineer with Tesla Motors who helps to design electric motors. It has...

Solve the following goal programming model graphically and by using thecomputer: minimize Pidt, Pd, P subject to 4x1 + 2x2 + d--dt = 80 XI + d2-dt =30

Kelly Limited is issuing a 15-year, $1,000 face value, 8% annual coupon bonds to finance its operations over the medium to long term. Required: i. If interest is paid annually, what is the value of...

3 An asset is: A ) a resource available to the business to earn income. B ) an obligation, where the business owes money to someone else. C ) a cost paid by the business and would be recorded as an...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...