Questions
In this homework you will implement a Library class that uses your Book and Person class...

In this homework you will implement a Library class that uses your Book and Person class from homework 2, with slight modifications. The Library class will keep track of people with membership and the books that they have checked out.

Book.java

You will need to modify your Book.java from homework 2 in the following ways:

field: dueDate (private)

            A String containing the date book is due.  Dates are given in the format "DD MM YYYY", such as "01 02 2017" (Feb. 1, 2017.)  This will help when calculating the number of days a book is overdue.

Field: checkedOut (private)

            A Boolean that is true if the book is checked out and false otherwise.

Field: bookId (private)

            An int that holds the unique Id for the book. Because it is unique it will not be changed so you can declare it as final. This will be used to distinguish separate copies of the same book (with the same title and author).

Field: bookValue (private)

            A double that holds the current value of the book in dollars.

Replace the old constructor with one that has the following method hearder

public Book(String title, String author, int bookId, double bookValue)

Add accessors and mutators for each of the new fields except for a mutator for bookId. Note that getters for boolean fields use "is" instead of the normal "get". For example the getter for checkedOut in the book class should be called isCheckedOut(). Update the equals method to only use the bookId since it is unique for each book. We do this because it is possiblie to have multiple copies of the same book (same title and author) and in this set up they would not be equal. Also, update the toString method.

Person.java

You will need to modify your Person.java from homework 2 in the following ways:

Field: address (private)

            A String that contains the address for the person, e.g. "101 Main St." For simplicity, do not worry about including the city, state, or zip code.

Field: libraryCardNum (private)

            An int that is the unique library id number for the person. Note that this replaces the id field from homework 2. Once this is set it will never change, so you can make if final if you would like.

Change the old constructor so that it has the following header and sets the correct fields:

public Person(String name, String address, int libraryCardNum)

Create accessors for the fields and mutators for the address field. Update equals method and toString. The ArrayList<Book> will now be called checkedOut and be a list of books the Person has checked out from the library. The addBook method will change slightly (see below). You can update the other methods as needed but they will not be used for this assignment and they will not be tested.

public boolean addBook(Book b)

Add the Book b to the list of the current object's checked out books if and only if it was not already in that list. Return true if the Book was added; return false if it was not added.

Library

Field: libraryBooks (private)

            An ArrayList<Book> that holds all books for the library. Note that the library may have multiple copies of the same book (same title and author) but the bookId for each copy must be unique.

Field: patrons (private)

            An ArrayList<Person> that holds all the people who are patrons of the library.

Field: name (private)

            A String that holds the name of the library

Field: numBooks (private)

            An int that keeps track of the number of books that are currently available to be checked out. A book that is checked out is not included in this count.    

Field: numPeople (private)

            An int that keeps the number of patrons to the library.

Field: currentDate (private)

            A String that represents the current date. Dates are given in the format "DD MM YYYY", such as "01 10 2016" (Oct. 1, 2016) just like the due date.

Constructor

            Write a constructor that takes in a String for the name of the library.

Accessors

            Write accessors for each of the fields.

Mutators

            Write a mutator for each field except for numBooks and numPeople as these depend on the other fields and should only be updated when the fields are updated or accessed.

Public int checkNumCopies( String title, String author)

            A method that takes in a string for the title and author of a book and returns the number of copies of this book in the library (both checked out and available)

Public int totalNumBooks()

            Returns the number of books in the library (either checked out or not)

Public boolean checkOut(Person p, Book b, String dueDate)

            A method that checks out the book to the given person only if the person is a patron and the book is in the library and not currently checked out. Note that the book object being passed in may be equal to a book in the library but not the actual book in the library. That means you need to be sure to update the book in the library not the book being passed into the method. It will also update the due date for the book object. It will return true if the book is successfully checked out and false otherwise.

Public ArrayList<Book> booksDueOnDate(String date)

            A method that returns an Array List of books due on the given date.

Public double lateFee(Person p)

            This method will calculate the late fee the person owes. The late fee is based on the value of the book and the number of days the book is overdue. The fee is 1% of the book value for every day the book is overdue. For example if a book is worth $20 and is nine days late the late fee will be $1.80. If the Person has multiple books overdue then the late fees are simply added together.

To calculate the number of days between the current date and the date the book is due, we recommend that you look at the GregorianCalendar class. Google the API for help. If you want to use/write another method to calculate the number of days between the current date and the due date you are welcome to do so! If you get ideas from online, please remember to site your sources at the top of your .java file(s).

Testing

You will need to write at least two JUnit tests for each of the following methods in the Library class:

checkNumCopies

checkOut

booksDueOnDate and

lateFee

You are encouraged to write tests for the other methods but we will not require it. You will need to submit these to Web-CAT along with the rest of your code. Use standard naming conventions for these JUnit tests (include the word 'test' in the name somewhere - such as "testCheckOut"), otherwise we do not mind what you call them. Remember, it would be best if you do not have more than one assert statement per JUnit test case (method). There is no upper limit on how many JUnit test cases you write. Place all your JUnit test cases in one single file ("JUnit Test Case") - you do not need separate files to test Book.java, Person.java, and Library.java.

Constraints

Each .java file must have the assignment name (Homework 3)

Do not put your classes into a package - leave it as default. (If you don't know what this means, don't worry about it.)

Observe the basic naming conventions you've been shown in class.

Your code must be correctly indented. Most code editors have a way of doing this for you. In Eclipse, select all text with CTRL-A (Command-A on the Mac), and then do Source->Correct Indentation (which is CTRL-I on Windows and Command-I on the Mac).

If two methods share identical logic, you should factor that out into a separate method (a helper method).

In: Computer Science

Part 1 – Create a Stock Class Write a class named Stock. Stock Class Specifications Include...

Part 1 – Create a Stock Class

Write a class named Stock.

Stock Class Specifications

Include member variables for name (string), price (double), shares (double).

Write a default constructor.

Write a constructor that takes values for all member variables as parameters.

Write a copy constructor.

Implement Get/Set methods for all member variables.

Implement the CalculateValue function. This function should multiply the prices by the shares and return that value. Use the following function header: double CalculateValue().

Add a member overload for the assignment operator.

Add a non-member operator<< overload. Prints the values of all member variables on the given ostream.

Stock Class Updates

The Stock class should implement all the specifications from the first assignment plus the updates and features listed below.

Change all member variables to pointers. You will need to update code in any functions that use these member variables. Do NOT change any function signatures for this class. All functions should operate the same as before from the user of the classes’ perspective. For example, assume the get/set functions for title have the following signatures:

std::string GetName();

void SetName(std::string n);

These signatures should remain exactly the same. The same goes for any other functions that use these member variables. Only the internal implementation of the functions will change to accommodate the use of pointers.

Update the constructors. The constructors should allocate memory for the pointer member variables.

Add a destructor. The destructor should deallocate memory for the pointer member variables.

Update operator= and copy constructor. The operator= and copy constructor should be updated to perform deep copies.

Update operator<<. Make sure it prints out the values and not the addresses.

Add a non-member operator>> overload. The >> operator is used for input. Reads the values of all member variables from the given istream.

You can assume that a one word string is being used for name in order to make it a little easier to code. This is important because if you did not make that assumption you could not use the >> operator to read a string value. The >> operator only reads up until the first whitespace it encounters.

Part 2 – Create a Portfolio Class

Write a class that will store a collection of Stock. This class will be used to keep track of data for multiple Stock class instances. You MUST implement ALL of the specifications below.

Portfolio Class Specifications

Create a private member variable that is a static array of Stock. The size of the array can be whatever you want it to be.

