Module 8: End of Module Project 1

1 00:00:02,340 --> 00:00:07,500 all right so this modulate in the flow

2 00:00:04,860 --> 00:00:09,300 in the module project one so right of

3 00:00:07,500 --> 00:00:11,880 the bat make sure you change your

4 00:00:09,300 --> 00:00:14,519 project name to underscore 2 because

5 00:00:11,880 --> 00:00:17,640 while we make reports in the further

6 00:00:14,519 --> 00:00:19,380 step and it will generate the name of

7 00:00:17,640 --> 00:00:21,660 the file and while you submit the file

8 00:00:19,380 --> 00:00:23,699 to the same gauge it might show here so

9 00:00:21,660 --> 00:00:27,240 make sure you change the name and then

10 00:00:23,699 --> 00:00:29,760 make sure you add the solver add-in

11 00:00:27,240 --> 00:00:32,940 okay so step one it is saying mother

12 00:00:29,760 --> 00:00:35,579 Patel is a sales analyst for foreign

13 00:00:32,940 --> 00:00:38,180 energy and go to income analysis

14 00:00:35,579 --> 00:00:41,160 worksheet so on the bottom click here

15 00:00:38,180 --> 00:00:43,440 which leads the revenue and expenses for

16 00:00:41,160 --> 00:00:45,780 the this one turbine and calculated the

17 00:00:43,440 --> 00:00:47,940 net income or the one to compare the

18 00:00:45,780 --> 00:00:50,160 financial outcome for better any varying

19 00:00:47,940 --> 00:00:52,860 amount of turbines sold and identify the

20 00:00:50,160 --> 00:00:56,820 number of units the company need to sell

21 00:00:52,860 --> 00:00:59,100 to break even modu has already entered

22 00:00:56,820 --> 00:01:01,920 formula in the range E5 through S5 to

23 00:00:59,100 --> 00:01:05,640 extract data from the income analysis in

24 00:01:01,920 --> 00:01:11,100 the range V4 through c26 in the range as

25 00:01:05,640 --> 00:01:13,380 5 through S14 or E5 through as 14 so

26 00:01:11,100 --> 00:01:15,540 okay E5

27 00:01:13,380 --> 00:01:19,619 through as 14

28 00:01:15,540 --> 00:01:22,140 it is saying create a one variable data

29 00:01:19,619 --> 00:01:24,479 table using cell S5 as the column input

30 00:01:22,140 --> 00:01:25,740 cell to calculate the revenue expenses

31 00:01:24,479 --> 00:01:28,320 and okay

32 00:01:25,740 --> 00:01:30,979 so here it is saying one variable data

33 00:01:28,320 --> 00:01:33,840 table for that go to data tab groups

34 00:01:30,979 --> 00:01:36,360 data Tab and then under the forecast

35 00:01:33,840 --> 00:01:39,200 group here is what if analysis click

36 00:01:36,360 --> 00:01:42,720 here and then go to data table

37 00:01:39,200 --> 00:01:46,020 so it is saying in this is create using

38 00:01:42,720 --> 00:01:48,560 C5 as the column input cell okay so

39 00:01:46,020 --> 00:01:52,920 column input cell as

40 00:01:48,560 --> 00:01:54,840 C5 to calculate Revenue expenses okay

41 00:01:52,920 --> 00:01:57,299 now hit OK

42 00:01:54,840 --> 00:01:59,460 all right so Step One is down now it is

43 00:01:57,299 --> 00:02:01,860 saying modu asked you to provide a

44 00:01:59,460 --> 00:02:04,259 visual representation of the break even

45 00:02:01,860 --> 00:02:06,360 data create a scatter with straight

46 00:02:04,259 --> 00:02:09,720 lines are based on the unit sold revenue

47 00:02:06,360 --> 00:02:11,760 and expenses in the data table range E4

48 00:02:09,720 --> 00:02:18,120 through z12

