Fixed Cost Model (Learn under DR. TAN CHIN LUNG).xlsx

	B	C	D	E	F	G
1
2	Input
3		Shirt	Short	Pant	Skirt	Jacket
4	Labor hours/unit	2	1	6	4	8
5	Cloth (sq. yd.)/unit	3	2.5	4	4.5	5.5
6
7	Selling price/unit	35	40	65	70	110
8	Variable cost/unit	20	10	25	30	35
9	Fixed cost for equipment	1500	1200	1600	1500	1600
10
11	Production plan, constraints on capacity
12		Shirt	Short	Pant	Skirt	Jacket
13	Rent equipment	0	1	0	0	1
14
15	Units produced	0	966	0	0	379
16	Sign	<=	<=	<=	<=	<=
17	Effective capacity	0	1800	0	0	500
18
19	Constraints on resources
20		Resource used	Sign	Available
21	Labor hours	3998.0	<=	4000
22	Cloth	4499.5	<=	4500
23
24	Monetary outputs
25	Revenue	80330.00
26	Variable cost	22925.00
27	Fixed cost for equipment	2800.00
28	Profit	54605.00
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100