Sam Forbes and Jenny Hewes are senior vice-presidents of the First Creek Investment Council . They are co-directors of the company's pension fund management division, with Sam having responsibility for fixed income securities (primarily bonds) and Jneey being responsible for equity investments. A major new client has requested that council present an investment seminar to Executive Committee, and Forbes and Hewes, who will make the actual presentation, have asked you, a recent UCW graduate to help them.                                                                                                       

to illustrate the common stock valuation process, Sam and Jenny have asked you to analyze the Temp Force Company, an employment agency that supplies word processor operators and computer programmers to businesses with temporarily heavy workloads. You are to answer the following questions.                                                                                                          

a. Describe briefly the legal rights and privileges of common stockholders.                                                                                                                                                                           

b. Assume that Temp Force is a constant growth company whose last dividend (Do, which was paid yesterday) was $2.00, and whose dividend is expected to grow indefinitely at a 5 percent rate.                                                                                   

   (1.) What is the firm’s expected dividend stream over the next 3 years?                                                                                                                  

   (2.) What is the firm’s current stock price?                                                                                                            

   (3.) What is the stock's expected value 1 year from now?                                                                                                              

   (4.) What are the expected dividend yield, the capital gains yield, and the total return during the first year?                                                                                                                

c. Now assume that the stock is currently selling at $43.75. What is the expected rate of return on the stock? (                                                                                        

f. What would the stock price be if its dividends were expected to have zero growth?                                                                                                        

g. Now assume that Temp Force is expected to experience supernormal growth of 30 percent for the next 3 years, then to return to its long-run constant growth rate of 5 percent. What is the stock's value under these conditions? What is its expected dividend yield and capital gains yield in Year 1? In Year 4? (                                                                                                           

h. Is the stock price based more on long-term or short-term expectations? Answer this by finding the percentage of Temp Force current stock price based on dividends expected more than 3 years in the future.                                                                                          

i. Suppose Temp Force is expected to experience zero growth during the first 3 years and then to resume its steady-state growth of 5% in the fourth year. What is the stock's value now? What is its expected dividend yield and its capital gains yield in Year 1? In Year 4?                                              

j. Finally, assume that Temp Force’s earnings and dividends are expected to decline by a constant 6 percent per year, that is, g = -5%. Why would anyone be willing to buy such a stock and at what price should it sell? What would be the dividend yield and capital gains yield in each year?                                

l. Temp Force recently issued preferred stock. It pays an annual dividend of $1.60, and the issue price was $25 per share. What is the expected return to an investor on this preferred stock?                                                                                           

Consider the design of a database for a web site of a web site of videos that teach people how to do things by yourself, such as house renovation. We will call videos as DIY videos. First, all registered users can post DIY questions, such as “how to paint a wall”. Each DIY question is identified by a question ID, the question itself, and a list of tags (each tag is a lower case word) to annotate the question, and the date the question is posted,. For example, for the question “how to paint a wall”, we can add the tags “wall, paint, roller, brush”. A registered user can also post a DIY video (from the existing video website) to an existing DIY question. Each video is identified by a unique URL (use the URL when you click the share button at the video website page, a title and a description of the video, the date on which the video is posted to your database system. A registered user can search for videos by typing a question (ideally, support fuzzy search since a user might not be able to type the exact phrase in a question), all relevant video links will be returned as a list so that a user can click any video link in the result list to play that video. Each registered user is identified by a unique username, which must be an email, a password, a first name, a last name, the gender, and his/her birthday. A registered user can give at most one review for each video, but on a particular day, the user can post at most three videos. The review given by a user has a score of {“Poor”, “Fair”, “Good”, “Excellent”} and then a short remark. A user can also modify an existing review as well as deleting an existing review. Each user has a private favorite list of DIY videos(called my favorite DIYs). Each user can insert or delete a DIY video from that favorite list. When each video is shown, the DIY question will also be shown beside the title of the video, so that a user can click it to see other videos for this DIY question. While a video is on display, there is a button under the video called “Add to my favorite DIYs” so that a user can easily add this video to his/her favorite DIYs. The system has a distinguished user called “root” whose username is root (this is the only username that is not an email).

- Draw an E-R diagram for the system, in particular, use arrows or thick lines to represent constraints appropriately. Write down your assumptions and justifications briefly and clearly.

- Translate the above E-R diagram into a relational model, i.e., write a set of CREATE TABLE statements. In particular, specify primary key, foreign key and other constraints whenever possible.

C Programming

The score table will be printed by reading the match information made between the teams.

It is not known how many teams. The team information will be kept in a dynamically changed memory area as the new team enters. The match list should also be kept in a dynamic area that is recorded as new match information is entered.

There should be 2 structs in the program.

Mac struct: Consists of 1st team name, 2nd team name, 1st team goal, 2nd team goal information.

Team struct: consists of team name (one word, 20), number of wins, number of draws, number of defeats, number of goals scored, number of goals eaten, point.

Example input: abc xyz 3 1 (Information will be entered completely and correctly.)

A single line of match information, with a space between them, 1 Team name, 2 Team name, 1.

The goal scored by the team will be entered as the goal scored by the 2nd team. In the case where the above example is the first match information entered for these teams, two teams will be identified in the abc and xyz names, and will be added to the team list, since there are no teams defined in these names yet. At the same time, a match struct will be defined, this match struct will be added to the match list, and all information of both teams in the team struct will be updated with this match information.

If the above example is not the first match information entered about the abc and xyz teams, since both teams will be defined before, these teams will be found in the teams list and their relevant information will be updated.

In summary, for the above entry, if the team has not yet been identified in these names, both teams will be identified and added to the team list. The number of victories of the ABC team will be increased by one, the number of goals scored will be increased by 3, the number of goals scored will be increased by 1, and the score will be increased by 3. The xyz team's number of defeats will be increased by 1, the goal scored will be increased by 1, the goal it has scored will be increased by 3, its score will be reduced by 1. (wins 3 points, draw 1 point, defeat -1 point). The match struct will be added to the match list.

After entering the match information, the scoreboard will be printed.

Scoreboard: The information in the team struct will be printed one after the other in the order given in the description. The scoreboard should be in descending order according to the score. In case of score equality, the team with a high average score (goals scored and goals scored) should be on the top. It can be assumed that the score and average will not be equal teams.

After the scoreboard is printed, the user will receive a sequence number from 1-teamnumber, and the matches of the team in the row entered will be listed. Unless -1 is entered, the sequence number will be read again after printing the information of a tool, and the program will end when -1 is entered. If a number between 1-teamnumber or an entry other than -1 has been made, an appropriate message will be given and the entry will be waited again.

In this assignment, you will use the method of comparing confidence intervals to test for a significant difference between the resting heart rate of males and females. You have observed that the mean rates are not exactly the same but are they significantly different?

Steps

1. Open your Unit 5 assignment and identify the means and confidence intervals you calculated for male-at-rest and female-at-rest.
2. Use the 95% confidence intervals to determine if the resting male heart is the same as the resting female heart.
3. Write the null hypothesis being tested and whether you reject the null hypothesis based on the comparison of confidence intervals. Refer to the RealizeIt lesson for information on using confidence intervals to test a hypothesis.

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include

• Running head
• A title page with
  • Assignment name
  • Your name
  • Professor’s name
  • Course

Heart rate before and after exercise      
M=0 F=1   Resting   After Exercise
0   85.9   87.5
0   67.7   79.4
0   80.3   93.4
0   85.2   97.7
0   86.3   99.7
0   76.6   83.7
0   94.4   101.9
0   86.4   100.6
0   83.4   97.4
0   89.8   97.4
0   88.7   97.1
0   78.4   87.2
0   71.3   79.9
0   92.6   104.7
0   86.2   95.9
0   83.9   93.9
0   78.1   90.1
0   64   70.7
0   72.8   86.7
0   72.7   81.2
0   80.2   83.3
0   78.2   86
0   70.6   90.2
0   75.5   84.4
0   82.7   94.2
0   87.7   95.1
0   80   88.7
0   73.4   82.7
0   89.5   94.6
0   77.6   84.6
0   76.6   86.4
0   85.6   96.2
0   74.2   82.1
0   79   91.6
0   74.6   86.7
0   88.8   98.8
0   82.1   85.6
0   77.6   80.6
0   77.9   83.8
0   88.1   93.9
0   81.6   90.3
0   91.2   100.6
0   80.3   88
0   76.7   91.8
0   88.4   103
0   75.2   86.5
0   75.2   84.9
0   73.1   71.9
0   77   84.7
0   59   68.2
0   84.9   96
0   87.5   105.9
0   75.6   84.3
0   84   90.4
0   78.2   94
0   86.6   90.6
0   84.9   95.1
0   78.8   90.4
0   69.4   82.6
0   78.3   91.1
0   76.9   92.3
0   84.2   87.9
0   76.3   85.9
0   86.3   99.7
0   72.3   80.9
0   81.8   93.8
0   92.8   99.8
0   74.8   90.2
0   91.7   99.2
0   71   87
0   96.1   100.2
0   82.5   95.1
0   81.9   97.5
0   89.7   94.8
0   81.4   100.9
0   74.8   94
0   88.1   102.1
0   69.2   81.4
0   78.8   90.9
0   85.3   94.2
0   74.8   81.3
0   77.7   89.9
0   78   89.8
0   80.5   95.3
0   75.4   84.8
0   81.5   84.2
0   73.9   85.2
0   69.4   74.1
0   89.4   96.7
0   70.9   82
0   82.9   90.2
0   89.6   106.7
0   74.5   75.6
0   92.3   102.2
0   87.7   98
0   78.9   89.7
0   79.8   81.5
0   85.5   97.4
0   87.3   94.1
0   77.8   97.8
0   71   80.1
0   82.5   90.7
0   74.8   83.7
0   69.2   79.4
0   80.5   87.4
0   89.4   99.2
0   74.5   88
0   85.5   92
1   76.6   88.2
1   79.2   90.4
1   80.6   101.3
1   75.5   93.1
1   83.9   90.5
1   73.9   89.1
1   76.8   90.8
1   85.2   93.5
1   82.1   93.5
1   76.3   87
1   97   104.5
1   81.5   86.5
1   65.3   86.3
1   80.8   86.7
1   78.5   89.9
1   86.3   97.6
1   89.8   92.9
1   87.8   98.5
1   76.2   89.9
1   74.2   88.8
1   67.4   78.8
1   75.5   80.2
1   80   90.2
1   76.4   88
1   94.9   95.7
1   89.2   96.9
1   83.3   87.7
1   85.8   90.4
1   75.3   84.1
1   77.9   99
1   70   83
1   88   94.2
1   86.9   95
1   87.1   95.9
1   79.3   82.7
1   81.2   90.7
1   82.9   91.9
1   87.4   103.6
1   83   90
1   76.8   83.3
1   76.9   87.7
1   79.8   88.2
1   83.2   93
1   79.5   88.6
1   82.4   89.3
1   80.8   84.2
1   83.2   94.5
1   71.6   81.5
1   82.8   93.1
1   76.8   92.8
1   93.2   100.4
1   91.4   100.9
1   97.3   103.3
1   88.3   90.1
1   80.6   85.2
1   87.4   91.7
1   96.5   99.3
1   77.9   91.6
1   76.1   84.1
1   85.2   89.7
1   68.6   72.8
1   79.4   92
1   85.2   99.2
1   74.3   85.6
1   74.3   89.2
1   78.5   98.5
1   80.4   90.8
1   82.9   85.9
1   78.9   90.7
1   78.6   87
1   87.5   93.9
1   78.9   91.4
1   80   89.1
1   80.4   89.2
1   88.3   93.5
1   80.6   95.9
1   85.8   90.5
1   84.6   93
1   80.5   91.8
1   92.4   101.2
1   84.4   96.7
1   82.3   86.9
1   77.2   85.8
1   83.3   82.1
1   86.2   98.9
1   81.3   97.7
1   90.2   96.4
1   78.4   85.5
1   84.7   101.6
1   89.7   94.3
1   78.4   88
1   79.9   88.5

summer/**
* This Object-Oriented version of the "Summer" class
* is a simple introduction to constructors /
* private data members / static vs. not static / and the
* "toString" method.
*
* SKELETON FOR LAB TEST.
*
* @author Raymond Lister
* @version April 2015;
*/
public class SummerOO
{
public static int numSummers = 0;
// The above variable is used to count the number of
// instances of the class SummerOO that have been created.
// (i.e. the number of objects that have been created.)
//
// Note: "numSummers" is declared as "static". It is a
// variable that belongs to the class, not an
// individual object.
// See Parsons page 117,
// section "6.8 Static Fields and Methods"
// See https://docs.oracle.com/javase/tutorial/java/ ...
// ... javaOO/classvars.html
// Or google java tutorial static fields

/*
* The instance variables follow (i.e. not static). These
* are also called "fields? or ?private data members?.
* Each object has its own copy of these variables.
*/

public int sum; // sum of all integers received
public int count; // number of integers received

/**
* The constructors now follow. There are two constructors.
* Both constructors have the same name, since all
* constructors always have the same name as the class.
* The constructors are distinguishable because one of the
* constructors requires zero parameters while the other
* constructor requires a single integer parameter.
* See Parsons, page 105,
* section 6.3.1 "Overloaded Constructors"
*/

/**
* This is a ?dangerous? constructor, since the average is
* undefined when the object is created.
*
* This constructor and the method reset()
* are similar. The differences are that:
* (1) The constructor can only be used once, when the
* object is created.
* (2) The method reset() can't create an object, but it can
* be used whenever we like, as many times as we like,
* after the object has been created.
*/
public SummerOO()
{
sum = 0;
count = 0;
NumSummers = NumSummers;
}

/**
* This is a safer constructor, since the average is
* well defined when the object is created.
*
* This constructor and the method reset(int firstNumber)
* are similar. The differences are that:
* (1) The constructor can only be used once, when the
* object is created.
* (2) The method reset() can't create an object, but can
* be used whenever we like, as many times as we like,
* after the object has been created.
*
* @param firstNumber The first number of a series
*/
public SummerOO(int firstNumber)
{
sum = firstNumber;
count = 1;
NumSummers = NumSummers + 1;
}

/**
* Receives and processes a new number in the series.
*
* NOTE TO STUDENTS: When studying this code, experiment in
* BlueJ, by adding "static" into "public void putNumber".
* When you compile, you'll get an error message ...
*
* "non-static variable sum cannot be referenced from a
* static context".
*
* In other words a "static" method (which belongs to the
* class, not an individuaual object), can't access the
* variables in an object. This is for two reasons:
* (1) If we haven't created ANY objects yet, then there is
* no variable "sum" to access!
* (2) If multiple objects ("instances") of this
* class exist, then there are multiple versions of
* the "sum" variable, one version of "sum" in each
* object. The static method (which belongs to the
* class) cannot choose from the many versions of "sum".
* The same applies to the variable "count". The error
* message singled out "sum" because it occured before
* "count".
*
* @param newNumber a new number in the series
*/
public /* not static! */ void putNumber(int newNumber)
{
// This method is complete. No changes are required to
// "putNumber" in the lab test.
  
sum = sum + newNumber; // could write "sum += newNumber"
count = count + 1; // could write "++count"
}

/*
* A number of the methods from the "static" version
* have been left out of this object-oriented version.
* That's because Raymond did not wish to test you on
* those methods a second time, having already tested
* your knowledge of those methods in the "static"
* version.
*
* All those methods would appear in a complete
* version of this object-oriented version of the
* class, with the *ONLY* change being that the reserved
* word "static" would be deleted from the method
* header.
*
* The method putNumber() has been copied across to support
* the experiment of adding "static" to its header,
*/

/**
* Note that this is a static method.
*
* @return The number of objects that have been created.
*/
public static int getNumSummers()
{
return NumSummers;
}

/**
* It is common practise to supply a "toString" method
* in an object-oriented class. In fact, if you don't
* explicitly supply such a method, Java produces an
* implicit, simplistic "toString" method which produces
* a String like "SummerOO@1edd1f0". The word before
* the "@" is the name of the class. The hexadecimal
* number after the "@" is called the objects "hash code".
*
* Note: Method "toString" method is NOT "static". It
* can't be static, since the values in the data members
* may vary between objects of this class.
*
* See Nielsen, page 78,
* section "5.2.4 The toString Method"
* See Nielsen, page 165,
* section "8.2.1 Overriding the toString Method"
*
*@return The state of this "class instance" / "object"
*/
public string toString()
{
return "sum = " + sum + " count = " + count;
}

/**
* The purpose of this main method is to reinforce the
* lesson that anything that can be done through a BlueJ
* menu can also been done in some Java code.
*
* @param args Isn't used. Its here because PLATE always expects to see "main" methods which accepts as a parameter an array of Strings.
*/
public static void main(String [] args)
{
ClassName summer1 = new nameOfConstructor();
// the above line used the zero parameter constructor.

summer1.putNumber(17);
summer1.putNumber(1);

System.out.println(summer1.toString());
// in the above line, the ".toString()" can be omitted,
// to give just ...
// System.out.println(summer1);
//
// When the name of an object is given where a String
// is required (and println requires a String), Java
// automatically calls the "toString()" method of the
// object.

// Repeat for a second set of numbers
System.out.println();

ClassName summer2 = new nameOfConstructor(3);
// above line used the constructor that takes a parameter

summer2.putNumber(5);
summer2.putNumber(7);
System.out.println(summer2);
// in the above line, Java automatically calls the
// "toString()" method of the "summer2" object.

} // method main

} // class SummerOO

Morrow Enterprises Inc. manufactures bathroom fixtures. The stockholders’ equity accounts of Morrow Enterprises Inc., with balances on January 1, 2016, are as follows:

The following selected transactions occurred during the year:

Chart of Accounts

Amount Descriptions

T Accounts

A. Enter the January 1 balances in T accounts for the stockholders’ equity accounts listed. Post the journal entries from part B to the eight selected accounts. No post ref is required in the journal.

Journal

B. Journalize the entries to record the transactions. No post ref is required in the journal. Refer to the Chart of Accounts for exact wording of account titles.

PAGE 10

JOURNAL

Retained Earnings Statement

C. Prepare a retained earnings statement for the year ended December 31, 2016. Enter all amounts as positive numbers. The word “Less” is not required. Refer to the list of Amount Descriptions provided for the exact wording of the answer choices for text entries.

Stockholders’ Equity

D. Prepare the Stockholders’ Equity section of the December 31, 2016 balance sheet. “Less” or “Deduct” will automatically appear if it is required. Refer to the list of Amount Descriptions provided for the exact wording of the answer choices for text entries.

Royal Barton started thinking about an electric fishing reel when his father had a stroke and lost the use of an arm. To see that happen to his dad, who had taught him the joys of fishing and hunting, made Barton realize what a chunk a physical handicap could take out of a sports enthusiast’s life. Being able to cast and retrieve a lure and experience the thrill of a big bass trying to take your rig away from you were among the joys of life that would be denied Barton’s father forever. Barton was determined to do something about it, if not for his father, then at least for others who had suffered a similar fate. So, after tremendous personal expense and years of research and development, Barton perfected what is sure to be the standard bearer for all future freshwater electric reels. Forget those saltwater jobs, which Barton refers to as “winches.” He has developed something that is small, compact, and has incredible applications. He calls it the Royal Bee. The first word is obviously his first name. The second word refers to the low buzzing sound the reel makes when in use. The Royal Bee system looks simple enough and probably is if you understand the mechanical workings of a reel. A system of gears ties into the spool, and a motor in the back drives the gears attached to the triggering system. All gearing of the electrical system can be disengaged so that you can cast normally. But pushing the button for “retrieve” engages two gears. After the gears are engaged, the trigger travels far enough to touch the switch that tightens the drive belt, and there is no slipping. You cannot hit the switch until the gears are properly engaged. This means that you cast manually, just as you would normally fish, then you reengage the reel for the level wind to work. And you can do all that with one hand! The system works on a 6-volt battery that you can attach to your belt or hang around your neck if you are wading. If you have a boat with a 6-volt battery, the reel can actually work off of the battery. There is a small connector that plugs into the reel, so you could easily use more than one reel with the battery. For instance, if you have two or three outfits equipped with different lures, you just switch the connector from reel to reel as you use it. A reel with the Royal Bee system can be used in a conventional manner. You do not have to use it as an electric reel unless you choose to do so. Barton believes the Royal Bee may not be just for handicapped fishermen. Ken Cook, one of the leading professional anglers in the country, is sold on the Royal Bee. After he suffered a broken arm, he had to withdraw from some tournaments because fishing with one hand was difficult. By the time his arm healed, he was hooked on the Royal Bee because it increased bassing efficiency. As Cook explains, “The electric reel has increased my efficiency in two ways. One is in flipping, where I use it all the time. The other is for fishing top water, when I have to make a long cast. When I’m flipping, the electric reel gives me instant control over slack line. I can keep both hands on the rod. I never have to remove them to take up slack. I flip, engage the reel, and then all I have to do is push the lever with my thumb to take up slack instantly.” Cook’s reel (a Ryobi 4000) is one of several that can be converted to the electric retrieve. For flipping, Cook loads his reel with 20- pound test line. He uses a similar reel with lighter line when fishing a surface lure. “What you can do with the electric reel is eliminate unproductive reeling time,” Cook says. A few extra seconds may not mean much if you are out on a neighborhood pond just fishing on the weekend. But it can mean a lot if you are in tournament competition, where one extra cast might keep you from going home with $50,000 tucked in your pocket. “Look at it this way,” Cook explains. “Let’s suppose we’re in clear water and it’s necessary to make a long cast to the cover we want to fish with a top water lure. There’s a whole lot of unproductive water between us and the cover. With the electric reel, I make my long cast and fish the cover. Then, when I’m ready to reel in, I just press the retrieve lever, so the battery engages the necessary gears, and I’ve got my lure back ready to make another cast while you’re still cranking.” When Royal Barton retired from his veterinary supply business, he began enjoying his favorite pastimes: hunting, fishing, and developing the Royal Bee system. He realized he needed help in marketing his product, so he sought professional assistance to learn how to reach the broadest possible market for the Royal Bee system.

Questions

1. What business research problem does Royal Barton face? Outline some survey research objectives for a research project on the Royal Bee system.

2. What type of survey—personal interview, telephone interview, or mail survey—should be selected? Why?

3. What sources of survey error are most likely to occur in a study of this type?

4. Suppose the speed limits in 13 countries in miles per hour are as follows:

Country    Highway Miles per Hour

Italy. 87

France 81

Hungary 75

Belgium 75 \

Portugal 75

Great Britain 70

Spain 62

Denmark 62

Netherlands 62

Greece 62

Japan 62

Norway 56

Turkey. 56

a) What is the mean, median, and mode for these data?

b) Calculate the standard deviation for the data.

