Suppose you put $10,000 into a CDwith an annual percentage yield of 6.15%. After one month, the CD is worth10000 + 10000 * 6.15 / 1200 = 10051.25After two months, the CD is worth10051.25 + 10051.25 * 6.15 / 1200 = 10102.76After three months, the CD is worth10102.76 + 10102.76 * 6.15 / 1200 = 10154.53and so on.Write a program that prompts the user to enter an amount (e.g., 10000), the annualpercentage yield (e.g., 6.15), and the number of months (e.g., 18) and displays atable as shown in the sample run. Enter the initial deposit amount: 10000↵EnterEnter annual percentage yield: 6.15↵EnterEnter maturity period (number of months): 18↵EnterMonth CD Value1 10051.25 2 10102.76...17 10907.9018 10963.81

Suppose you put $10,000 into a CDwith an annual percentage yield of 6.15%. After one month, the CD is worth10000 + 10000 * 6.15 / 1200 = 10051.25After two months, the CD is worth10051.25 + 10051.25 * 6.15 / 1200 = 10102.76After three months, the CD is worth10102.76 + 10102.76 * 6.15 / 1200 = 10154.53and so on.Write a program that prompts the user to enter an amount (e.g., 10000), the annualpercentage yield (e.g., 6.15), and the number of months (e.g., 18) and displays atable as shown in the sample run. Enter the initial deposit amount: 10000↵EnterEnter annual percentage yield: 6.15↵EnterEnter maturity period (number of months): 18↵EnterMonth CD Value1 10051.25 2 10102.76...17 10907.9018 10963.81

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter23: Simulation With The Excel Add-in @risk

Section23.10: Using Data To Obtain Inputs For New Product Simulations

Problem 1P

See similar textbooks

Similar questions

