A manufacturing firm has three plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (25) Customer 2 (50) Customer 3 (125) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?
Q: Haip Save & C This is the same information for all six questions about this hypothetical situation…
A: In exponential Smoothing : Forecast formula: F(t+1) = alpha*D(t) + (1-alpha)*F(t)
Q: Discuss the extent to which the project life cycle interfaces with project outcome
A: The project life cycle is a framework that defines the phases of a project from start to finish. It…
Q: Below is the details about a. What is the maximum and minimum human resource that would be required…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Question 31 When a firm operates in multiple geographic markets simultaneously it is said to be…
A: Note - Hi! Thank you for the question As per the honour code, We’ll answer the first question since…
Q: 60 SECURITY (Percent of terrorists caught) 8 4 5 0 0 True 30 60 TOURISM (Millions of visitors) 90…
A: Ans) Graph Explanation: The graph is between security and Tourism. With the decrease in security,…
Q: STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: hat would be your production rate each month? A. 4250 B. 3500 OC. 4250, 3000, 4000, 5000 OD. 2000,…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: a) what would be an appropriate reorder paint? b) How does your ur answer
A:
Q: The production planner for a private label soft drink maker is planning the production of two soft…
A: Decision variable: Suppose- X be the no. of root beer to be produced Y be the no. of sassafras…
Q: ts utilized to define IT project
A: Projects involving computer systems, databases, and related infrastructure are all considered IT…
Q: Refer to the legend for the activity that corresponds to each code. Using the line drawing tool,…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: A liquor store sells two types of whiskey: Gold and Blue. Gold sells for $3,000/100ml. Every 100ml…
A: Here, we need to determine the optimal production plan, and this would come with LP formulation and…
Q: Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in…
A: Lot size = 700 Annual requirement = 8400 units Ordering cost = $180 per order Inventory carrying…
Q: Agile Project Management with Scrum
A: ‘Agile project management’ is an iterative style which focuses upon frequent value delivery &…
Q: Four jobs are to be assigned to employees. There are 5 available employees. Durations for each…
A: The aim of an assignment problem is to assign one employee to each task in a way such that the total…
Q: Tobacco is shipped from North Carolina to a cigarette manufacturer in Cambodia once a year. The…
A: From the given information, Service level, α = Stock out cost÷Stockout +holding cost…
Q: The annual demand of a product is 27.098; the holding cost, h, is $2.46 per unit per year, and the…
A: Solution Annual Demand(D) = 27.098 Holding cost(H) = $2.46 Ordering cost(S) = $213 Order size(Q) =…
Q: **10.38 The Miami Central Hotel has 400 rooms. Every day. the housekeepers clean any room that was…
A: Given- Total available minutes in a days' shift = 6 hours…
Q: Subject: logistic management 1) Briefly explains the Lean manufacturing approach and also share…
A: * As per the guidelines for multipart questions, the first one is answerable. Lean manufacturing is…
Q: 1) What is Network Design and its importance in logistic managemet?
A: Note - Hi! Thank you for the question As per the honour code, We’ll answer the first question since…
Q: The management and oversight of scope modifications within the project has an impact on the…
A: Project scope is the component of project planning that concerns determining & documenting a…
Q: w the optimal shipping plan. ipping cost is $. (Enter your response as a whole number) More Info…
A: Ans) We will assign a very large cost to warehouse 3 city 4 , so it cannot transport. Sum of…
Q: In relation to the low levels of diversification, mention an example (a company) and explain
A: A diversification strategy is generally used when the organization wishes to grow. Diversification…
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A:
Q: Discuss the concepts of internal and external supply chain integration, and explain why each of…
A: In general, supply chain integration can be stated as the information and interaction system of all…
Q: As a student of feasibility study writing, do you agree or disagree with the statement? Support your…
A: Feasibility study:- A feasibility study is a thorough evaluation that takes into account all of the…
Q: Grave City is considering the relocation of several police substations to obtain better enforcement…
A:
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A: Formulae used: (i) Naive Method- Last period actual data = Current period forecast data (ii)…
Q: Given the following data: Activity Predecessor Duration (days) a - 10 b - 15 c a 17 d b 5 e b 4 f c…
A: Find the Given details below: Activity Predecessors Duration(Days) a - 10 b - 15 c a 17 d…
Q: Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, β=…
A: α = 0.5 β= 0.3 Initial trend value(I) = 12 Initial forecast (Ft) = 200
Q: Determine whether project management software might help you better manage project costs.
A: Project management This can be defined as a scientific approach to managing the projects for an…
Q: integrating the environment into a company's business
A: The 5 approaches mentioned in the Reinhardt article are: Managing Environmental Risk. Saving Costs.…
Q: Use Johnson's rule to obtain the optimum sequence of job processing for the following jobs through a…
A: Johnson's Rule is: From the checklist of unscheduled jobs, choose the one having the shortest…
Q: integration process except for
A: Given Below are the considerations while a particular integration process takes place:
Q: Discuss the concepts of internal and external supply chain integration, and explain why each of…
A: Definitions Internal supply chain integration: - It refers to the collaboration or coordination with…
Q: DMAIC methodology in managing quality
A: The DMAIC framework: To improve business processes systematically, the DMAIC framework can be used.…
Q: The Decision Sciences Department is tyring to determine whether to rent a slow or fast copier. The…
A: The following information is given to us for the two copiers, fast and slow. Slow Copier - Rent is…
Q: Hart Manufacturing makes three products. Each product requires manufacturing operations in three…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: What special case in linear programming does the following graph depict? 10 X2 8 2 0 2x₁+x₂57 2 A)…
A: Ans) This graph has two constraints. 1 Constraint is less than type and other is greater than type.…
Q: An electronics firm produces two models of pocket calculators: the A-100 (A), which is an…
A: Decision Variable: Suppose- A be the no. of A-100 model pocket calculator to be produced each…
Q: What is the standard deviation of the demand during lead-time? A. 60 bottles B. 90 bootles OC. 40…
A: Given- Lead Time (LT)= 4 daysWeekly Std. Deviation (σ)=30 bottlesService Level=90%
Q: Jamaica Cane Products has a fixed cost of $10,000 this period. Its direct labor is $1.50 per unit,…
A: Fixed cost(F) = $10000 Direct labor(L) = $1.50 Material(M) = $0.75 Selling price(S) = $4 Let…
Q: Are there any common errors you've seen in Performance Testing?
A: Performance testing, as the name suggests is a method to test the performance of systems in terms of…
Q: Where is the supply chain organization vulnerable to potential risk? Identify at least four risks
A: In order to ensure that goods are delivered in the proper amounts, to the right location, and in an…
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A: Note: - As it is specified to answer 2, 3, and 4, we will answer only those. Given data is
Q: The production system design planning considers input requirements, conversion process and output.…
A: Capacity planning can be stated as the type of production planning that generally involves…
Q: Based on the activity time estimates, the expected times for each of the activities are (round…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A: 2. Naïve methodThe naïve method is the simplest forecasting method and just predicts that the value…
Q: Samantha’s Group of Companies is deciding if it should design an advertising system for use on its…
A: Find the Given details below: Given details: Decision Good Condition Bad Condition Option 1:…
Q: Describe the importance of control over inventory ? Describe three inventory cost flow assumptions…
A: "Since you have asked multiple questions, we will the first question for you. If you want any…
A manufacturing firm has three plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below:
Customer (requirement) | ||||||||||||
Factory (capacity) | Customer 1 (25) | Customer 2 (50) | Customer 3 (125) | Customer 4 (75) | ||||||||
A (100) | $ | 15 | $ | 10 | $ | 20 | $ | 17 | ||||
B (75) | $ | 20 | $ | 12 | $ | 19 | $ | 20 | ||||
C (100) | $ | 22 | $ | 20 | $ | 25 | $ | 14 | ||||
Note: This question requires Solver.
Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?
Step by step
Solved in 3 steps with 4 images
- Supply Chain Management Metrics: Back order – An unfilled customer order. A back order is demand (immediate or past due) against an item whose current stock level is insufficient to satisfy demand. Customer order promised cycle time – The anticipated or agree upon cycle time of a purchase order. It is a gap between the purchase order creation date and the requested delivery date. Customer order actual cycle time – The average time it takes to actually fill a customer’s purchase order. This measure can be viewed on an order or an order line level. Inventory replenishment cycle time – Measure of the manufacturing cycle time plus the time included to deploy the product to the appropriate distribution center. Inventory turns (inventory turnover) - The number of times that a company’s inventory cycles or turns over per year. It is one of the most commonly used supply chain metrics. Here's a question for you: to track these metrics, what kind of a system would you need to implement in your…As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $1.75 $1.50 $0.75 Variable Cost $0.70 $1.00 $0.35 $0.35 % of Revenue 24 25 29 22 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $250.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $250.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $60.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $ (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for w servings (round…As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.20 $2.00 $1.25 $1.20 Variable Cost $0.60 $0.95 $0.35 $0.25 % of Revenue 26 24 30 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $633.640 (round your response to two decimal places).
- I need correct and non plagiarised answer. I will rate accordingly. What is the difference between Quantity Production and Flow Line Production?Jefferson Company’s demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. Actual run time this week 6,106 minutes Machine time available per week 8,600 minutes Actual run rate this week 4.32 units per minute Ideal run rate 6.00 units per minute Defect-free output this week 11,315 units Total output this week (including defects) 15,500 units 1. Compute the utilization rate.2. Compute the efficiency rate. 3. Compute the quality rate. 4. Compute the overall equipment effectiveness (OEE).As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $2.00 $1.00 $0.75 Variable Cost $0.65 $0.90 $0.30 $0.25 % of Revenue 25 24 31 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $60.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $ 1138.92 (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for wine =…
- A department works on 8 hours shift, 288 days a year and has the usage data of a machine, as given below: Processing time (Standard time in hours) Annual Demand Product (units) A 325 5 B 450 4 550 6 Calculate: (a) Processing time needed in hours to produce products A, B and C (b) Annual production capacity of one machine in standard hours (c) Number of machines requiredFedori Corporation has a Parts Division that does work for other Divisions in the company as well as for outside customers. The company's Machinery Division has asked the Parts Division to provide it with 4,000 special parts each year. The special parts would require P23.00 per unit in variable production costs. The Machinery Division has a bid from an outside supplier for the special parts at P37.00 per unit. In order to have time and space to produce the special part, the Parts Division would have to cut back production of another part-the YR24 that it presently is producing. The YR24 sells for P40.00 per unit, and requires P28.00 per unit in variable production costs. Packaging and shipping costs of the YR24 are P3.00 per unit. Packaging and shipping costs for the new special part would be only P1.50 per unit. The Parts Division is now producing and selling 15,000 units of the YR24 each year. Production and sales of the YR24 would drop by 20% if the new special part is produced for…As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $2.00 $1.50 $1.00 Variable Cost $0.65 $0.90 $0.30 $0.25 % of Revenue 25 26 30 19 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $957.69 (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for wine =…
- The option attempts to absorb the demand fluctuations is : Capacity option Demand optionA production line is a set of sequential operations established in a factory plant where components are assembled to make a finished product or where materials are put through a refining process to produce an end-product that is suitable for onward consumption. Ford have seven production lines in their manufacturing plant for their automotive parts where each production line produces 120, 100, 80, 116, 77, 94, 112 output per day. (a) As the Production Manager at Ford, you are required to submit the daily report of the production plant. Calculate the mean, median, and mode from the data based on the output that has been provided. (b) Also calculate the three critical parameters for measuring spread in the following ways: Range Variance Standard DeviationAs a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…