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: 62% (16 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.
-
In New York State, healthcare workers have to choose either being vaccinated against influenza or are required to wear a surgical or procedure mask while working in areas where patients or residents...
-
Question: Maine exempted many charitable institutions from real estate taxes but denied this benefit to a charity that primarily benefited out-of-state residents. Camp Newfound was a Christian...
-
Waterways has two major public-park projects to provide with comprehensive irrigation in one of its service locations this month. Job J57 and Job K52 involve 15 acres of landscaped terrain which will...
-
NEW PROJECT ANALYSIS You must evaluate a proposed spectrometer for the R&D Department. The base price is $140,000, and it would cost another $30,000 to modify the equipment for special use by the...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case 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...
-
Why is cost accumulation easier in a process costing system than it is in a job-order costing system?
-
10. Bene Petit currently offers three meal sizes: single-serve, dual-serve, and family-size. Single-serve meals make up about 5% of total sales revenue and have the lowest contribution margin of the...
-
Blossom, Incorporated prepared the following master budget items for July: Production and sales Variable manufacturing costs: Direct materials Direct labor Variable manufacturing overhead Fixed...
-
Explain the three types of risk and beta, and how these concepts relate to a company's required rate of return. Apple Inc.company's beta from a credible source. You can get this information from the...
-
Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided...
-
Bergo Bay's accounting system generated the following account balances on December 31. The company's manager knows something is wrong with this list of balances because it does not show any balance...
-
What are the three key elements to a negotiation situation that should be evaluated before bargaining begins? Why is each a key to the process?
-
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...
-
Which one of the following relations defines a circle with center (-2, 3) and radius 2? (x-2)+(y+3) = 2 (x+2)+(y+3) = 4 (x+2)+(y-3) = 4 (x-2)+(y+3) = 4
-
A company selling licenses for new e-commerce computer software advertises that firms using this software obtain, on average during the first year, a yield of 11% on their initial investments. A...
-
R 1. Select the inverse of g(x) = log x-2 5 g(x)=5(10)+2 (x) = 2(10)*+5 g'(x)=5(2)* '(x) = 10(5)*+2 2. Select the range of f(x) = log(x 3) All real numbers Oy>0 Oy>3 3. Select the domain of [f(x) =...
Study smarter with the SolutionInn App