You have been given charge of organizing the company picnic. The local resort where you want...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been given charge of organizing the company picnic. The local resort where you want to organize the event requires that you specify in advance how many people will be present (called the order amount) and charges a per person fee of $150 for them. There are no refunds if fewer people show up. However, the resort will accommodate last minute requests for additional attendees at a cost of $250 per person. The company would like to encourage employees and their family members to attend and it is important that nobody is turned away. However, budgets are tight and so it is also important to minimize the cost of the event. In the past there has been considerable variation in the number of people who show up. After some thought, you decide that no fewer than 125 people will show up, that the most likely number showing up will be 175, and the maximum number showing up can be 275. Hence you decide to model the number of people showing up using a triangular distribution with these three parameters. This distribution can generate a non-integer number of people showing up ? so round to the nearest integer. 1. What?is?the?@Risk?formula?that?describes? (generates)?the?random?number?of?people?showing?up?for?the?picnic? Suppose you decide to estimate the number of people showing up at the picnic by the number most likely to show up (i.e. 175). This is entered as the order amount. Construct the @Risk model that will allow you to compute the cost of the picnic to the company. Use the model to compute (1) the expected cost, (ii) the standard deviation, and (ii) maximum cost. Include your annotated @Risk model. [Run the simulation for 500 iterations using a random number generator seed of 123. 1. Now?use?the?simulation?model?to?come?up?with?the?optimal?order?amount?to?specify?in?the?contract?from?the?following? possibilities:?160,?165,2170,2175,2180,?185,?190?and?195.? 2. Suppose the charge for additional attendees is $350 instead of $250. Does this change your optimal order amount? How? What if the charge for additional attendees is the same (i.e. $150)? You have been given charge of organizing the company picnic. The local resort where you want to organize the event requires that you specify in advance how many people will be present (called the order amount) and charges a per person fee of $150 for them. There are no refunds if fewer people show up. However, the resort will accommodate last minute requests for additional attendees at a cost of $250 per person. The company would like to encourage employees and their family members to attend and it is important that nobody is turned away. However, budgets are tight and so it is also important to minimize the cost of the event. In the past there has been considerable variation in the number of people who show up. After some thought, you decide that no fewer than 125 people will show up, that the most likely number showing up will be 175, and the maximum number showing up can be 275. Hence you decide to model the number of people showing up using a triangular distribution with these three parameters. This distribution can generate a non-integer number of people showing up ? so round to the nearest integer. 1. What?is?the?@Risk?formula?that?describes? (generates)?the?random?number?of?people?showing?up?for?the?picnic? Suppose you decide to estimate the number of people showing up at the picnic by the number most likely to show up (i.e. 175). This is entered as the order amount. Construct the @Risk model that will allow you to compute the cost of the picnic to the company. Use the model to compute (1) the expected cost, (ii) the standard deviation, and (ii) maximum cost. Include your annotated @Risk model. [Run the simulation for 500 iterations using a random number generator seed of 123. 1. Now?use?the?simulation?model?to?come?up?with?the?optimal?order?amount?to?specify?in?the?contract?from?the?following? possibilities:?160,?165,2170,2175,2180,?185,?190?and?195.? 2. Suppose the charge for additional attendees is $350 instead of $250. Does this change your optimal order amount? How? What if the charge for additional attendees is the same (i.e. $150)?
Expert Answer:
Answer rating: 100% (QA)
1 The Risk formula that describes generates the random number ... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
You have been given the following return data on 3 assetsF, G, and Hover the period 20152018. Using these assets, you have isolated 3 investment alternatives: Alternative Investment 1 ........ 100%...
-
You have been given the following information about ALG Co. Ltd., which uses a standard cost system in accounting for its one product: 1. In the month of November 2016, 5,000 units were produced. 2....
-
You have been given the following information about ALG Co. Ltd., which uses a standard cost system in accounting for its one product: 1. In the month of November 2012, 5,000 units were produced. 2....
-
What is the average US Gross of movies? What is the average Budget of movies? What is the average Run time of movies? Place the plot of Budget and US Gross here.
-
Contrast the position of being short with that of being long in futures contracts.
-
Junes Java provides coffee services (coffee, cups, cream, sugar, and coffee makers) to local companies for use in their offices. Each of five drivers has a truck with inventory and has a different...
-
Mr. Tam is the front man for the Asian American dance-rock band The Slants. Mr. Tam named his band The Slants to reclaim and take ownership of Asian stereotypes. The band draws inspiration for its...
-
The Broughton Cap Company requires that prenumbered receiving reports be completed when purchased inventory items arrive in the receiving department. At the time of receipt, the receiving clerk...
-
Discuss the importance of an object-oriented database. How does it differ from the relational model?
-
Prime Contractors (Prime) is a privately owned company that contracts with the U.S. government to provide various services under multiyear (usually five-year) contracts. Its principal services are as...
-
Two firms, each domiciled in its respective country and having foreign operations in the others, are seeking to use a swap agreement to reduce their borrowing costs while hedging their currency...
-
What information can you obtain from each of these statements? Examine Director's Resource 5-2: Income Statement, and Director's Resource 5-3: Statement of Financial Position.
-
A share of wells Fargo stock is paid a dividend of $3/share which is expected to grow at 2% annually. If the investor paid $1 for every share purchased at $40 and has 5% required rate of return, what...
-
IThe cost of replacing an existing building with a comparable substitute building, using modern construction methods and materials, is called:n Chapter eight we leIn the " Income Approach to Value"...
-
Hankins Corporation has 6.5 million shares of common stock outstanding, 322,000 shares of 4.7 percent preferred stock outstanding, par value of $100, and 75,000 5.5 percent semiannual bonds...
-
Wildly Successful Incorporated became so successful and profitable that on the advice of their accounting firm they decided to use a holding company when branching off certain services. Active...
-
You purchased an asset three years ago at a cost of $135,000 and sold it today for $82,500. The equipment is 5-year property for MACRS. The MACRS table values are 2000, 3200, 1920, 1152, 1152, and...
-
Consider the advantages and disadvantages of extending property rights so that everyone would have the right to prevent people imposing any costs on them whatsoever (or charging them to do so).
-
Repeat M7-8, except assume Literacy for the Illiterate uses a perpetual inventory system and it sold 600 units between January 9 and January 28. Refer M7-8 In its first month of operations, Literacy...
-
Match each situation below to two applicable reasons that require an adjustment to be made. . Delta Airlines provided flights this month for cus- A. Revenue has been earned. tomers who paid cash last...
-
For each of the following situations, indicate whether it represents an accounting error and explain why it is or is not an error. Also state whether a trial balance would indicate that an error...
-
A newspaper recently lowered its price from $5.00 to $3.00. As it did, the number of newspapers sold increased from 240,000 to 280,000. a. What was the newspapers elasticity of demand? b. Given that...
-
Suppose average movie ticket prices are $8.50 and attendance is 1.2 billion. The price of tickets rises to $9.50 and attendance rises to 1.4 billion. a. What happened to total revenue? b. If you were...
-
Which of the following producers would you expect to support a tax on beer? Which would not? Explain your answer. a. Producers of hard liquor. Cross-price elasticity with beer: 0.11. b. Producers of...
Study smarter with the SolutionInn App