You own a fruit shop. You buy fruit from suppliers by weight (cost per kg), and then you sell it either loose or pre-packaged for a fixed price. For example, a typical sale could be: 1. Apples Pink Lady 1.360kg x $3.50/kg = $4.76 2. Pears Golden 3.400kg x $1.75/kg = $5.95 3. Apples Green Smith 2.180kg x $2.50/kg = $5.45 4. Breakfast package 2x $5/pk = $10 5. Mandarins package 1x $3/pk = $3 -- Total $29.16 Where "Breakfast package" might consist of: a. Bananas Cavandish 500g b. Apples Green Smith 500g c. Mandarin Imperial 500g And "Mandarins package" is: a. Mandarins Imperial 600g b. Mandarins Queens 400g Question ----------- How can I create a relational database schema to record stock and sales? MYSQL
Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest rate. Then, divide the…
You and your friends decided to hold a “Secret Santa” gift exchange, where each person buys a gift for someone else. To see how this whole thing works, let’s consider the following example. Suppose there are 7 people A, B, C, D, E, F, and G. We denote x → y to mean “x gives a gift to y.” If the gift exchange starts with person A, then they give a gift to E. Then E gives a gift to B. And it is entirely possible that B gives a gift to A; in such a case we have completed a “cycle.” In case a cycle occurs, the gift exchange resumes with another person that hasn’t given their gift yet. If the gift exchange resumes with person D, then they give a gift to G. Then G gives a gift to F. Then F gives a gift to C. Then finally C gives a gift to D, which completes another cycle. Since all of the people have given their gifts, the giftexchange is done, otherwise the gift exchange resumes again with another person. All in all, there are two cycles that occurred during the gift exchange: A → E → B → A…
Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment.If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profitof 4.5 dollar.For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% where for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. Investment will always be greater or equal to 25,000 and multiple of 100.Complete the RECURSIVE methods below that take an array of integers (investments)and an iterator (always sets to ZERO(‘0’) when the…
You found an exciting summer job for five weeks. It pays, say, $15.50 per hour. Suppose thatthe total tax you pay on your summer job income is 14%. After paying the taxes, you spend10% of your net income to buy new clothes and other accessories for the next school yearand 1% to buy school supplies. After buying clothes and school supplies, you use 25% of theremaining money to buy savings bonds. For each dollar you spend to buy savings bonds,your parents spend $0.50 to buy additional savings bonds for you. Write a flowchart that prompts the user to enter the number of hours you worked each week. The program thenoutputs the following:a. Your income before and after taxes from your summer job.b. The money you spend on clothes and other accessories.c. The money you spend on school supplies.d. The money you spend to buy savings bonds.e. The money your parents spend to buy additional savings bonds for you.
Suppose you open a small shop and can't pay electronically. There are only four kinds of coins in the cashbox: 25 cents, 10 cents, 5 cents and 1 cent. If you are a salesperson and want to change 41 cents for customers, how can you arrange to give customers the right amount of money and the least number of coins? The idea:Take the coin with largest denomination without exceeding the remaining amount of cents, make the locally best choice at each step.
Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment. If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profit of 4.5 dollar. For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% where for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. Investment will always be greater or equal to 25,000 and multiple of 100. Complete the RECURSIVE methods below that take an array of integers (investments) and an iterator (always sets to…
Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment. If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profit of 4.5 dollar. For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% whereas for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. The investment will always be greater or equal to 25,000 and multiple of 100. Complete the RECURSIVE methods below that take an array of integers (investments) and an iterator (always sets to…
You are considering developing a new product. Forecastyear 1 sales are for 80,000 units, and the year 1 price is$4.00 per unit. In file Simidata.xls you are given data onseven similar products from the past. (See Figure 63.)For example,For product 1, actual sales were 92.26% of forecast sales.Year 2 price (in real dollars) was 76.7% of year 1 price.Year 2 demand was 30.7% more than year 1 demand.Product 1 only sold for 6 years.The risk-adjusted discount rate is 11% per year. We assumethat the price index will climb 5% per year.We are unsure about the fixed cost of developing theproduct. It is equally likely to be $50,000 or $150,000. Weare also unsure about the year 1 variable cost of producingit. It is equally likely to be $1, $1.50, or $2. After year 1,variable cost will climb by 5% per year. It costs $3 to buildone unit of annual capacity.a Assuming 80,000 units of annual capacity, estimatethe 10-year risk-adjusted NPV of this product.b What capacity level do you recommend?
Suppose we use the following KB (where x,y,z are variables and r1, r2, r3, goal are constants) to determine whether a particular robot can score a) Open(x) ∧ HasBall(x) -> CanScore(x) b) Open(x) ∧ CanAssist(y,x) ∧ HasBall(y) -> CanScore(x) c) PathClear(x,y) -> CanAssist(x,y) d) PathClear(x,z) ∧ CanAssist(z,y) -> CanAssist(x,y) e) PathClear(x,goal) -> Open(x) f) PathClear(y,x) -> PathClear(x,y) g) HasBall(r3) h) PathClear(r1, goal) i) PathClear(r2, r1) j) PathClear(r3, r2) k) PathClear(r3, goal) Intuitively, CanScore(x) means x can score on goal. CanAssist(x,y) means there exists some series of passes that can get the ball from x to y. Open(x) means x can shoot on goal directly. And PathClear(x,y) means the path between x and y is clear. Provide a SLD-derivation for the query CanScore(x) in which the answer provided is r1. Provide a SLD-derivation for the query CanScore(x) in which the answer provided is r3. How many "distinct" derivations (i.e., involving different…
Consider the following scenario: Question: "What type of ticket do you require, single or return?" IF the customer chooses "return": Ask: "What rate, Standard or Cheap-Day?" IF the customer replies "Cheap Day" Say: That will be $11.20 ELSE Say: That will be $19.50 ELSE Say: "That will be $9.75 ENDIF What is the minimum number of tests that are needed to ensure that all the questions have been asked, all combinations have occurred and all replies are given? a. 3 b. 5 c. 6 d. 4
You are a professor who has a summer business that makes custom sheds. During the three monthsof operation, you do not know the demand, but you know it will be 1 or 2 sheds for each month, andeach choice is equally likely. There is a storage cost of $100 per shed in each month that you haveany held over, and the most you can hold over is 3 sheds. Every month that you make any shedscosts you $300 to rent shop space, and each shed costs you an additional $200 in materials. You sellsheds during the summer for $1500 each, and any that are left over at the end of the summer yousell to a woodworker for $200 each.(a) Use probabilistic dynamic programming to determine an optimal production schedule.