49 00:02:11,760 --> 00:02:19,800 okay so from E4 through g12 or G14 so

50 00:02:18,120 --> 00:02:22,140 z14

51 00:02:19,800 --> 00:02:25,379 already saying scattered with state line

52 00:02:22,140 --> 00:02:27,620 chart so for that go to insert and then

53 00:02:25,379 --> 00:02:30,780 here is the chart

54 00:02:27,620 --> 00:02:33,660 so let's go to recommended chart

55 00:02:30,780 --> 00:02:35,459 and then click on all that Tab and then

56 00:02:33,660 --> 00:02:37,500 it was saying scattered

57 00:02:35,459 --> 00:02:39,180 okay and then it was saying straight

58 00:02:37,500 --> 00:02:41,160 lines

59 00:02:39,180 --> 00:02:42,180 so this is with marker so this is

60 00:02:41,160 --> 00:02:43,680 straight line

61 00:02:42,180 --> 00:02:46,140 oh let's say this is the required one

62 00:02:43,680 --> 00:02:48,120 and then hit OK

63 00:02:46,140 --> 00:02:49,739 and then it is saying resize and

64 00:02:48,120 --> 00:02:56,660 reposition the search so it covered the

65 00:02:49,739 --> 00:02:56,660 range I 3 through 9 n 15. all right so

66 00:02:57,360 --> 00:03:03,840 i3

67 00:03:00,060 --> 00:03:08,099 through and 15.

68 00:03:03,840 --> 00:03:11,400 okay so let's make sure oops

69 00:03:08,099 --> 00:03:13,640 this is I3

70 00:03:11,400 --> 00:03:17,060 and then

71 00:03:13,640 --> 00:03:17,060 15 okay

72 00:03:17,819 --> 00:03:22,140 so this is n 15.

73 00:03:21,000 --> 00:03:24,000 all right

74 00:03:22,140 --> 00:03:25,980 now

75 00:03:24,000 --> 00:03:28,620 step three designing other one to

76 00:03:25,980 --> 00:03:31,019 clarify the purpose of that and focus on

77 00:03:28,620 --> 00:03:34,980 the UI containing data use Break Even

78 00:03:31,019 --> 00:03:36,180 Point as the chart title okay so double

79 00:03:34,980 --> 00:03:38,900 click

80 00:03:36,180 --> 00:03:42,840 and then it wants

81 00:03:38,900 --> 00:03:44,580 break gas even and then fight

82 00:03:42,840 --> 00:03:47,280 change the minimum bound of the

83 00:03:44,580 --> 00:03:49,319 horizontal axis okay so for that click

84 00:03:47,280 --> 00:03:51,360 floss and then

85 00:03:49,319 --> 00:03:53,459 and just click any of these and then

86 00:03:51,360 --> 00:03:55,200 click more options and then this section

87 00:03:53,459 --> 00:03:56,700 will have error you can double click

88 00:03:55,200 --> 00:03:58,799 double click on the chart in this

89 00:03:56,700 --> 00:04:00,959 section will have here so it is saying

90 00:03:58,799 --> 00:04:03,480 change minimum bound of horizontal axis

91 00:04:00,959 --> 00:04:06,299 so for that click on this drop down and

92 00:04:03,480 --> 00:04:08,220 then click horizontal value axis and

93 00:04:06,299 --> 00:04:09,959 then click on this icon access option

94 00:04:08,220 --> 00:04:12,540 and then click on access option drop

95 00:04:09,959 --> 00:04:15,959 down and everything change minimum bound

96 00:04:12,540 --> 00:04:18,600 so minimum bound it is zero so it sends

97 00:04:15,959 --> 00:04:22,040 it to 2500 and it is saying let the

98 00:04:18,600 --> 00:04:24,419 maximum bound at this automatically okay

99 00:04:22,040 --> 00:04:26,699 change the minimum bound of the vertical

