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 corporate member of the center (there are currently 10) receives five 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 Registration processing Speaker costs Continental breakfast Lunch Parking $150 $8.50 per person (3 speakers $800 each) $4.00 per person $7.00 per person $5.00 per person a) Build a spreadsheet model that calculates a profit or loss based on the total number of 100 nonmember registrants. b) Use Goal Seek to find the number of nonmember registrants that will make the event break even. c) 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 nonmembers who do not attend will be refunded 50% of the price. Extend the model you developed in a) 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 pays for parking only for those who attend. What is the profit if each corporate member registers their full allotment of tickets and 127 nonmembers register? d) Use a two-way data table to show how profit changes as a function of number of registered nonmembers and the no-show percentage of nonmembers. Vary the number of nonmember registrants from 80 to 160 in increments of 5 and the percentage of nonmember no-shows from 10 to 30% in increments of 2%.
please show the excel and work
In: Statistics and Probability
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 twelve 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
1. Which of the following is NOT counted when calculating the U.S. GDP using the income approach
A. after-tax profits (dividends) paid to the Japanese owners resulting from the activity of the Toyota Motor Manufacturing plant that operates in Kentucky, US.
B. the wage compensation paid to a Japanese plant manager who has been helping run (on-site) the Kentucky factory for this past year.
C. interest paid to domestic lenders by the state of Kentucky for a loan made to cover a temporary shortfall in the unemployment benefit payments system due to a large number of workers that had been laid off by Toyota Motor Manufacturing, Kentucky
D. business taxes paid to the local government by Toyota Motor Manufacturing plant that operates in Kentucky.
E. wages and salaries paid to domestic workers at Toyota Motor Manufacturing (a Japanese owned brand) in Kentucky, US.
2. Which of the following statements is TRUE?
A. Depreciation is not included in current GDP.
B. GNP is calculated by subtracting from GDP the balance of trade (i.e. the difference between imports and exports).
C. Since personal taxes are not included in GDP when calculating GNP they must be added back.
D. GNP is, by definition, a larger dollar value than GDP.
E. Current GDP does not include the market value of final goods and services produced domestically in a different time period.
In: Economics
In: Economics
You work for Shrad Ltd (a small Canadian importing firm). Shrad Ltd is interested in having your help to manage the exchange rate exposure on its foreign currency transactions. In your first month the firm agrees to buy goods from a US supplier. Payment of US$10,000,000 is to be made in 90 days. To help with your decisions, you obtain the following information from the international money markets.
Exchange Market
Spot (C$/US$1) 1.5870/1.5886
Forward (C$/US$1) 90 days 1.5898/1.5908
Money Market Rates (annual)
90 day C$ interest rates 1.575 / 1.545%
90 day US$ interest rate 1.200 / 1.000%
Over the counter options
90 day options on C$ with strike price of C$1.60/US$1:
Premium C$50,000 for a US$10million contract.
Use 90 and 360 days in your calculations.
i. Determine the C$ value of the US$ payable if you lock in this amount using a forward contract.
ii. Describe how Shrad Ltd could construct a money market hedge for this situation. Present and explain your calculations in detail.
iii. Draw a diagram that illustrates the risk profile of the underlying risk facing Shrad Ltd, the forward contract and the option contract (y axis effective revenue, x axis C$/US$). Determine the exchange rate, C$/$, at which the option hedge would produce a better outcome for the firm than the forward hedge and also the exchange rate at which the option hedge would produce a better outcome than being unhedged.
In: Finance
A starting lineup in basketball consists of two guards, two
forwards, and a center. a. A certain college team has
on its roster three centers,
four guards, four forwards, and one individual (X) who can play
either guard or forward. How many different starting lineups can be
created? [Hint: Consider lineups without X, then lineups with X as
guard, then lineups with X as forward.]
b. Now suppose the roster has 5 guards, 5 forwards, 3
centers, and 2 “swing players” (X and Y) who can play either guard
or forward. If 5 of the 15 players are randomly selected, what is
the proba- bility that they constitute a legitimate starting
lineup?
In: Statistics and Probability
TRUE OR FALSE.Write True if the statement is correct and False if the statement is wrong. (10 pts.)_____
1. Investment management is also known as portfolio management._____
2. The largest financial fund are firms that exhibit all the complexity of demands._____
3. The internal auditors are the one who took account of the institutions’ own money and cost._____
4. The financial controllers are the one who examines the internal system of the organization._____
5. The important of investment management is to formulate a suitable portfolio strategy._____
6. Successful fund managers are expensive and headhunted by competitions._____
7. The objectives of individual investors are to maximize return on investment._____
8. Investment management is not important to the investors._____
9. Investment managers would not require a discipline process of funds.
In: Finance
As you are considering the various functions of self, how might how we view ourselves impact how we view others? For example, in DQ1 we have been discussing biases and how easy it is to judge an individual by appearances. How do self-concept and self-perception influence our judgments of others? According to research conducted by Horton (2003), “The physical attractiveness stereotype (i.e., inferences regarding the sociability and integrity of the target) was contingent upon self-perception. Participants who rated themselves highly on attractiveness regarded attractive targets as more sociable (marginally so) and as having more integrity than did those participants who regarded themselves as less attractive” (p. 146).
In: Psychology
MBA-AC721 Project Part 2 Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel workbook for BRBC Budgeted Income Statement and create the 2018 budget using the following information.
Budgeted Sales of Bike C: Online 75,000 bikes; instore 5,000 bikes. Bike C is purchased from Built-Right Bike Company, a sister company in the Biltmore Bicycle Corporation (BMBC), for $52 and is sold for $104.
Inventory: Beginning inventory: $ 52,000
Purchases 4,108,000
Sales ?
Ending Inventory $ 52,000
Employees:
Managerial Staff: Manager: 1 FTE, $45,000 annual salary plus 20% benefits
Bookkeeper: 1 FTE, $40,000 annual salary plus 20% benefits
Purchasing & Receiving Supervisor: 1 FTE, $35,000 annual salary plus 20% benefits Other staff: Warehouse: 2.5 FTEs make $15 per hour plus 17% benefits Online sales staff: 2 FTEs, $15 per hour plus 17% benefits (no commission)
NOTE: 1 FTE = 2080 hours
Store Hours: Monday – Saturday 10:00 am – 6:00 pm
2 sales clerks work from 10-3 M-F
3 sales clerks work from 3-6 M-F
4 sales clerks work 10-6 on Saturdays
Sales clerks earn $15 per hour plus 17% benefits Instore sales staff share commission equal to 10% of instore sales.
Budgeted Utility cost: $13,200
Budgeted Marketing Cost: $175,000
Contributions & community service: 10% of instore revenue
Other costs (includes depreciation, insurance, etc): $1,300,000
Income tax 29% of Net Revenue
In: Accounting
Disintermediation refers to: a. Financial institutions preferring to move away from individual accounts to corporate accounts. b. Government providing alternatives to normal deposit accounts so as to reduce the dependence of the economy on depository institutions. c. The FED reducing its performance and involvement in the open market economy. d. The movement of funds more directly than indirectly through financial institutions.
Which agency is a major regulator of Banks?
In: Finance