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.
-
How can organizations effectively leverage synergies between different departments to enhance cross-functional collaboration and achieve strategic objectives?
-
Table B. 13 presents data on the thrust of a jet turbine engine and six candidate regressors. Use all possible regressions and the \(C_{p}\) criterion to find an appropriate regression model for...
-
Beth Electronics makes DVD players in three processes: assembly, programming, and packaging. Direct materials are added at the beginning of the assembly process. Conversion costs are incurred evenly...
-
1. Graph the functions: a. y = 2x (= b. y =
-
Boehm Corporation has had stable earnings growth of 8% a year for the past 10 years and in 2013 Boehm paid dividends of $2.6 million on net income of $9.8 million. However, in 2014 earnings are...
-
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...
-
Identify which investment manager is most suitable for Patnode. Justify your response based solely on each managers investment philosophy and approach Susan Patnode, age 66, was recently widowed and...
-
Show the impact on the Federal Reserves balance sheet of a foreign exchange market intervention where the Fed purchases $5,000 worth of foreign exchange reserves. Explain what impact, if any, the...
-
Analyze the link between the monetary base and the money supply.
-
Dollarizing and joining a monetary union both involve giving up a countrys own currency, but there are key differences between these two options. Identify one factor that might lead a country to...
-
The collapse of banks and the banking system disrupts both the payments system and the screening and monitoring of borrowers. a. Intermediaries are insolvent when their liabilities exceed their...
-
Describe unconventional monetary policy tools and how they work.
-
At January 1, 2017, Rui Corporation had plan assets of $250,000 and a defined benefit obligation of the same amount based on projected costs. During 2017, the current service cost was $27,500, the...
-
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...
-
5. Recursive method; what is printed if we call mystery (6, 12); public static void mystery (int x, int y) { if (x > y) { System.out.print ("/"); else if (x = y) { } else { System.out.print ("=" + y...
-
Simmonds Products has spent $158,500 (sunk cost) on research to develop low-fat imitation wine. The firm is planning to spend $210,000 on a machine to produce new wine. Shipping cost of $60,000 and...
-
In particular, you were introduced to three decision-making techniques -- majority rule, minority rule by authority or expertise, and consensus rule -- each with their own pros and cons. Using these...
Study smarter with the SolutionInn App