hello I need help with number 13 please and I need it only in excel
Q: Weighted-average costs per equivalent unit are $2 for direct materials and $3 for conversion. There…
A: Given: Direct materials 2 Conversion 3 Goods completed 10000 Ending inventory 1000
Q: Hello, I was wondering if anyone can help me out with calculating safety stock with the information…
A: Given the data stated below, The average customer demand=100 units The standard deviation of…
Q: Look for a sample healthcare project charter document on the Internet from the University of…
A: A sample healthcare project charter document from the University of Michigan on their site at this…
Q: Why distribution range negative infinity to positive infinity is transformed to zero to positive…
A: The distribution range from negative infinity to positive infinity is transformed to zero to…
Q: Explain what is meant by an “assignment problem” and how it arises. How can an assignment problem…
A: Assignment problems are one of the most common issues faced in a variety of industries. Fortunately,…
Q: ablet computers designed for consumers are actively changing how organizations store, retrieve, and…
A: Meaning- Performance management is one of the areas where data visualization adds esteem.…
Q: How much, if any, customer service will be available just online?
A: Customer service is the technique or the process through which the organizations provide customer…
Q: You are constructing an office building. Work has started and you are in the middle of your project.…
A: Here, from the case, we could see that the work has been started and is going through the middle of…
Q: A shoe company forecasts the following demands duringthe next six months: month 1—200; month 2—260;…
A: Let supply be x Let demand be y Assuming that the company supplies the shoes with OT and RT in the…
Q: 2. How does this forecast differ from that using the 5-year average? 3. Which forecast would you…
A: The average forecasting method, also known as the mean method, is a simple and straightforward…
Q: How do organizations create and maintain a sustainable strategic management process?
A: Meaning of Sustainable strategic management - Sustainable strategic management (SSM) includes…
Q: design strategies?
A: Mobile First and Desktop First are two different approaches to responsive design, which is the…
Q: At the conclusion of Internal Projects, an agreement with the client should be reviewed to ensure…
A: For the internal or in-house project, the executives include utilizing individuals from inside your…
Q: To what extent does the capacity analysis react when several processes are running in parallel?
A: Capacity Analysis Capacity Analysis means an analysis which provides information about the demanded…
Q: 1. What are the conflicts in this case study? Is it a wise decision if B&W sub- contracted the…
A: The conflicts in this case study include the management failure at Babcock & Wilcox (B&W) in…
Q: What does "dynamic programming" imply, and how does it function?
A: Dynamic programming is a decision-making method using a mathematical and computational approach. It…
Q: Consider the following: Activity A B C D Normal time 4 DEFG 238 2 Crash time Normal cost Crash cost…
A: Project crashing is a process which helps to reduce the project duration using additional cost and…
Q: What are the management Philosophies that emerged and influence the current personnel…
A: NOTE: We are allowed to do one question only at a time. Management philosophies are the set of…
Q: George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats…
A: Given data is Year 5 annual demand = 5600
Q: Case Study: Anna runs a small cafe that’s really busy at lunchtime but quiet at other times. She…
A: Anna is a cafe owner, who is facing a problem where there are a lot of customers during lunchtime…
Q: How does ERP link the many parts of the company?
A: Enterprise resource planning (ERP) would be a platform used by organizations to coordinate and…
Q: Green Capital, Inc. (GC) is a small investment banking firm that specializes in securing funds for…
A: Find the Given details below: Activity Predecessor Optimistic Time(To) a(Week) Pessimistic…
Q: From the following information, develop an AON project network. Complete the forward and backward…
A: The slack time is the difference between late start and early start of the activity or late finish…
Q: Mauricio estimates that the first module of the project could be completed in as few as 15 days or…
A: There are several MCQ questions here, so following the rules, the first question should be used for…
Q: (d) The computer solution for the linear program in part (a) provides the following objective…
A: Linear programming is a mathematical technique that is commonly used in the operations management…
Q: 4. Construct a Gantt chart to represent the various activities of the project with a date. The…
A: Find the Given details below: Activity Predecessor Optimistic Time(To) a(Week) Pessimistic…
Q: a) Develop a mathematical model for the mixing process. Let Q represent the amount of dye in…
A: Solution a) dQdt=(0.25r)-Q(10+r)5 Solution b) r= 10/1.5= 6.67 L/min
Q: what is Marshall olkin transformation? When it is first used and why we need it? Simply explain…
A: Marshall Olkin Transformation is a mathematical technique used in the field of probability and…
Q: Please put the data in excel , or at least try to do so. --------- Company Z has the following…
A:
Q: Justify your reasoning for why a company would want to invest in IT infrastructure.
A: A company may invest in IT infrastructure to improve efficiency and productivity, to better manage…
Q: Hello, can someone here help me find the Economic Order Quantity with the given information: Average…
A: The economic order quantity (EOQ) is the order quantity that limits complete holding and ordering…
Q: Anna runs a small cafe that’s really busy at lunchtime but quiet at other times. She needs a way to…
A: Introduction: Managing the inventory or capacity according to the demand of the market is a tricky…
Q: Sampling 4 pieces of precision-cut wire (to be used in computer assembly) every hour for the past…
A: Given-
Q: Question: How does Anna balance demand and capacity by doing a special on bagels from 2 to 4 pm?
A: Anna balances demand and capacity by doing a special on bagels from 2 to 4 pm in several ways: By…
Q: hello, can someone help me with this question?: if a company regularly holds 50 units of safety…
A: Inventory management refers to the process of overseeing and controlling the flow of goods, from…
Q: Upper Control Limit (UCLx) =
A: Control charts are also known as process-behavior charts. It is a statistical process that helps in…
Q: Which of the following is considered to be a drawback to Entrepreneurship? Uncertainty of Income…
A: Drawback to Entrepreneurship Uncertainty of Income Long Hours and Hard Work Risk of losing your…
Q: Consider your current organization or an organization with which you were once affiliated. Is there…
A: Change management is an essential part of the organization and as every organization needs change,…
Q: The operations manager for the Blue Moon Brewing Co. produces two beers: Lite (L) and Dark (D). He…
A: Maximize Z = 3L + 2D subject to 2L + 4D <= 8x60 minutes 5L + 3D <= 675 gallons
Q: a) Which station is the bottleneck? (b) What is the process capacity in units per day (round to the…
A: Given Calculations:- Formulas Used:-
Q: Task-2. Briefly describe the 4 types of sampling techniques. Your description must use at least one…
A: Research is an integral part of growth. No organization can grow without conducting timely…
Q: hello, can someone help me with this question?: if a company regularly holds 50 units of safety…
A: Here, the order quantity is 500 units, and the safety stock is 50 units, for this given data, the…
Q: Discuss what is meant by unit command? By the scalar principle? Can an organization have one without…
A: Discuss what is meant by unit command? By the scalar principle? Scalar principle : The chain or path…
Q: Can someone help me to calculate the lead time for Supplier A? Supplier A: has 2 days to review the…
A: As per the Q, I would determine the lead time for supplier A, The formula for this lead time is…
Q: Company Z has the following historical sales information for one of its hydraulic pump models for…
A: Answer: Given Data : Company Z has the following historical sales information for one of its…
Q: Make recommendations to the airline company, using Taguchi analysis.
A: To make recommendations to the airline company using Taguchi analysis, the following steps can be…
Q: How do I Calculate the total cost of ownership for each supplier? Image of the table is available…
A: Given-
Q: A hardware store will run an advertising campaign using radio and newspaper. Every dollar spent on…
A: Let us say x1 and x2 as the decision variables as radio and newspaper ads. Now since the costs are…
Q: xplain the operations decision making flow chart.
A: Introduction- Operational decisions are those decisions that are changed all the more oftentimes in…
Q: What are the international transport modes? Identify the criteria that a company might consider to…
A: Business is a very vast field where many processes are executed simultaneously to provide a good…
hello I need help with number 13 please and I need it only in excel
Step by step
Solved in 4 steps with 5 images
- Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. 14.) A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. From the information shown, generate: a) An indented bell of material for product A. b) Net requirements for each part to produce 10 As in week 8 using lot-for-lot. Figure 14:Given the product structure, master productionschedule, and inventory status in Figure 14.13, and assuming therequirements for each BOM item is I:a) develop a gross requirements plan for Item C;b) develop a net requirements plan for Item C.1. A company that produces golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times and quantities on hand is shown in the following table. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree.
- A firm that produces electric golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times, and quantities on hand is shown in the following table. Use this information to do each of the following: a. Develop a material requirements plan that will provide 200 golf carts by week 8, assuming lot-for-lot ordering. (Excel)The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton Hand Direct Components End 3 0 L(2), C(1), K(3) L 3 12 B(2), J(3) C 4 17 G(2), B(2) K 4 22 H(4), B(2) B 3 30 J 4 29 G 4 3 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.)Additional units b. An order for the end item is scheduled to be shipped at the start of week 13. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.) The latest weeka) Given the product structure and master production scheduleshown in Figure 14.12, develop a gross requirements plan forall items.b) G iven the product structure, master production schedule, andinven tory status shown in Figure 14.12, develop a net requirementsplan (planned order release) for all items.
- Once a material requirements plan (MRP) has been estab-lished, what other managerial applications might be found for the technique?In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank-be certain to enter "0" wherever required.) ITEM 3 Gross requirements On-hand Net requirements Planned order receipt Planned order release Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases WEEK NUMBER 2 3 76 4 48 76 5 72 48 72The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount Direct Components on Hand End 1 0 L(2), C(1), K(3) L 1 10 B(2), J(3) C 2 14 G(2), B(2) K 2 19 H(4), B(2) B 1 34 J 2 25 G 2 7 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are needed? b. An order for the end item is scheduled to be shipped at the start of week 9. What is the latest week that the order can be started and still be ready to ship on time?
- The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton Hand Direct Components End 1 0 L(2), C(1), K(3) L 2 11 B(2), J(3) C 3 17 G(2), B(2) K 4 23 H(4), B(2) B 3 34 J 3 25 G 3 7 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.) b.An order for the end item is scheduled to be shipped at the start of week 11. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.)10. In the following MRP planning schedule for item J, indicate the correct net requirements, planned-order receipts, and planned-order releases to meet the gross requirements. Lead time is one week. WEEK NUMBER 3 ITEM J Gross requirements On-hand Net requirements Planned-order receipts Planned-order releases 0 40 1 2 75 4 5 50 70The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount on Hand Direct Components End 2 0 L(2), C(1), K(3) L 2 11 B(2), J(3) C 3 15 G(2), B(2) K 3 20 H(4), B(2) B 2 25 J 3 34 G 3 3 H 2 0 Click here for the Excel Data File a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.) b. An order for the end item is scheduled to be shipped at the start of week 11. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.)