In the Great Threads model, we didnt constrain the production quantities in row 16 to be integers,
Question:
In the Great Threads model, we didn’t constrain the production quantities in row 16 to be integers, arguing that any fractional values could be safely rounded to integers. See whether this is true. Constrain these quantities to be integers and then run Solver. Are the optimal integer values the same as the rounded fractional values in Figure 6.12?
Figure 6.12
Transcribed Image Text:
A B D E F. G H K 1 Great Threads fixed cost clothing model Range names used: Effective_capacity Rent equipment =Model!$B$18:$F$18 =Modell$B$14:$F$14 =Model!$B$29 =Model!$D$22:ŞD$23 |=Model!$B$22:$B$23 =Modell$B$16:$F$16 2 3 Input data on products Shirts Profit Resource available Resource_used Units produced 4 Shorts Pants Skirts Jackets 5 Labor hours/unit 6 Cloth (sq. yd.)/unit 2 8 3 2.5 4. 4.5 5.5 7 8 Selling price/unit 9 Variable cost/unit 10 Fixed cost for equipment $35 $20 $1,500 $40 $10 $65 $25 $70 $30 $110 $35 $1,200 $1,600 $1,500 $1,600 11 12 Production plan, constraints on capacity 13 Shirts Shorts Pants Skirts Jackets 14 Rent equipment 15 16 Units produced 965.52 379.31 17 <= く= <= <= <= 18 Effective capacity 0.00 1800.00 0.00 0.00 500.00 19 20 Constraints on resources 21 Resource used Available 22 Labor hours 4000.00 4000 くニ 23 Cloth 4500.00 く= 4500 24 25 Monetary outputs 26 Revenue 27 Variable cost 28 Fixed cost for equipment 29 Profit $80,345 $22,931 $2,800 $54,614 Objective to maximize
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 64% (14 reviews)
Answered By
ANDREW KIPRUTO
Academic Writing Expert
I have over 7 years of research and application experience. I am trained and licensed to provide expertise in IT information, computer sciences related topics and other units like chemistry, Business, law, biology, biochemistry, and genetics. I'm a network and IT admin with +8 years of experience in all kind of environments.
I can help you in the following areas:
Networking
- Ethernet, Wireless Airmax and 802.11, fiber networks on GPON/GEPON and WDM
- Protocols and IP Services: VLANs, LACP, ACLs, VPNs, OSPF, BGP, RADIUS, PPPoE, DNS, Proxies, SNMP
- Vendors: MikroTik, Ubiquiti, Cisco, Juniper, HP, Dell, DrayTek, SMC, Zyxel, Furukawa Electric, and many more
- Monitoring Systems: PRTG, Zabbix, Whatsup Gold, TheDude, RRDtoo
Always available for new projects! Contact me for any inquiries
4.30+
1+ Reviews
10+ Question Solved
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Question Posted:
Students also viewed these Business questions
-
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both bindingthe company is using all it has. a. Use SolverTable to see what happens to the optimal...
-
The Ruddle Co. Ltd had planned to install and, with effect from next April, commence operating sophisticated machinery for the production of a new product - product Zed. However, the supplier of the...
-
The following is abbreviated testimony from Troy Normand in the WorldCom (USA) case. He was a manager in the company reporting department and was one of five individuals who pleaded guilty. He...
-
Find the eccentricity and the distance from the pole to the directrix of the conic. Then identify the conic and sketch its graph. Use a graphing utility to confirm your results. r = 6 2 + cos 0
-
In Exercises 23 and 24, show that the least squares solution of Ax = b is not unique and solve the normal equations to find all the least squares solutions 1. 2.
-
The bus admittance matrix for the power system shown in Figure 6.24 is given by With the complex powers on load buses 2, 3, and 4 as shown in Figure 6.24, determine the value for \(\mathrm{V}_{2}\)...
-
What happens if the conducting rod in Figure P29.1 rotates (a) clockwise about the \(z\) axis as viewed looking down the positive \(z\) axis toward the origin, \((b)\) clockwise about the \(x\) axis...
-
1. A company has an inventory of 1,250 assorted parts for a line of missiles that has been discontinued. The inventory cost is $ 76,000. The parts can be either (a) remachined at total additional...
-
19. Find the tension T for the system shown in figure :- T T T 1 kg 2 kg 3 kg (1) IgN (2) 2 gN (3) 5 gN (4) 6 gN 20. A ball of mass 0.5 kg moving with a velocity of 2 m/sec strikes a wall normally...
-
X Ltd. has 10 lakhs equity shares outstanding at the beginning of the accounting year 2016. The appropriate P/E ratio for the industry in which D Ltd. is 8.35. The earnings per share is Rs. 15 in the...
-
Expand and then solve the capital budgeting model in Figure 6.5 so that 20 investments are now possible. You can make up the data on cash requirements, NPVs, and the budget, but use the following...
-
In the original Western set-covering model in Figure 6.22, we used the number of hubs as the objective to minimize. Suppose instead that there is a fixed cost of locating a hub in any city, where...
-
Rework Problem 2-32 assuming that the plate is subjected to a convection environment on both sides of temperature T with a heat-transfer coefficient h. Tw is now some reference temperature not...
-
Assignment 5: Audit Testing For this assignment, the expected population exception rate (EPER) was specified as 1% or 2%, the tolerable exception rate (TER) was specified as 7% or 8%, and the...
-
1. Why is the rule for debit and credit entries the same for liability and owners equity accounts? 2. A hotel shows office supplies such as stationery on its balance sheet as a $500 asset, even...
-
Fill in the annual income statement plan using the information on the attached file. The first tab is the income statement; the plan column will populate sales and operating expenses from your inputs...
-
Describe developmental milestones and explain why they are important. For each disability category, describe typical cognitive, linguistic, physical, social, and emotional development and the...
-
Revenue Recognition Project For each part of this project, perform the 5 steps of the revenue recognition. Use headers. Explain the step. Then detail/document/complete each step of the process. You...
-
On September 1, 2012, Southwest Airlines borrows $40 million, of which $8 million is due next year. Show how Southwest Airlines would record the $40 million debt on its December 31, 2012, balance...
-
What is the difference between the straight-line method of depreciation and the written down value method? Which method is more appropriate for reporting earnings?
-
Mary died on April 3, 2017. As of this date, Marys gross estate was valued at $6.5 million. On October 3, Marys gross estate was valued at $5.8 million. The estate neither distributed nor sold any...
-
Val died on May 13, 2017. On July 3, 2015, she gave a $400,000 life insurance policy on her own life to son Ray. Because the value of the policy was relatively low, the transfer did not cause any...
-
In December 2015, Curt and Kate elected gift splitting to report $16,228,000 of gifts of stocks Curt made to Curt, Jr. Each paid gift taxes of $1,068,000 by spending his or her own funds. Kate died...
-
Can you elaborate on the processes of somatic hypermutation and class-switch recombination in B lymphocytes, detailing their roles in generating antibody diversity and optimizing antibody-mediated...
-
Can you delve into the complex interplay between the gut microbiota and host immune system, highlighting the mechanisms by which commensal microbes shape immune development, tolerance, and...
-
Marisa wants to buy a home in Atlanta with a 30-year mortgage that has an annual interest rate of 4.9%. The house she wants is $250,000, and she will make a $55,000 down payment and borrow the...
Study smarter with the SolutionInn App