Your class must implement all of the following functions (use the given function prototypes):

void Set(int index, Stock s) – Sets the value at the given index to the given Stock instance. You should test the index to make sure that it is valid. If the index is not valid then do not set the value.

Stock Get(int index) – Return the Stock located at the given index in the array.

int PriceRangeCount(double lowerBound, double upperBound) – Returns the count of the number of Stocks that fall within the given range. For example, assume the following number of Stock prices: 10, 20, 15, 25, 30, 40

If lowerBound is 20 and upperBound is 30 then the returned value should be 3. Any values that fall on the boundaries should be included in the count. In this example we are getting a count of the number of stocks that have a price between $20 and $30. Remember, this function is using price and not value.

Stock MostShares() – Returns the Stock in the Portfolio that has the most shares.

bool FindByName(string name, Stock &v) – Returns true if the Stock with the given name is in the array and false otherwise. If the Stock is in the array you should copy it into the Stock reference parameter.

double TotalValue() – Returns the sum of all Stock values (not prices) in the collection.

int Size() – Returns the size of the array.

void Initialize() – Initializes all of the elements of the array to reasonable default values.

string GetAuthor() – Returns your name. Just hard code your name into the function.

Create a default constructor that will initialize all elements of the array to default values.

Portfolio Class Updates

The Portfolio class should implement all the specifications from the first assignment plus the updates and features listed below.

Dynamic array. Change the internal implementation of the array so that the array is dynamically allocated.

Add a size member variable to the class. This member variable should ALWAYS contain the number of elements in the array (size of the array). Some functions may cause the size of the array to change so make sure that this member variable is updated to reflect the new size.

Update all the necessary code in the class so that it is usable with a dynamic array. One example of this is to change the ending condition of loops that visit all elements of the array. The ending limit should not be hard coded. They should use the new size variable as the ending condition.

Add a one parameter constructor that takes a size. This constructor should dynamically allocate an array of the given size. It should also set the size member variable to reflect the size.

Add a copy constructor. This function should make a deep copy of the passed in instance.

Add a destructor. This function should perform any necessary cleanup.

Add a member overload of operator= (assignment operator). This method should perform a deep copy of the passed in instance. After this function ends the size of the current instance’s array should be the same as the other instance’s array and all the data from the other instance should be copied into the current instance’s array.

Hint: C++ arrays have a fixed size. You may need to delete and then reallocate memory for the current instance’s array in order to make the current instance’s array the same size as the other instance’s array. Be careful for memory leaks.

Add a non-member operator<< overload. Prints the values of all elements of the array on the given ostream.

Add a Resize function. Here is the function signature:

void Resize(int newSize);

This function should create a new array that has the passed in size. You MUST retain any values that were previously in the array. The new array size can be larger or smaller. If the new array size is SMALLER just retain as many elements from the previous array that can fit.

Hint: C++ arrays have a fixed size. You may need to delete and then reallocate memory. Be careful for memory leaks.

Add a function named Clone with the following signature:

Portfolio *Clone();

This method should allocate a new dynamic instance of Portfolio that is a deep copy of the current instance. This method should return a pointer to the new instance.

Part 4 – Main Function

Main should create instances of Stock and Portfolio and contain an automated unit test for both of them.

Automated Test

Part 2 – Console Application - Main Function

Create a C++ console application that imports and uses the static library solution that you created. The console application should have a main function. In main you should create instances of the updated Portfolio class and demonstrate that ALL functions work properly. You can write unit testing code if you want but you are not required to.

In: Computer Science

In the original flashcard problem, a user can ask the program to show an entry picked...

In the original flashcard problem, a user can ask the program to show an entry picked randomly from a glossary. When the user presses return, the program shows the definition corresponding to that entry. The user is then given the option of seeing another entry or quitting.

A sample session might run as follows:

Enter s to show a flashcard and q to quit: s Define: word1 Press return to see the definition definition1 Enter s to show a flashcard and q to quit: s Define: word3 Press return to see the definition definition3 Enter s to show a flashcard and q to quit: q

The flashcard program is required to be extended as follows:

Box 1 – Specification of extended problem

There are now two glossaries: the ‘easy’ and the ‘hard’.

The program should allow the user to ask for either an ‘easy’ or a ‘hard’ glossary entry. If the user chooses to see an ‘easy’ entry, the program picks an entry at random from the easy glossary and shows the entry. After the user presses return, the program should show the definition for that entry.

If the user chooses to see a ‘hard’ entry, the program picks an entry at random from the hard glossary and shows the entry. After the user presses return, the program should show the definition for that entry.

The user should be able to repeatedly ask for an easy or a hard entry or choose an option to quit the program.

A sample dialogue might run as follows. Changes from the original flashcard program are indicated by underlining. word3 is from the ‘easy’ glossary, word6 from the ‘hard’ glossary.

Enter e to show an easy flashcard, h to show a hard one, and q to quit: e Define: word3 Press return to see the definition definition3 Enter e to show an easy flashcard, h to show a hard one, and q to quit: h Define: word6 Press return to see the definition definition6 Enter e to show an easy flashcard, h to show a hard one, and q to quit: q

Box 2 – Keeping a notebook

As you work through part (a) of this question you should keep a notebook. You will need this for your answer to part (a)(vi). This should be very brief: it is simply a record of your personal experience while working on the task and what you feel you have learned from it.

In your notebook we suggest that you record the following information:

How A brief description of how you went about the task.
Resources What documentation, if any, you consulted (including course materials and any online sources) and which you found most useful. There is no need for full references, just note the source, and – in the case of the course materials – what the relevant part and section or activity was.
Difficulties Anything you found difficult about the task, and how you dealt with it.
Lessons learnt Anything you learned from the task that would be useful if you faced a similar problem in the future.

There is more than one way of solving the extended problem, but the approach we ask you to follow for this TMA starts by addressing the subproblem of showing a random entry from either the easy or the hard glossary and, after the user enters return, showing the definition. The algorithm should select which glossary to use depending on the user's input.

  • a.

    • i.Begin by writing an algorithm for the subproblem, show definition, described in the middle paragraph of Box 1 above, and repeated here for convenience:

      The program should allow the user to ask for either an easy or a hard glossary. If the user chooses to see an easy entry, the program picks an entry at random from the easy glossary and shows the entry. After the user presses return, the program should show the definition for that entry.

      If the user chooses to see a hard entry, the program picks an entry at random from the hard glossary and shows the entry. After the user presses return, the program should show the definition for that entry.

      At this stage, no looping is involved and the steps of the algorithm only need to do what is asked for in the paragraph above and nothing more. Your algorithm will need to cater for the two variables of the user asking for either an easy or a hard entry.

      The steps of your algorithm must be written in English and not use any Python code. The algorithm should be high-level and at a similar level of detail to the solution to Activity 2.24 of Block 3 Part 2, where an algorithm is given for show flashcard.

    • ii.Next you will translate your algorithm into Python code.
    • Modify the function show_flashcard() so it translates into Python the steps of the algorithm you wrote in Part (i). You can assume the user's choice is stored in the variable user_input and is either 'e' or 'h' for easy or hard respectively.

      Make sure you write a suitable docstring for the function.

      Copy your modified show_flashcard() function and paste it into your Solution Document.

    • iii.When you have modified the show_flash card() function, test it as follows.

      Run the program and, when asked to make a choice, immediately enter q so the program quits.

      Although the program has quit, the function is still loaded into memory and can be called from the shell. To test it, first set the value of user_input to 'e'

      >>> user_input = 'e'

      Now call the function

      >>> show_flashcard()

      If the function is correct, this should display one of the ‘easy’ words: word1, word2 or word3, followed by Press return to see the definition.

      Repeat this process but this time set the value of user_input to 'h' and check that now the word displays one of the 'hard' words: word4, word5 or word6.

      Debug the code and/or algorithm as necessary. If you need to make modifications, you should record them in your notebook.

      Copy and paste two example tests into your Solution Document. The first test should show the result of user_input being set to 'e', the function being called, and the user pressing return. The second test should show the result of user_input being set to 'h', the function being called, and the user pressing return.

      Alternatively, if you were unable to get the function working correctly, you should still paste in example tests and explain briefly how the results are different from what you were expecting.

    • iv.Now you need to make changes to the part of the program that implements the interactive loop, so the user is offered a choice between entering 'e' for an easy entry, 'h' for a hard entry, or 'q' to quit.

      If the user enters either ‘e’ or ‘h’, the show_flashcard() function should be called. The function will then show a random entry from either the easy or hard glossary, depending on which of the two the user chose, which will have resulted in user_input being set to the corresponding value.

      If the user enters ‘q’, the program should quit as before.

      If the user enters anything else, the program should print a message reminding them what the possible options are.

      Once you have made the changes, run the whole program. Copy a test dialogue into your Solution Document to show the user first choosing to see an 'easy' entry, then a 'hard' one, then entering an invalid option, and finally entering 'q' to quit the program.

      Alternatively, if you were unable to produce a test dialogue because you could not get the program to function as intended, you should briefly explain how a successful test dialogue would look.

    • v.Next, modify the docstring for the program as a whole to reflect the changes you have made.

