5 A company produces two kinds of products. A product of the first type requires 1/4 hours of assemblylabor, 1/8 hours of testing, and $1.20 worth of raw materials. A product of the second type requires 1/3hours of assembly, 1/3 hours of testing, and S0.90 worth of raw materials. Given the current personnel ofthe company, there can be at most 90 hours of assembly labor and 80 hours of testing each day. Productsof the first and second type have a market value of $9 and $8, respectively.1. Formulate a linear programming problem that can be used to maximize the daily profit of the company.2. Suppose that up to 50 hours of overtime assembly labor can be scheduled, at a cost of $7 per hour.Modify the linear program from (a) to incorporate this change. Clearly specify the entire new LP, notjust any changes. Solve this in Excel. Attach the (1) Solver box, (2) Answer report, (3) Main sheetwith the formulas showing to your HW.

Part (A): Decision Variable- Suppose x = No. of units produced of product A y = No.…

Answered: A company produces two kinds of…

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
A manufacturing process has a i xed cost of $150,000 per month. Each unit of product being produced contains $25 worth of material and takes $45 of labor. How many units are needed to break even if each completed unit has a value of $90?
Quasi-Tech Corporation produces specially machined parts. The parts are produced in batches in one continuous manufacturing process. Each part is custom produced and requires special engineering design activity (based on customer specifications). Once the design is completed, the equipment can be set up for batch production. Once the batch is completed, a sample is taken and inspected to see if the parts are within the tolerances allowed. Thus, the manufacturing process has four activities: engineering, setups, machining, and inspecting. Costs have been assigned to each activity using direct tracing and resource drivers as follows: Activity Expected Cost Activity Driver Activity Capacity Engineering $1,000,000 Engineering hours 5,000 hours Setups 900,000 Setups 200 setups Machining 2,000,000 Machine hours 25,000 machine hours Inspection 800,000 Inspection hours 2,500 inspection hours Quasi-Tech produces two models: Model C and Model D. The following table…
Digital Controls, Inc. (DCI), manufactures two models of a radar gun used by police to monitor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the smaller model B has an accuracy of plus or minus miles per hour. For the next week, the company has orders for 100 units of model A and 150 units of model B. Although DCI purchases all the electronic components used in both models, the plastic cases for both models are manufactured at a DCI plant in Newark, New Jersey. Each model A case requires 4 minutes of injection-molding time and 6 minutes of assembly time. Each model B case requires 3 minutes of injection-molding time and 8 minutes of assembly time. For next week, the Newark plant has 600 minutes of injection-molding time available and 1,080 minutes of assembly time available. The manufacturing cost is $10 per case for model A and $6 per case for model B. Depending upon demand and the time available at the Newark plant, DCI occasionally…
A machine makes two components; call them types A and B. It takes 630 seconds to switch production between the component types. During that time, no production occurs. When in production, each unit of A or B requires 0.5 second to be completed. The two components, A and B, are combined in an assembly process to make a final product; call it C. The assembly step can combine the two components into 1 unit every 4 seconds, or 15 units per minute. Suppose the machine rotates between one batch of 2,520 units of A and 2,520 units of B. In that case, what is the capacity of the machine in component pairs per minute, where a component pair is one unit of A and one unit of B? Suppose the machine rotates between one batch of 2,520 units of A and 2,520 units of B. What is the utilization of the machine? Suppose the machine rotates between one batch of 2,520 units of A and 2,520 units of B. What is the average inventory of B components? If the production schedule could be adjusted with…
Suppose you work in a textiles factory. You know that it's normal for machines to print an average of 12 flaws per bolt of fabric. But if there's something wrong with the machine, they will print more flaws; you use this fact to determine if a machine needs to be fixed. Fixing a machine is always a time consuming process--it can require two hours just to take the machine apart to inspect it--so you only fix them if you really think there's something wrong. A machine just printed 15 flaws on a bolt of fabric. Using the appropriate distribution function in Excel, determine the chance that this is just a coincidence and the machine is working fine? Express your answer as a decimal to four places. Include a zero before the decimal point.
Non-inventory goods were purchased and delivered on June 15, 2010. Several security interests exist in these goods. Which of the following security interests has priority over the others? Group of answer choices purchase money security interest perfected June 24, 2010 Security interest perfected June 20, 2010 Security interest attached June 15, 2010 Security interest in future goods attached on June 10, 2010
A machine makes two components; call them types A and B. It takes 630 seconds to switch production between the component types. During that time, no production occurs. When in production, each unit of A or B requires 0.5 second to be completed. The two components, A and B, are combined in an assembly process to make a final product; call it C. The assembly step can combine the two components into 1 unit every 4 seconds, or 15 units per minute. Suppose the machine rotates between one batch of 2,520 units of A and 2,520 units of B. In that case, what is the capacity of the machine in component pairs per minute, where a component pair is one unit of A and one unit of B?
5. Meg Jones, the CEO of Ajax Computer Company, and Brad Smith, its Director of Operations, had been discussing how to increase the firm’s production of the company’s flagship XR58. The XR58 was particularly important because it sold 12,500 of them in the most recent year for $950, at a gross margin of 55%. After a lot of discussion, they decided to pursue an incentive system designed to increase production by 12% in the next year. After Brad discussed this possible incentive with the production team, the team determined that it could increase production by this amount without adding any more people or equipment. They believed they could accomplish this improvement primarily through process redesign. To incent them to do the hard work of process improvement, Brad told the team that it would receive 25% of the increased profits if it met the new production goal. For this team of 20 people, this would mean an additional compensation of _________ for each team member, on average, for…
A machine makes two components; call them types A and B. It takes 250 seconds to switch production between the component types. During that time, no production occurs. When in production, each unit of A or B requires 0.5 second to be completed. The two components, A and B, are combined in an assembly process to make a final product; call it C. The assembly step can combine the two components into 1 unit every 2 seconds, or 30 units per minute. Assume there is ample demand. If the production schedule could be adjusted with the goal of minimizing inventory in the process, how many units of A should be produced before switching to component B? In other words, calculate the optimal batch size for component A. Assume the same number of units of B would be produced as well. answer:_______units
A machine makes two components; call them types A and B. It takes 250 seconds to switch production between the component types. During that time, no production occurs. When in production, each unit of A or B requires 0.5 second to be completed. The two components, A and B, are combined in an assembly process to make a final product; call it C. The assembly step can combine the two components into 1 unit every 2 seconds, or 30 units per minute. Assume there is ample demand. Suppose the machine rotates between one batch of 1,000 untis of A and 1,000 units of B. In that case, what is the capacity of the machine in component pairs per minute, where a component pair is one unit of A and one unit of B? answer: __________ component pair per minute
A machine makes two components; call them types A and B. It takes 250 seconds to switch production between the component types. During that time, no production occurs. When in production, each unit of A or B requires 0.5 second to be completed. The two components, A and B, are combined in an assembly process to make a final product; call it C. The assembly step can combine the two components into 1 unit every 2 seconds, or 30 units per minute. Assume there is ample demand. Suppose the machine rotates between one batch of 1,000 unties of A and 1,000 units of B. What is the utilization of the machine? answer: _____percent

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS