sam capstone project 1b

View SAM Project Answer Keys

View the correct answers for SAM projects.

• Click SAM assignments .

• Click the file under Solution File to download it to your computer.
• Open the solution file.

Screen recorder

Record your screen for free.

Video editor

Easily edit your videos for free.

Video & Image Hosting

Share & protect your content with our content management platform.

Screenshots

Instantly capture and annotate your screen.

Image editor

Edit screenshots & imported images within minutes.

Video quizzing

Engage with your audience through quiz questions, ratings, and polls.

Streamline video creation with storyboards and scripts.

Stock Library

Explore videos, images and music.

Understand your audience with advanced video analytics.

Edit with our intuitive video editor.

Edit screenshots & uploaded images within minutes.

Share & protect your videos and image with our content management platform.

Word Module 1: SAM Project 1b

Module 3: SAM Project 1b

Description

PROJECT STEPS

• Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments Division is planning to manufacture and market an innovative hearing aid suitable for all ages. Amy is using an Excel workbook to estimate the sales, expenses, and profits of the new device. Switch to the Unit Sales Projections worksheet. Use the values in the range C5:D5 to fill the range E5:I5 with a series of incremented percentages.
• Use the values and formatting in the range B6:B7 to extend the list of years to the range B8:B10 and project five years of growth.
• Use AutoFill to fill the range C8:I10 with the formatting from the range C6:I7 to apply a consistent format in the projections.
• Enter formulas as follows to complete the table of projections in the range C6:I10: a. In cell C7, create a formula without using a function that multiplies the sales projection for the first year (cell C6) by the first growth rate (cell C5), and adds the sales projection for the first year (cell C6) to the result to determine the first estimate for 2022. b. Use an absolute reference to row 5 in the reference to cell C5. c. Copy the formula from cell C7 to the range C8:C10, and then copy the formulas from the range C7:C10 to the range D7:I10 to complete the table of projections.
• Switch to the Cost Analysis worksheet, which analyzes the vendor and shipping costs per unit to select a vendor and shipper for the new product. In cell B10, find the average vendor cost per unit by creating a formula using the AVERAGE function to calculate the average of the values in the range B5:B8. Copy the formula to cell E10 to find the average shipping cost per unit.
• In cell B11, find the highest vendor cost per unit by creating a formula using the MAX function to identify the maximum value in the range B5:B8. Copy the formula to cell E11 to find the highest shipping cost per unit.
• In cell B12, find the lowest vendor cost per unit by creating a formula using the MIN function to identify the minimum value in the range B5:B8. Copy the formula to cell E12 to find the lowest shipping cost per unit.
• In cell C14, identify the vendor with the lowest cost per unit by creating a formula using the VLOOKUP function to look up the value from cell B12 (the lowest vendor cost) in the range B5:C8 (the vendor cost per unit table), return the name of the vendor (column 2), and specify an exact match. Copy the formula to cell F14 to identify the shipper with the lowest cost per unit.
• Switch to the Profit Projections worksheet, which sets a schedule for developing and launching the new product and projects its profits for five years. In cell I7, use the TODAY function to insert the current date.
• In cell I9, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells I7 and I8. Leave the Holidays argument blank.
• Use the values in the range C14:D14 to fill the range E14:I14 with a series of incremented percentages.
• Use the values in the range B15:B16 to extend the list of years to the range B17:B19 for five years of projections.
• Estimate the gross profit for 2021 as follows: a. In cell C15, create a formula without using a function that subtracts the vendor cost (cell C7) and the shipping cost (cell C9) from the sales price (cell C8), and then multiplies the result by the projected number of units for sale in 2021 (cell C10). b. Use absolute references to each cell in the formula. c. Copy the formula from cell C15 to the range D15:I15 to complete the estimates for 2021.
• Complete the growth estimates for the years 2022 to 2025 as follows: a. In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15). b. Use an absolute row reference to cell C14. c. Copy the formula from cell C16 to the range C17:C19 to enter the first estimates for 2023–2025. d. Copy the formulas from the range C16:C19 to the range D16:I19 to enter the remaining sales projections.
• Delete row 21 since the worksheet is now complete.

#cengage #solutions

Disclaimer: Our videos are intended solely for educational purposes, with the goal of assisting students in understanding how to solve problems in various courses. We want to emphasize that any attempt to copy or replicate the solutions shown in these videos may be regarded as a breach of academic integrity policies at your college or university. We strongly recommend that you use these videos as a guide and as a tool to support your learning, but we urge you to complete your assignments independently and refrain from cheating or plagiarism. Please be aware that we are not liable for any consequences resulting from the misuse of these videos in violation of academic integrity policies.

1 00:00:02,100 --> 00:00:08,760 all right what's going on so this is

2 00:00:05,040 --> 00:00:12,240 module 3 Sam project 1B so here it is

3 00:00:08,760 --> 00:00:14,639 saying is a financial analyst with made

4 00:00:12,240 --> 00:00:16,619 site instruments a global so we don't

5 00:00:14,639 --> 00:00:18,900 need this information you can skip up to

6 00:00:16,619 --> 00:00:22,199 here so it is saying switch to the unit

7 00:00:18,900 --> 00:00:25,019 sales projects and worksheet so on the

8 00:00:22,199 --> 00:00:27,240 bottom click on unit sales projection

9 00:00:25,019 --> 00:00:29,820 and then it is saying use the values in

10 00:00:27,240 --> 00:00:35,040 the range C5 through D5 to fill the

11 00:00:29,820 --> 00:00:38,340 range E5 through I5 so let's see C5 C5

12 00:00:35,040 --> 00:00:40,500 through D5 so here is C5 and then here

13 00:00:38,340 --> 00:00:44,460 is D5 and then it is going to fill the

14 00:00:40,500 --> 00:00:46,260 range E5 through I5 so you can just go

15 00:00:44,460 --> 00:00:48,840 to the corner and then this plus sign

16 00:00:46,260 --> 00:00:52,079 will appear and then hold it and drag it

17 00:00:48,840 --> 00:00:53,940 until I5 so it will use those value as a

18 00:00:52,079 --> 00:00:56,460 reference and then increment those other

19 00:00:53,940 --> 00:00:59,100 value so step two it is saying use the

20 00:00:56,460 --> 00:01:03,539 values and formatting in the range B6

21 00:00:59,100 --> 00:01:07,979 through B7 so here is B6 and then B7

22 00:01:03,539 --> 00:01:10,320 oops so let's select B6 and B7 both just

23 00:01:07,979 --> 00:01:12,000 click on this cell and then double tap

24 00:01:10,320 --> 00:01:14,340 and then hold and drag it down so this

25 00:01:12,000 --> 00:01:17,760 way you can select both range or you can

26 00:01:14,340 --> 00:01:19,560 just click on B6 and then hold shift and

27 00:01:17,760 --> 00:01:21,720 then click here so this way also you can

28 00:01:19,560 --> 00:01:23,939 select both CLS

29 00:01:21,720 --> 00:01:26,640 so it is saying select this and extend

30 00:01:23,939 --> 00:01:29,220 to the list of year to the range B8

31 00:01:26,640 --> 00:01:31,700 through B10 so go to the corner plus

32 00:01:29,220 --> 00:01:33,659 sign will appear and then drag it until

33 00:01:31,700 --> 00:01:36,240 B 10

34 00:01:33,659 --> 00:01:38,640 okay and project five years of clothes

35 00:01:36,240 --> 00:01:40,860 so it is showing five years and then it

36 00:01:38,640 --> 00:01:43,500 is saying use autofill to fill the range

37 00:01:40,860 --> 00:01:45,960 and see it through I10 with the

38 00:01:43,500 --> 00:01:48,240 formatting from the range C6 through i7

39 00:01:45,960 --> 00:01:49,619 to apply a consistent formatting in the

40 00:01:48,240 --> 00:01:52,619 projections

41 00:01:49,619 --> 00:01:54,720 so double click and then drag it until I

42 00:01:52,619 --> 00:01:56,579 and then here is seven or you can just

43 00:01:54,720 --> 00:01:59,220 click on this cell and then hold shift

44 00:01:56,579 --> 00:02:02,939 and then click on Cell i7 this way also

45 00:01:59,220 --> 00:02:05,040 you can select cell C6 through i7 so it

46 00:02:02,939 --> 00:02:07,500 is saying use this range to fill the

47 00:02:05,040 --> 00:02:10,319 range C8 through I10

48 00:02:07,500 --> 00:02:12,360 so here is CA through item so autofill

49 00:02:10,319 --> 00:02:15,180 means same thing just go to the corner

50 00:02:12,360 --> 00:02:16,860 plus sign library and then drag it up to

51 00:02:15,180 --> 00:02:19,379 itin

52 00:02:16,860 --> 00:02:23,099 so it will apply same formatting from CA

53 00:02:19,379 --> 00:02:27,480 to I10 by copying the formatting from C6

54 00:02:23,099 --> 00:02:29,819 through I8 I mean i7 so it is saying

55 00:02:27,480 --> 00:02:31,860 enter formulas as follow to complete the

56 00:02:29,819 --> 00:02:36,060 table of projection in the range C6

57 00:02:31,860 --> 00:02:38,580 through I10 so here is C6 and then a

58 00:02:36,060 --> 00:02:41,280 result this whole thing it is saying in

59 00:02:38,580 --> 00:02:43,140 cell C7 create a formula without using a

60 00:02:41,280 --> 00:02:45,959 function that multiplies the sale flow

61 00:02:43,140 --> 00:02:49,080 section for the first year sales C6 so

62 00:02:45,959 --> 00:02:51,599 click on Cell C7 and then click on this

63 00:02:49,080 --> 00:02:53,519 status bar and then so to enter any

64 00:02:51,599 --> 00:02:56,040 formula we shall begin with equals to

65 00:02:53,519 --> 00:02:58,260 sign and then it is saying without using

66 00:02:56,040 --> 00:03:00,300 any function so we need to enter the

67 00:02:58,260 --> 00:03:02,340 cell number directly so it is saying

68 00:03:00,300 --> 00:03:07,319 multiplies the cell projection for first

69 00:03:02,340 --> 00:03:10,379 year C6 and then multiply symbol by C5

70 00:03:07,319 --> 00:03:13,739 and then it is saying and adds the cell

71 00:03:10,379 --> 00:03:17,519 projection for the first year clc6

72 00:03:13,739 --> 00:03:19,440 so we need to multiply C6 by C5 and then

73 00:03:17,519 --> 00:03:21,300 wrap it in parenthesis and then this

74 00:03:19,440 --> 00:03:26,099 will give a result and then that result

75 00:03:21,300 --> 00:03:28,200 will get added to cell C6 to the result

76 00:03:26,099 --> 00:03:32,640 um and to determine the first first

77 00:03:28,200 --> 00:03:36,000 estimate for 2022 and then hit enter

78 00:03:32,640 --> 00:03:39,180 okay and then step forward is saying use

79 00:03:36,000 --> 00:03:41,940 an absolute reference to row five in and

80 00:03:39,180 --> 00:03:45,900 the reference to the cell C5

81 00:03:41,940 --> 00:03:49,440 okay so in this formula for C5

82 00:03:45,900 --> 00:03:51,299 the row files will be absolute so if we

83 00:03:49,440 --> 00:03:54,360 drag it and then copy and paste this

84 00:03:51,299 --> 00:03:56,940 formula somewhere so C6 and C6 will

85 00:03:54,360 --> 00:03:59,159 change according to its reference but C5

86 00:03:56,940 --> 00:04:03,900 will be constant so this row number will

87 00:03:59,159 --> 00:04:06,120 be constant so what am I saying is

88 00:04:03,900 --> 00:04:09,299 let's see it is saying copy the formula

89 00:04:06,120 --> 00:04:11,819 from cell C7 to the range C8 through C10

90 00:04:09,299 --> 00:04:14,159 so if we copy this so to copy this also

91 00:04:11,819 --> 00:04:16,380 you need to go to the corner and then

92 00:04:14,159 --> 00:04:17,519 plus sign will appear and then drag it

93 00:04:16,380 --> 00:04:20,459 until

94 00:04:17,519 --> 00:04:23,639 C 10 so in bottom C10

95 00:04:20,459 --> 00:04:27,780 okay so if we see the formula so C6 it

96 00:04:23,639 --> 00:04:31,280 sends to C7 C8 C9 but this C5 is

97 00:04:27,780 --> 00:04:34,020 constant this 5 is constant and if you

98 00:04:31,280 --> 00:04:37,020 copy this formula to this row this c

99 00:04:34,020 --> 00:04:38,120 will be changed to D but this 5 will be

100 00:04:37,020 --> 00:04:40,380 constant

101 00:04:38,120 --> 00:04:42,419 so let's see

102 00:04:40,380 --> 00:04:46,800 it is saying copy the formula from the

103 00:04:42,419 --> 00:04:49,259 range C7 through C10 so oops did escape

104 00:04:46,800 --> 00:04:53,759 and then select C7 and the Mobile Shift

105 00:04:49,259 --> 00:04:58,020 click C10 C7 old shift key and then

106 00:04:53,759 --> 00:05:02,759 press C10 okay and then it is saying

107 00:04:58,020 --> 00:05:06,419 use this C8 through C10 to the range c d

108 00:05:02,759 --> 00:05:09,120 D7 through I10 so again here is D7 and

109 00:05:06,419 --> 00:05:11,340 the nearest I10 so go to the corner and

