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...
-
La Jolla Beverage Products is considering producing a wine cooler that would be a blend of a white wine, a ros wine, and fruit juice. To meet taste specifications, the wine cooler must consist of at...
-
What is the value of a perpetuity that pays $100 every 6 months forever? if The discount rate quoted on an APR basis is 5.6%.
-
a. Beginning with the score function for the logit case in equation (11.5), show that the information matrix can be expressed as \[\mathbf{I}(\boldsymbol{\beta})=\sum_{i=1}^{n} \sigma_{i}^{2}...
-
Virgil Cronk wants to purchase a life insurance policy that will allow him to increase his future coverage without having to take another medical exam. Virgil's family has a history of cardiac...
-
Image transcription text 4) You've landed a spot on the operations team for the Europa Clipper mission! (htt s: www.' |.nasa. ov missions euro a-cli er or httpsz?europahasagovf ]. In addition to the...
-
A secret service courier carrying a briefcase with the codes to the USA's nuclear defense system has a mean delivery time of 62 minutes with a standard deviation of 13 minutes. What is the...
-
Use the future value formula to find the indicated value. n = 49; i = 0.03; PMT = $64; FV = ? FV = $ (Round to the nearest cent.)
-
A project has the following financial projections: Purchase price = $10000 Salvage value = 1000 Annual Savings = 4000 Annual Maintenance Cost = 3000 i = 5%, n = 7 years What is the Equivalent Uniform...
-
When the parent and subsidiary have differing fiscal periods, the fiscal period of the subsidiary can be changed or the financial statements of the subsidiary can be adjusted each period. Current...
-
Using a company's WACC to evaluate a project is . I) always correct II) always incorrect III) correct for projects that have average risk compared to the firm's other assets A. I only B. II only C....
-
A retail company is considering investing in a new IT system for online sales. This would involve investing 10 million in servers and computer software that would have an expected useful life of 3...
-
Which campaign finance loophole was exploited by the energy company Enron, leading to the passage of the Bipartisan Campaign Finance Reform Act of 2002? Multiple choice question. contributions by...
-
At a point in a stressed body, the Cartesian components of stress are: [xx Txy Txz] 45 108 361 [0] = Tyx Oyy Tyz = 108 90 54 MPa Tzx Tzy Ozz] 36 54 45] Determine the normal and shear stresses on a...
-
Wilsons Auto Repair ended 2011 with Accounts Receivable of $85,000 and a credit balance in Allowance for Uncollectible Accounts balance of $11,000. During 2012, Wilsons Auto Repair had the following...
-
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...
-
Find the probability of an IQ less than 85.
-
If 25 women are randomly selected, find the probability that the mean of their red blood cell counts is less than 4.444. Assume that red blood cell counts of women are normally distributed with a...
-
Mensa International calls itself the international high IQ society, and it has more than 100,000 members. Mensa states that candidates for membership of Mensa must achieve a score at or above the...
Study smarter with the SolutionInn App