In: Computer Science

The Problem Facebook has long conducted digital experiments on various aspects of its website. For example,...

The Problem

Facebook has long conducted digital experiments on various aspects of its website. For example, just before the 2012 election, the company conducted an experiment on the News Feeds of nearly 2 million users so that they would see more “hard news” shared by their friends. In the experiment, news articles that Facebook users' friends had posted appeared higher in their News feeds. Facebook claimed that the news stories being shared were general in nature and not political. The stories originated from a list of 100 top media outlets from the New York Times to Fox News. Industry analysts claim that the change may have boosted voter turnout by as much as 3 percent.

Next, Facebook decided to conduct a different kind of experiment that analyzed human emotions. The social network has observed that people's friends often produce more News Feed content than they can read. As a result, Facebook filters that content with algorithms to show users the most relevant and engaging content. For one week in 2012, Facebook changed the algorithms it uses to determine which status updates appeared in the News Feed of 689,000 randomly selected users (about 1 of every 2,500 Facebook users). In this experiment, the algorithm filtered content based on its emotional content. Specifically, it identified a post as “positive” or “negative” if it used at least one word previously identified by Facebook as positive or negative. In essence, Facebook altered the regular news feeds of those users, showing one set of users happy, positive posts while displaying dreary, negative posts to another set.

Previous studies had found that the largely positive content that Facebook tends to feature has made users feel bitter and resentful. The rationale for this finding is that users become jealous over the success of other people, and they feel they are not “keeping up.” Those studies, therefore, predicted that reducing the positive content in users' feeds might actually make users less unhappy. Clearly, Facebook would want to determine what types of feeds will make users spend more time on its site rather than leave the site in disgust or despair. Consequently, Facebook designed its experiment to investigate the theory that seeing friends' positive content makes users sad.

The researchers—one from Facebook and two from academia—conducted two experiments, with a total of four groups of users. In the first experiment, they reduced the positive content of News Feeds; in the second experiment, they reduced the negative content. In both experiments, these treatment conditions were compared with control groups in which News Feeds were randomly filtered without regard to positive or negative content.

The results were interesting. When users received more positive content in their News Feed, a slightly larger percentage of words in their status updates were positive, and a smaller percentage were negative. When positivity was reduced, the opposite pattern occurred. The researchers concluded that the emotions expressed by friends, through online social networks, elicited similar emotions from users. Interestingly, the results of this experiment did not support the hypothesis that seeing friends' positive content made users sad.

Significantly, Facebook had not explicitly informed the participants that they were being studied. In fact, few users were aware of this fact until the study was published in a paper titled “Experimental evidence of massive-scale emotional contagion through social networks” in the prominent scientific journal Proceedings of the National Academy of Sciences. At that point, many people became upset that Facebook had secretly performed a digital experiment on its users. The only warning that Facebook had issued was buried in the social network's one-click user agreement. Facebook's Data Use Policy states that Facebook “may use the information we receive about you . . . for internal operations, including troubleshooting, data analysis, testing, research, and service improvement.” This policy led to charges that the experiment violated laws designed to protect human research subjects.

Some lawyers urged legal action against Facebook over its experiment. While acknowledging the potential benefits of digital research, they asserted that online research such as the Facebook experiment should be held to some of the same standards required of government-sponsored clinical trials. What makes the Facebook experiment unethical, in their opinion, was that the company did not explicitly seek subjects' approval at the time of the study.

Some industry analysts challenged this contention, arguing that clinical research requirements should not be imposed on Facebook. They placed Facebook's experiment in the context of manipulative advertising—on the web and elsewhere—and news outlets that select stories and write headlines in a way that is designed to exploit emotional responses by their readers.

On July 3, 2014, the privacy group Electronic Privacy Information Center filed a formal complaint with the Federal Trade Commission claiming that Facebook had broken the law when it conducted the experiment without the participants' knowledge or consent. EPIC alleged that Facebook had deceived its users by secretly conducting a psychological experiment on their emotions.

Facebook's Response

Facebook Chief Operating Officer Sheryl Sandberg defended the experiment on the grounds that it was a part of ongoing research that companies perform to test different products. She conceded, however, that the experiment had been poorly communicated, and she formally apologized. The lead author of the Facebook experiment also stated, “I can understand why some people have concerns about it (the study), and my co-authors and I are very sorry for the way the (academic) paper described the research and any anxiety it caused.”

For its part, Facebook conceded that the experiment should have been “done differently,” and it announced a new set of guidelines for how the social network will approach future research studies. Specifically, research that relates to content that “may be considered deeply personal” will go through an enhanced review process before it can begin.

The Results

At Facebook, the experiments continue. In May 2015, the social network launched an experiment called Instant Articles in partnership with nine major international newspapers. This new feature allowed Facebook to host articles from various news publications directly on its platform, an option that the social network claims will generate a richer multimedia experience and faster page-loading times.

The following month Facebook began experimenting with its Trending sidebar, which groups news and hashtags into five categories among which users can toggle: all news, politics, science and technology, sports, and entertainment. Facebook maintained that the objective is to help users discover which topics they may be interested in. This experiment could be part of Facebook's new effort to become a one-stop news distributor, an approach that would encourage users to remain on the site for as long as possible.

A 2016 report asserts that Facebook's list of top trending topics is not quite objective. For example, one source stated that Facebook's news curators routinely excluded trending stories from conservative media sites from the trending section. Facebook strongly denied the claim.

Questions

  1. Discuss the ethicality and legality of Facebook's experiment with human emotions.
  2. Was Facebook's response to criticism concerning that experiment adequate? Why or why not?
  3. Consider the experiments that Facebook conducted in May and June 2015. Is there a difference between these two experiments and Facebook's experiment with human emotions? Why or why not?
  4. Should the law require companies to inform their users every time they conduct experiments? Why or why not?

In: Operations Management

Saint Mary’s University jointly runs a dual degree program with the Beijing Normal University at Zhuhai....

