MBA 675 Week 10 HW

xlsx

School

Bellevue University *

*We aren’t endorsed by this school

Course

675

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by ElizabethAK

Report
Order 1 2 3 4 5 Order Due Date (hours from now) 1 6 10 12 Order 2 5 3 8 2 3 3 15 18 1 4 1 9 20 3 5 0 7 21 4 The due dates reflect the need for the order to be at its next operation. 5 B. Comment on the performance of the two rules relative to these measures. Order 2 5 4 1 3 Chapter 10, Problems #18- in addition to developing scheduling rules based on FCFS and EDD develop scheduling rules for shortest processing time (SPT) and Slack using the definition of Slack at the start of this assignments document. In addition to evaluating the average flow time and average lateness, also evaluate the average early time. The Hickory Company manufactures wooden desks. Management schedules overtime every weekend to reduce the backlog on the most popular models. The automatic routing machine is used to cut certain types of edges on the desktops. The following orders need to be scheduled for the routing machine: Time since order arrived (hours ago) Estimated Machine Time (hours) A. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average past due hours. After calculations, the SPT has the shortest late time and the highest early time. Hickory company should use the SPT schedule for the most efficiency.
First Come First Serve (FCFS) Start Est. Machine Time (hrs.) Finish time Due Time Past Late Time Time Since Order Arrival Flow Time Early Hours 0 10 10 12 0 6 16 2 10 3 13 8 5 5 18 0 13 15 28 18 10 3 31 0 28 9 37 20 17 1 38 0 37 7 44 21 23 0 44 0 11 29.4 0.4 Avg. Late Time Earliest Due Date (EDD) Start Est. Machine Time (hrs.) Finish time Due Time Past Late Time Time Since Order Arrival Flow Time Early Hours 0 3 3 8 0 5 8 5 3 10 13 12 1 6 19 0 13 15 28 18 10 3 31 0 28 9 37 20 17 1 38 0 37 7 44 21 23 0 44 0 10.2 28 1 Avg. Late Time Shortest Processing Time (SPT) Start Est. Machine Time (hrs.) Finish time Due Time Past Late Time Time Since Order Arrival Flow Time Early Hours 0 3 3 8 0 5 8 5 3 7 10 21 0 0 10 11 10 9 19 20 0 1 20 1 19 10 29 12 17 6 35 0 29 15 44 18 26 3 47 0 8.6 24 3.4 Avg. Late Time FCFS 12.9 FCFS 31.5 1.1 EDD 16.125 EDD 34.375 1.125 SPT 15.90625 SPT 34.21875 1.40625 Avg. Flow Time Avg. Early Time Avg. Flow Time Avg. Early Time Avg. Flow Time Avg. Early Time
Ingredients Almonds 180 6 8% 6% $ 0.28 Walnuts 190 4 2% 6% $ 0.38 Peanuts 170 7 0% 4% $ 0.12 Variable Almonds Walnuts Peanuts SUM Sign RHS Ounces 1.6 1 1.4 4 - - Min. Pacakge Cost $ 0.45 $ 0.38 $ 0.17 $ 1.00 - - Calories (per oz.) 180 190 170 - - - Calories 288 190 238 716 <= 720 Grams (per oz.) 6 4 7 17 Protein 9.6 4 9.8 23.4 >= 20 ADR Calcium 8% 2% 0% 10% ADR Iron 6% 6% 4% 16% % of Calcium 13% 2% 0% 15% >= 15 % of Iron 10% 6% 6% 21% Total Ounces 1.6 1 1.4 4 = 4 Total Almonds 1.6 1.6 >= 0.5 Total Walnuts 1 1 >= 0.5 Total Peanuts 1.4 1.4 >= 1 Supplement D, Problems #16 - work both parts a) and b). For part b), if the solution in part a) does not satisfy the marketing requirements, just provide the additional constraints that are required for the marketing requirements to be satisfied. You do not need to resolve the linear programming problem A problem often of concern to managers in processing industries is blending. The Nutmeg Corporation, from Problem 15, is considering a new product it intends to sell to active and health-concerned adults. This new product will be a 4-ounce package of nuts that conforms to specific heath requirements. First, the 4-ounce package can contain no more than 720 calories. It must deliver at least 20 grams of protein. Finally, the package must provide at least 15 percent of the adult daily requirement (ADR) of calcium and 20 percent of the ADR of iron. Nutmeg would like to use only almonds, walnuts, and peanuts in this new product. The following table provides nutritional data on each of these ingredients as well as their cost to Nutmeg. Calories (per oz) Grams of protein (per oz.) % ADR of Calcium (per oz.) % ADR of Iron (per oz.) Cost (per oz.) A. Use linear programming to find the cost-minimizing number of ounces of each ingredient that Nutmeg should use in each 4-ounce package. What is the per-package cost of raw materials?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Ingredients Almonds 180 6 8% 6% $ 0.28 Walnuts 190 4 2% 6% $ 0.38 Peanuts 170 7 0% 4% $ 0.12 Decision Variables: Almonds Walnuts Peanuts 0.28 0.38 0.12 Capacity X1(calories) 0 0 0 <= 720 Capacity X2(protein 0 0 0 >= 20 Capacity X3 (Calcium %ADR) 0.15 0.15 0.15 >= 0.15 Capacity X4 (Iron % ADR) 0.2 0.2 0.2 >= 0.2 Objective: Minimize costs: .28A+.38W+.12P Constraints: Calories: 180A+190W+170P <= 720 Protein: 6A+4W+7P<=20 Calcium: .08A+.02W+0P >= 0.15 Iron: .06A+.06W+.04P >= 0.2 C= Calories (per oz) Grams of protein (per oz.) % ADR of Calcium (per oz.) % ADR of Iron (per oz.) Cost (per oz.)
Variable Almonds Walnuts Peanuts SUM Sign RHS Ounces 0.5 0.5 1 - - - Min. Pacakge Cost $ 0.14 $ 0.19 $ 0.12 - - - Solution B satisfies the new constraints Calories (per oz.) 180 190 170 - - - Calories 90 95 170 355 <= 720 Grams (per oz.) 6 4 7 Protein 3 2 7 12 >= 20 ADR Calcium 8% 2% 0% ADR Iron 6% 6% 4% % of Calcium 4% 1% 0% 5% >= 15 % of Iron 3% 3% 4% Total Ounces 0.5 0.5 1 2 = 4 Total Almonds 0.5 0.5 >= 0.5 Total Walnuts 0.5 0.5 >= 0.5 Total Peanuts 1 1 >= 1 B. The marketing department at Nutmeg insists that each package should contain at least 0.5 ounce of almonds, at least 0.5 ounce of walnuts, and no more than 1 ounce of peanuts. Does the solution developed for part (a) satisfy these new constraints? If not, use linear programming to find a solution that includes these marketing requirements. What is the new cost of raw materials?
The following is a linear programming model for analyzing the product mix of Maxine’s Hat Company, which produces three hat styles: Supplement D, Problems #18 explain your answers and do not resolve the problem to answer the 3 questions but use the sensitivity analysis in Figure D.15 to answer these questions; o n part a), by being part of the optimal product mix, this means having a non-zero value in the optimal solution
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Consider each of the following statements independently, and state whether it is true or false. Explain each answer. B. The capacity of machine B can be reduced to 280 hours without affecting profits. C.If machine C had a capacity of 115 hours, the production output would remain unchanged. A. If the price of hat 3 were increased to $11.50, it would be part of the optimal product mix. Hint: Hat 3 is represented by and its optimal value currently is 0, which means that it is not to be produced (and not part of the optimal product mix). False- the reduced cost for X3 is $7, this would mean that you would want to increase the price to maxamize profits. Selling hat 3 for $11.50 would not yeild enough profits. True- the lower bound value is 265, the current solution has slack of 135 hours. Reducing capacity to to 280 does not affect the schedule and has the same overall profit. (15 hours of slack time available if this did happen) False- The upper bound limit is 120, meaning the capacity is over 115 which is less than the upper bound limit. Shadow price could be used in this scenario, the production output would change to utilize the increased capacity.
Product B. Solve yo Alpha Beta Delta Gamma Price $ 350.00 $ 320.00 $ 400.00 $ 500.00 Material Cost $ 50.00 $ 40.00 $ 125.00 $ 150.00 Weekly Demand (in units) 100 60 50 80 20 0 40 10 25 20 0 50 0 20 60 30 Alpha= Beta= Delta= Gamma= Alpha Beta Delta Gamma Supplement D, Problems #23 – works parts a), b) and d) and for d) only set-up the formulation for this part but you do not need to solve it. On a) the demand is the maximum demand Supertronics, Inc., would like to know how the firm’s profitability is altered by product mix. Currently, product mix is determined by giving priority to the product with the highest per-unit contribution margin (defined as the difference between price and material cost). Details on the Supertronics product line, including processing time at each workstation, follow: (in min) (in min) (in min) A. Assume that Supertronics has 5,500 minutes of capacity available at each workstation each week. Develop a linear program to define the production mix that maximizes contribution margin. D. How wo already com
our formulation using the excel solver 100 Total Contribution= 73,150 60 50 36 >= 50 >= 50 >= 50 >= 50 ould your formulation and solution in part (b) change if 50 units of each product were mmitted to customers and thereby had to be produced?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Perform an ethical analysis using the concepts presented in the Week Nine Assignments document What is th What are the two most critical issues that must be addressed in this Ethical Dilemma? Ethical Dilemma #2 Scheduling people to work second and third shifts (evening and “graveyard”) is a problem in almost every 24-hour company. There can be potentially dangerous issues on the night shift. In addition, ergonomic data indicate the body does not respond well to significant shifts in its natural circadian rhythm of sleep. There are also significant long-run health issues with frequent changes in work and sleep cycles. Consider yourself the manager of a nonunion steel mill that must operate 24-hour days, and where the physical demands are such that 8-hour days are preferable to 10- or 12-hour days. You and your employees have spent much time and energy developing an employee empowerment work environment. Your empowered employees have decided that they want to work weekly rotating shifts. That is, they want a repeating work cycle of 1 week 7 A.M. to 3 P.M, followed by a second week from 3 P.M. to 11 P.M., and the third week from 11 P.M. to 7 A.M. You are sure this is not a good idea in terms of both productivity and the long-term health of the employees. If you do not accept their decision, you undermine the work empowerment program, generate a morale issue, and perhaps. More significantly, generate a few more votes for a union. Answer the following questions:Perform an ethical analysis using the concepts presented in the Week Nine Assignments document. What are the two most critical issues that must be addressed in this Ethical Dilemma? What is the ethical position and what would you do? Things to consider: 1. Define the conflict and identify the higher-order values involved 2. Identify the stakeholders 3. Identify the options you can reasonly take 4. Identify the potential cnsequences of your options The ethical dilemma at hand revolves around two crucial issues: employee health and safety, and organizational productivity and efficiency. Firstly, the well-being of the employees is a significant concern, as working rotating shifts, particularly night shifts, can disrupt their natural sleep patterns, leading to fatigue, reduced alertness, and potential safety hazards in a physically demanding steel mill environment. Secondly, there is a potential impact on productivity and efficiency, as significant shifts in work schedules can result in decreased concentration, fatigue-related errors, and overall performance decline, hindering the mill's operational effectiveness. To address this ethical dilemma, it is important for the manager to find a balance between employee preferences and the long-term interests of both the individuals and the organization. This involves considering alternative solutions that prioritize employee health and safety while maintaining productivity levels. Open and transparent communication with the empowered employees is crucial to understand their concerns and collaboratively reach a mutually beneficial resolution. By actively addressing these critical issues, the manager can navigate the ethical dilemma, uphold the work empowerment program, foster a positive work environment, and ensure the well-being and productivity of the employees. The ethi employe As the m 1. Gathe of rotati 2. Foster perspec input. 3. Educa understa them m 4. Explo empowe rotation 5. Priori indicate alternati In summ open dia environm
he ethical position and what would you do? ical position in this scenario is to carefully balance employee well-being and organizational productivity. It involves considering the potential risks to ee health and safety posed by rotating shift schedules, while also acknowledging the importance of maintaining operational effectiveness. manager in this situation, my proposed course of action would be as follows: er Relevant Information: I would thoroughly research and analyze scientific studies, expert opinions, and industry best practices regarding the effects ting shift schedules on employee health, safety, and productivity. This knowledge would inform my decision-making process. r Open Dialogue: I would actively engage in open and honest conversations with the empowered employees to gain a deep understanding of their ctives, concerns, and reasons for advocating for a rotating shift schedule. This dialogue would demonstrate my willingness to listen and value their ate and Inform: Using the research findings, I would transparently share information with the employees to provide them with a comprehensive anding of the potential risks associated with rotating shifts. By raising awareness about the impact on long-term health and safety, I would help make informed decisions regarding their work schedules. ore Alternative Solutions: Together with the employees, I would collaboratively explore alternative scheduling options that offer flexibility and erment while mitigating the negative consequences of rotating shifts. This proactive approach could involve considering modified shift patterns, job ns, or innovative solutions that strike a balance between employee preferences and their well-being. itize Health and Safety: Ultimately, the well-being and safety of the employees would be my top priority. If the scientific evidence overwhelmingly es that rotating shifts pose significant risks, I would transparently communicate these concerns to the employees. In such cases, I would propose tive schedules that prioritize their long-term health and safety while ensuring the organization's operational efficiency. mary, my ethical stance would prioritize employee health and safety while also considering the productivity needs of the organization. By fostering alogue, sharing information, exploring alternative solutions, and making decisions that strike a balance, I would strive to maintain a positive work ment, preserve the principles of the empowerment program, and safeguard the well-being of the employees in the best possible way.