1. A startup in Dallas is analyzing the decision to launch a new drone. The development costs...
Question:
1. A startup in Dallas is analyzing the decision to launch a new drone. The development costs are estimated to be $100,000. The material and labor costs for each drone is estimated to be $11.62 and $12.40 respectively. The revenue per unit will be $28.52. Use Goal Seek to find the exact breakeven point. (Number of drones)
2. A Los Pollos Hermanos restaurant in Albuquerque usually has sales with a mean of 30.45 orders/hour and a standard deviation of 4.2. What are the median and range of orders/hour using Monte Carlo simulation for 500 trials? (25)
3. A French vineyard in the Chalibis region uses Chardonnay grapes to make Chardonnay wine and Blanc be Blancs blended champagne. To produce one gallon of wine, the vineyard uses 8 pounds of grapes and 2.5 hours of winemaking process. To produce one gallon of Blanc de Blancs, about 6 pounds of grapes and 3 hours of winemaking process is used. The selling prices of Chardonnay and Champagne per gallon are $55 and $45 respectively. Each week, 400 pounds of Chardonnay grapes and 150 hours of wine processing are available.
How many gallons of Chardonnay and champagne should the vineyard make?
If the amount of grapes available increases to 500 pounds, how much Chardonnay and champagne should the vineyard make?
If the price of champagne drops to $30 per liter, how much Chardonnay and champagne should the vineyard?