1. A consumer buys a television made by XYZ company from Town Electronics. The
consumer hosts a party to watch a football game. The TV explodes, injuries the consumer (who
becomes paralyzed from the neck down), guests and damages the house. The consumer’s wife is
not injured. Describe what tort suits may be brought, by whom, on what theories and the
damages that may be sought and from whom?

2. John is a 41 year old white male who works for NewCo. His female boss, a 38 year-old
female Vice President named Mary, has tried to seduce John several times, but John has rebuffed
her advances. Although everyone in the company gets a 3 percent raise, Mary gives John only a
1 percent raise, telling him that “you know what you need to do to get a bigger raise.” John
complains to the President of NewCo, who tells John to “don’t be an old fart, do what you need
to do to get ahead in this company.” John says he will not, and the next day, he is fired and is
replaced by a 38 year old man who John later learns slept with Mary and got a raise the next day.
What claims does John have against NewCo? Please make reference to the appropriate statutes
by name.

A small town with one hospital has 4 ambulances to supply ambulance service. Requests for ambulances during nonholiday weekends average 0.68 per hour and tend to be Poisson-distributed. Travel and assistance time averages 2.40 hours per call and follows an exponential distribution Use Table 1.

a. Find system utilization. (Round your answer to the nearest whole percent. Omit the "%" sign in your response.)

System utilization             %

b. Find the average number of customers waiting. (Round your answer to 3 decimal places.)

Average number of customers            

c. Find the average time customers wait for an ambulance. (Round your answer to 3 decimal places.)

Average time             hour

d. Find the probability that all ambulances will be busy when a call comes in. (Round intermediate calculations to 3 decimal places and final answer to 2 decimal places.)

Probability  

Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow:

o Sales are budgeted at $380,000 for November, $390,000 for December, and $400,000 for January.
o Collections are expected to be 70% in the month of sale, 27% in the month following the sale, and 3% uncollectible.
o The cost of goods sold is 65% of sales.
o The company desires to have an ending merchandise inventory equal to 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
o Other monthly expenses to be paid in cash are $22,000.
o Monthly depreciation is $20,000.
o Ignore taxes.

The cash balance at the end of December would be:   

Answer using excel and please provide excel instructions for all outputs meaning what formula was used to calculate the output and how was it implemented using excel and which excel functions to use. Thank you.

Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company in its finance department. One of the major revenue‐producing items manufactured by Conch Republic is a smart phone. Conch Republic currently has one smart phone model on the market and sales have been excellent. The smart phone is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current smart phone has limited features in comparison with newer models. Conch Republic spent $500,000 to develop a prototype for a new smart phone that has all the features of the existing one but adds new features such as wifi tethering. The company has spent a further $200,000 for a marketing study to determine the expected sales figures for the new smart phone. Conch Republic can manufacture the new smart phone for $175 each in variable costs. Fixed costs for the operation are estimated to run $3.1 million per year. The estimated sales volume is 75,000, 92,000, 95,000, 80,000, and 50,000 per year for the next five years, respectively. The unit price of the new smart phone will be $400. The necessary equipment can be purchased for $25.5 million and will be depreciated on a seven‐year MACRS schedule. It is believed the value of the equipment in five years will be 1.5 million. Net working capital for the smart phones will be 12 percent of sales and will occur with the timing of the cash flows for the year (i.e., there is no initial outlay for NWC). Changes in NWC will thus first occur in Year 1 with the first year's sales. Conch Republic has a 33 percent corporate tax rate and a required return of 12 percent. Shelly has asked Jay to prepare a report that answers the following questions:

QUESTIONS 1. What is the payback period of the project?

2. What is the profitability index of the project?

3. What is the IRR of the project?

4. What is the NPV of the project?

5. Perform a sensitivity analysis for the price of the new smart phone. Measure the effects on NPV by moving price 5% up and down.

6. Perform a sensitivity analysis for the quantity of phones sold. Measure the effects on NPV by moving quantity 5% up and down.

7. Should Conch Republic produce the new smart phone?

8. Suppose Conch Republic loses sales on other models because of the introduction of the new model. How would this affect your analysis?

