Consider the following description of an enterprise.

An auction Web site has items for sale that are provided by sellers. Each item has an opening price, a description, and ending time. Customers submit bids. The highest earliest bid submitted before the ending time is the winning bid and the item is sold to the bidder. Each seller must pay 5% of the winning bid. The auction company wants to be able to analyze the sales behavior of its customers and sellers and so must keep track of all bids and sales.

1. What entity classes are mentioned in the description?
2. List seven attributes that will be used in a data model for the auction company.
3. What relationship types exist between the entity classes of part a?
4. Give three example entities of each class listed in part a.

Speedy net service is concerned that the level of access for customers is decreasing, as a result of heavier use. The proportion of peak period time when a customer’s download speed drops by 20 percent or more below average time is considered a good measure of service level. The percentage of time a customer experiences such drops during peak periods varies. Using a sampling process, the ISP set up control charts to monitor the service level, based on proportion of below average download speed during peak periods. Construct the p-chart using the sample data in the table worksheet Prob 07-07 in the ch07data.xlsx file on the student companion site for this chapter. What does the chart show? Is the service level based on the pchart data good or bad in your opinion?

CPG Bagels starts the day with a large production run of bagels. Throughout the morning, additional bagels are produced as needed. The last bake is completed at 3 p.m. and the store closes at 8 p.m. It costs approximately $0.20 in materials and labor to make a bagel. The price of a fresh bagel is $0.60. Bagels not sold by the end of the day are sold the next day as “day old” bagels in bags of six, for $0.99 a bag. About two-thirds of the day-old bagels are sold; the remainder are just thrown away. There are many bagel flavors, but for simplicity, concentrate just on the plain bagels. The store manager predicts that demand for plain bagels from 3 p.m. until closing is normally distributed with a mean of 60 and a standard deviation of 27.

b. Suppose that the store manager is concerned that stockouts might cause a loss of future business. To explore this idea, the store manager feels that it is appropriate to assign a stockout cost of $5 per bagel that is demanded but not filled. (Customers frequently purchase more than one bagel at a time. This cost is per bagel demanded that is not satisfied rather than per customer that does not receive a complete order.) Given the additional stockout cost, how many bagels should the store have at 3 p.m. to maximize the store’s expected profit? (Round your answer to the nearest whole number.)

To maximize the store's expected profit ___?

c. Suppose the store manager has 98 bagels at 3 p.m. How many bagels should the store manager expect to have at the end of the day? (Round your answer to the nearest whole number.)

Expected left over inventory ___?

Buffalo Company sells tablet PCs combined with Internet service, which permits the tablet to connect to the Internet anywhere and set up a Wi-Fi hot spot. It offers two bundles with the following terms.

1. Buffalo Bundle A sells a tablet with 3 years of Internet service. The price for the tablet and a 3-year Internet connection service contract is $471. The standalone selling price of the tablet is $243 (the cost to Buffalo Company is $163). Buffalo Company sells the Internet access service independently for an upfront payment of $283. On January 2, 2017, Buffalo Company signed 100 contracts, receiving a total of $47,100 in cash.

2. Buffalo Bundle B includes the tablet and Internet service plus a service plan for the tablet PC (for any repairs or upgrades to the tablet or the Internet connections) during the 3-year contract period. That product bundle sells for $565. Buffalo Company provides the 3-year tablet service plan as a separate product with a standalone selling price of $159. Buffalo Company signed 180 contracts for Buffalo Bundle B on July 1, 2017, receiving a total of $101,700 in cash.

In response to competitive pressure for Internet access for Buffalo Bundle A, after 2 years of the 3-year contract, Buffalo Company offers a modified contract and extension incentive. The extended contract services are similar to those provided in the first 2 years of the contract. Signing the extension and paying $84 (which equals the standalone selling of the revised Internet service package) extends access for 2 more years of Internet connection. 40 Buffalo Bundle A customers sign up for this offer.

Prepare the journal entry when the contract is signed on January 2, 2019, for the 40 extended contracts. Assume the modification does not result in a separate performance obligation.

Prepare the journal entry on December 31, 2019, for the 40 extended contracts (the first year of the revised 3-year contract).

In each of the following examples, identify whether the person or institution will be penalized by inflation and, if so, why.

a. Mosie borrows $5,000 for her college expenses at an interest rate of 4 percent to be paid off over five years, during which time the inflation rate averages 6 percent.

b. Oscar invests $3,000 in securities that pay 5.3 percent anually for 10 years, and the inflation rate during that time averages 6.4 percent.

c. The Lilyton National Bank commits to $10 million in 15-year mortgages at an average mortgage rate of 4.5 percent. The inflation rate averages 6 percent over this 15-year period.

d. Barney bought a house in 2006 for $100,000 that he is now selling for $200,000. During this time the inflation rate has averaged 3 percent.

1.     When Netflix first started its business, what were the conditions that enabled this business work?

2.     What were the competitive advantages of Netflix over traditional video rental stores?

3.     In 2006 when Blockbuster introduced a hybrid mail and in-store rental model (Blockbuster Total Access), it seemed very obvious that Blockbuster wins a competition with Netflix. However, why do you think Blockbuster could not successfully take advantage of this opportunities and ended up with filing for bankruptcy?

4.     How can Netflix keep subscribers loyal and acquire new ones in the tougher competition with Amazon, HBO, Disney + and Hulu?

5.     Netflix growth in the US market seems to be maturing. How can Netflix increase demand for its services in the US?

The budgets of three companies yield the following information. fill in the blanks for each missing value. Carey Company: Net sales Revenue ________, Variable Costs 196,000, Fixed Costs 162,000, Operating Income (loss)__________, Units Sold 14,000, Contribution Margin per Unit__________, Contribution Margin Ratio 60%.

Doren Company: Met Sales Revenue 950,000, Variable Costs 760,000, Fixed Costs 100,000, Operating Income(loss)__________, Units Sold_________, Contribution Margin per Unit $76.00, Contribution Margin Ratio____________.

Everest Company: Net Sales Revenue___________, Variable Costs 186,300, Fixed Costs____________, Operating Income (loss) 107,800, Units Sold_____________, Contribution Margin per Unit $18.00, Contribution Margin Ratio 40%.

Rudolph Corporation is an oil well service company that measures its output by the number of wells
serviced. The company has provided the following fixed and variable cost estimates that it uses for
budgeting purposes.
Fixed Element per Month
Variable Element per Well Serviced
Revenue
$
4,500
Employee salaries and wages
$
47,400
$
1,200
Servicing materials
$
700
Other expenses
$
29,500
When the company prepared its planning budget at the beginning of July, it assumed that 34 wells
would have been serviced. However, 36 wells were actually serviced during July. The activity
variance for revenue for July would have been:
a. $10,800 U.
b. $9,000 F.
c. $9,000 U.
d. $10,800 F.

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer this question is to look at row B, the annual company percentage increase in revenue, versus row A, the CEO's annual percentage salary increase in that same company. Suppose that a random sample of companies yielded the following data:

Do these data indicate that the population mean percentage increase in corporate revenue (row B) is different from the population mean percentage increase in CEO salary? Use a 5% level of significance. Find (or estimate) the P-value.