Saint Mary’s University jointly runs a dual degree program with the Beijing Normal University at Zhuhai. In order to do so, Saint Mary’s provides faculty to instruct in China. For the spring session scheduled to run from April 22nd to May 31st, 2019 Saint Mary’s had an individual prepared to instruct this course. This person entered into a contract with SMU which stated in part that the individual would instruct in China during the entirety of the spring session, but said nothing about cancellation by either party. At some point on or about late February, this individual advised Saint Mary’s that they would not be able to come to Zhuhai. Assume for the purposes of this assignment that the individual had been diagnosed with cancer, and was unable to travel.

In or about early March Professor Scott had been offered and had accepted a position as the new instructor by Saint Mary’s. A contract was entered into that included, among other things, clear instructions that he would need to secure the appropriate Visa that would allow him to travel to Zhuhai. As time was tight (in legal terms we say that time was of the essence) Scott was encouraged to go ahead and book flights and make the necessary arrangements in order to be in China to start classes on April 22.

In Canada, the Chinese embassy is responsible for issuing appropriate Visas for travel to China. In order to facilitate the processing of applications, the embassy utilizes an independent company known as the Chinese Visa Processing Centre Limited…this company is a separate entity from the government and operates at arm’s length from the embassy. Applications are filled out online, and when complete, the applicant must print the application form and attend in person at the offices of the Chinese Visa Processing Centre where they pay a fee and also provide biometric scans that enable the embassy to conduct their work. The Chinese Visa Processing Centre essentially pre screens visa applications to ensure conformity with the established decision parameters. If there are readily apparent issues, for example an expired passport or things of an administrative nature, then the Chinese Visa Processing Centre will hold an application pending the correction of the issue by the applicant. The Processing Centre also states that applicants who cannot pick up their passport in person must provide a prepaid pre-addressed return envelope so that the passport containing the Visa can be returned to the applicant.

Scott prepared the online application form as advised. Given the type of Visa required, Scott needed a letter, known as the Foreign Expert Invitation Letter issued by the provincial government in Guangdong, China. Although this letter was not mentioned in the contract, Saint Mary’s represented verbally that they would secure the letter for Scott. Saint Mary’s did, in fact secure the letter, which was advanced to Scott via email on March 19. Having completed the application, and with the letter in hand, Scott flew to Ottawa to deliver the visa application.

Before that however, Scott had booked flights from Halifax to Zhuhai that would have him arrive in China on April 19 in time to begin classes on the 22nd. Scott was instructed to secure cancellation insurance on all flights. Scott did, in fact, pay for and receive a policy of insurance that clearly stated that it would cover the cost of flights cancelled due to medical emergencies or death, including medical emergencies or death to immediate family members of the insured party.

While sitting in the departure lounge awaiting his return flight to Halifax, having attended at the Visa Processing Centre as required Scott received a telephone call from the Chinese Visa Processing Centre and was told that the embassy has already had a look at the Foreign Expert Invitation Letter. Scott was advised that the letter would not suffice because it lacked certain information, and also because it needed to be issued by the appropriate government authorities in the Guangdong Province. The letter had actually been issued by the University, in accordance with past practice This issue had not been raised for previous applications.

As a result of this problem, it became impossible to travel as planned and Scott advised his travel agent that the flights would need to be cancelled or changed. Further, Scott and officials at Saint Mary’s decided that he should not rebook any travel until it was absolutely certain that the new letter could be obtained.

On April 19, Scott received a different Foreign Expert Invitation Letter and forwarded it to the Chinese Visa Processing Centre. They acknowledged receipt on April 22 and indicated that he should receive confirmation that the Visa had been processed by April 26.

With this new knowledge, Saint Mary’s and Beijing Normal University at Zhuhai amended the start date of the course to May 6.

On April 26, Scott received word that his Visa had been processed and his passport had been placed in the provided pre-paid, pre-addressed envelope and put in the mail. The expected delivery date was April 29. Unfortunately, on April 29 it was discovered that the passport had been delivered to any entirely different address, not in Halifax Nova Scotia, but in Mississauga Ontario, 2000 kilometres away. The address label on the envelope that had been purchased from Canada Post had been tampered with before it was sold. When it was placed in the postal system by the Chinese Visa Processing Centre, it had two different addresses, and Canada Post picked one but they picked the wrong one. When contacted by Scott, Canada Post officials advised that once the envelope had been placed in the mailbox of the receiver, it became the receiver’s property, and Canada Post could not recover it because this would constitute theft. They took no responsibility for the envelope, saying it was the buyer’s problem.

Fortunately the passport was located. The individual that had the passport said that he would return it if Scott came to get it at his home. When Scott travelled to the home, the gentleman said he would only return it if Scott paid a significant reward. At first Scott declined, but the gentleman indicated that he would call the police and state that Scott was trespassing on his property. Scott felt he had no choice, and so he complied and made the payment.

When Scott returned to his hotel with the passport, the rain started to fall heavily. The stone walkway at the front of the hotel was quite slippery, and unfortunately Scott fell and injured his shoulder. Hotel staff would take no responsibility for the injury, stating Scott should have been more careful as it was raining. A sign on the wall of the hotel indicated that the paving stones could become slippery when wet, and patrons of the hotel were cautioned that the hotel accepted no responsibility for injuries. Unfortunately, the hotel concierge had left a luggage cart in front of the sign such that it was not visible.

  1. IDENTIFY ALL THE POTENTIAL LEGAL ISSUES WITH REFERENCE TO THE MATERIALS COVERED IN THE COURSE. YOU MAY PREPARE YOUR ANSWER IN POINT FORM. NOTE ALSO THAT YOU ARE ASKED ONLY TO IDENTIFY THE POTENTIAL LEGAL ISSUES, SO A COMPLETE ANALYSIS IS NOT REQUIRED. (50 points)

  1. ASSUME YOU ARE A LAWYER RETAINED BY SAINT MARY’S. ADVISE SAINT MARY’S OF ALL OF THEIR RIGHTS AND OBLIGATIONS IF SCOTT HAD NOT BEEN ABLE TO SECURE THE VISA. (10 points)

  1. IDENTIFY, WITH REFERENCE TO RISK MANAGEMENT STRATEGIES, AREAS WHERE RISK WAS ENCOUNTERED AND HOW THE PARTIES DEALT WITH THE RISK. SPECIFY THE PARTICULAR RISK MANAGEMENT STRATEGY. (35 points)

  1. WOULD IT MAKE ANY DIFFERENCE TO YOUR ANALYSIS IF SCOTT WAS PAID OR IF HE WAS A VOLUNTEER? WHY OR WHY NOT? (5 points)

In: Operations Management

This is a student essay with paragraphs that have been placed out of order. Rearrange the...

This is a student essay with paragraphs that have been placed out of order. Rearrange the paragraphs into an order that seems logical to you.

A

At a young age, I knew I had to get a good grip on the English language, both on paper and verbally. My parents had it rough trying to find work and getting through school. I saw them struggle so much trying to communicate to the world. English, through my eyes, became this elite world I so badly wanted to be a part of. I was excited to finally understand the language fluently and I was proud to be able to compose summaries and essays throughout grade school. In high school though, I encountered a series of new frustrations with English grammar. Some teachers were lenient but for the most part a lot of my teachers had zero tolerance for grammatical errors. It was incredibly frustrating when I would receive a graded paper back with a less than deserving grade and annoying annotations. This was the result of me not placing appropriate apostrophes or mistakenly used their in place of there. I always wanted to ask my teachers why they couldn’t cut me some slack. If I was a competent student and you knew my intentions, why must I settle for that grade when you were able to follow along and understand me in the assignment?

