Please provide excel calculation as well 6-40 A photocopy machine company produces three typesof laser printers-the Print Jet, the Print Desk, andthe Print Pro the sale of which earn profits of $60,$90, and $73, respectively. The Print Jet requires2.9 hours of assembly time and 1.4 hours of testingtime. The Print Desk requires 3.7 hours of assem-bly time and 2.1 hours of testing time. The Print Prorequires 3 hours of assembly time and 1.7 hours oftesting time. The company wants to ensure that PrintDesk constitutes at least 15% of the total productionand Print Jet and Print Desk together constitute atleast 40% of the total production. There are 3,600hours of assembly time and 2,000 hours of testingtime available for the month. What combination ofprinters should be produced to maximize profits?

Profit$60$90$73Assembly hrs.2.93.73Testing hrs.1.42.11.7Constraints 1-0.150.85-0.15Constraints…

A photocopy machine company produces three types of laser printers—the Print Jet, the Print Desk, and the Print Pro-the sale of which earn profits of $60, $90, and $73, respectively. The Print Jet requires 2.9 hours of assembly time and 1.4 hours of testing time. The Print Desk requires 3.7 hours of assem-

A photocopy machine company produces three types of laser printers—the Print Jet, the Print Desk, and the Print Pro-the sale of which earn profits of $60, $90, and $73, respectively. The Print Jet requires 2.9 hours of assembly time and 1.4 hours of testing time. The Print Desk requires 3.7 hours of assem-

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

Atlanta Manufacturing Company produces products W, X, Y, and Z through a joint process. The joint costs amount to $250,000. Product Units Produced Sales Value at Split-Off Additional Costs of Processing Sales Value After Processing W 750 $10,000 $2,500 $15,000 X 1,500 $30,000 $3,000 $35,000 Y 1,000 $20,000 $4,000 $25,000 Z 1,500 $40,000 $6,000 $45,000 If W is processed further, profits of W will: 1) Increase by $2,500 2) Increase by $12,500 3) Decrease by $23,000 4) Increase by $5,000
Two models of controlling boards. The 1" type has high specification for work from the 2nd type. The better type has a profit of 50S and the other 40$ per board. The 1 type of boards requiring five as much as the 2nd needs for production and the total production are 2000 boards, the first model requires 400 min to be complete and 700 min to the second model. Write this expression with LP equations to have the maximum profit with production of each model.
Link's Lumber creates pressure-treated utility poles from pine logs bought from several surrounding pine plantations. At the Link's Lumber operation, a batch of 100 pine logs yields 85 utility poles with 5 labor-hours required to process the entire batch. Link's Lumber is owned by Artemis Link, whose brother Devious Link is plan- ning to marry Betty Davis, owner of Northlands Pine Plantation. Artemis expects that his future sister-in-law will sell him pine logs for the same price he is paying to purchase them from other growers right now. The difference in Northlands Pine Plantation logs, however, is that they are considerably higher-quality wood than the logs he purchases from his current suppliers. If Betty agrees to sell him Northlands Pine Plantation pine logs, each batch of 100 logs can be expected to yield 100 util- ity poles, although it will take an additional 4 labor-hours per batch to process the higher-quality wood. a. What is the current labor productivity at Link's Lumber?…
The following table provides a random sample of the unit values and annual demands of eight SKUs. SKU Code Unit Value Demand (units) A104 $0.02 D205 $2.60 X104 $4.80 U404 $2.50 L205 $0.36 S104 $0.84 X205 $4.35 L104 $0.23 4,500 30 25 2,500 1,040 380 70 250 Southern Markets Inc. is considering the use of ABC analysis to focus on the most critical SKUs in its inventory. a. Based on the percentage of dollar usage, which class should L205 belong to? Class b. Based on the percentage of dollar usage, which class should L104 belong to? Class
The recipe for a fruit smoothie requires 2 cups of fruit per 6 cups of yogurt to maintain a 1/3 ratio. While making the fruit smoothie, Suzy accidentally puts 3 cups of fruit into the pitcher. How many cups of yogurt should be put out n the pitcher to maintain the ratio of 1/3?
Carol Cagle bas a repetitive manufacturing plantproducing trailer bitches in Arlington, Texas. The plant has anaverage inventory tu rnover of only 12 times per year. She hastherefore determined that she will reduce her component lotsizes. She has developed the following data for one component,the safety chain clip:Annual demand = 31,200 unitsDaily demand = 120 unitsDaily production (in 8 hours) = 960 unitsDesired lot size (I hour of production) = 120 unitsHolding cost per unit per year = $12Setup labor cost per hour = $20How many minutes of setup time should she have her plant manageraim for regarding this component?
PT Bulan Sabit is a company engaged in fan manufacturingair conditioner with the following production datai. Setup fee = $15ii. Inventory cost per fan per year = $ 125iii. Production capacity per day = 246 fansiv. Production time per fan = 2 daysv. Fan requirement per year = 20,000 fansvi. Safety stock = 1/2 day fan productionIf PT Bulan Sabit wants to implement Kanban, then calculate the needs of the companyas follows:a) Explain the definition and purpose of kanban b) Specify production order quantity c) Calculate the container kanban that must be provided by PT Bulan Sabit Assuming the time used is per year 50 weeks and 5 days per week
A 10 station automated assembly system produces an ideal cycle time (Tc) of 14 seconds/cycle. When a defective part enters any assembly station it sometimes causes a station jam or stoppage. Defective parts occur at a rate of 0.07 and a jams due to defective parts occur at a rate of 0.4. When a jam occurs, it takes on average 74 seconds to clear and restart the station. Determine the production rate of acceptable parts (Rap) to the nearest 1 part/hour.
Tica (Pty) Limited manufactures and sells combined fax and telephone answering machines. In order to tender for a specific contract, the technical team of the company has developed a new model called FINO. To date, two units of FINO have been manufactured and are being used as demonstration models. The following information is available: Direct labour hours taken to manufacture the first two units: Hours First unit 60 Second unit 48 The following average direct variable costs relate to the manufacture of the first two units of FINO: R/unit Material 620 Labour 440Variable overheads 324 1384 · Since the first two units were manufactured, material costs have increased by 10% and labour costs by 5%. · Variable overheads – variable per…
1. In a worker paced assembly line, consider a situation where the daily requirement has suddenly increased. Which of the following statements will be true? a) The required cycle time will also increase proportionally b) The minimum number of workstations required will come down c) The idle times at many workstations will increase d) It will be possible to handle the new requirement by increasing the available time. 2. Which of the following statements will hold good in the case of a system with uncertainty in demand for service and in service times? a) When the utilization of resources fall it is an indication of greater efficiency of the service b) It is a good practice to plan for resource utilization levels more than 85% c) Cost of waiting to get serviced is directly proportional to the cost of providing the service d) None of the above 3. Which of the following pertains to an efficient supply chain? a) It deals with innovative products b) The product life cycle will be…
The ERG Theory was developed by which of the following theorists? a. Clay Alderfer b. Frederick Herzberg c. Douglas McGregor d. Abraham Maslow e. David McClelland
Suppose a final assembly is produced by assembling two components. THE The first component, A, is produced internally and goes through three process steps, which are stamping, forging and machining, with scrap estimates of 10%, 15% and 25%, respectively. For every three produced units of component A, two are used in the final assembly and one is separate to meet spare parts needs. The second component, B, which is used exclusively in final assembly, is purchased from a supplier external and inspected on arrival; 2% do not pass inspection. A unit of the component purchased is required for each final assembly. The final assembly process produces 5% of scraps. Spare parts demands for component A and final Su assembly match to 1,000 and 5,000 units, respectively. How many input units are needed for produce component A, and how many units of component B should the firm buy?