1.1 [40] 

Geodesic Telecommunications, Inc., plans to build a global satellite network to provide wireless communications service to the world. To accomplish this, they plan to launch 480 communications satellites in low Earth orbit. Satellites are launched in groups of 8 by a single rocket. Each satellite costs $1.3 million, and each rocket launching costs $77.4 million. The rocket launch facility can support a launch rate of 3 per week. Launches begin in Week 1 of 2011.

By carrying out the following steps, create a spreadsheet model to be used to compute GTI's cash needs. In all calculations, columns are to represent weeks, as advised in Structuring Excel Models.

(a) [20] 

Compute the cumulative total cost of launch operations, week by week, showing the cumulative dollar volume of launched assets plus the cumulative total cost of launching those assets on a weekly basis beginning in Week 1 and ending in Week 20. Express your result in millions of dollars. Your result should be a single 1x20 range.

(b) [20] 

GTI plans to provide service to the surface of the Earth sector by sector. It takes 10 satellites to cover a sector. Until those 10 satellites are functioning, the revenue for the sector they cover is 0. On average, the revenue generated by a sector is expected to be $0.94 million per week, independent of where that sector is in the world. Compute GTI's expected cumulative revenue, week by week, for weeks 1 through 20. Express your result in millions of dollars. Your result should be a single 1x20 range.

1.2 [40] 

Toddler's Togs, Inc., a retailer of small children's apparel, is expanding. The facilities manager has produced a plan that shows, quarter by quarter for three years, the maximum number of locations the warehouse and distribution functions will be able to support, shown in the table below. TTI now operates 18 stores. In the table, the notation "Y2Q2," for example, means "Year 2, Quarter 2."

	Y1Q1	Y1Q2	Y1Q3	Y1Q4	Y2Q1	Y2Q2	Y2Q3	Y2Q4	Y3Q1	Y3Q2	Y3Q3	Y3Q4
Stores	19	20	21	30	33	36	42	51	53	63	71	79

(a) [20] 

Before it can open for business, each location has to hire a store manager, nine part-time sales associates and three full-time sales associates. Compute the hiring schedule, by employee category, that will be required to support the new stores. Present your result in the order, from top to bottom, Store Managers, Full-timers and Part-timers. Your result should be a single 3x12 range.

(b) [20] 

If a part-timer is hired in a particular quarter, there is a 10% chance that he or she will have to be replaced in the quarter immediately following their hiring. People who make it through that first quarter following their hiring then stay on indefinitely. Compute the number of hires of part-timers required in each quarter to replace those who do leave in the first quarter following their hiring. Consider only the hiring you plan to execute to support the new stores. You may assume that there is no other turnover, beyond this first-quarter-following-hire phenomenon, but be certain that your model takes into account all such first-quarter-following-hire turnover, and only that turnover. Construct your model so that the replacement rate is a parameter. Don't worry about rounding to the nearest whole person; a result in terms of fractional people is OK. Your result should be a single 1x12 range.

1.3 [20] 

Install the special tools for this course. After the installation, select a cell to hold the answer for this problem, and choose the command Test Installation from the SMM menu. If you've installed the command correctly, the command installs a note saying that you succeeded. If not, it advises you of that too. Full credit for this problem is possible only if you correctly install the tools and demonstrate your success by submitting the note that the installation tester creates. Your result should be a single cell.