100 00:04:24,419 --> 00:04:30,419 axis so

101 00:04:26,699 --> 00:04:32,580 for vertical axis so same thing go to

102 00:04:30,419 --> 00:04:35,100 axis option drop down and then it is

103 00:04:32,580 --> 00:04:37,139 saying change the minimum bound

104 00:04:35,100 --> 00:04:39,960 to

105 00:04:37,139 --> 00:04:42,740 2 and then one two three four five six

106 00:04:39,960 --> 00:04:45,540 or two million and then hit enter okay

107 00:04:42,740 --> 00:04:49,560 now step forward is saying model also

108 00:04:45,540 --> 00:04:51,720 wants to examine how berang sales price

109 00:04:49,560 --> 00:04:54,300 and volume effect net income from wind

110 00:04:51,720 --> 00:04:56,820 turbine she has already entered the net

111 00:04:54,300 --> 00:04:59,820 income in cell E18

112 00:04:56,820 --> 00:04:59,820 27

113 00:05:00,780 --> 00:05:03,300 so

114 00:05:02,750 --> 00:05:05,300 [Music]

115 00:05:03,300 --> 00:05:05,300 um

116 00:05:05,580 --> 00:05:09,780 okay so from here

117 00:05:07,740 --> 00:05:11,699 to j27

118 00:05:09,780 --> 00:05:13,440 so from here to here

119 00:05:11,699 --> 00:05:16,320 it is saying

120 00:05:13,440 --> 00:05:19,979 uh created two variable data table using

121 00:05:16,320 --> 00:05:21,240 the price per unit C6 as so same thing

122 00:05:19,979 --> 00:05:24,120 go to

123 00:05:21,240 --> 00:05:26,400 data Tab and then under

124 00:05:24,120 --> 00:05:29,280 oops under forecast group where is what

125 00:05:26,400 --> 00:05:31,139 if analysis and then go to data table so

126 00:05:29,280 --> 00:05:32,820 now it is two variables so we need to

127 00:05:31,139 --> 00:05:35,580 input we want to interpose row and

128 00:05:32,820 --> 00:05:38,940 column value so for

129 00:05:35,580 --> 00:05:43,680 for row input cell it is saying C6 okay

130 00:05:38,940 --> 00:05:46,680 C6 and then for column input cell

131 00:05:43,680 --> 00:05:48,300 okay as row input cell and then C5 has

132 00:05:46,680 --> 00:05:51,060 column

133 00:05:48,300 --> 00:05:55,100 so insulating create a question okay so

134 00:05:51,060 --> 00:05:55,100 after this we'll do that here okay

135 00:06:01,340 --> 00:06:07,800 instead of this okay so into display

136 00:06:04,199 --> 00:06:09,360 unit zone so right click and then format

137 00:06:07,800 --> 00:06:11,940 cell

138 00:06:09,360 --> 00:06:16,440 okay and then click on this custom tab

139 00:06:11,940 --> 00:06:20,100 under category group and then

140 00:06:16,440 --> 00:06:22,280 oops let's scroll okay otherwise you

141 00:06:20,100 --> 00:06:26,639 just click here and then delete

142 00:06:22,280 --> 00:06:30,240 this and then under quotation type units

143 00:06:26,639 --> 00:06:33,840 sold so units and then sold and then

144 00:06:30,240 --> 00:06:36,360 quotation mark and then click ok so this

145 00:06:33,840 --> 00:06:38,880 will change the unit is sold so after

146 00:06:36,360 --> 00:06:40,979 that in step 5 it is saying model has

147 00:06:38,880 --> 00:06:42,780 created two scenarios in the income

148 00:06:40,979 --> 00:06:43,979 analysis work so we are on the same

149 00:06:42,780 --> 00:06:46,800 worksheet

150 00:06:43,979 --> 00:06:49,139 now so the current Cinema scenario

151 00:06:46,800 --> 00:06:51,780 assumes the current value for unisol

152 00:06:49,139 --> 00:06:54,360 price and fix expenses the lower price

153 00:06:51,780 --> 00:06:56,759 scenario as in small units sold as a

154 00:06:54,360 --> 00:06:58,860 lower price you also want to create a

155 00:06:56,759 --> 00:07:01,020 scenario that assumes fewer unit sold at

156 00:06:58,860 --> 00:07:03,780 a higher price okay so create a scenario

157 00:07:01,020 --> 00:07:06,600 using the data shown in bold in table

158 00:07:03,780 --> 00:07:09,960 one without applying any scenarios okay

159 00:07:06,600 --> 00:07:11,940 so we need to insert this scenario so it

160 00:07:09,960 --> 00:07:14,759 is instated that she already created two

161 00:07:11,940 --> 00:07:17,100 scenarios so let's look go to data Tab

162 00:07:14,759 --> 00:07:19,020 and then again forecast group what if

163 00:07:17,100 --> 00:07:21,000 analysis and then this time go to

164 00:07:19,020 --> 00:07:23,819 scenario manager option

165 00:07:21,000 --> 00:07:28,080 so as you can see here is current and

166 00:07:23,819 --> 00:07:30,800 lower price scenario now it want to add

167 00:07:28,080 --> 00:07:33,360 so here is the scenario name raise price

168 00:07:30,800 --> 00:07:36,900 so enter that

169 00:07:33,360 --> 00:07:39,419 race price and then changing sales will

170 00:07:36,900 --> 00:07:44,039 be C5 through C6 and then c18 through

171 00:07:39,419 --> 00:07:46,860 C20 so this is done now hit ok now unit

172 00:07:44,039 --> 00:07:51,440 sold will be 4500

173 00:07:46,860 --> 00:07:53,340 so 4500 and then price per units will be

174 00:07:51,440 --> 00:07:57,419 12.39

175 00:07:53,340 --> 00:08:00,419 and then sales and benefits will be

176 00:07:57,419 --> 00:08:03,419 how many zero are there

177 00:08:00,419 --> 00:08:06,419 okay so 800 000.

178 00:08:03,419 --> 00:08:09,419 so 800 and then three

179 00:08:06,419 --> 00:08:13,380 okay and distribution is

180 00:08:09,419 --> 00:08:16,259 five one zero zero zero zero okay

181 00:08:13,380 --> 00:08:21,720 and then this will be three zero zero

182 00:08:16,259 --> 00:08:25,440 zero zero okay and then hit okay

183 00:08:21,720 --> 00:08:28,440 after that's close this model and then

184 00:08:25,440 --> 00:08:30,479 go to step 6 say design use the scenario

185 00:08:28,440 --> 00:08:33,240 manager to create a scenario summary

186 00:08:30,479 --> 00:08:35,520 report that summarizes the effect of

187 00:08:33,240 --> 00:08:39,000 current lower price and raise prices

188 00:08:35,520 --> 00:08:42,300 raise price scenario so we just created

189 00:08:39,000 --> 00:08:45,660 this in step five Knight one two make

190 00:08:42,300 --> 00:08:48,000 the report okay so use the total revenue

191 00:08:45,660 --> 00:08:51,480 total expenses and net income in the

192 00:08:48,000 --> 00:08:52,860 range C 24 through c26 as a result sale

193 00:08:51,480 --> 00:08:55,080 okay

194 00:08:52,860 --> 00:08:56,820 so for that again go to data Tab and

195 00:08:55,080 --> 00:08:59,100 then on the forecast group there is what

196 00:08:56,820 --> 00:09:01,320 if analysis click here and then go to

197 00:08:59,100 --> 00:09:03,839 scenario manager so we have we have all

198 00:09:01,320 --> 00:09:05,459 three scenario now go to summary

199 00:09:03,839 --> 00:09:08,640 and then

200 00:09:05,459 --> 00:09:09,800 so it wants a summary summary report

201 00:09:08,640 --> 00:09:12,720 [Music]

202 00:09:09,800 --> 00:09:18,860 step six yeah summary report and then

203 00:09:12,720 --> 00:09:18,860 the result CLR c24 through c26 okay

204 00:09:21,480 --> 00:09:28,440 let me close this and then go to summary

205 00:09:25,320 --> 00:09:32,540 and then scenario summary and then

206 00:09:28,440 --> 00:09:35,940 delete this and then enter c24 through

207 00:09:32,540 --> 00:09:38,399 c26 as the result those sales go to the

208 00:09:35,940 --> 00:09:40,620 scenario somebody works it and okay so

209 00:09:38,399 --> 00:09:42,959 now hit OK

210 00:09:40,620 --> 00:09:45,660 it will take some time so after this it

211 00:09:42,959 --> 00:09:48,600 will take us to this step scenario

212 00:09:45,660 --> 00:09:50,640 summary worksheet now it is saying go to

213 00:09:48,600 --> 00:09:52,680 this worksheet and delete column D which

214 00:09:50,640 --> 00:09:54,180 repeats the current values yeah it

215 00:09:52,680 --> 00:09:56,760 repeats the color value so click on

216 00:09:54,180 --> 00:09:59,880 column T and then right click and then

217 00:09:56,760 --> 00:10:02,700 choose the delete option okay

218 00:09:59,880 --> 00:10:05,399 now go to scenario pivot table worksheet

219 00:10:02,700 --> 00:10:07,680 okay

220 00:10:05,399 --> 00:10:10,440 oops return to income so we are on step

221 00:10:07,680 --> 00:10:12,540 7 return to income analysis worksheet so

222 00:10:10,440 --> 00:10:15,000 this works it and you can create a

223 00:10:12,540 --> 00:10:16,620 scenario people table report okay so

224 00:10:15,000 --> 00:10:18,720 this time people table report of the

225 00:10:16,620 --> 00:10:21,360 three scenario displaying total revenue

226 00:10:18,720 --> 00:10:23,519 total expenses and net income again go

227 00:10:21,360 --> 00:10:25,560 to data Tab and then all under forecast

228 00:10:23,519 --> 00:10:28,260 group there is vertical analysis click

229 00:10:25,560 --> 00:10:29,760 scenario manager and then again go to

230 00:10:28,260 --> 00:10:31,380 summary but this time instead of

231 00:10:29,760 --> 00:10:33,180 scenario somewhere it wants scenario

232 00:10:31,380 --> 00:10:38,279 pivot table report

233 00:10:33,180 --> 00:10:42,000 okay so select this and then range so

234 00:10:38,279 --> 00:10:44,820 range c24 through c26 okay so hit okay

235 00:10:42,000 --> 00:10:47,579 now it will take this take us to this

236 00:10:44,820 --> 00:10:49,860 tab scenario people table worksheet

237 00:10:47,579 --> 00:10:51,720 now it is saying go to scenario people

238 00:10:49,860 --> 00:10:53,940 worksheets so okay we are in the same

239 00:10:51,720 --> 00:10:55,680 worksheet and say mother wants to make

240 00:10:53,940 --> 00:10:57,480 the pivot table easier to interpret

241 00:10:55,680 --> 00:11:00,300 remove the filter from the pivot table

242 00:10:57,480 --> 00:11:02,640 okay so this is the filter so just right

243 00:11:00,300 --> 00:11:05,940 click and then remove

244 00:11:02,640 --> 00:11:09,959 all right now it is saying

245 00:11:05,940 --> 00:11:15,120 and then use total revenue as okay so

246 00:11:09,959 --> 00:11:18,720 these are the row level in V3 so P3

247 00:11:15,120 --> 00:11:20,399 change these two total oops

248 00:11:18,720 --> 00:11:22,079 total revenue

249 00:11:20,399 --> 00:11:24,959 okay

250 00:11:22,079 --> 00:11:26,640 and then use total expenses as row level

251 00:11:24,959 --> 00:11:30,000 so

252 00:11:26,640 --> 00:11:31,800 to relax which is in here

253 00:11:30,000 --> 00:11:36,800 again

254 00:11:31,800 --> 00:11:36,800 total expenses and then foreign

255 00:11:39,420 --> 00:11:44,880 make I capital okay noticing display

256 00:11:42,480 --> 00:11:47,100 Revenue expenses and net income value in

257 00:11:44,880 --> 00:11:49,019 the currency number format with no

258 00:11:47,100 --> 00:11:50,480 decimal places okay so these are the

259 00:11:49,019 --> 00:11:53,459 value make sure you select everything

260 00:11:50,480 --> 00:11:57,000 and then go to Home tab and under number

261 00:11:53,459 --> 00:12:00,480 groups click this expand Arrow

262 00:11:57,000 --> 00:12:04,079 and then under category group go to

263 00:12:00,480 --> 00:12:06,899 currency tab and then decimal place it

264 00:12:04,079 --> 00:12:08,820 one and no decimal place so make it zero

265 00:12:06,899 --> 00:12:11,100 and then for negative numbers here is

266 00:12:08,820 --> 00:12:12,360 the section for negative numbers it want

267 00:12:11,100 --> 00:12:15,480 this red

268 00:12:12,360 --> 00:12:18,720 red and enclosion parenthesis okay

269 00:12:15,480 --> 00:12:21,360 select that and then hit OK

270 00:12:18,720 --> 00:12:23,760 all right noticing resize column B

271 00:12:21,360 --> 00:12:27,120 through D to their base fit using out of

272 00:12:23,760 --> 00:12:30,540 it okay so select p through D and then

273 00:12:27,120 --> 00:12:33,420 right click and then search auto feed

274 00:12:30,540 --> 00:12:34,920 out of its selection okay or you can

275 00:12:33,420 --> 00:12:36,420 just double click on here and then

276 00:12:34,920 --> 00:12:39,480 double click on here and it will auto

277 00:12:36,420 --> 00:12:41,399 fit it all right now step 9 it is saying

278 00:12:39,480 --> 00:12:43,260 model also want to compare the three

279 00:12:41,399 --> 00:12:45,600 scenario in a chart create a clustered

280 00:12:43,260 --> 00:12:47,459 column column keyword chart based on

281 00:12:45,600 --> 00:12:51,120 pivot table okay so click on this pivot

282 00:12:47,459 --> 00:12:52,860 table and then go to insert and then it

283 00:12:51,120 --> 00:12:55,860 was saying clustered

284 00:12:52,860 --> 00:12:55,860 foreign

285 00:13:03,260 --> 00:13:07,560 so that it covers the range A8 through

286 00:13:06,180 --> 00:13:10,440 e24

287 00:13:07,560 --> 00:13:13,980 so here's the eight

288 00:13:10,440 --> 00:13:17,839 and then e 24

289 00:13:13,980 --> 00:13:17,839 okay make sure everyone the 24

290 00:13:20,040 --> 00:13:23,459 okay

291 00:13:21,300 --> 00:13:25,980 so e24 already

292 00:13:23,459 --> 00:13:28,320 now step 10 it is saying go to the

293 00:13:25,980 --> 00:13:30,540 product line worksheet okay

294 00:13:28,320 --> 00:13:32,220 this income analysis and then product

295 00:13:30,540 --> 00:13:35,180 line okay

296 00:13:32,220 --> 00:13:38,459 which list three wind turbine that four

297 00:13:35,180 --> 00:13:40,680 winding okay mother wants to find the

298 00:13:38,459 --> 00:13:43,079 product mix that generates the most net

299 00:13:40,680 --> 00:13:44,760 income for the company use solver to

300 00:13:43,079 --> 00:13:47,700 maximize the percentage of the

301 00:13:44,760 --> 00:13:50,180 difference between the even and optimal

302 00:13:47,700 --> 00:13:52,920 product mixes so

303 00:13:50,180 --> 00:13:55,320 cl23 so for this we need to use solver

304 00:13:52,920 --> 00:13:58,320 so for that go to data Tab and then

305 00:13:55,320 --> 00:14:00,899 under analyze there should be solver

306 00:13:58,320 --> 00:14:02,459 so if you don't have solver just search

307 00:14:00,899 --> 00:14:05,279 add-ins

308 00:14:02,459 --> 00:14:07,320 from this Source tab click on add-ins

309 00:14:05,279 --> 00:14:09,240 and then make sure you check mark this

310 00:14:07,320 --> 00:14:10,860 and then hit okay or you can follow the

311 00:14:09,240 --> 00:14:12,180 instruction it is given on the top of

312 00:14:10,860 --> 00:14:16,620 this instruction

313 00:14:12,180 --> 00:14:19,800 Word file let's show click on the solver

314 00:14:16,620 --> 00:14:23,579 now it is saying so you have 23 so

315 00:14:19,800 --> 00:14:26,579 objectives will be F 23 and then by

316 00:14:23,579 --> 00:14:29,100 changing the optimal product mix so okay

317 00:14:26,579 --> 00:14:31,920 so by changing this so first lady saying

318 00:14:29,100 --> 00:14:34,260 to maximize so make sure you click on

319 00:14:31,920 --> 00:14:36,480 maximize and then by changing the

320 00:14:34,260 --> 00:14:39,899 optical product mix so

321 00:14:36,480 --> 00:14:43,079 by changing this variable so yours will

322 00:14:39,899 --> 00:14:45,240 be C 10 through E10

323 00:14:43,079 --> 00:14:47,160 okay so now subject to the following

324 00:14:45,240 --> 00:14:48,000 constant so we need to add constraint

325 00:14:47,160 --> 00:14:49,980 here

326 00:14:48,000 --> 00:14:53,720 by following this it is saying the total

327 00:14:49,980 --> 00:14:58,560 units sold in the optimal product mix so

328 00:14:53,720 --> 00:15:00,779 cld18 must be must be equal to 4750

329 00:14:58,560 --> 00:15:04,139 so

330 00:15:00,779 --> 00:15:07,800 four seven five zero so hit add

331 00:15:04,139 --> 00:15:09,240 and then cell reference must be oops

332 00:15:07,800 --> 00:15:11,459 d18

333 00:15:09,240 --> 00:15:14,220 and then it is saying must be so that

334 00:15:11,459 --> 00:15:18,420 must be equals to and then constant will

335 00:15:14,220 --> 00:15:21,120 be four seven five Jill and then hit and

336 00:15:18,420 --> 00:15:24,000 then going to add others also yeah I'm

337 00:15:21,120 --> 00:15:27,019 going to add others so click on ADD

338 00:15:24,000 --> 00:15:30,480 after using the company needs to produce

339 00:15:27,019 --> 00:15:33,180 1200 or more of each turbine model so

340 00:15:30,480 --> 00:15:36,420 the optimal mix value for each model

341 00:15:33,180 --> 00:15:40,800 I'll range C 10 through E10 must be at

342 00:15:36,420 --> 00:15:43,740 least 1200 okay so C 10 through 18 must

343 00:15:40,800 --> 00:15:48,360 be at least 1200 that means must be

344 00:15:43,740 --> 00:15:51,779 greater than or equals to 1200 so 1200

345 00:15:48,360 --> 00:15:54,540 and then those same value in the range C

346 00:15:51,779 --> 00:15:56,519 10 through 18 must be integer okay so we

347 00:15:54,540 --> 00:16:01,860 need to add another constant also so

348 00:15:56,519 --> 00:16:03,600 again E 10 through C 10 through 18 must

349 00:16:01,860 --> 00:16:05,339 be integer so again click on this drop

350 00:16:03,600 --> 00:16:07,620 down and here is the hint

351 00:16:05,339 --> 00:16:11,399 and then it fill the integer

352 00:16:07,620 --> 00:16:13,500 okay now after that hit OK so all three

353 00:16:11,399 --> 00:16:15,899 constraints are added here now it is

354 00:16:13,500 --> 00:16:18,620 saying the remaining value for each

355 00:16:15,899 --> 00:16:21,660 assemble part range J5

356 00:16:18,620 --> 00:16:23,880 j13 must be greater than or equals to

357 00:16:21,660 --> 00:16:25,320 zero okay

358 00:16:23,880 --> 00:16:29,339 so again we need to add another

359 00:16:25,320 --> 00:16:33,600 constraint so this time with J5

360 00:16:29,339 --> 00:16:35,940 through J 13 and then must be greater

361 00:16:33,600 --> 00:16:37,440 than equals to zero okay so greater than

362 00:16:35,940 --> 00:16:39,980 or equals to

363 00:16:37,440 --> 00:16:39,980 okay

364 00:16:40,440 --> 00:16:45,779 sorry whether it is saying run the

365 00:16:42,240 --> 00:16:49,380 solver okay so click on so make sure it

366 00:16:45,779 --> 00:16:52,440 is you have 23 and then okay

367 00:16:49,380 --> 00:16:54,360 so run the solver

368 00:16:52,440 --> 00:16:56,639 and then it is saying keep the solution

369 00:16:54,360 --> 00:16:58,920 so keep the server solution make sure

370 00:16:56,639 --> 00:17:01,259 you check mark this click on this and

371 00:16:58,920 --> 00:17:05,160 then it is saying and then return to the

372 00:17:01,259 --> 00:17:07,260 solver solver parameter okay so make

373 00:17:05,160 --> 00:17:09,020 sure you click on this check mark and

374 00:17:07,260 --> 00:17:11,880 then hit OK

375 00:17:09,020 --> 00:17:16,260 and it is saying save the model to the

376 00:17:11,880 --> 00:17:18,780 range as at 17 through s24 so as 17

377 00:17:16,260 --> 00:17:20,280 through s24 click on this load slash

378 00:17:18,780 --> 00:17:22,559 save option

379 00:17:20,280 --> 00:17:26,400 and then

380 00:17:22,559 --> 00:17:29,160 I'll be with this and then select f17

381 00:17:26,400 --> 00:17:32,900 through as 24.

382 00:17:29,160 --> 00:17:36,720 okay so click on Save

383 00:17:32,900 --> 00:17:40,020 and then close this dialog box

384 00:17:36,720 --> 00:17:43,799 okay now it saved the solver is a linear

385 00:17:40,020 --> 00:17:47,960 okay so let's check our result

386 00:17:43,799 --> 00:17:47,960 so scenario summary oops

387 00:17:48,799 --> 00:17:54,299 okay so this is right and then scenario

388 00:17:52,320 --> 00:17:58,020 pivot table worksheet

389 00:17:54,299 --> 00:18:01,500 okay so this is also right

390 00:17:58,020 --> 00:18:04,500 make sure you place this chart in in the

391 00:18:01,500 --> 00:18:07,980 given in the given range

392 00:18:04,500 --> 00:18:09,240 so final figure three input analysis

393 00:18:07,980 --> 00:18:10,980 worksheet

394 00:18:09,240 --> 00:18:13,620 okay

395 00:18:10,980 --> 00:18:15,660 okay so this is also good and then

396 00:18:13,620 --> 00:18:18,900 product line works it

397 00:18:15,660 --> 00:18:20,580 all right so solver results so yeah

398 00:18:18,900 --> 00:18:25,520 these are also good

399 00:18:20,580 --> 00:18:25,520 all right so see you in next video