Question

Calculating the Ideal Spot To calculate where the ideal spot is in each round, start with the segment center in the table below and then adjust for the offset. These offsets represent the distance from the center of the segment to the ideal spot. The activity practices how to calculate the ldeal Spot using information in the Industry Conditions report. Looking at the table below for Round 1, the 'Low End' segment center hasa Performance (Pfmn) specification of 3 and a Size specification of 17 Now we look at the bottom of the table to see how much the ideal spot is offset from the center of the segment, and we see that the Low End ideal spot is offset by -0.8 for Pfmn and +0.8 for size Segment Center by Round Traditional Low End High End Performance Size Round Pfmn Size Pfmn Size Pfmn Size Pfmn Size Pfmn Size 5.0 15.0 2.5 17.5 7.5 12.5 8.0 17.0 3.0 12.0 5.7 14.3 3.0 17.0 8.4 11.6 9.0 16.3 3.7 11.0 6.4 13.6 3.5 16.5 9.3 10.7 10.0 15.6 4.4 10.0 7.1 12.9 4.0 16.0 10.2 9.8 11.0 14.9 5.1 9.0 Offset 0.0 0.00.8 +0.8+1.4 1.4 1.4 1.0 1.0 1.4 0 So, we can calculate that the Round 1 ideal spot for my product in the Low End segment is Center Offset Ideal Spot Pfmn: 3.0 17.0 0.8 2.2 Size +0.8 17.8 Use the segment centers in the table above to calculate the new ideal spots for the segments. Once you have successfully entered the correct ideal spots for Rounds 0 and 1 (the green cells), the rest of the table wi in automatically. If you have entered any answers incorrectly, a red line should appear in the cell.

capsim simulation
the first part is already been answered.
could you please Help me on the second part the last two photos.

Answer 1

You will need the Segment Analysis reports (pages 5 - 9) of The Capstone Courier for Round 0 and the Industry Conditions Report. At the top of each Segment Analysis page you will find a box called Statistics. On Form 2, copy the Total Industry Unit Demand number for each segment into the Demand cell for Round 0. Next, copy the Next Year’s Growth Rate, which is also in the Statistics box, into the Rate cell.

The table mentioned above looks like this:

Total Industry Unit Demand	10,713
Actual Industry Unit Sales	9,746
Segment % of Total Industry	25.4%
Next Year's Growth Rate	5.4%

The Round 0 demand is 10,713 and the growth rate is 5.4%.

Multiply the Round 0 demand by the growth rate and add the result to the Round 0 demand. This will give you a close approximation of Round 1 demand. Copy this number into the Demand cell for Round 1.

Thus, the demand for Round 1 becomes: 10,713(1+0.054) = 11,291.502

The second part of the question asks us to predict the demand for the next year for Rounds 2-8. We have been told that the Round 1 growth rate will continue into the future unchanged - this means that for all Rounds, we can assume a growth rate of 5.4%.

Thus for Round 2, demand is = (Round 1 demand)x(1.054) = 11,291.502 x 1.054 = 11,901.243
Round 3 Demand = 11,901.243 x 1.054 = 12,543.910
Round 4 Demand = 12,543.910 x 1.054 = 13,221.281
Round 5 Demand = 13,211.281 x 1.054 = 13,935.23

Similarly, we can calculate for the next rounds. The process becomes easier if we solve on an Excel sheet and assign the formula to cells instead of calculating individually.

Now, for low end/worst case analysis, growth rate halves and becomes (0.5x5.4) = 2.7%
And for high end/best case analysis, growth rate becomes 1.5 times 5.4% = 8.1%

Low End Round 1 Demand = 10,713 x 1.027 = 11,002.251
Low End Round 2 Demand = 11,002.251 x 1.027 = 11,299.312
Low End Round 3 Demand = 11,299.312 x 1.027 = 11,604.393 and so on.

High End Round 1 Demand = 10,713 x 1.081 = 11,580.753
High End Round 2 Demand = 11,580.753 x 1.081 = 12,518.794
High End Round 3 Demand = 12,518.794 x 1.081 = 13,532.816 and so on.