Jason runs a bakery that sells two kinds of cookies. Jason knows the bakery must make at least 72 and at most 280 trays of the Fluffy Deliciousness. The bakery must also make between 4 and 288 trays of the White Chocolate Blizzards. The trays of Fluffy Deliciousness take 16 ounces of sugar, while trays of White Chocolate Blizzards require 7 ounces of sugar. The bakery only has 5488 ounces of sugar available. If trays of Fluffy Deliciousness generate $2.66 in income, and trays of White Chocolate Blizzards generate $1.72, how many trays of the cookies should Jason have the bakery make to get the most income?

Jason runs a bakery that sells two kinds of cookies. Jason knows the bakery must make at least 72 and at most 280 trays of the Fluffy Deliciousness. The bakery must also make between 4 and 288 trays of the White Chocolate Blizzards. The trays of Fluffy Deliciousness take 16 ounces of sugar, while trays of White Chocolate Blizzards require 7 ounces of sugar. The bakery only has 5488 ounces of sugar available. If trays of Fluffy Deliciousness generate $2.66 in income, and trays of White Chocolate Blizzards generate $1.72, how many trays of the cookies should Jason have the bakery make to get the most income?

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.
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3
A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.
A manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
In an oil company, its south refinery produces per day 300 barrels of high grade oil, 200 barrels of medium grade oil and 150 barrels of low grade oil. The cost of operation of this refinery amounts to P 600,000 per day. The north refinery of the company produces each day 100 barrels of high grade oil and 100 barrels of medium-grade oil and 150 of low-grade oil. Which has a total of P500,000 operational costs. If the company’s production requirement is at least 900 barrels for high-grade oil, 800 barrels for medium-grade oil, and 750 for low-grade oil, how many days, are required for each refinery to operate to obtain the minimum cost?
Plainwell Polymers is going to producing the main dashboard structure for a new car design. The dashboard will be produced in three colors with expected daily demand as follows: Black: 365 units/day Grey: 110 units/day Tan: 210 units/day The injection-molding machine can produce a total of 1,090 parts per day running 24 hours per day. It costs Plainwell $1,040 to set up each color for producition and the daily holding cost for each part is $0.49. What is the length of the lowest cost cyclic schedule (ignoring setup time constraints) in days?
The interContinental Hotel at Tsim Sha Tsui has 100 total rooms available for Dec 31. There are two types of customers, business customers and leisure customers. InterContinental charges a high rate of $300/night and a low rate of $120/night. High-rate guests do not need pre-booking and has time flexibilities; low-rate guests need pre-booking. Assume business customers always take the high rate option and leisure customers always take the low rate option. Leisure customers always book far earlier before business customers and there are sufficient leisure customers. Which of the following actions would increase the optimal protection level for business customers? Increase both the high and low rates by a factor of two Decrease the high rate from $300 to $200 Decrease both the high and low rates by half O Decrease both the high and low rates by $20 O Increase both the high and low rates by $20
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…