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.2 million, and each rocket launching costs $77.6 million. The rocket launch facility can support a launch rate of 3 per week. Launches begin in Week 1 of 2009.

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.

(b) [20] 

GTI's plan is 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.98 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.

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 17 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	31	34	37	42	51	55	63	72	79

(a) [20] 

Before it can open for business, each location has to hire a store manager, ten 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.

(b) [20] 

If a part-timer is hired in a particular quarter, there is a 9% 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. 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.

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.