110 00:05:09,120 --> 00:05:13,740 then drag it until here

111 00:05:11,340 --> 00:05:17,880 okay now if you see the formula so this

112 00:05:13,740 --> 00:05:21,419 in this case uh C7 here is C6 series C7

113 00:05:17,880 --> 00:05:25,139 C8 C9 body C5 is constant this 5 is

114 00:05:21,419 --> 00:05:28,919 constant but here it should be D9 and

115 00:05:25,139 --> 00:05:32,100 then D5 and then again D9

116 00:05:28,919 --> 00:05:35,220 so look this row number is constant so

117 00:05:32,100 --> 00:05:37,320 again if you look at above anywhere the

118 00:05:35,220 --> 00:05:39,900 row number is always constant because we

119 00:05:37,320 --> 00:05:41,639 put dollar symbol of it this means this

120 00:05:39,900 --> 00:05:43,020 is absolute it will not change no matter

121 00:05:41,639 --> 00:05:47,400 how

122 00:05:43,020 --> 00:05:48,900 okay so let's see in step five it is

123 00:05:47,400 --> 00:05:51,600 saying switch to the cost analysis

124 00:05:48,900 --> 00:05:53,699 worksheet so click here which analyzes

125 00:05:51,600 --> 00:05:56,100 the vendor and saving cost for you need

126 00:05:53,699 --> 00:05:58,380 to select a vendor and C for two c for

127 00:05:56,100 --> 00:06:00,180 the new product in cell B10 find the

128 00:05:58,380 --> 00:06:02,460 average vendor cost for unit by creating

129 00:06:00,180 --> 00:06:04,199 a formula using the average function to

130 00:06:02,460 --> 00:06:07,919 calculate the average of the houses in

131 00:06:04,199 --> 00:06:10,620 the range V5 through B8 okay so in cell

132 00:06:07,919 --> 00:06:12,240 B10 we need to calculate average so

133 00:06:10,620 --> 00:06:14,039 again to enter any formula I'm going to

134 00:06:12,240 --> 00:06:17,340 start with equals to sign and then type

135 00:06:14,039 --> 00:06:20,039 average so and you can double click here

136 00:06:17,340 --> 00:06:22,319 and then it accepts range of number or

137 00:06:20,039 --> 00:06:26,699 you can directly enter the range so you

138 00:06:22,319 --> 00:06:30,539 can it accepts either four comma 5 comma

139 00:06:26,699 --> 00:06:31,919 six uh five any number and then so this

140 00:06:30,539 --> 00:06:34,199 will calculate the average by adding

141 00:06:31,919 --> 00:06:36,720 this and dividing by three or you can

142 00:06:34,199 --> 00:06:38,580 also pass the range so in this case we

143 00:06:36,720 --> 00:06:42,900 are given range

144 00:06:38,580 --> 00:06:45,900 so enter bf5 through B8 so now it will

145 00:06:42,900 --> 00:06:48,060 take whole this number 47.48 it will add

146 00:06:45,900 --> 00:06:50,460 this number and then divide by 5 and

147 00:06:48,060 --> 00:06:51,600 then give us the result so you can hit

148 00:06:50,460 --> 00:06:55,319 enter

149 00:06:51,600 --> 00:06:57,840 okay and then it is saying uh used copy

150 00:06:55,319 --> 00:07:01,919 this formula to cell E10 and find okay

151 00:06:57,840 --> 00:07:04,620 so just Ctrl C and then go to cell E 10

152 00:07:01,919 --> 00:07:06,900 and then Ctrl d all right and you can

153 00:07:04,620 --> 00:07:10,380 hit escape to remove this dot line

154 00:07:06,900 --> 00:07:13,020 okay in cell steps or in steps six it is

155 00:07:10,380 --> 00:07:15,300 saying in cell b11 find the highest

156 00:07:13,020 --> 00:07:17,520 vendor cost per unit by creating a

157 00:07:15,300 --> 00:07:20,220 formula using the max function to

158 00:07:17,520 --> 00:07:23,039 identify the maximum number in range B5

159 00:07:20,220 --> 00:07:26,400 through B8 okay

160 00:07:23,039 --> 00:07:28,319 so in b11 we need to use max function

161 00:07:26,400 --> 00:07:30,180 again to enter any function or to enter

162 00:07:28,319 --> 00:07:33,539 any formula we need to start with equals

163 00:07:30,180 --> 00:07:35,940 to sign and then Max and parenthesis and

164 00:07:33,539 --> 00:07:38,099 then again it accepts either a series of

165 00:07:35,940 --> 00:07:41,460 numbers separated by comma or it accepts

