A firm offers three different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $13 each for the firs- 65 units, $12 each for units 66-130, and $11 for each unit over 130. Product 2's profitability is $17 each for the first 40 units, $16 each f units 41-80, and $15 each for each unit over 80. The products each require 3 raw materials to produce (see table below for usages and available quantities). Product 1 usage (pounds per unit) 5 Available Quantity (pounds) 2,300 1,700 1,100 Product 2 usage (pounds per unit) Raw Material 7 7 15 15 Use 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 the nearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.)

A firm offers three different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $13 each for the firs- 65 units, $12 each for units 66-130, and $11 for each unit over 130. Product 2's profitability is $17 each for the first 40 units, $16 each f units 41-80, and $15 each for each unit over 80. The products each require 3 raw materials to produce (see table below for usages and available quantities). Product 1 usage (pounds per unit) 5 Available Quantity (pounds) 2,300 1,700 1,100 Product 2 usage (pounds per unit) Raw Material 7 7 15 15 Use 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 the nearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Like many students at college, Arturo struggles to find a parking space on campus. Every year he has to buy a parking permit, which allows him to park on campus. Unfortunately, buying a permit does not guarantee that he can find a parking spot. So he often gets to campus well before class starts, hoping to find a good parking spot, but ends up driving around until someone leaves. One day after his economics class, Arturo comes up with a potential solution to the problem. He suggests the following: Suppose the demand for parking is given by the following equation: Qp = 10,000 - 500P. At Arturo's school, there are 7,000 parking spaces for students. For the questions below, give all answers to the nearest whole number. a. At most universities, students do not pay to park each day. They pay for a permit, which only allows them to park on campus. Therefore, the price students face each day is $ Unfortunately, this creates a shortage of parking spaces. b. The university, in order to prevent…
eBook Problem 15-27 (Algorithmic) Gubser Welding, Inc., operates a welding service for construction and automotive repair jobs. Assume that the arrival of jobs at the company's office can be described by a Poisson probability distribution with an arrival rate of four jobs per 8-hour day. The time required to complete the jobs follows a normal probability distribution, with a mean time of 1.4 hours and a standard deviation of 1 hour. Answer the following questions, assuming that Gubser uses one welder to complete all jobs: a. What is the mean arrival rate in jobs per hour? If required, round your answer to two decimal places. per hour b. What is the mean service rate in jobs per hour? If required, round your answer to four decimal places. per hour c. What is the average number of jobs waiting for service? If required, round your answer to three decimal places.
Kara wants to build a business. She has plenty of capital and potential investors and partners. She wants to avoid the burden of sole liability for her business and wants to be able to close the business when she is no longer interested in it. Which of the following would lead Kara to choose a sole proprietorship organization for her business? Avoidance of sole liability Ability to close the business easily Many potential investors/partners Plenty of capital
A conflict of interest can occur when a decision maker’s personal interests interfere to the extent that he or she makes decisions that adversely affect customers or employees. True False
The partnership agreement of Jones, King, and Lane provides for the annual allocation of the business's profit or loss in the following sequence: Jones, the managing partner, receives a bonus equal to 25 percent of the business's profit. Each partner receives 19 percent interest on average capital investment. Any residual profit or loss is divided equally. The average capital investments for 2021 were as follows: Jones $ 125,000 King 250,000 Lane 375,000 The partnership earned $58, 000 net income for 2021. Prepare a schedule showing how the 2021 net income should be allocated to the partners. (Loss amounts should be indicated with a minus sign.)
Describe the steps that are used to resolve constraint issues.
North Platt Machinery Company manufactures a shaft that must fit inside a sleeve. The firm has just received an order of 53,000 units from Southernstar Exploration Company for $48 per unit. North Platt can manufacture the shaft at $18 per unit. Southernstar desires the diameter of the shaft to be 1.278 cm. The diameter of the shaft must not be less than 1.253 cm in order to fit properly inside the sleeve. To be able to insert the shaft into a sleeve without the use of force, the diameter cannot be larger than 1.303 cm. A defective shaft is discarded and a replacement has to be shipped via express freight to locations around the world. North Platt estimates that the average cost of handling and shipping a replacement shaft will be approximately $38. Shown below are the diameters from a sample of 100 shafts manufactured during a trial run: Diameter 1.235 1.243 1.253 1.261 1.265 1.273 1.275 Number of Units 2 3 4 3 3 4 7 Diameter 1.276 1.277 1.278 1.279 1.280 1.283 1.291 Number of Units 7…