HelloFresh is at the forefront of disrupting a multi-trillion-dollar industry at the very beginning of its online transition. HelloFresh is a truly local food product, uniquely suited to individual tastes and meal-time preferences offering delivery of a giant box of delicious food with recipes to enable easy and enjoyable meal preparation for a weekly fee. HelloFresh aims to provide each and every household in its 7 markets with the opportunity to enjoy wholesome home-cooked meals with no planning, no shopping, and no hassle required. Everything required for weeknight meals, carefully planned, locally sourced and delivered to your door at the most convenient time for each subscriber. Behind the scenes, a huge data driven technology platform puts us in the prime position for disrupting the food supply chain and for fundamentally changing the way consumers shop for food. HelloFresh has local founders across the globe who are able to leverage the global platform, and at the same time ensure that the HelloFresh product in each market truly reflects the local community. The soft subscription model business enables us to leverage our weekly subscriber touchpoint to consistently manage supply chains and demand, and to optimize the customer experience as well as our business economics. Customers sign-up for a box containing between 2 and 5 meals per week for a flat fee. If the customer is out of town or unavailable he can easily cancel any week without a penalty provided they notify HelloFresh in advance. Dominik Richter has been CEO since starting HelloFresh in 2011. He has responsibility for keeping a general oversight of the business and strategy. Prior to HelloFresh, Dominik worked with Goldman Sachs in London. Dominik graduated with a degree in International Business in 2009, and from the London School of Economics in 2010 with a Masters in Finance. Thomas Griesel has been responsible for the logistics and operations behind HelloFresh since founding with Dominik in 2011. Previously, Thomas had spent time at OC&C Strategy Consultants and worked on a range of his own businesses and ideas. He graduated with a degree in International Business Administration in 2009, and from the London Business School in 2010 with a Masters in Management. 2011 All the way back in 2011, Dominik and Thomas arrived in Berlin, intent on starting a new and disruptive business. With a love of healthy food, nutrition, cooking, and a desire to make access to healthy food as easy as possible for as many people as possible - starting a Food at Home business seemed the natural choice. 2012 After examining business models from Sweden to Japan to very local ideas, they and a group of like-minded individuals formulated the recipe for HelloFresh. The team started early in 2012 packing shopping bags in Berlin, Amsterdam and London with a view to target the highest density population areas in Europe. Quite quickly, they started getting requests from people outside those areas who all wanted to become a part of the HelloFresh family. Wanting to serve as many people as possible, the team developed a logistics model that enabled them to deliver to every single household across a given country. 2013 The HelloFresh product started to rapidly gain in popularity, as subscribers shared the excitement about their weekly boxes, with friends and colleagues. Subscriber referrals accelerated, as it became clear that HelloFresh had finally solved the "What's for dinner tonight" problem for its subscribers. 2014 Having launched on the East Coast of the U.S in December 2012, HelloFresh moved to cover the entire country in September 2014. Over the short time since then, HelloFresh has grown rapidly to become one of the largest players in this market. QUESTIONS Do you consider HelloFresh a form of disruptive or sustaining technology? Is HelloFresh an example of Web 1.0 (ebusiness) or Web 2.0 (Business 2.0)? Describe the ebusiness model associated with HelloFresh. Describe the revenue model associated with HelloFresh.

1. A random sample of 64 second graders in a certain school district are given a standardized mathematics skills test. The sample mean score is 51.58. Assume the standard deviation for the population of test scores is 15. The nationwide average score on this test us 50. The school superintendent wants to know whether the second graders in her school district have greater math skills than the nationwide average. Perform the hypothesis test and compute the P value. Based on your P value, what is the conclusion if we test at 0.05 level of significance?

2. Suppose that the mean price of a home in Denver, Colorado in 2008 was 225.3 thousand dollars. A random sample of 49 homes sold in 2010 had a mean price of 200.1 thousand dollars. A real estate firm wants to test to see if the mean price of 2010 differs from the mean price in 2008. Assume that the population standard deviation is 140. Perform the hypothesis test and compute the P value. Based on your P value, what is the conclusion if we test at the 0.05 level of significance?

Your parents have accumulated a $150,000 nest egg. They have been planning to use this money to pay college costs to be incurred by you and your sister, Courtney. However, Courtney has decided to forgo college and start a nail salon. Your parents are giving Courtney $18,000 to help her get started, and they have decided to take year-end vacations costing $12,000 per year for the next four years. Use 6 percent as the appropriate interest rate throughout this problem. Use Appendix A and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods.

a. How much money will your parents have at the end of four years to help you with graduate school, which you will start then? (Round your final answer to 2 decimal places.)

b. You plan to work on a master’s and perhaps a PhD. If graduate school costs $22,500 per year, approximately how long will you be able to stay in school based on these funds? (Round your final answer to 2 decimal places.)

In some states, high school students must pass a graduation test before they are able to receive their high school diplomas. Suppose the students are given up to three chances to pass the exam. If they pass it, they don't need to take it again. If they do not pass the test on the first try, they take it a second time. If they don't pass on the second try, they take it a third time. From past data, we know that 78% of students pass the test the first time, while 85% of students who take it a second time pass on the second try, and 60% of students who take it a third time pass on the third try.

a) What percent of students are not allowed to graduate because of their performance on the exam? Enter your answer as a percent, rounded to the nearest tenth of a percent

b) What percent of students take the test three times? Enter your answer as a percent, rounded to the nearest tenth of a percent

c) What percent of students pass a graduation test and receive their high school diplomas? Enter your answer as a percent, rounded to the nearest tenth of a percent.