166 00:07:38,099 --> 00:07:45,599 range of number so we have range

167 00:07:41,460 --> 00:07:48,060 so B 5 through B8 and then close

168 00:07:45,599 --> 00:07:50,099 parenthesis and then enter

169 00:07:48,060 --> 00:07:54,000 and then it is saying copy the formula

170 00:07:50,099 --> 00:07:56,880 to cell 11 and then copy and then go to

171 00:07:54,000 --> 00:07:59,099 11 and then paste Ctrl C control b or

172 00:07:56,880 --> 00:08:00,780 you can just right click and then paste

173 00:07:59,099 --> 00:08:03,419 formulas

174 00:08:00,780 --> 00:08:05,520 okay and then step 7 it is saying in

175 00:08:03,419 --> 00:08:07,440 Excel B12

176 00:08:05,520 --> 00:08:10,560 B12

177 00:08:07,440 --> 00:08:12,599 it is saying use mean function so equals

178 00:08:10,560 --> 00:08:14,940 to sign mean function again this accepts

179 00:08:12,599 --> 00:08:17,280 either number separated by commas or the

180 00:08:14,940 --> 00:08:20,699 range so we are given range we'll use

181 00:08:17,280 --> 00:08:23,879 range B5 through B8 and then close

182 00:08:20,699 --> 00:08:26,580 parenthesis and then copy this and then

183 00:08:23,879 --> 00:08:28,319 paste it to cell E12

184 00:08:26,580 --> 00:08:31,379 and then okay

185 00:08:28,319 --> 00:08:33,479 now in cell C 14 it is saying identify

186 00:08:31,379 --> 00:08:36,000 the vendor with the lowest cost per unit

187 00:08:33,479 --> 00:08:39,719 by creating a formula using the vlookup

188 00:08:36,000 --> 00:08:42,360 function so in cell oops hit Escape key

189 00:08:39,719 --> 00:08:44,339 to remove this and then 14 it is saying

190 00:08:42,360 --> 00:08:46,920 vendor function or look up vlookup

191 00:08:44,339 --> 00:08:48,660 function so equals to sign and then we

192 00:08:46,920 --> 00:08:51,660 look up and then you can double click

193 00:08:48,660 --> 00:08:54,839 and then it accepts lookup lookup value

194 00:08:51,660 --> 00:08:58,260 so lookup value is B12

195 00:08:54,839 --> 00:09:03,180 and then the range is so table array is

196 00:08:58,260 --> 00:09:05,519 our range so range is B5 through C8 and

197 00:09:03,180 --> 00:09:08,580 then let's see return the number of

198 00:09:05,519 --> 00:09:09,980 enter column two so we have given column

199 00:09:08,580 --> 00:09:13,380 2

200 00:09:09,980 --> 00:09:16,980 and then it is it is saying specify an

201 00:09:13,380 --> 00:09:19,620 exact match so again hit comma and then

202 00:09:16,980 --> 00:09:22,800 true is approximate match false is exact

203 00:09:19,620 --> 00:09:25,140 match so double click on false and then

204 00:09:22,800 --> 00:09:29,040 close parenthesis and then enter

205 00:09:25,140 --> 00:09:32,399 okay so laser biomedical now it is

206 00:09:29,040 --> 00:09:35,160 saying copy this to be F14 so just Ctrl

207 00:09:32,399 --> 00:09:38,940 V Ctrl C and the control B

208 00:09:35,160 --> 00:09:40,500 all right and then is in sales c19 so

209 00:09:38,940 --> 00:09:43,800 before that it is saying switch to the

210 00:09:40,500 --> 00:09:46,019 project profit projection worksheet

211 00:09:43,800 --> 00:09:48,300 so let's see here is profit projects and

212 00:09:46,019 --> 00:09:50,220 worksheet and then it is saying which

213 00:09:48,300 --> 00:09:52,980 sets I schedule for developing and

214 00:09:50,220 --> 00:09:55,440 launching a new product and projects EA

215 00:09:52,980 --> 00:09:58,440 it's

216 00:09:55,440 --> 00:10:01,260 which sets I schedule for developing and

217 00:09:58,440 --> 00:10:04,500 launching the new product and projects

218 00:10:01,260 --> 00:10:06,420 its profit for five years in sale I17

219 00:10:04,500 --> 00:10:10,680 use the 2D function to insert the

220 00:10:06,420 --> 00:10:12,540 current date so in cell i7 again to

221 00:10:10,680 --> 00:10:14,220 enter any function or any formula we

