Alma has decided to purchase a cell phone with Internetaccess and must choose a rate plan. The “occasional-user”plan is $0.50/minute, regardless of how many minutes ofair time are used. The “frequent-user” plan charges a flatrate of $55/month for 70 minutes of air time plus$0.33/minute for any time over 70 minutes. The “executive” plan charges a flat fee of $75 per month for 100minutes of air time plus $0.25/minute over 100 minutes. Inthe interest of simplicity, Alma has decided to go with theoccasional-user plan to start with and then upgrade as shesees fit at a later date.a. How much air time per month would Alma need touse before she upgrades from the occasional-user planto the frequent-user plan?b. At what usage rate should she switch from thefrequent-user plan to the executive plan?

Alma has decided to purchase a cell phone with Internetaccess and must choose a rate plan. The “occasional-user”plan is $0.50/minute, regardless of how many minutes ofair time are used. The “frequent-user” plan charges a flatrate of $55/month for 70 minutes of air time plus$0.33/minute for any time over 70 minutes. The “executive” plan charges a flat fee of $75 per month for 100minutes of air time plus $0.25/minute over 100 minutes. Inthe interest of simplicity, Alma has decided to go with theoccasional-user plan to start with and then upgrade as shesees fit at a later date.a. How much air time per month would Alma need touse before she upgrades from the occasional-user planto the frequent-user plan?b. At what usage rate should she switch from thefrequent-user plan to the executive plan?

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.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
There are four fare classes on a flight with the following rates: Y: $800 B: $500 M: $350 T: $200 The EMSR of the next seat is $425. According to EMSRa, what is the lowest fare class open? Y M T B
Global Logistics needs to rent space for storing product for the next three years. The following information regarding the demand and spot price is available. Current demand for the product is 150,000. Historically, Global Logistics has required 1500 square feet to store 1500 units of the product. Demand for the product can go up by 20% with a probability of 0.7 or down by 20% with a probability of 0.3. Global Logistics can sign a three-year fixed lease to rent 150,000 square feet of space at $1.00 per square foot per year. The firm may also choose to obtain warehousing space on the spot market. The current spot market price is $1.20 per square foot per year. The spot price can go up by 10% with a probability of 0.8 and can decrease by 10% with a probability of 0.2. The firm receives a revenue of $1.22 for each unit of demand. a) Create a decision tree showing period 0, 1 and 2 for the scenario described above. b) Calculate the NPV for the option when the firm decides to sign a…
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
Smith Inc. is a retail mail order firm that currently uses a centralized collection system that requires all checks to be sent to its flotation headquarters. An average of 6 days is required for mailed checks to be received, 3 days for Smith Inc. to process them, and 2 days for the checks to clear through its bank. A proposed lockbox system would decrease the mailing and processing time to 2 days and the check clearing time for 1 day. Smith Inc. has an average daily collection of P250,000. If Smith Inc. adopts this proposed lockbox system, its average cash balance will increase by. A. 1.2M B. 450k C. 750k D. 2M
Mytown’s street department repaves a street every 8 years. Potholes cost $15,000 per mile beginning at the end of Year 3 after construction or repaving. The cost to fix potholes generally increases by $15,000 each year. Repaving costs are $200,000 per mile. Mytown uses an interest rate of 8%. What is the EUAC for Mytown’s policy? What is the EUAC for the optimal policy? What is the optimal policy?The plant manager may purchase a piece of unusual machinery for $10,000. Its resale value after 1 year is estimated to be $3000. Because the device is sought by antique collectors, resale value is rising $500 per year.
As part of their application for a loan to buy Lakeside Farm, a property they hope to develop as a bed-and-breakfast operation, the prospective owners have projected: Monthly fixed cost (loan payment, taxes, insurance, maintenance) $6000 Variable cost per occupied room per night $ 20 Revenue per occupied room per night $ 75 Write the expression for total cost per month. Assume 30 days per month. Write the expression for total revenue per month. How many rooms they need to sell per night in order to break even? Suppose 5 rooms can be sold per night, how much they should charge per night in order to breakeven?
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines of industrial chassis for the rack mounting of Internet routers, modems, and other telecommunications equipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per pound and for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of a Standard chassis rack and $15 contribution on a Deluxe chassis rack. During the next production cycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or in chassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16 pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal. The output of metal sheeting is restricted only by the capacity of the polisher. For the next production cycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassis manufacture…
Grand Garden is a hotel with 140 suites. Its regular suite price is $210 per night per suite. The hotel’s total cost per night is $150 per suite and consists of the following. Variable cost $ 110 Fixed cost 40 Total cost per night per suite $ 150 The hotel manager receives an offer to hold the local Bikers’ Club meeting at the hotel in March, which is the hotel’s slow season with a low occupancy rate per night. The Bikers’ Club would reserve 120 suites for one night if the hotel accepts a price of $118 per night.(a) What is the contribution margin from this special offer?(b) Should the Bikers’ Club offer be accepted or rejected?