The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives eight free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:
| Rental cost for the auditorium: | $150 | |
| Registration Processing: | $8.50 | per person |
| Speaker Costs: 3@$800 | $2,400 | |
| Continental Breakfast: | $4.00 | per person |
| Lunch: | $7.00 | per person |
| Parking: | $5.00 | per person |
| (a) | The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but for nonmembers who do not attend, 50% of the price will be refunded. Build a spreadsheet model in Excel that calculates a profit or loss based on the number of nonmember registrants. Extend the model you developed for the Business Intelligence Symposium to account for the fact that historically, 25% of members who registered do not show and 10% of registered nonmembers do not attend. The center pays the caterer for breakfast and lunch based on the number of registrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allotment of tickets and 127 nonmembers register? | |||||
|
If required, round your answers to two decimal places.
|
In: Accounting
Required information
[The following information applies to the questions displayed below.]
Warnerwoods Company uses a periodic inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||||
| Mar. | 1 | Beginning inventory | 160 | units | @ $50 per unit | |||||||||
| Mar. | 5 | Purchase | 460 | units | @ $55 per unit | |||||||||
| Mar. | 9 | Sales | 480 | units | @ $85 per unit | |||||||||
| Mar. | 18 | Purchase | 240 | units | @ $60 per unit | |||||||||
| Mar. | 25 | Purchase | 320 | units | @ $62 per unit | |||||||||
| Mar. | 29 | Sales | 280 | units | @ $95 per unit | |||||||||
| Totals | 1,180 | units | 760 | units | ||||||||||
For specific identification, the March 9 sale consisted of 60 units from beginning inventory and 420 units from the March 5 purchase; the March 29 sale consisted of 100 units from the March 18 purchase and 180 units from the March 25 purchase.
4. Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places and final answers to nearest whole dollar.)
In: Accounting
[The following information applies to the questions
displayed below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 150 | units | @ $52.00 per unit | |||||||
| Mar. | 5 | Purchase | 250 | units | @ $57.00 per unit | |||||||
| Mar. | 9 | Sales | 310 | units | @ $87.00 per unit | |||||||
| Mar. | 18 | Purchase | 110 | units | @ $62.00 per unit | |||||||
| Mar. | 25 | Purchase | 200 | units | @ $64.00 per unit | |||||||
| Mar. | 29 | Sales | 180 | units | @ $97.00 per unit | |||||||
| Totals | 710 | units | 490 | units | ||||||||
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 90 units from beginning inventory and 220 units from the March 5 purchase; the March 29 sale consisted of 70 units from the March 18 purchase and 110 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.)
In: Accounting
The following information applies to the questions displayed
below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 150 | units | @ $52.00 per unit | |||||||
| Mar. | 5 | Purchase | 250 | units | @ $57.00 per unit | |||||||
| Mar. | 9 | Sales | 310 | units | @ $87.00 per unit | |||||||
| Mar. | 18 | Purchase | 110 | units | @ $62.00 per unit | |||||||
| Mar. | 25 | Purchase | 200 | units | @ $64.00 per unit | |||||||
| Mar. | 29 | Sales | 180 | units | @ $97.00 per unit | |||||||
| Totals | 710 | units | 490 | units | ||||||||
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 90 units from beginning inventory and 220 units from the March 5 purchase; the March 29 sale consisted of 70 units from the March 18 purchase and 110 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.)
In: Accounting
Required information
[The following information applies to the questions
displayed below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 160 | units | @ $52.20 per unit | |||||||
| Mar. | 5 | Purchase | 255 | units | @ $57.20 per unit | |||||||
| Mar. | 9 | Sales | 320 | units | @ $87.20 per unit | |||||||
| Mar. | 18 | Purchase | 115 | units | @ $62.20 per unit | |||||||
| Mar. | 25 | Purchase | 210 | units | @ $64.20 per unit | |||||||
| Mar. | 29 | Sales | 190 | units | @ $97.20 per unit | |||||||
| Totals | 740 | units | 510 | units | ||||||||
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 95 units from beginning inventory and 225 units from the March 5 purchase; the March 29 sale consisted of 75 units from the March 18 purchase and 115 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.)
In: Accounting
[The following information applies to the questions
displayed below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 70 | units | @ $50.40 per unit | |||||||
| Mar. | 5 | Purchase | 210 | units | @ $55.40 per unit | |||||||
| Mar. | 9 | Sales | 230 | units | @ $85.40 per unit | |||||||
| Mar. | 18 | Purchase | 70 | units | @ $60.40 per unit | |||||||
| Mar. | 25 | Purchase | 120 | units | @ $62.40 per unit | |||||||
| Mar. | 29 | Sales | 100 | units | @ $95.40 per unit | |||||||
| Totals | 470 | units | 330 | units | ||||||||
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 50 units from beginning inventory and 180 units from the March 5 purchase; the March 29 sale consisted of 30 units from the March 18 purchase and 70 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.)
In: Accounting
Identify the applicable accounting convention for the following business scenario and explain your choice
The Morrison Company receives much of its revenue from those customers who buy or rent furniture and appliances on the installment plan. Because the company uses an accrual-based accounting system, revenue is recognized at the point of sale, even though cash comes in on a monthly basis from customers. Lately, the company's accountant is questioning the use of the accrual basis for recognizing revenue, because several customers have defaulted on their contracts, causing problems in the accounting system.
In: Accounting
Direct mail advertisers send solicitations ("junk mail") to thousands of potential customers in the hope that some will buy the company's product. The response rate is usually quite low. Suppose a company wants to test the response to a new flyer and sends it to1030 people randomly selected from their mailing list of over 200,000 people. They get orders from 104 of the recipients. Use this information to complete parts a through d.
a) Create a 90% confidence interval for the percentage of people the company contacts who may buy something.
(__%___%)
(Round to one decimal place as needed.)
In: Statistics and Probability
Read Case Ticketmaster – Making Better Decisions passage below and answer the following questions 1-4 in bold :
Case Study: Ticketmaster
In 2010, Ticketmaster found out the hard way that the entertainment
industry is not, in fact, as recession-proof as it was once widely
believed to be. The company, which sells tickets for live music,
sports, and cultural events, and which represents a significant
chunk of parent company’s Live Nation Entertainment’s business, saw
a drop in ticket sales that year of a disconcerting 15 percent.
Then there was the mounting negative press, including artist
boycotts, the vitriol of thousands of vocal customers, and a number
of major venues refusing to do business with Ticketmaster.
Yet 2012 has been more friendly to the company—under the
leadership of former musician and Stanford MBA- educated CEO Nathan
Hubbard, who took over in 2010 when Ticketmaster merged with Live
Nation, the country’s largest concert promoter. Third-quarter
earnings were strong, with just under $2 billion in revenue, a 10
percent boost from the same period last year, driven largely by
Live Nation’s ticketing and sponsorship divisions. Ticketmaster was
largely responsible as well, thanks to the sale of 36 million
tickets worth $2.1 billion, generating $82.1 million in adjusted
operating income, which translates to an increase of 51 percent for
the year.
That’s because Hubbard knows how to listen, and read the writing on
the wall, “If we don’t disrupt ourselves, someone else will,” he
said, “I’m not worried about other ticketing companies. The Googles
and Apples of the world are our competition.”
Some of the steps he took to achieve this included to the creation of Live Analytics, a team charged with mining the information (and related opportunities) surrounding 200 million customers and the 26 million monthly site visitors, a gold mine that he thought was being ignored. Moreover Hubbard redirected the company from being an infamously opaque, rigid and inflexible transaction machine for ticket sales to a more transparent, fan-centered e-commerce company, one that listens to the wants and needs of customers and responds accordingly. A few of the new innovations rolled out in recent years to achieve this include an interactive venue map that allows customers to choose their seats (instead of Ticketmaster selecting the “best available”) and the ability to buy tickets on iTunes.
Hubbard eliminated certain highly unpopular service fees, like
the $2.50 fee for printing one’s own tickets, which he announced in
the inaugural Ticketmaster blog he created.
Much to the delight of event goers—and the simultaneous chagrin of
promoters and venue owners, who feared that the move would deter
sales—other efforts toward transparency included announcing fees on
Ticketmaster’s first transaction- dedicated page, instead of
surprising customers with them at the end, while consolidating
others. “I had clients say, ‘What are you doing? We’ve been doing
it this way for 35 years,’” Hubbard recalled, “I told them, ‘You
sound like the record labels.’”
Social media is an integral part of listening, and of course, “sharing.” Ticketmaster alerts on Facebook shows friends of purchasers who is going to what show. An app is in the works that will even show them where their concert going friends will be seated. Not that it’s all roses for Ticketmaster—yet. Growth and change always involve, well, growing pains, and while goodwill for the company is building, it will take some time to shed the unfortunate reputation of being the company that “everyone loves to hate.” Ticketmaster made embarrassing headlines in the first month of 2013 after prematurely announcing the sale of the president’s Inaugural Ball and selling out a day early as a result, disappointing thousands. But as the biggest online seller of tickets for everything from golf tournaments to operas to theater to rock concerts, and with Hubbard’s more customer-friendly focus, Ticketmaster should have plenty of opportunity to repent their mistake
1. Identify the problems that Ticketmaster was facing, using cause and effect analysis. What were the Symptomatic Effects? What were the Underlying Causes?
2. What process(es) did Nathan Hubbard use to Generate Alternatives? What alternatives were available to Mr. Hubbard? What types of Uncertainty did he experience?
3. How did Mr. Hubbard select his most desirable alternative? Describe which type of Decision Making he used, and explain your findings.
4. Were the recent decisions that Mr. Hubbard made effective, according to the concepts in Chapter 7 – Decision Making? Explain your response.
In: Operations Management
In: Economics