The seasonal yield of olives greatly increases by a process of branch pruning instead of olives by normal process. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 250 hours of labor available and a total of 150 acres for growing. A barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $30. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. The best combination of barrels of pruned and regular olives in order to earn maximum profit X1(barrels of pruned) and X2( barrels of regular olives) One of the constraints of the problem is Select one: 2X1+5X2<=250 30X1+20X2<=250 2X1+2X2<=250 5X1+2X2<=250 5X1+2X2>=250

The seasonal yield of olives greatly increases by a process of branch pruning instead of olives by normal process. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 250 hours of labor available and a total of 150 acres for growing. A barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $30. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. The best combination of barrels of pruned and regular olives in order to earn maximum profit X1(barrels of pruned) and X2( barrels of regular olives) One of the constraints of the problem is Select one: 2X1+5X2<=250 30X1+20X2<=250 2X1+2X2<=250 5X1+2X2<=250 5X1+2X2>=250

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.
Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
In order to produce 1000 units of X in a week  units X is scheduled weekly for Operation B (due to 5% scrap ratio)  units X is scheduled weekly for Operation A (due to 2% scrap ratio) Based on your answer in part a, find the number of machines required to produce 1000 units of X per week.  The total time required to perform Operation B = minutes per week  The total time required to perform Operation A = minutes per week H= Available Time in a week = minutes /week Thus FA = . FB = . Since both of the operations A and B are performed on the same machine  machines are required
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. Question Why is the capacity design important?
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. In design capacity it is assume that the company will produce in best and ideal condition to produce goods and services while in Effective capacity it is assume that company will produce in current operating conditions. In design capacity it is assume that the company have unlimited resource's. It means these resource's include:- Men,…
Casting molds are produced by MYMOLD company. Each order has unique specifications, depending on customer needs. MYMOLD has received an order of two molds from a customer. The agreed selling price of the molds is 5000TL per mold. According to the agreement, for a defective mold the customer will pay 1000TL instead of the standard price. The customer will not buy any more than two molds and there is a 2000 TL fine for not meeting the demand with two non-defective molds. The excess molds can be salvaged for 500 TL per piece. The cost of production per mold is 2000TL and the probability of producing a non-defective mold is 0.8. Assume that MYMOLD decided to produce two molds, and the first production has been succesfull (a non-defective mold is produced). What is the expected profit given the result of the first production?
. A commercial orchard grows, picks, and packs apples and pears. A peck (quarter bushel) of apples takes 4 minutes to pick and 5 minutes to pack; a peck of pears takes 5 minutes to pick and 4 minutes to pack. Only one picker and one packer are available. How many pecks each of apples and pears should be picked and packet every hour (60 minutes) if the profit is $3/peck for apples and $2/peck for pears? Solve graphically as a linear program and confirm analytically.
3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z? A) 28.73 B) 39.27 C) 0 D) 1E + 30 3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally? A) $0 B) $9.09 C) $29.00 D) $158.18
Luther’s company has just received an order for 1,200 of its Flying Z machines. The customer wants 350 of them next year, 400 the year after, and the balance in the third year. Luther estimates that after one year of production, the average worker with this one year of experience can produce 12 machines per year. However, new workers are 25% less productive in the first year. He has 25 workers with at least one year of experience to work on the first year’s order. He will need to hire new workers for any production that exceeds what these workers can produce. To further complicate matters, he believes 10% of his current experienced workforce will turnover at the end of the first year and the number of workers from his current workforce should remain steady after that. His history also shows that only 75% of new hires stay after their first year. Given these facts, how many total people should Luther plan to hire over the duration of this order? Please solve in excel. Group of answer…
The annual maintenance costs of a machine that has been in use for 3 years are 300 TL, 350 TL and 375 TL, respectively. The machine is expected to be available for 8 years after purchase. The maintenance costs foreseen for the coming years are 400 TL in the first year and 150 TL in the following years. If the machine is sold today, it can be sold for 1500 TL, and in the following years for 1000 TL. What is the optimum regeneration time of the machine if the MCVO is 10%?