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? ABD.FGHK1 Great Threads fixed cost clothing modelRange names usedEffective_capacityRent_equipmentProfitResource_availableResource_used=Modell$B$18:$F$18EModell$B$14:SF$14-Modell$B$29|-Model!SD$22:$D$23=Modell$B$22:$B$23=Model I$B$16:$F$1623 Input data on products4ShirtsShortsPantsSkirtsJackets5 Labor hours/unit6 Cloth (sq. yd.)/unit248.2.544.55.57.Units produced8 Selling price/unit9 Variable cost/unit10 Fixed cost for equipment$35$40$65$70$110$20$10$25$30$35$1,500$1,200$1,600$1,500$1,6001112 Production plan, constraints on capacity13ShirtsShortsPantsSkirtsJackets14 Rent equipment1516 Units produced965.52379.311718 Effective capacity0.000.001800.000.00500.001920 Constraints on resources21Resource usedAvailable22 Labor hours23 Cloth4000.0040004500.0045002425 Monetary outputs26 Revenue27 Variable cost28 Fixed cost for equipment29 Profit$80,345$22,931$2,800$54,614Objective to maximize

Given the details of the clothing on Variable/Fixed cost, selling price, labor hours, and cloth…

Answered: A B D. F G H K 1 Great Threads fixed…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

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?

A
B
D.
F
G
H
K
1 Great Threads fixed cost clothing model
Range names used
Effective_capacity
Rent_equipment
Profit
Resource_available
Resource_used
=Modell$B$18:$F$18
EModell$B$14:SF$14
-Modell$B$29
|-Model!SD$22:$D$23
=Modell$B$22:$B$23
=Model I$B$16:$F$16
2
3 Input data on products
4
Shirts
Shorts
Pants
Skirts
Jackets
5 Labor hours/unit
6 Cloth (sq. yd.)/unit
2
4
8.
2.5
4
4.5
5.5
7.
Units produced
8 Selling price/unit
9 Variable cost/unit
10 Fixed cost for equipment
$35
$40
$65
$70
$110
$20
$10
$25
$30
$35
$1,500
$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
0.00
1800.00
0.00
500.00
19
20 Constraints on resources
21
Resource used
Available
22 Labor hours
23 Cloth
4000.00
4000
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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions