A firm offers three different prices on Its products, depending upon the quantity purchased. Since available resources are limited, thefirm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $18 each for the first90 units, $17 each for units 91-180, and $16 for each unit over 180. Product 2's profitability is $12 each for the first 65 units, $11 each forunits G6-130, and $10 each for each unit over 130. The products each require 3 raw materlals to produce (see table below for usagesand available quantities).Product 1 usage (poundsProduct 2 usage (poundsper unit)Available QuantityRaw Materialper unit)(pounds)2,5002,e002,3001110Use separable programming to find the optimal production plan.(Leave no cells blank - be certain to enter "0" wherever required. Round the first two answers (units of Product 1 and 2) to thenearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.)units of Product t andunits of Product 2The total profit from this plan will be

Decision variables - x11= product 1 with a profit of $18 per unit x12= product 1 with a profit of…

Answered: A firm offers three different prices on…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

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.
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.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Kpogas produces chairs and tables. Using economic forecast for the next month, Kpogas’ marketing manager has judged that during that period, it will be possible to sell as many chairs or tables as the company can produce. Management must now recommend a production target for next month. That is, how many chairs and tables should be produced if Kpogas’ management wishes to maximize next month’s profit contribution? Making this decision requires a consideration of the following key factors: ● Kpogas’s unit contribution margin is GH¢ 5,000 on each chair that is sold and GH¢ 4,000 on each table that is sold. ● Each product is put through Kpogas’s machining operations in both department A and department B. For next month’s production, the two departments have 150 and 160 hours available time, respectively. Each chair produced uses 10 hours of machining in department A and 20 hours of machining in department B, whereas each table produced uses 15 hours of machining in department A and 10…
6. A dessert shop plans to purchase a new commercial ice cream maker to replace the old one. They are deciding on two models: Model SUPER costs $3,000 for purchase and $1 in average to make one serving of ice cream. Model PRO costs $5,000 for purchase and a lower cost of $0.8 to make one serving of ice cream. The shop is selling $4 per ice cream serving in average. What would be the monthly demand (in servings) to make Model PRO more preferred? Select one: a. at least 16,000 servings b. no more than 10,000 servings c. at least 10,000 servings d. model PRO is always preferred. e. always no preference.
A small publishing company is planning to publish a new book. The production costs will include one-time fixed costs (such as editing) and variable costs (such as printing). There are two production methods it could use. With one method, the one-time fixed costs will total $49,465, and the variable costs will be $11.25 per book. With the other method, the one-time fixed costs will total $19,240, and the variable costs will be $19 per book. For how many books produced will the costs from the two methods be the same?
You have been hired by Kia as manager for its Pakistan operations. Assume following is the short-run production function at their assembly plant outside Karachi: Q = 10L2 – 0.5 L3 where L is variable input labor, Q is output of Cars assembled a. At the end of the year it is expected that output will double with purchase ofnew equipment and machinery. The production function is estimated to be Q = 60L.30K.70 where L is labor and K is capital. Suppose initial L1 = 1 and K1 = 1. When inputs are in increased to L2 = 2 and K2 = 2, do you observe increasing, decreasing or constant returns to scale? b. Assume Kia Head Office is considering hiring more laborers either at their Gwadar plant or alternatively at the Karachi plant. What will be your advice if workers’ marginal product is 40 at wage of Rs=5/hour in Karachi and marginal product is 28 at wage of Rs=4/hour in Gawdar?
Rainbow Inc's products are given below. If the company's total labor capacity is 3200 hours/week, which of the products should be produced in a week? Regarding with this plan what will be the total sales and total variable costs of the firm per week? Total Labor Hour Demand Product / Unit Price / Unit vC / Unit (unit) XC610 2,500 1,000 300 XD740 4 3,100 1,500 250 ZS650 3 1,850 750 400 ST340 2 2,250 975 500
Jody of Jody’s Custom Tailoring is considering expanding her growing business. The question is whether to expand with a bigger facility than she needs or with a small facility, knowing that she will have to reconsider expanding in three years. Jody has estimated the following chances for demand: The likelihood of demand being high is 0.50. The likelihood of demand being low is 0.50. She has also estimated profits for each alternative: Large expansion has an estimated profitability of either $200,000 or $100,000, depending on whether demand turns out to be high or low. Small expansion has a profitability of $80,000, assuming that demand is low. Small expansion with an occurrence of high demand would require considering whether to expand further. If the business expands at that point, the profitability is expected to be $120,000. If it does not expand further, the profitability is expected to be $70,000. Draw a decision tree and solve it. What should Jody’s Custom Tailoring do?
11. Shown below are the planning period's demand and the standard hours required for four products from a company's sales and operations plan. Assume that the company has 65,000 hours of labor available during the planning period, and determine whether the sales and operations plan is feasible. Product Units Demanded Standard Hours (in hours/unit) A 32,500 0.60 B 23,000 0.80 0 40,000 0.20 D 15,000 1.15
. A 100 cu.m. pit is to be excavated using a hydraulic excavator with a rate of 7.1 cu.m. per hour. The rental price of the hydraulic excavator is P12,600.00 per day. If the excavator is used 8 hours per day, determine the equipment cost to finish the excavation work. 18-21. The material cost of a certain scope of work has a total of P250,500.00. Determine the number of days to finish the work if they are using 3 tools that has a rental price of P760.00 per day each. Use (Labor Cost + Equipment Cost)/Material Cost = 30% Workers Salary per day P1050.00 P650.00 P480.00 P320.00 Project Engineer Foreman 2 Skilled Laborer 3 Laborer

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS