An electronics firm produces two models of pocket calculators: the A-100 (A), which is an inexpensive four-function calculator, and the B-200 (B), which also features square root and percent functions. Each model uses one (the same) circuit board, of which there are only 2,500 available for this week's production. Also, the company has allocated a maximum of 800 hours of assembly time this week for producing these calculators, of which the A-100 requires 15 minutes (.25 hours) each, and the B-200 requires 30 minutes (.5 hours) each to produce. The firm forecasts that it could sell a maximum of 4,000 A- 100's this week and a maximum of 1,000 B-200's. Profits for the A-100 are $1.00 each, and profits for the B-200 are $4.00 each. What is the objective function? What is the assembly time constraint (in hours)? Which of the following is not a feasible production/sales combination? What are optimal weekly profits?

An electronics firm produces two models of pocket calculators: the A-100 (A), which is an inexpensive four-function calculator, and the B-200 (B), which also features square root and percent functions. Each model uses one (the same) circuit board, of which there are only 2,500 available for this week's production. Also, the company has allocated a maximum of 800 hours of assembly time this week for producing these calculators, of which the A-100 requires 15 minutes (.25 hours) each, and the B-200 requires 30 minutes (.5 hours) each to produce. The firm forecasts that it could sell a maximum of 4,000 A- 100's this week and a maximum of 1,000 B-200's. Profits for the A-100 are $1.00 each, and profits for the B-200 are $4.00 each. What is the objective function? What is the assembly time constraint (in hours)? Which of the following is not a feasible production/sales combination? What are optimal weekly profits?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.5: Ordering With Quantity Discounts And Demand Uncertainty

Problem 6P

See similar textbooks

Similar questions

In the lawn mower production problem in Example 8.4, experiment with the penalty cost for unsatisfied pickups in week 1. If this cost is sufficiently small, does the company ever produce fewer than seven models in week 1 and allow some week 1 pickups to be unsatisfied?
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets.Set up the problem in Excel and find the optimal solution. (Leave no cells blank — be certain to enter "0" wherever required. Round your answers to 2 decimal places.) (Round your answer to 2 decimal places.)
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $25 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $300 for gadgets. Widgets consume 6 units of raw material A and 8 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. Set up the problem in Excel and find the optimal solution. The manufacturer will produce .......widgets and ...... gadgets the manufacturer's profit will be ......
Hilliard Electronics produces specially coded computer chips for laser surgery in 64MB, 256MB, and 512MB sizes. (1MB means that the chip holds 1 million bytes of information.) To produce a 64MB chip requires 8 hours of labor, a 256MB chip takes 13 hours, and a 512MB chip requires 16 hours. Hilliard’s monthly production capacity is 1,200 hours. Mr. Blank, the firm’s sales manager, estimates that the maximum monthly sales of the 64MB, 256MB, and 512MB chips are 40, 50, and 60, respectively. The company has the following goals (ranked in order from most important to least important): 1. Fill an order from the best customer for thirty 64MB chips and thirty-five 256MB chips. 2. Provide sufficient chips to at least equal the sales estimates set by Mr. Blank. 3. Avoid underutilization of the production capacity. Formulate this problem using goal programming
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $40 each. To produce each item, a setup cost is incurred. This setup cost is $300 for widgets and $400 for gadgets. Widgets consume 5 units of raw material A and 4 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 600 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. Set up the problem in Excel and find the optimal solution.
A small firm makes three similar products, which all follow the same three-step process, consisting of milling, inspection, and drilling. Product A requires 12 minutes of milling, 5 minutes forinspection, and 10 minutes of drilling per unit; product B requires 10 minutes of milling, 4 minutesfor inspection, and 8 minutes of drilling per unit; and product C requires 8 minutes of milling, 4minutes for inspection, and 16 minutes of drilling. The department has 20 hours available duringthe next period for milling, 15 hours for inspection, and 24 hours for drilling. Product A contributes$2.40 per unit to profit, product B contributes $2.50 per unit, and product C contributes $3.00 perunit. Determine the optimal mix of products in terms of maximizing contribution to profits for theperiod. Then, find the range of optimality for the profit coefficient of each variable.
Duluth Electronics makes two types of scooters: Falcon and Hawk. The Falcon model has a lighter engine and a smaller frame to make novice riders easier to balance. The Hawk is a little bigger and uses a heavier engine. Falcon requires 6 hours of manufacturing time and Hawk takes only 3 hours. Duluth's main plant in Kentucky has 2,100 hours of engine manufacturing time available. Duluth's vendors have the ability to supply as many Falcon frames as needed, but they only provide 280 Hawk frames. Falcon requires 2 hours of testing and 2.5 hours for Hawk. There are only 1,000 hours available for testing. The finance department estimates that the Falcon model contributes a profit of $2,400 and the Hawk $1,800. Determine the optimal solution for this problem. Recommend what you think is a good strategy for Duluth, given your computations. Type your final answers in the space provided and show your graph in the solutions file (no need for hand-drawn graphs, but the feasible region should be…
In a production process model such as Repco’s, certain inputs make no sense in the usage table (the range B7:D9 of the model). For example, suppose that, in addition to current usages, each unit of drug A -requires one unit of drug C. Why does this result in a nonsensical problem? What happens if you run Solver on it anyway? What happens if you run Solver on it after adding a constraint that the sum of the units produced (over all three drugs) must be at least 1?
Dalton Desk makes two different types children's desks: a regular model (R) and a deluxe model (D) with an extra shelf for book storage. Both types of desks go through Daltons' three production departments: fabrication, assembly, and packing/shipping, but required a different number of minutes in each department. For example, the regular desk needs 60 minutes of fabrication time, 45 minutes of assembly, and 15 minutes in packing & shipping. The deluxe model needs 120 minutes of fabrication time, 60 minutes in assembly, and 20 minutes in packing & shipping. Dalton has 850 hours of production time available in fabricating department, 450 hours available in its assembly department, and 200 hours available in its packaging and shipping department. Dalton reports unit profits of $6 and $8 for its regular and deluxe desks, respectively. What is the objective function? What is the fabrication constraint? What is the assembly constraint?What is the Shipping and Packing constraint?
A firm making snowblowers produces the augers for each snowblower in batches. Annual demand is for 3,000 snowblowers, which means 3,000 augers need to be produced each year. On a given workday, 10 augers are needed for snowblower production. Annual holding costs are $3 per auger. Before the augers are produced, a setup cost of $100 is incurred to setup the equipment to produce a batch of augers. The firm can produce 50 augers per day. Given this information, find the economic production quantity for the auger units. Note: When doing interim calculations, round value to 2 decimal points.
A glassblower makes glass decanters and glass trays on a weekly basis. Each item requires 1 pound of glass, and the glassblower has 15 pounds of glass available each week. A glass de- canter requires 4 hours of labor, a glass tray requires only 1 hour of labor, and the glassblower works 25 hours a week. The profit from a decanter is $50, and the profit from a tray is $10. The glassblower wants to determine the total number of decanters (x1) and trays (x2) that he needs to produce in order to maximize his profit. Requirements:a) Define decision variables and tabulated datab) Formulate the Integer Linear Programming Model.
The American National Bus Lines is proud of its 8-week bus driver training program that it conducts for all its drivers. Each 8-week training program costs the company $ 25000 for instructors, equipment and so on and is independent of the number of new drivers in the class as long as the class size remains less than or equal to 35. The training program must provide the company with 7 new fully trained drivers per month. After completing the training program, new drivers are paid $1800 per month but do not work until a full-time position is open. The company views the $1800 as holding cost necessary to maintain a supply of newly trained drivers available for immediate service. Viewing new drivers as inventory –type units, how large should the training classes be in order to minimize the total annual training and new driver idle-time costs? How many training classes should the company hold each year? What is the total annual cost of your recommendation?