Solve LP Model for the problem stated below in Excel and submit your file Production Capacity:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Solve LP Model for the problem stated below in Excel and submit your file Production Capacity: 160 computers per week 50 more computers with overtime Assembly Costs: $190 per computer regular time; $260 per computer overtime Inventory Holding Cost: Order schedule: $10 computer per week Week 1 2 3 4 5 6 Computer Orders 105 170 230 180 150 250 Decision Variables Decision Variables: r₁ = regular production of computers in week j (j= 1, 2, ..., 6) 0₁ = overtime production of computers in week j (j= 1, 2,..., 6) i, = extra computers carried over as inventory in week j (j=1, 2, ..., 5) Model: Minimize Z=$190(₁+₂+3+4+²5° +₂ +₂+₁+5+6) +$260 (0₁+02 2 +03+04+05+06)+10(₁+2+3+14+15) subject to: r₁ ≤160 computers in week j (j=1, 2, 3, 4, 5, 6) 0, <150 computers in weekj (j =1, 2, 3, 4, 5, week 1 week 2 week 3 week 4 week 5 week 6 ₁+9₁-₁105 = 1₂+0₂ +1₁-1₂=170 13 +03+12-13 = 230 4+04+13-14 = 180 r5 +05 +14-15 = 150 6 +06+15=250 1₁,0,1, 20 Solve LP Model for the problem stated below in Excel and submit your file Production Capacity: 160 computers per week 50 more computers with overtime Assembly Costs: $190 per computer regular time; $260 per computer overtime Inventory Holding Cost: Order schedule: $10 computer per week Week 1 2 3 4 5 6 Computer Orders 105 170 230 180 150 250 Decision Variables Decision Variables: r₁ = regular production of computers in week j (j= 1, 2, ..., 6) 0₁ = overtime production of computers in week j (j= 1, 2,..., 6) i, = extra computers carried over as inventory in week j (j=1, 2, ..., 5) Model: Minimize Z=$190(₁+₂+3+4+²5° +₂ +₂+₁+5+6) +$260 (0₁+02 2 +03+04+05+06)+10(₁+2+3+14+15) subject to: r₁ ≤160 computers in week j (j=1, 2, 3, 4, 5, 6) 0, <150 computers in weekj (j =1, 2, 3, 4, 5, week 1 week 2 week 3 week 4 week 5 week 6 ₁+9₁-₁105 = 1₂+0₂ +1₁-1₂=170 13 +03+12-13 = 230 4+04+13-14 = 180 r5 +05 +14-15 = 150 6 +06+15=250 1₁,0,1, 20
Expert Answer:
Answer rating: 100% (QA)
Solve LP Model for the problem stated below in Excel and submit your file Product... View the full answer
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Posted Date:
Students also viewed these accounting questions
-
2 3 4 5 3. Item Value 15 30 40 20 25 Weight 2 4 6 8 10 Considering the above table contains the items along with their profit and weight. Now, your task is to calculate the maximum profit for...
-
Accounting Please complete the following in Excel and submit via email to me by end of day Sunday January 24th, 2021. Show all calculations including information that may not be used in the final...
-
Week 1 2 3 4 5 6 LC% 30% 60% 70% 80% 90% 100% We have a new team with this learning curve and a labor cost of $ 1.3 per unit. If the capacity is 16,457 units per week, how much would be the labor...
-
Controlling Program Flow w/i an ATM Using selection statements & loops to complete the following: Validate the user's PIN -- only allow them to attempt three (3) times before ending the program If...
-
The following comparative income statement information was provided by AMR Corp., the parent company of American Airlines for the years ended December 31, 2004 and 2003. 1. Provide a vertical...
-
Kitchen Korner produces refrigerators, dishwashers, and stoves at three different factories. The table gives the number of each product produced at each factory per day. Kitchen Korner receives an...
-
Using the results from Problem 10.10, derive the equations for both parts of the off-axis complex modulus, \(E_{x}^{*}=E_{x}^{\prime}\left(1+i \eta_{x} ight)\), for an arbitrary angle \(\theta\);...
-
In the late 1990s, car leasing was very popular in the United States. A customer would lease a car from the manufacturer for a set term, usually two years, and then have the option of keeping the...
-
Find dx dt dx - dt at x= dy =-4 if y = x + 2 and = dt 1.
-
A maker of a certain brand of low-fat cereal bars claims that their average saturated fat content is 0.5 gram. In a random sample of 8 cereal bars of this brand the saturated fat content was 0.6....
-
A gasoline-driven and an electrically powered pump are being considered for service in a remote location. Pertinent data are as follows: The income tax rate is 35% and the acceptable return is 15%....
-
Tyler Tooling Company uses a job order cost system with overhead applied to products on the basis of machine hours. For the upcoming year, the company estimated its total manufacturing overhead cost...
-
Laker Incorporated s fiscal year - end is December 3 1 , 2 0 2 4 . The following is an adjusted trial balance as of December 3 1 . Accounts Debit Credit Cash $ 1 0 , 6 0 0 Supplies 3 2 , 0 0 0...
-
On March 1 , 2 0 2 3 , VisionTech Inc. s board of directors declared a 5 % share dividend when the market price per share was $ 2 8 . 0 0 . On November 1 5 , 2 0 2 3 , the board of directors declared...
-
Explain trojan horse and its types with example and diagram?
-
An investment opportunity requires an outlay of $x today but is not expected to have any cash inflows for the coming four years. At the end of year five its expected cash flow is $2,800 and that is...
-
Stephen has just purchased a home for $165,300. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 5.25%. Stephen has agreed to pay 30% of the purchase price as a...
-
Catherine (aged 42) and Johnson (aged 45) have been married for 12 years. Johnson is a project manager of an event company at a monthly salary of $55,000 with an additional one-month salary of...
-
The school cafeteria can make pizza for approximately $0.30 a slice. The cost of kitchen use and cafeteria staff runs about $200 per day. The Pizza Den nearby will deliver whole pizzas for $9.00...
-
Discuss some of the uses and limitations of learning curves.
-
AV City (Problem 13-1) assumed with certainty that the ordering cost is $625/order and the inventory carrying cost is $130/unit/year. However, the inventory model parameters are frequently only...
-
Which form of financing allows the source of the funds to share in the wealth if the company which received the financing does well? a. A loan b. An investment c. Both a loan and an investment d....
-
Which form of financing requires repayment, regardless of whether the company receiving the funds does well or not? a. A loan b. An investment c. Both a loan and an investment d. Neither a loan nor...
-
What are vertical and horizontal financial statement analyses? What are their advantages?
Study smarter with the SolutionInn App