222 00:10:12,540 --> 00:10:16,980 need to start with equals to sign and

223 00:10:14,220 --> 00:10:18,899 then enter today and then function will

224 00:10:16,980 --> 00:10:20,760 always have open and close parenthesis

225 00:10:18,899 --> 00:10:23,820 and then hit enter

226 00:10:20,760 --> 00:10:26,399 okay so this is today's date and then in

227 00:10:23,820 --> 00:10:30,660 cell I9 it is going to create a formula

228 00:10:26,399 --> 00:10:32,100 that uses Network days function to

229 00:10:30,660 --> 00:10:35,399 calculate the number of working days

230 00:10:32,100 --> 00:10:38,700 between the dates in cell i7 and I8 lead

231 00:10:35,399 --> 00:10:43,100 the holidays argument blank okay so

232 00:10:38,700 --> 00:10:46,620 total means net and then working this

233 00:10:43,100 --> 00:10:50,220 suitable acid started so start day will

234 00:10:46,620 --> 00:10:52,920 be current date it is given here so it

235 00:10:50,220 --> 00:10:55,620 is I 7

236 00:10:52,920 --> 00:10:58,019 current date is i7 and then product

237 00:10:55,620 --> 00:11:00,779 launches so you can also click the cell

238 00:10:58,019 --> 00:11:03,300 energy lot medical Interiors here and

239 00:11:00,779 --> 00:11:05,040 then close parenthesis and then later so

240 00:11:03,300 --> 00:11:08,399 we will get negative result here because

241 00:11:05,040 --> 00:11:10,079 in this condition current date is after

242 00:11:08,399 --> 00:11:13,380 the product launch date which is

243 00:11:10,079 --> 00:11:15,660 impossible uh so uh current it is after

244 00:11:13,380 --> 00:11:18,600 the product launch date because same

245 00:11:15,660 --> 00:11:20,940 guess has written 2021 in here but here

246 00:11:18,600 --> 00:11:24,180 it is saying to use today function so

247 00:11:20,940 --> 00:11:27,060 today is uh after this date so it will

248 00:11:24,180 --> 00:11:28,440 give us negative value so don't worry

249 00:11:27,060 --> 00:11:31,920 about this

250 00:11:28,440 --> 00:11:34,800 okay so let's go to Step 11 it is saying

251 00:11:31,920 --> 00:11:38,040 use the value in the range C 14 through

252 00:11:34,800 --> 00:11:40,320 D14 to fill the range e 14 through i14

253 00:11:38,040 --> 00:11:41,519 with a series of income incremented

254 00:11:40,320 --> 00:11:45,060 percentage

255 00:11:41,519 --> 00:11:47,220 so select C 14 oops

256 00:11:45,060 --> 00:11:51,540 let's see c14

257 00:11:47,220 --> 00:11:54,360 and D14 and then go to the corner plus

258 00:11:51,540 --> 00:11:56,760 sign up here and extend it up to i14

259 00:11:54,360 --> 00:11:59,940 up here so it will automatically

260 00:11:56,760 --> 00:12:01,860 increase those percentages all right so

261 00:11:59,940 --> 00:12:04,820 step two already saying use the values

262 00:12:01,860 --> 00:12:08,220 in the range B15 through B16 so again

263 00:12:04,820 --> 00:12:10,140 select these and then extend up to b19

264 00:12:08,220 --> 00:12:12,899 so go to the corner plus sign will

265 00:12:10,140 --> 00:12:16,140 appear and extend up to P 19 and it will

266 00:12:12,899 --> 00:12:18,060 automatically fill those years okay and

267 00:12:16,140 --> 00:12:21,000 in Step 13 it is saying estimate the

268 00:12:18,060 --> 00:12:23,579 gross profit for 2021 as follows in

269 00:12:21,000 --> 00:12:26,160 sales C15 create a formula without using

270 00:12:23,579 --> 00:12:29,160 a function that subtracts the vendor

271 00:12:26,160 --> 00:12:33,180 cost and the shipping cost from the sale

272 00:12:29,160 --> 00:12:36,300 price okay so in cell 50 15

273 00:12:33,180 --> 00:12:39,540 it is saying that subtracts the vendor

274 00:12:36,300 --> 00:12:42,420 cost and shipping cost from sales from

275 00:12:39,540 --> 00:12:44,700 the sales price so when it says from the

276 00:12:42,420 --> 00:12:47,820 sale price we need to enter C8 at first

277 00:12:44,700 --> 00:12:51,000 because we need to subtract those C7 and

278 00:12:47,820 --> 00:12:53,160 C9 from not to the sales price it is

279 00:12:51,000 --> 00:12:56,519 saying from the sales price so when it

280 00:12:53,160 --> 00:13:02,160 says from it will be at ahead

281 00:12:56,519 --> 00:13:07,440 okay and C7 minus C9 so it will subtract

282 00:13:02,160 --> 00:13:10,139 C7 and C9 from C8 or you can do C8 and

283 00:13:07,440 --> 00:13:12,959 then subtract and then parenthesis and

284 00:13:10,139 --> 00:13:14,279 then plus and then this so this is same

285 00:13:12,959 --> 00:13:17,940 thing

286 00:13:14,279 --> 00:13:21,180 so it will subtract this value from C8

287 00:13:17,940 --> 00:13:22,500 so C8 minus this the total value of C7

288 00:13:21,180 --> 00:13:24,899 and C9

289 00:13:22,500 --> 00:13:26,820 okay and then and then multiply the

290 00:13:24,899 --> 00:13:32,220 result by the projected number of unit

291 00:13:26,820 --> 00:13:35,220 files for sale in 2021 CLC 10 so let's

292 00:13:32,220 --> 00:13:36,779 again wrap this result and then this

293 00:13:35,220 --> 00:13:40,320 result will be

294 00:13:36,779 --> 00:13:42,120 multiplied to cell C 10. so again if you

295 00:13:40,320 --> 00:13:44,160 are confused it is saying create a

296 00:13:42,120 --> 00:13:47,279 formula using a function that subtracts

297 00:13:44,160 --> 00:13:49,860 the vendor cost this and this from this

298 00:13:47,279 --> 00:13:53,760 it is saying subtract this and this from

299 00:13:49,860 --> 00:13:58,440 this so it will be C8 minus C7 minus C9

300 00:13:53,760 --> 00:14:01,440 or C8 minus the addition of C7 and C9

301 00:13:58,440 --> 00:14:03,360 that's the same thing and then this will

302 00:14:01,440 --> 00:14:07,380 give us one result and then that result

303 00:14:03,360 --> 00:14:09,839 will be multiplied to sell City so hit

304 00:14:07,380 --> 00:14:12,480 enter all right and then it is saying

305 00:14:09,839 --> 00:14:14,700 use absolute reference to each cell in

306 00:14:12,480 --> 00:14:16,740 the formula so in every cell we need to

307 00:14:14,700 --> 00:14:18,000 enter absolute reference so just click

308 00:14:16,740 --> 00:14:20,279 here and then

309 00:14:18,000 --> 00:14:23,160 wrap it with dollar sign or you can

310 00:14:20,279 --> 00:14:27,480 enter F4 if you are using Windows

311 00:14:23,160 --> 00:14:30,120 and then here then F4 and then again F4

312 00:14:27,480 --> 00:14:31,139 all right hand and enter so same same

313 00:14:30,120 --> 00:14:33,240 value

314 00:14:31,139 --> 00:14:38,940 okay now it is saying copy the formula

315 00:14:33,240 --> 00:14:41,760 from CLC 15 to range D15 I15 okay

316 00:14:38,940 --> 00:14:43,560 so here is C15 again go to the kernel

317 00:14:41,760 --> 00:14:47,940 plus sign will appear and then drag it

318 00:14:43,560 --> 00:14:49,740 until D15 and then up to I15

319 00:14:47,940 --> 00:14:52,380 okay

320 00:14:49,740 --> 00:14:56,279 now step 14 recent complete the growth

321 00:14:52,380 --> 00:14:59,940 estimate for the years 2022 2025 in cell

322 00:14:56,279 --> 00:15:03,899 C15 copy the formula that adds 1 to the

323 00:14:59,940 --> 00:15:05,699 growth rate CLC 14 so in cell c16 again

324 00:15:03,899 --> 00:15:07,519 already start with equals to sign and

325 00:15:05,699 --> 00:15:11,220 then it is saying add for

326 00:15:07,519 --> 00:15:13,860 one two CLC 14 all right

327 00:15:11,220 --> 00:15:16,380 and multiply the result so this will

328 00:15:13,860 --> 00:15:18,899 give one result so I did see it will be

329 00:15:16,380 --> 00:15:22,620 it's only one so this will give one

330 00:15:18,899 --> 00:15:25,980 result so this result will be multiplied

331 00:15:22,620 --> 00:15:30,300 to sell C15 so it is saying and multiply

332 00:15:25,980 --> 00:15:34,860 the result by estimated profit from 2021

333 00:15:30,300 --> 00:15:37,440 all right so this is C15 and then enter