B

I am a first-generation college student. My parents are refugees from Cambodia and they came to the U.S. when they were about 10 or 11 years old. Our native language is Khmer. In our language, subjunctives do not exist. It was something that was really hard to acclimate to when I started to learn English. Though I was born here, I always spoke my language at home and did not pick up English until I was around 6 years old. In my language there is only what is and what is not. Any kind of wishful thinking or possible outcomes just don’t exist. I struggled learning English but eventually got through it. I was about 9 years old when I finally was able to kick my accent. Boy was I relieved that the teasing was finally going to stop. I felt confident. I felt like I had mastered my second language. But I was wrong. I’m going to share with you my reflection on the subject of the English language, through my experiences.

C

I have learned to embrace all of my grammatical mistakes. I even started to humor my occasional broken English. It is inevitable and I take a lesson from it every time. At the end of the day, what’s important is that we are able to produce a proper paper, right? An articulate paper despite having all these different avenues we can use to communicate English. In a TED Talk titled, “3 Ways to Speak English,” Jamila Lyiscott speaks out poetically about the several ways she speaks English in her community. She talks about the challenges of speaking several completely different styles of English between her friends, her parents and in a classroom setting. A line from her speech that really resonated with me was when she said, “I know I had to borrow your language because mine was stolen, but you can’t expect me to speak ‘your’ history wholly while mine was broken.” How beautiful and powerful is that? As a first-generation student, I really want to make my family proud. Hearing Jamila’s TED Talk gave me a sense of confidence and reassurance in some way. She is letting us know that it is ok to switch things up with your vocabulary. It’s ok to dab in and out of the social norms of English to make sense of the message that you are trying to relay to people on a day to day basis. Just so long as you know the rules and you know when it’s ok to break them. That’s what will set you apart, and that is what will make you articulate.

D

I felt incredibly defeated and thought no way is this fair. Throughout school we’d often get assigned into group projects where we needed to combine all of our research and opinions into a summary. I remember correcting my classmate’s grammar and calling them out for a misspelled word. Where this comma or that apostrophe should or should not go, what needs to be capitalized. I remember coming home and boasting to my mom about these scenarios and one day she said to me, “If you were able to understand what your friends in class are trying to describe, why are you having to tell them that they are wrong?” And in that exact moment, I came to realize that I was a huge hypocrite. Why didn’t I choose to be a little more patient and try to comprehend my classmates? It was then that I realized, it doesn’t matter how we speak or if English was your second language. On paper, there are rules to live up to that everyone should follow because it really is for our own good. A couple weeks ago in class, we read an article called “Opinion Piece on Grammatical Correctness” by Ursula K. Le Guin (33). There was a piece from the reading where she says, “How we talk is important to us all, and we’re all shamed when told in public that we don’t talk correctly. Shame can paralyze our minds.”

E

Her article took me right down memory lane and I started to recall my own journey through the strange world of the English language. From when I was a child, to an adolescent, to an adult. I started to see that there are actually different ways I had to use English. So many ways we had to change things up to make sense of something in whatever social setting we were in.

For school, for work, for our family and for our friends. We even use an entirely different vocabulary for each. To be honest, I was so caught up in learning English, I forgot how to read and write in my own native language. I was no longer able to truly proclaim myself as being bilingual. I became choppy in my first language and started speaking it horribly. So, I enrolled in a Khmer class to freshen up and re learned everything. In the process of that, I came across all these wonderful students from all walks of life. Some were like me and some were learning for the first time. The interactions we had showed me the versatility of language and how we personalize it to communicate and make sense to each other. We must grow and elevate ourselves into your fullest potential. Even if you have to get through the process by speaking a little broken English. Progress is progress no matter what stage you’re in.

In: Psychology

13.8End-of-Chapter Case: Pay To Play? Motivating Megadiamond's Suppliers The supplier-quality meeting ended at 3:10 PM and...

13.8End-of-Chapter Case: Pay To Play? Motivating Megadiamond's Suppliers The supplier-quality meeting ended at 3:10 PM and Tim Rock was bummed. The meeting ended without having accomplished one of Tim Rock's major goals. Tim Rock, senior purchasing manager at MegaDiamond, had hoped his idea to offer advantageous payment terms to certified suppliers would be approved. Unfortunately, Mega's CFO, Jack Hardplace, had rejected the plan dismissively, saying, "We just can't do that. We can't offer some suppliers special payment terms for doing what they should be doing in the first place." As Tim entered his office, he muttered, "Who does Jack think we are? Mega is no Fortune 500 player. We don't buy in big volumes. And we're definitely not Honda. We don't have an engineering team to send out to teach suppliers how to improve their own operations. Why in the world would our suppliers want to cooperate more fully in Mega's new supplier quality improvement program? Without some sort of monetary inducement, we're powerless." Mega's Quality Track Record Technological uniqueness had paved the way for Mega's entry into the market. Tim knew, however, that Mega's reputation for producing and delivering high-quality inserts was vitally important to future growth. The tight-knit oil and gas drilling industry was a lot like a small town—bad news traveled quickly. Because customers talked to one another, defective product could kill a company's reputation overnight. By contrast, positive word-of-mouth could help Mega's recognition as a preferred supplier of PDC inserts go viral. Because a reputation for poor quality meant a quick exit from the market, Tim had always viewed quality as critical. However, the quest for quality became formalized in 2004 when Superbdrill, Mega's largest customers obtained ISO 9000 certification. Superbdrill had pressured its major suppliers, including Mega, to get ISO certified. Mega complied, obtaining the ISO certification in the same year. Tim was proud of the fact that by 2009, Mega had established industry-leading standards of excellence in quality, on-time delivery, and pricing. Mega was hitting on all cylinders. The result: DrillMaster, a major Mega customer, named Mega as its "Number 1" vendor for 2011. As part of the commendation, Mega was elevated to "Level 1" vendor status, which meant DrillMaster would no longer conduct receiving inspection on incoming parts. The entire management team at Mega was thrilled to have met the standards necessary to be named a "dock-to-stock" supplier. This triumph validated Mega's quest for excellence. It also motivated Tim to extend "dock-to-stock" certification backward to Mega's suppliers. Motivating Supplier Quality Tim Rock had joined Mega in 2002—shortly before the initial ISO certification. He quickly realized that much of Mega's success rested on its reputation for producing extremely high-quality PDC inserts. The coolest designs only mattered if the quality was equally good. Tim had also recognized that purchasing had a significant opportunity to impact Mega's competitiveness through the acquisition of low-cost, high-quality materials. Mega purchased from approximately 400 suppliers, which were classified into three levels. Level 1 suppliers provided materials that were used directly as components of PDC inserts. Each PDC insert consisted of two principal components: A tungsten carbide base A polycrystalline diamond cutting surface Because of the composition of the inserts, Tim referred to these two parts as "bread and butter products." In effect, the tungsten base was the bread and the PDC the butter. Given the simple nature of a PDC insert, only 12 suppliers classified as Level 1 suppliers. However, these 12 suppliers represented over 50% of all purchase dollars. Level 2 suppliers provided inputs used in the production process. Mega actively sourced from 100 Level 2 suppliers, spending about 30% of the purchasing budget with these suppliers. Level 3 suppliers provided routine inputs that supported both operations and administration. The remaining 300 suppliers were all Level 3 suppliers. Tim dedicated most of his time and effort to improving relationships with Level 1 suppliers. In fact, to support Mega's quality emphasis, Tim completed the training needed to certify as an ISO auditor in 2009. Tim used this training to help suppliers improve their quality processes. For example, in a visit to Tungsten Specialist Incorporated (TSI), Mega's leading supplier of tungsten carbide substrates, Tim noted that TSI was not matching the specification sheet they received from Mega with the final materials certification. This finding helped explain why Mega occasionally received lots that did not meet required specs. More importantly, it raised serious questions about the quality practices at TSI. Because the quality of the tungsten carbide substrate was critical to the performance of the finished PDC insert, Tim had initiated a study of tungsten carbide suppliers. Mega had been purchasing tungsten carbide substrates from three suppliers; however, 99% of its tungsten carbide substrates were sourced from TSI. After surveying both existing suppliers as well as other buyers of substrates, Tim decided that TSI was the best source of substrates and that it would be more appropriate to "tighten up" the relationship rather than start over with a new supplier. The decision to "tighten" the relationship with TSI provided an excellent opportunity to begin to extend supplier certification backward to Mega's Level 1 suppliers. He was worried, however, that simply recognizing suppliers as certified would not motivate them to want to become a "Mega Certified Supplier." After all, despite Mega's world-class performance, a plaque from MegaDiamond hanging in a supplier's lobby wouldn't be viewed as a "world-class" endorsement. And, although Mega was growing fast, it couldn't buy in the kind of blowout volumes that would excite suppliers. To motivate the exceptional quality performance he desired to see from Mega's suppliers, Tim felt he needed to put some kind of "bottom-line" incentive on the table. Tim had identified three primary challenges to providing such a "bottom-line" motivation. Mega's small size had historically prevented it from being a dominant customer for most of its suppliers. In the case of TSI, Mega already purchased 99% of its substrates from TSI. Mega couldn't promise increased volumes as a reward for certification. Senior management needed to approve any—and all—ideas like offering special payment terms to certified suppliers. As Tim sat at his desk, he wondered aloud, "What can we offer to Level 1 suppliers to get their attention and motivate them to improve their quality practices?" Questions What do you think of Tim's plan? What are the pros and cons of a pay-for-performance certification program? If you think Tim should proceed, what can he do to get the CFO and other top management to support a financial reward for certified suppliers? If you don't like the pay-for-performance concept, how do you suggest Tim proceed to get suppliers to buy in to certification?

In: Operations Management

As part of the quarterly reviews, the manager of a retail store analyzes the quality of...

As part of the quarterly reviews, the manager of a retail store analyzes the quality of customer service based on the periodic customer satisfaction ratings (on a scale of 1 to 10 with 1 = Poor and 10 = Excellent). To understand the level of service quality, which includes the waiting times of the customers in the checkout section, he collected data on 100 customers who visited the store; see the attached Excel file: ServiceQuality.

Using XLMiner Platform > Cluster, apply K-Means Clustering with the following Selected Variables: Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating as Selected Variables. In Step 2 of the XLMiner k-Means Clustering procedure, normalize input data, assume k = 5 clusters, 50 iterations, and fixed start with the default Centroid Initialization seed of 12345. (Note: If the allowable number of iterations is less than 50, it means that you do not use the educational version of XLMiner available to BUAD 2070 students; see the syllabus.)

1. A) What is the minimum normalized (standardized) Euclidean distance between created cluster centers (centroids)?

B) What is the maximum average normalized Euclidean distance between the cluster observations and the cluster centroid?

C) Based on your answers to Questions 1a and 1b, are the five created clusters justifiable? (Note. Recall that the distances between clusters should be greater than the distances within clusters.)

D) Using original data (coordinates), what are the maximum and the minimum average customer satisfaction ratings for the five created clusters?

E) Using original data (coordinates), what are the maximum and the minimum average wait times (in minutes) for the five created clusters?

F) Using original data (coordinates), what are the maximum and the minimum average purchase amounts ($) for the five created clusters?

G) Based on your answers to Questions 1d, 1e, and 1f, what reasons do you see for low customer satisfaction ratings?

2. Using XLMiner Platform > Cluster, apply Hierarchical Clustering with the following Selected Variables: Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating. In Steps 2 and 3 of the XLMiner Hierarchical Clustering procedure, normalize input data and apply Ward’s clustering method with k = 5 clusters.

A) What is thee obtained dendrogram?

B) For each of the five created clusters, find the number of observations and the averages for the four variables. Hint: Using the worksheet HC_Clusters, you may first sort the column Cluster ID, and next calculate these numbers (using e.g. Excel function COUNTIF) and these averages (using Excel function AVERAGE).

C) Based on your findings for Task 2b, what reasons do you see for low customer satisfaction ratings?

D) Provide some recommendations for improving customer satisfaction.

Write a managerial report in MS Word that presents your findings. Do not attach any separate XLMiner and/or Excel outputs. Instead paste into your report the XLMiner outputs with answers to Questions 1a, 1b, 1d, 1e, and 2a, and Excel results related to Task 2b. Showing these outputs/results is crucial because without them I will not be able to verify your findings.

Customer Number Wait Time (min) Purchase Amount ($) Customer Age Customer Satisfaction Rating
1 2.3 436 42 7
2 2.8 408 33 6
3 3.2 432 38 5
4 3.4 431 40 5
5 3.4 456 29 6
6 4.2 537 46 4
7 3.2 456 42 5
8 1.4 430 40 8
9 6.4 663 24 3
10 7.8 839 37 4
11 6.5 659 52 5
12 9.8 836 43 2
13 5 543 56 4
14 1.8 419 35 8
15 6.1 700 39 6
16 3.4 432 44 7
17 7.8 845 33 5
18 2.8 467 42 6
19 1.2 425 46 8
20 9.5 848 50 4
21 8.2 808 55 3
22 7.6 674 35 3
23 5.4 547 52 4
24 6.7 691 38 5
25 9.6 847 53 4
26 11.4 826 48 2
27 2.1 426 52 7
28 5.6 535 32 7
29 3.7 521 43 8
30 4.9 513 44 6
31 6.4 645 53 5
32 9.3 846 52 4
33 10.6 730 51 3
34 6.5 786 53 3
35 5.4 523 46 5
36 7.6 654 36 6
37 3.2 443 48 7
38 2.4 409 54 8
39 1 400 39 6
40 0.2 418 51 7
41 2.4 498 30 6
42 5.7 532 32 5
43 6.4 663 44 7
44 6 681 39 8
45 3.7 543 54 5
46 8.7 800 51 5
47 6.9 673 45 5
48 9.8 856 43 4
49 10 756 44 4
50 9.5 854 43 6
51 6.3 672 50 6
52 7.4 698 47 7
53 2.3 434 43 7
54 4.6 544 40 4
55 4.9 523 53 6
56 5.7 546 55 6
57 7.4 676 42 8
58 6.8 662 36 6
59 9.6 1000 40 5
60 6.4 678 46 5
61 7.2 655 32 4
62 5.6 535 36 5
63 9.7 833 35 3
64 2.3 498 30 7
65 4.3 508 41 6
66 5.7 542 49 6
67 2.4 435 39 8
68 6.7 665 41 5
69 2.4 387 54 9
70 9.8 845 34 7
71 4.5 532 40 6
72 6.7 687 30 5
73 7.2 643 33 4
74 3.5 424 49 7
75 8.9 836 47 5
76 9.7 876 31 4
77 3.5 456 47 7
78 4.7 523 49 6
79 8.5 818 35 5
80 9.7 845 54 4
81 2.7 401 55 7
82 5.7 554 43 6
83 7.6 648 51 7
84 4.4 540 31 6
85 7.8 839 45 5
86 9.4 845 48 4
87 4.9 534 36 5
88 7.1 693 44 4
89 5.4 512 39 3
90 6.7 665 49 5
91 8.6 825 36 5
92 4.5 548 30 7
93 6.1 704 31 5
94 5.3 509 31 6
95 6.7 672 35 5
96 8.1 824 36 4
97 6.3 632 30 4
98 7.4 689 35 2
99 8.8 839 50 4
100 9.6 847 35 2

In: Statistics and Probability

Goup Number: 14 Group Project 2 - Financial Condition Analysis John Green, a recent graduate with...

Goup Number: 14
Group Project 2 - Financial Condition Analysis
John Green, a recent graduate with four years of for-profit health management experience, was
recently brought in as assistant to the chairman of the board of Digital Diagnostics, a manufacturer of
clinical diagnostic equipment. The company had doubled its plant capacity, opened new sales offices outside its
home territory, and launched an expensive advertising campaign. Digital's results were not satisfactory,
to put it mildly. Its board of directors, which consisted of its president and vice president plus its major
stockholders (who were all local business people), was most upset when directors learned how the expansion
was going. Suppliers were being paid late and were unhappy, and the bank was complaining about the cut off
credit. As a result, Eddie Sanders, Digital’s president, was informed that changes would have to be made, and
quickly, or he would be fired. Also, at the board's insistence, John Green was brought in and given the job of
assistant to Wendy Smith, a retired banker who was Digital's chairwoman and largest stockholder. Sanders
agreed to give up a few of his golfing days and help nurse the company back to health, with Green's assistance.
Green began by gathering financial statements and other data, shown below. The data show the dire situation
that Digital Diagnostics was in after the expansion program. Thus far, sales have not been up to the
forecasted level, costs have been higher than were projected, and a large loss occurred in Year 2, rather than
the expected profit. Green examined monthly data for Year 2 (not given in the case), and he detected an
improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the early
months had turned to a small profit by December. Thus, the annual data look somewhat worse than final monthly
data. Also, it appears to be taking longer for the advertising program to get the message across, for the new
sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words,
the lags between spending money and deriving benefits were longer thanDigital's managers had anticipated.
For these reasons, Green and Sanders see hope for the company—provided it can survive in the short run.
Green must prepare an analysis of where the company is now, what it must do to regain its financial health,
and what actions should be taken. Green requested your group to complete this assigned task for him.
Use this Excel Workbook to perform the quantitative parts of the analysis and prepare the report as a Word document.
The report shpuld include only the interpretations of the quantitative results. How you found these results are to be shown in this Excel Workbook.
Submit both files via Blackboard as instructed.
Digital Diagnostics
Statement of Operations
Yr 1 Actual Yr 2 Actual Yr 3 Projected
Revenue:
Net patient service revenue $3,432,000 $5,834,400 $7,035,600
Other revenue $0 $0 $0
    Total revenues $3,432,000 $5,834,400 $7,035,600
Expenses:
Salaries and benefits $2,864,000 $4,980,000 $5,800,000
Supplies $240,000 $620,000 $512,960
Insurance and other $50,000 $50,000 $50,000
Drugs $50,000 $50,000 $50,000
Depreciation $18,900 $116,960 $120,000
Interest $62,500 $176,000 $80,000
    Total expenses $3,285,400 $5,992,960 $6,612,960
Operating income $146,600 -$158,560 $422,640
Provision for income taxes $58,640 -$63,424 $169,056
Net income $87,960 -$95,136 $253,584
Digital Diagnostics
Balance Sheet
Yr 1 Actual Yr 2 Actual Yr 3 Projected
Assets
Current assets:
Cash $9,000 $7,282 $14,000
Marketable securities $48,600 $20,000 $71,632
Net accounts receivable $351,200 $632,160 $878,000
Inventories $715,200 $1,287,360 $1,716,480
    Total current assets $1,124,000 $1,946,802 $2,680,112
Property and equipment $491,000 $1,202,950 $1,220,000
Less accumulated depreciation $146,200 $263,160 $383,160
Net property and equipment $344,800 $939,790 $836,840
Total assets $1,468,800 $2,886,592 $3,516,952
Liabilities and shareholders' equity
Current liabilities:
Accounts payable $145,600 $324,000 $359,800
Accrued expenses $136,000 $284,960 $380,000
Notes payable $120,000 $640,000 $220,000
Current portion of long-term debt $80,000 $80,000 $80,000
    Total current liabilities $481,600 $1,328,960 $1,039,800
Long-term debt $323,432 $1,000,000 $500,000
Shareholders' equity:
Common stock $460,000 $460,000 $1,680,936
Retained earnings $203,768 $97,632 $296,216
    Total shareholders' equity $663,768 $557,632 $1,977,152
Total liabilities and shareholders' equity $1,468,800 $2,886,592 $3,516,952
Other data:
Stock price $8.50 $6.00 $12.17
Shares outstanding 100,000 100,000 250,000
Tax rate 40% 40% 40%
Lease payments $40,000 $40,000 $40,000
ANSWER
Industry
Yr 1 Actual Yr 2 Actual Yr 3 Projected Average
Profitability ratios
Total margin 4% -3% 6% 3.6%
Return on assets 6% -3% 7% 9.0%
Return on equity 13% -17% 13% 17.9%
Liquidity ratios
Current ratio 2.33 1.46 2.58 2.70
Days cash on hand 1.01 0.45 0.79 22.0
Debt management (capital structure) ratios
Debt ratio 55% 81% 44% 50.0%
Debt to equity ratio 0.49 1.79 0.25 2.5
Times-interest-earned ratio 1.35 -1.9 4.28 6.2
Cash flow coverage ratio 1.65 -1.24 5.78 8.00
Asset management (activity) ratios
Fixed asset turnover 9.95 6.21 8.41 7.00
Total asset turnover 2.34 2.02 2 2.50
Days sales outstanding 37.35 39.55 45.55 32.0
Other ratios
Average age of plant 6.1
Earnings per share n/a
Book value per share n/a
Price/earnings ratio 16.20
Market/book ratio 2.90
Digital Diagnostics
Common Size Statement of Operations
Industry
Yr 1 Actual Yr 2 Actual Yr 3 Projected Average
Revenue:
Net patient service revenue 100.0% 100.0% 100.0% 100.0%
Other revenue 0.0% 0.0% 0.0% 0.0%
    Total revenues 100.0% 100.0% 100.0% 100.0%
Expenses:
Salaries and benefits 83.0% 85.0% 82.0% 84.5%
Supplies 7.0% 11.0% 7.0% 3.9%
Insurance and other 1.0% 1.0% 1.0% 0.3%
Drugs 1.0% 1.0% 1.0% 0.3%
Depreciation 1.0% 2.0% 2.0% 4.0%
Interest 2.0% 3.0% 1.0% 1.1%
    Total expenses 96.0% 103.0% 94.0% 94.1%
Operating income 4.0% -3% 6.0% 5.9%
Provision for income taxes 2.0% -1.0% 2.0% 2.4%
Net income 3.0% -2.0% 4.0% 3.5%
Digital Diagnostics
Common Size Balance Sheet Industry
Yr 1 Actual Yr 2 Actual Yr 3 Projected Average
Assets
Current assets:
Cash 0.3%
Marketable securities 0.3%
Net accounts receivable 22.3%
Inventories 41.2%
    Total current assets 64.1%
Property and equipment 53.9%
Less accumulated depreciation 18.0%
Net property and equipment 35.9%
Total assets 100.0%
Liabilities and shareholders' equity
Current liabilities:
Accounts payable 10.2%
Accrued expenses 9.5%
Notes payable 2.4%
Current portion of long-term debt 1.6%
    Total current liabilities 23.7%
Long-term debt 26.3%
Shareholders' equity:
Common stock 20.0%
Retained earnings 30.0%
    Total shareholders' equity 50.0%
Total liabilities and shareholders' equity 100.0%

Please add the work on how to do it on excel. Detailed explanation please. Thank you!

In: Accounting

The unadjusted trial balance of Epicenter Laundry at June 30, 2016, the end of the fiscal...

The unadjusted trial balance of Epicenter Laundry at June 30, 2016, the end of the fiscal year, follows:

Epicenter Laundry

UNADJUSTED TRIAL BALANCE

June 30, 2016

ACCOUNT TITLE DEBIT CREDIT

1

Cash

11,000.00

2

Laundry Supplies

21,500.00

3

Prepaid Insurance

9,600.00

4

Laundry Equipment

232,600.00

5

Accumulated Depreciation

125,400.00

6

Accounts Payable

11,800.00

7

Sophie Perez, Capital

105,600.00

8

Sophie Perez, Drawing

10,000.00

9

Laundry Revenue

232,200.00

10

Wages Expense

125,200.00

11

Rent Expense

40,000.00

12

Utilities Expense

19,700.00

13

Miscellaneous Expense

5,400.00

14

Totals

475,000.00

475,000.00

The data needed to determine year-end adjustments are as follows:

• Laundry supplies on hand at June 30 are $3,600.
• Insurance premiums expired during the year are $5,700.
• Depreciation of laundry equipment during the year is $6,500.
• Wages accrued but not paid at June 30 are $1,100.

Required:

1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as “Bal.”
2. (Optional) On your own paper or spreadsheet, enter the unadjusted trial balance on an end-of-period work sheet and complete the work sheet.
3.
a. Journalize the adjusting entries on page 10 of the journal. Adjusting entries are recorded on June 30.
b. Post the adjusting entries. In the T accounts, identify the adjustments by “Adj.” and the new balances as “Adj. Bal.” (Be sure to add a posting reference to the journal.)
4. Prepare an adjusted trial balance.
5. Prepare an income statement, a statement of owner’s equity, and a balance sheet.*
6.
a. Journalize the closing entries on page 11 of the journal.
b. Post the closing entries. In the T accounts, identify the closing entries by “Clos.” (Be sure to add a posting reference to the journal.)
7. 7. Prepare a post-closing trial balance.
*Be sure to read the instructions for each financial statement carefully.

Chart of Accounts

CHART OF ACCOUNTS
Epicenter Laundry
General Ledger
ASSETS
11 Cash
13 Laundry Supplies
14 Prepaid Insurance
16 Laundry Equipment
17 Accumulated Depreciation
LIABILITIES
21 Accounts Payable
22 Wages Payable
EQUITY
31 Sophie Perez, Capital
32 Sophie Perez, Drawing
33 Income Summary
REVENUE
41 Laundry Revenue
EXPENSES
51 Wages Expense
52 Rent Expense
53 Utilities Expense
54 Laundry Supplies Expense
55 Depreciation Expense
56 Insurance Expense
59 Miscellaneous Expense

Labels and Amount Descriptions

Labels
Current assets
Current liabilities
Expenses
For the Year Ended June 30, 2016
June 30, 2016
Property, plant, and equipment
Revenues
Amount Descriptions
Add withdrawals
Decrease in owner’s equity
Increase in owner’s equity
Less withdrawals
Net income
Net loss
Sophie Perez, capital, June 30, 2016
Sophie Perez, capital, July 1, 2015
Total assets
Total current assets
Total expenses
Total liabilities
Total liabilities and owner’s equity
Total property, plant, and equipment

T Accounts

1. For each account listed in the unadjusted trial balance, enter the balance in the appropriate T account. Identify the balance as “Bal.”
3.b. Post the adjusting entries. Identify the adjustments by “Adj.” and the new balances as “Adj. Bal.”
6.b. Post the closing entries. In the T accounts, identify the closing entries by “Clos.” (Be sure to add a posting reference to the journal.)
Cash (Acct. 11)
Laundry Supplies (Acct. 13)
Prepaid Insurance (Acct. 14)
Laundry Equipment (Acct. 16)
Accumulated Depreciation (Acct. 17)
Accounts Payable (Acct. 21)
Wages Payable (Acct. 22)
Sophie Perez, Capital (Acct. 31)
Sophie Perez, Drawing (Acct. 32)
Income Summary (Acct. 33)
Laundry Revenue (Acct. 41)
Wages Expense (Acct. 51)
Rent Expense (Acct. 52)
Utilities Expense (Acct. 53)
Laundry Supplies Expense (Acct. 54)
Depreciation Expense (Acct. 55)
Insurance Expense (Acct. 56)
Miscellaneous Expense (Acct. 59)

Work Sheet

(Optional) On your own paper or spreadsheet, enter the unadjusted trial balance on an end-of-period work sheet and complete the work sheet.

Journal

3.a. Journalize the adjusting entries on page 10 of the journal. Adjusting entries are recorded on June 30.
6.a. Journalize the closing entries on page 11 of the journal. (Note: Complete the adjusted trial balance, the income statement, the statement of owner’s equity, and the balance sheet BEFORE completing part 6. a.)

PAGE 10PAGE 11

GENERAL JOURNAL

DATE ACCOUNT TITLE POST. REF. DEBIT CREDIT

1

Adjusting Entries

2

3

4

5

6

7

8

9

Adjusted Trial Balance

4. Prepare an adjusted trial balance.

Epicenter Laundry

ADJUSTED TRIAL BALANCE

June 30, 2016

ACCOUNT TITLE DEBIT CREDIT

1

Cash

2

Laundry Supplies

3

Prepaid Insurance

4

Laundry Equipment

5

Accumulated Depreciation

6

Accounts Payable

7

Wages Payable

8

Sophie Perez, Capital

9

Sophie Perez, Drawing

10

Laundry Revenue

11

Wages Expense

12

Rent Expense

13

Utilities Expense

14

Laundry Supplies Expense

15

Depreciation Expense

16

Insurance Expense

17

Miscellaneous Expense

18

Totals

Income Statement

5. Prepare an income statement for the year ended June 30, 2016. If a net loss has been incurred, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items other than account names. You will not need to enter colons (:) on the income statement.

Epicenter Laundry

Income Statement

1

2

3

4

5

6

7

8

9

10

11

Statement of Owner’s Equity

5. Prepare a statement of owner’s equity for the year ended June 30, 2016. No additional investments were made during the year. If a net loss has been incurred or there has been a decrease in owner’s equity, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items.

Epicenter Laundry

Statement of Owner’s Equity

1

2

3

4

5

Balance Sheet

5. Prepare a balance sheet as of June 30, 2016. Fixed assets must be entered in order according to account number. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items other than account names. You will not need to enter colons (:) or the word "Less" on the balance sheet; they will automatically insert where necessary.

Epicenter Laundry

Balance Sheet

1

Assets

2

3

4

5

6

7

8

9

10

11

12

Liabilities

13

14

15

16

17

Owner’s equity

18

19

Post-closing Trial Balance

7. Prepare a post-closing trial balance.

Epicenter Laundry

POST-CLOSING TRIAL BALANCE

June 30, 2016

ACCOUNT TITLE DEBIT CREDIT

1

Cash

2

Laundry Supplies

3

Prepaid Insurance

4

Laundry Equipment

5

Accumulated Depreciation

6

Accounts Payable

7

Wages Payable

8

Sophie Perez, Capital

9

Totals

In: Accounting