Question: Please use excel to make the simulation 1 7 Siblings Kyle and Anna have a business selling cupcakes at neighborhood tennis courts. In exchange for

Please use excel to make the simulation

Please use excel to make the simulation 1 7

1 7 Siblings Kyle and Anna have a business selling cupcakes at neighborhood tennis courts. In exchange for working the concession stand, they get to sell their cupcakes to spectators and participants from the concession stand at the complex. They have been keeping track of their demand (including requests made after they had sold out) for the past 100 tournaments, and observed the pattern shown below. Cupcakes Number of Demanded tournaments 11 12 1 13 4 14 15 12 16 19 17 19 18 15 16 20 14 21 6 22 1 23 2 24 2 25 26 Total 100 The cupcakes cost 95 cents to make, and Kyle and Anna sell them for 3 dollars. Assume they bake 24 cupcakes each tournament. For health reasons, they must throw away unsold cupcakes. Simulate their sales for 70 tournaments and determine their earnings. Keep track of cupcakes thrown away and customers that went away without a cupcake. 19 1 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Refer to the facts in Tax Form/Return Preparation Problem C:9-58. Now assume the company is an S corporation rather than a partnership. Additional facts are as follows: Drs. Bailey and Firth formed...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

General Information Overview of the Exercise This exercise involves the sale of a house, agents, and electronic mail ("email"). The buyer and seller are physically distant from the property, and have...

Hello, I need help with with Return of the Tallahassee Beancounters Case (the 2010 version). The solution and teachers handouts for the 2003 version have already been made available, however it's...

MGT411 Innovative and Creative Business Thinking University of Phoenix Material Organizational Ecosystem Case Study Wal-Mart Stores, Inc. is a leading company in its industry and a widely recognized...

Beta = 0.66 Risk-free rate, r RF = 3.0% Market risk premium, RP M = 5.0% Forecasted 2022 Dividend (D 1 ) = $1.68 c. Set up a simple Excel data table where you show how the estimated intrinsic value...

please use excel to make life easy and show the equations, please and thank you Micromedia offers computer training seminars on a variety of topics. In the seminars, each student works at a personal...

Below you can find the problem I need you to solve. As you will notice is similar to the one I sent you before. The only difference is the in this case the WACC must be used to calculate the present...

Please use this information to answer the questions above. If more information is required, it can be found under the 2021 considation sheets for Apple Inc. Please use excel and make the formuals...

Define the terms relative performance contract and rolling financial forecast. What role for these is envisioned by critics of the traditional budgeting process?

Find the area of the lot in Problem 10.25. In Problem 10.25 Determine the lengths and bearings of the sides of a lot whose corners have the following X and Y coordinates (in feet): A (5000.00,...

8 Automatic software updates are used by many mobile phone companies. The following flowchart shows the procedure for updating mobile phone software automatically overnight. Seven of the boxes in the...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...