334 00:15:34,860 --> 00:15:42,000 and it is saying use an absolute row

335 00:15:37,440 --> 00:15:44,399 reference to cell c14 okay so for c14 we

336 00:15:42,000 --> 00:15:47,220 need to use absolute row reference so

337 00:15:44,399 --> 00:15:50,220 only the row will be absolute so c means

338 00:15:47,220 --> 00:15:53,220 this c means this is column but 14 is

339 00:15:50,220 --> 00:15:56,279 rho so we need to add dollar symbol

340 00:15:53,220 --> 00:15:59,100 ahead of 14. so this will so this way if

341 00:15:56,279 --> 00:16:01,320 we copy this formula to it any place she

342 00:15:59,100 --> 00:16:03,480 will get chance see 15 will get changed

343 00:16:01,320 --> 00:16:04,800 but this 14 this row number will never

344 00:16:03,480 --> 00:16:07,800 change

345 00:16:04,800 --> 00:16:10,920 okay now hit enter and then it is then

346 00:16:07,800 --> 00:16:15,600 copy the formula from CLC 16 to range

347 00:16:10,920 --> 00:16:18,959 c17 c19 okay so oops you can

348 00:16:15,600 --> 00:16:20,519 cancel this so click c16 and then go to

349 00:16:18,959 --> 00:16:23,519 the corner plus sign up here and then

350 00:16:20,519 --> 00:16:29,120 drag it until C 19 let's see it is

351 00:16:23,519 --> 00:16:29,120 saying c16 to the range scene 19.

352 00:16:30,180 --> 00:16:35,880 and then it is saying copy the formulas

353 00:16:32,579 --> 00:16:38,399 from the range c16 through c19 to the

354 00:16:35,880 --> 00:16:40,500 range D16 through d19 so this is already

355 00:16:38,399 --> 00:16:42,120 selected we need to just go to the

356 00:16:40,500 --> 00:16:43,220 corner plus sign in library and then it

357 00:16:42,120 --> 00:16:47,220 is saying

358 00:16:43,220 --> 00:16:49,920 D16 through i19 all the way to here and

359 00:16:47,220 --> 00:16:52,860 then release okay and then it will

360 00:16:49,920 --> 00:16:56,220 automatically fill the data so it is

361 00:16:52,860 --> 00:16:59,339 saying delayed row delete row 21 since

362 00:16:56,220 --> 00:17:01,680 the worksheet is now complete so row 21

363 00:16:59,339 --> 00:17:04,919 click click on this 21 and then right

364 00:17:01,680 --> 00:17:07,679 click and then click until it all right

365 00:17:04,919 --> 00:17:09,660 so it is saying your workbook looks uh

366 00:17:07,679 --> 00:17:12,600 should look like the final figure on the

367 00:17:09,660 --> 00:17:15,540 following Pages the value inclusive sale

368 00:17:12,600 --> 00:17:17,400 i7 and I9 of I have been international

369 00:17:15,540 --> 00:17:20,100 keyboard as they will never be constant

370 00:17:17,400 --> 00:17:21,959 so okay so this and this value will not

371 00:17:20,100 --> 00:17:26,400 be same as a feature

372 00:17:21,959 --> 00:17:31,320 and then let's see how result okay

373 00:17:26,400 --> 00:17:34,380 so here 10 000 Yep this is good and then

374 00:17:31,320 --> 00:17:37,500 cost analyzes this this

375 00:17:34,380 --> 00:17:38,880 Yep this is also good and then the final

376 00:17:37,500 --> 00:17:41,700 worksheet

377 00:17:38,880 --> 00:17:44,280 profit projection so these two are

378 00:17:41,700 --> 00:17:46,020 blurred so this will never be same so

379 00:17:44,280 --> 00:17:48,000 this is okay

380 00:17:46,020 --> 00:17:51,179 because the current date is different

381 00:17:48,000 --> 00:17:53,820 and then here this must be same let's

382 00:17:51,179 --> 00:17:56,100 see yep all value are same and then you

383 00:17:53,820 --> 00:17:58,080 are also all values are same all right

384 00:17:56,100 --> 00:18:00,660 so if you feel any difficulties while

385 00:17:58,080 --> 00:18:04,280 doing it feel free to comment down below

386 00:18:00,660 --> 00:18:04,280 all right thank you for watching

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.

• Leningrad Oblast
•  » 

Cement and concrete products

Phone 8 (800) 250-45-75 8 (800) 250-45-75

Phone 8 (812) 595-35-30 8 (812) 595-35-30

Fax 8 (812) 595-35-38

Shopping other near Cement and concrete products