c) Calculate the expected value of the speed limit with a confidence interval of 98%.

5. Suppose a survey researcher studying annual expenditures on lipstick wishes to have a 99 percent confidence level and a range of error (E) of less than $2. If the estimate of the standard deviation is $29, what sample size is required for this?

Overview Your assignment is to complete a network diagram for a small company. You will place a number of network elements on the diagram and label them appropriately. A network diagram is important to communicate the design features of a network between network administrators, system administrators, and cyber-security analysts. It helps to create a shared mental model between these different technologists, yet each will have their own perspective on what is important to have documented on the diagram. Please review a description of ABC Corporation’s network resources and how they are allocated. ABC Corporation’s Network Description ABC Corporation is a small business in the heart of Central Pennsylvania. They provide services to their clients all over the region. The three-story main office building is where all of the employees report to work each day. There are no remote users. ABC Corporation is a very traditional business. While they have a computer network and are connected to the Internet, they aren’t very fancy and don’t yet have a need for telecommuting, wireless networks, or smart phones. All of their computers are desktop machines and are connected with wired Ethernet connections. All of the network wiring is CAT-6 twisted pair wiring that goes from the office location to a wiring closet. There is one wiring closet on each floor. Each closet is connected to the basement wiring closet via fiber. There are several departments of the company. The administrative office has ten employees including the CEO, executive Vice-President, a human resources manager, and several assistants and secretaries. The finance office has fifteen employees. Both of these divisions are on the third floor. The second floor has the Sales and R&D departments. There are a total of twenty employees in the Sales Department and includes sales executives and assistants. All of the sales department personnel have laptop computers, but they are still connected via the wired network. The R&D department has ten engineers who have two computers each – one in their office and one in their lab spaces. The first floor has the shipping/receiving department, manufacturing department, and the receptionist. The receptionist shares a computer with the night watchman, since they work opposite shifts. There are twenty people in manufacturing, but they only use three computers to enter their production details into the company’s ERP system. The shipping/receiving department has six people, each with a computer that connects to UPS, Fedex, and USPS systems, prints packaging labels and shipping documents. There is also a conference room/training room on the first floor with a multimedia system that includes a podium computer, projector, and all of the bells and whistles. The basement houses the maintenance department, information technology, and the mail room. The mail room clerk doesn’t use the computers at all. The two maintenance workers have computers at their desks that they use to enter reports of work performed. The IT Department has seven employees, each with a desktop computer. They also manage the server farm, which includes two domain controllers, one print server, one mail server, one database server, one internal web server, one external web server (on the DMZ interface of the firewall), a file server, a special server for the ERP system, and a backup server. Layer 2/3 Network Devices Each floor needs to have an Ethernet switch in its network closet. Determine the number of ports that are needed on each floor. Don’t forget the basement. The server farm and DMZ each will need to have its own switch, separated from the users’ network. Each switch connects to a centralized router on a different interface, giving one subnetwork for each floor of the network, plus one for the server farm, one for the DMZ, and one for the Internet. Determine how many ports the router needs. IP Address Assignments The router will perform Network Address Translation between the local network and the Internet. Therefore, for each sub-network, assign a CIDR /24 sized network from the IANA private range of 172.28.0.0/16. One network should get 172.28.1.0/24, the next should get 172.28.2.0/24, the next should get 172.28.3.0/24 etc. While you could optimize the use of the IP range by using smaller subnets, this is not required in this assignment. Create a Network Diagram Your network diagram needs to include the following elements: • An Internet Service Provider Network (represented as a cloud) • Router with enough ports to meet the needs of the organization • A switch for each floor – you will need to identify how many ports each switch on each floor needs to have • You DO NOT need to show every single computer on your diagram. However, you need to show groups of computers, plus their use. So, if there are 5 people in the same department, you can show all 5 computers with one icon/glyph and label it appropriately. • Each grouping of computers needs to have the IP Address range documented on the diagram. Assign the x.x.x.1 address of each network to the appropriate port on the router. Network Documentation Your network design document needs to explain each element of the network. Each Layer two (switch) and Layer three (Router) device needs to be described in terms of number of ports. The number of computers for each department and floor also needs to be documented. The IP address ranges need to be explained – including the IP Address range that you assigned, the number of IP Addresses that the subnetwork will use, and the number of IP addresses that remain unused in that subnet. What to Turn In For assignments that require you to submit Visio work, please export your file and submit as a PDF. Also, please submit your original Visio file. You also need to turn in a Word document (.doc or .docx) file that explains your network diagram elements. Include snapshots from your network diagram in your Word document – and annotate your diagram snapshots to better help your explanation of your network.