Please, solve with Excel and provide step by step details and formulas.
Simulation using Excel only platform
Results
Total number of 'Wins' can be found using formula =SUM(L:L)
This is coming 152. This means that only 15.2% chance exists for making any profit. This is also clear from the histogram as 85% of the time there is no profit.
--------------------------------
To compare for Bid amount $13,000 and $15,000, change the cell $C$2 accordingly,
For $13,000
SUM(L:L) = 330 so, the probability of making a profit = 33%
For $15,000SUM(L:L) = 69 so, the probability of making a profit = 6.9%
Please, solve with Excel and provide step by step details and formulas. A contractor has found...
Please provide solution through excel with formulas please. Thank You! 3. (25 points) In order to be ready for the upcoming holiday season, BTS Toy Company (BTC) designed a new doll called The V that teaches children how to dance. The fixed cost to produce the doll is $105,000. The variable cost, which includes material, labor, and shipping costs, is $35 per doll. During the holiday selling season, FTC will sell the dolls for $45 each. If BTC overproduces the...
Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...
Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...
if you could please provide a step by step explanation I would really appreciate it Discrete Random Variables Question 23. Let Y Bin(17,0.25) denote the binomially distributed random variable mea- suring the number of times an archer hits the bullseye. Calculate the probability that the archer scores exactly one or two arrows in the bullseye. Question 24. A dairy factory produces eleven buckets of milk and records the masses in kilograms. Compute to three decimal places the population mean and...
Question 1 [12 + 4 =16 marks] A. Let A and B be two events such that P( A) 0.6 , P(B) 0.4 and P( A B) 0.10. Calculate P( A B). Calculate P( A | B). iii. Are events A and B independent? Justify your answer. iv. Are events A and B mutually exclusive events? Justify your answer. (2 + 2 + 3 + 3 = 10 marks) B. A box contains 20 DVDs,...
****PLEASE READ THE VALUES**** Jeri Cooper, the sales manager of Brunners Corporation, is getting worried. Her last three bids were rejected in favor of a bid from a new competitor to the market. Now, she is putting together a bid for a potential new customer, and she wants to make sure the price is competitive, but still profitable. As the managerial accountant at Brunners, your job is to help Jeri prepare bids by providing the most accurate cost estimates. Brunners...
please help with 3 question in detail on excel. thank you CASE STUDY The Sourcing Decision at Forever Young Forever Young is a retailer of trendy and low-cost apparel in the United States. The company divides the year into four sales seasons of about three months each supplier costs 55 yuan/unit (inclusive of all delivery and brings in new merchandise for each season. The company has historically outsourced production to China given the lower costs. Sourcing from the Chinese costs),...
usion (24 points) Two firms are playing a repeated Bertrand game infinitely, each with the same marginal cost 100. The market demand function is P-400-Q. The firm who charges the lower price wins the whole market. When both firms charge the same price, each gets 1/2 of the total market. I. Coll A. (6 points) What price will they choose in the stage (only one period) Nash equilibrium? What price will they choose if in the stage game (only one...
Please answer question 1,2,3 in details and explanation CASE 4 HELPING HAND ACCOUNTING FUNDAMENTALS "I got real lucky when I was fired," William Pendleton was fond of telling his employees and business associates. Pendleton was an insurance salesman in Illinois nea hobby, he loved to tinker around the house and he developed a local reputation as a person who knew how to "fix things." Pendleton decided to capitalize on this reputation and opened a hardware store, Helping Hand, based on...
Sarah Drogo, president of Storage, Inc. a company that makes a wide variety of storage boxes for home and office use, is thinking about adding a new line of small plastic storage boxes. This would require a new technology. The company currently uses predominantly cardboard of various weights that are used in its other products. Since this is a big move for the company, Sarah wants to make sure that all of the financial and nonfinancial implications are understood before...