Pete Morton is planning to go to graduate school in a program of study that will take three years. Pete wants to have $13,000 available each year for various school and living expenses. If he earns 8 percent on his money, how much must be deposited at the start of his studies to be able to withdraw $13,000 a year for three years? (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)

Pete Morton is planning to go to graduate school in a program of study that will take three years. Pete wants to have $13,000 available each year for various school and living expenses. If he earns 8 percent on his money, how much must be deposited at the start of his studies to be able to withdraw $13,000 a year for three years? (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
A quarry uses five types of rocks to fulfill four orders. The gypsum content, availability of each type of rock, and the production cost per pound for each rock, as well as the size of each order and the minimum and maximum gypsum percentage in each order, are given below.Rock type-------Cost-------% gypsum-------Amount Available1-------------------$1.00-----------2.0%-----------5002-------------------$5.00-----------5.0%-----------6003-------------------$5.50-----------4.5%-----------7004-------------------$2.00-----------3.0%-----------4005-------------------$1.20-----------6.0%-----------450 Order No.--------------------1----------2----------3---------4Order Size------------------500------600------500------350Min % gypsum-----------3.5%-----3.8%-----4.0%-----3.6%Max % gypsum----------4.4%-----4.6%-----4.7%-----4.8%What is the cheapest way to fill the orders?
Travel Co. specializes in trans-American moves for businesses and individuals through the shipment of containers. For every container the company transports via rail, Travel Co. must pay the rail owners $5,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.40. Harry plans to charge $0.68 per pound to his customers. How many pounds would a container have to hold in order for the company to Break Even? What would the total revenue be at Break Even? The company finds out that to maintain the integrity of its containers, each container could only hold an average of 16,000 pounds. What would the company have to charge customers to make $7,000 in profit on each container?
ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.The company finds out that to maintain the integrity of its containers, each container could only hold an average of 8,000 pounds. What would the company have to charge customers to make $5,000 in profit on each container?
An oil company ships to three different customers. Customer A requires 60 tons per year, Customer B requires 24 tons, and Customer C requires 8 tons. The product costs $10,000 per ton, and holding costs are estimated at 25%. Each truck costs $800 to send as a fixed cost and incurs an additional $250 charge for each stop it makes. Each truck can haul 12 tons of the product. What is the optimal delivery policy if the oil company ships to each customer individually? What is the optimal delivery policy if the oil company aggregates all shipments to the customers?
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
Optimal Lot Size problem: A meat packing firm estimates that it will sell 10,000 tons of beef during the coming year. Cold storage for beef costs $5.00 per ton, and it costs the firm $700 each time it shifts from processing poultry to beef. What is the optimal lot size?
The Sanders Garden Shop mixes two types of grass seed into a blend. Each type of grass has been rated (per pound) according to its shade tolerance, ability to stand up to traffic, and drought resistance, as shown in the table. Type A seed costs $1 and Type B seed costs $2. If the blend needs to score at least 300 points for shade tolerance, 400 points for traffic resistance, and 750 points for drought resistance, how many pounds of each seed should be in the blend? Type A Type B Shade Tolerance 1 1 Traffic Resistance 2 1 Drought Resistance 2 5 Formulate a LP Model for this problem.
VITRAN Bus Services purchases diesel fuel from Domino Gas Supply. In addition to fuel cost, Domino Gas Supply charges VITRAN Bus Services $250 per order to cover the expenses of delivering and transferring the fuel to VITRAN Bus Services storage tanks. The lead time for new shipment from Domino Gas Supply is 10 days, the cost of holding a gallon of fuel in the storage tanks is $0.04 per month, or $0.48 per year and the annual usage of fuel is 150,000 gallons. VITRAN Bus Services buses operate 300 days a year. What is the optimal order quantity for VITRAN Bus Services? How frequently should VITRAN Bus Services order to replenish the gasoline supply?
Flanger is an industrial distributor that sources from hundreds of suppliers. The two modes of transportation available for inbound shipping are LTL (less than truck- load) and TL (truckload). LTL shipping costs $1 per unit, whereas TL shipping costs $500 per truck. Each truck can carry up to 1,000 units. Flanger wants a rule assigning products to shipping mode (TL or LTL) based on annual demand. Each unit costs $50, and Flanger uses a holding cost of 22 percent. Flanger incurs a fixed cost of $150 for each order placed with a supplier. a. Determine a threshold for annual demand above which TL is preferred and below which LTL is preferred. b. How does the threshold change [relative to part (a)] if unit cost is $150 (instead of $50 ) with all other data unchanged? Which mode becomes preferable as unit cost grows? c. How does the threshold change [relative to part (a)] if the LTL cost comes down to $0.8 per unit (instead of $1 per unit)?
PROBLEM The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash investment. They have determined that the cost of either investing in or selling marketable securities is $100. By looking at Book Warehouse’s past cash needs, they have determined that the variance of daily cash flows is $20,000. Book Warehouse’s opportunity cost of cash, per day, is estimated to be 0.03%. Based on experience, management has determined that the cash balance should never fall below $10,000. 1. How much is the cost per transaction?(Use a number, no decimal value, no commas, no currency, no space) * 2. How much is the return point based on the Miller-Orr model of cash management? (Use a number, no decimal value, no commas, no currency, no space) * 3. How much is the upper limit based on the Miller-Orr model of cash management?(Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS. THANKS!
The Robot Company franchises combination gas and car wash stations throughout the United States. Robot gives a free car wash for a gasoline fill-up is about the same as far a wash alone, charges $0.50. Past expericnce shows that the number of customers that have car washes following fill-ups is about the same as for a wash alone. The average profit on a gasoline fill-up is about $0.70, and the cost of the car wash to Robot is $0.10 Robot stays open 14 hours per day. Robot has three power units and drive assemblies, and a franchisee must select the unit prefered Unit I can wash cans at the rate of one every five minutes and is leased for $12 per day. Unit I, a larger unit, can wash cars at the rate of one every four minutes but costs $16 per day. Unit II, the largest, costs $22 per day and can wash a car in three minutes. The franchisee estimates that customers will not wait in line more than five minutes for a car wash. A longer time will cause Robot to lose the gasoline sales as well…