The AC company decides to open a new factory to satisfy increasing demand. They already have four plants, (A, B, C and D) and want to open a new one in site E or F. 4 B C D Factory Wharehouse W1 W2 W3 The capacity of the new plant is going to be 40.000 units The company distributes to the following wharehouses: Expected Annual Demand Capacity A 3 C D E = 20,000 50,000 35,000 70,000 80,000 50,000 70,000 The Logistics department compiled the following cost table specifying the cost per unit to ship the product from each plant to each warehouse: Plant Warehouse W2 2 4 4 1 2 3 W1 1 1 2 5 1 5 Evaluate wich site E or F is more convenient. W3 2 1 5 2 3 4
Q: K65. The Talbot Company uses electrical assemblies to produce an array of small appliances. One of…
A: Given data: Annual demand (D) = 8000 units Ordering cost (Co) = $50 Holding cost (Ch) = $10 per…
Q: Read the articles below and answer the questions that follow. South Africa’s indigenous rooibos tea…
A: Integrated Logistics Support (ILS) is a technical process which imbibes support and logistics…
Q: PERIOD Gross 1 2 3 4 5 6 7 8 9 10 11 12 requirements 30 40 30 70 20 02 10 80 *Holding cost =…
A: Gross demand D = 30+40+30+70+20+10+80+50=330 Holding cost H = 2.50 Set up cost S = 150 EOQ = 2×D×SH…
Q: Q3 Table Q3(i), Table Q3(ii) and Table Q3(iii) show the data provided by a Tababa company involving…
A: Determine the capacity of factory and warehouse demand by resolving table 3ii and 3iii: Demand is…
Q: In a recent review meeting, the client has insisted you complete the project on time. You would like…
A: Given data is Earned value (EV) = $176,500 Actual cost (AC) = $223,500 Planned value (PV) = $229,100…
Q: What could Convention Bureau do to help attract exhibition event to their destination?
A: Destination display and promotion :Convention Bureaux might help with sorting out promotional…
Q: High-Price Oil corporation owns a network of pipelines that is used to transport oil from a drilling…
A: A maximum flow problem tends to seek the flow through all the possible routes.
Q: Globalization of the location decision is the result of all EXCEPT which of the following? A.higher…
A: Globalization refers to accelerating global flows or transfers (of people, products and services,…
Q: Problem 13-2 (Algo) A metal fabricator produces connecting rods with an outer diameter that has a 1…
A: Process capability index is a statistical measure of process capability. It is measure the ability…
Q: Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are…
A: Also, the demand for 550 units of component 1 must be satisfied. Convert available hours in minutes…
Q: SAMPLE NUMBER 1 -2345678 3 10 11 12 13 14 15 READINGS (IN OHMS) 976 1014 1019 1018 989 1009 995 984…
A: Formulae used: Mean (X) =X1+X2+X3........XnNRange = X (largest value) - X (smallest value) Xbar…
Q: Outline the difference between design capacity and effective capacity. Describe their…
A: The table below shows key difference points between design capacity and effective capacity. Sr.…
Q: What are the key traits and differences of Project and Review Technique (PERT)/Critical Path Method…
A: PERT is a project management tool that may be used to control unpredictable project activities. It…
Q: Using the FCFS rule for scheduling, the sequence is Sunny Park Tailors has been asked to make three…
A: Given-
Q: An ?̅ control chart with three-sigma control limits has UCL = 48.75 and LCL = 42.71. Suppose that…
A: Given that: UCL = 48.75 LCL = 42.71 Standard deviation = 2.25 Remember the formula: UCL = μ + (3*…
Q: Robin Is trying to figure out how much extra of boxes of imported chocolate to keep. During the past…
A: Given data is Demand (D) = 85 per weel The standard deviation of demand = 12 Lead time = 6 weeks…
Q: In Excel Answer each of the following problem (II) using regression analysis (easiest way is using…
A: Regression equation can be computed using manual least square method and also by using excel. Here,…
Q: Identify the objectives of Nike
A: Nike Inc. fights against competition while pursuing global market supremacy. Competitive rivalry…
Q: Resource Allocation Your salami manufacturing plant can order up to 1,000 pounds of pork and 2,400…
A: Given data is Product Count Dracula Frankenstein Pork (pounds) 1 2 Beef (pounds) 3 2…
Q: What is carrying cost and provide an example of it.
A: Inventory management is the process of ordering, storing, using, and selling the inventory of the…
Q: Canning Transport is to move goods from three factories to three distribution centers. Information…
A:
Q: How the employees effectively handle a Heavy workload?
A: Organizations usually come across tons of work and they have to complete the tasks on time with…
Q: Briefly explain the following: Strategy formulation Strategy implementation Strategy evaluation
A: Making a great strategy is sometimes easier said than done, but it may put your business on the…
Q: A manufacturing firm requires 600 units of a annually of which the unit cost is 100$. The ordering…
A: Economic order quantity is optimal order size. This optimal order quantity should purchase to…
Q: Mountain States Electric Service is an electrical utility company serving several states in the…
A: If the utility replaces the PCB transformer- Cost $85,000 If the company decides to keep the…
Q: Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the…
A: Net requirements = Gross requirements - (Projected on hand + current period Scheduled receipts)…
Q: Question 1 A firm practices a chase strategy. Production last quarter was 800. Demand over the next…
A: Given data is Quarter 1 2 3 4 Demand 1000 1000 800 700 Last quarter production = 800 Hiring…
Q: Items that the convention bureau could do to help attract MICE events to their destination
A: Convention and visitor's bureau (CVB) - The nonprofit organization that offers information,…
Q: Cox Electric makes electronic components and has estimated the following for a new design of one of…
A: Find the Calculation methods below: Production Volume = 0 to 100000Material Cost = Production volume…
Q: Forecasts based on an average tend to exhibit less variability than the original data.
A: Forecasting is a technique used to predict future outcomes on the basis of past data. Business…
Q: What were the most important improvements in transportation durng the first half of the nineteenth…
A: Transportation is an integral part of our daily lives. It is a medium that provides access to…
Q: Task time estimates for the modification of an assembly line at Jim Goodale's Carbondale,…
A: Given data is
Q: Kidnly answer the following and include steps: Financial planner Minnie Margin has a substantial…
A: Objective function=(R1−20)2+(R2−22)2+(R3−8)2+(R4+2)2 Constraints: (i) 22.37IS + 15.48LC + 17.42MC +…
Q: What is the process for turning an organization's information security plan into a project strategy?
A: Complexity of information security risks has increased, as has the frequency with which news reports…
Q: Read the article below and answer the questions that follow. South Africa’s indigenous rooibos tea…
A: Supply chain Linkages: Supply chain is defined as there is a chain between from raw…
Q: A production process at Kenneth Day Manufacturing is shown in the figure below. The drilling…
A: Given data: Sawing = 6 units/hr Sanding = 2.5 units/hr Drilling = 1.8 units/hr Welding = 7…
Q: The total cost, including normal time labor costs, for this hiring and layoffs plan is $enter…
A: Given cost: Stockout cost = $160 per unitInventory Holding cost = $40 per unitHiring cost = $35 per…
Q: Wanda Lux must select a supplier for a plastic bottle and proprietary dispenser for its new hair…
A: Annual demand = 40000 units Number of operating days = 250 Daily requirement = 40000/250 = 160…
Q: Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools.…
A: Given, Annual Demand = 100000 / year Working weeks = 50 weeks Weekly requirement = 100000/50 = 200…
Q: The senior management at Davis Watercraft would like to determine if it is possible to improve firm…
A: a. Product mix : model A =90, model C = 16, model B = 68 profit = $40900
Q: Which of the following aspects of supply chain management have strong connections? (Check all that…
A:
Q: 1. Explain 4 different configuration of supply chain with the type of product each configuration…
A: Note: As per guidelines, only 1 question can be answered at a time. The first one has been answered.…
Q: a. Draw the AOA network. b. Calculate the Early Event Time and Late Event Time for every node in the…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: What is waste production and its significance?
A: Production of waste indicates the use of materials and energy as well as the depletion of both…
Q: The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements…
A: Formulae used: Average monthly demand = Sum of demandNo. of months For ending inventory and…
Q: This can be a very serious issue because there is a tight timeline. What do you do next? Select an…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: a) What is the crossover point (point of indifference) for the two machines? The crossover point…
A: Given data is as follows: Machine A: Fixed Cost = 77000VC = $18Capacity = 14000 Machine B:Fixed Cost…
Q: What products make up inventory?
A: Inventory management is the process of ordering, storing, using, and selling the inventory of the…
Q: a. Complete the analysis, determining the optimal solution for shipping at the Mosier Clothing…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Identify what documents you would find in the above transactions of Chocolate company in the month…
A: Inventory management refers to the process of sourcing, storing, and selling inventory (finished and…
Please solve using Excel. Thank you.
Step by step
Solved in 2 steps with 5 images
- A franchise operation that sells frozen custardintends to open one or more new stores in amedium-sized metropolitan area. Three sitesare under consideration. Each site hassomewhat different projected profitcontribution and different supervisionrequirements. The first site has an estimateddaily profit of $200 and a weekly supervisionrequirement of 48 hours; the second site has aprojected profit of $100 per day and a weeklysupervision requirement of 30 hours; and thethird site has an estimated daily profit of $150and a weekly supervision requirement of 20hours. The firm will have 65 hours available forper week for supervision.Use Excel to determine which site or sitesshould be selected in order to obtain thehighest projected daily profit?Sue and Joe are a young married couple who are consideringpurchasing a new home. Th eir search has been reduced to threehomes that they both like, at diff erent locations. Th ey haveidentifi ed the factors they consider important and assigneda factor score to each location based on a 5-point scale. Th einformation is shown in the table. (a) Construct a spreadsheet model to help Sue and Joe maketheir decision. What is your recommendation?(b) Construct a stacked column chart to illustrate thealternatives.Mrs. Z, vice president for operations of XY, Inc., a manufacturer of imaginary product T, is constrained from meeting her 5-year forecast by limited capacity at the company’s two existing facilities, which are in San Diego, California (F1) and Grenville, South Carolina (F2). As her able assistant, you have been told that because of existing capacity constraints and the expanding market for the company’s product, a third plant is to be added. The real estate department has advised Mrs. Z that two potential sites seem particularly good, located in Waco, Texas (F3), and Norfolk, Nebraska (F4). The company ships the products to three demand markets in East (M1), Mid-West (M2), and West (M3), via its two cross-docking distribution centers in Colorado (D1) and Kentucky (D2). You are asked to find the optimal distribution strategy that will determine where the third facility be located (F3 or F4), and the best distribution pattern across the supply chain. The company consider the…
- The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown below. Shipping Cost per Case to Warehouses Factory Сарacity W1 W2 W3 W4 W5 $1.20 $3.60 | $4.80 $6.00 $7.20 F1 40,000 30,000 10,000 $2.40 $2.40 | $1.20 $4.80 $6.00 F2 30,000 25,000 5,000 $1.20 $6.00 $1.20 $3.60 $1.20 F3 30,000 10.000 20,000 $6.00 $2.40 $4.80 $6.00 $4.80 F4 25,000 25,000 Demand 30,000 35,000 25,000 15,000 20,000 125,000 What is the total cost of the optimal solution? Total cost = $ (Enter your response to the nearest dollar.)Bob Carlton’s golf camp estimates the following staff requirements for its services over the next 2 years.Quarter 1 2 3 4Demand (hours) 4,200 6,400 3,000 4,800Quarter 5 6 7 8Demand (hours) 4,400 6,240 3,600 4,800Each certified instructor puts in 480 hours per quarter regular time and can work an additional 120 hours overtime. Regular-time wages and benefits cost Carlton $7,200 per employee per quarter for regular time worked up to 480 hours, with an overtime cost of $20 per hour. Unused regular time for certified instructors is paid at $15 per hour. There is nocost for unused overtime capacity. The cost of hiring, training, and certifying a new employee is $10,000. Layoff costs are $4,000 per employee. Currently, eight employees work in this capacity.a. Find a staffing plan using the level…14. Stephanie, the supply chain analyst of Nestle is asked to present an expansion plan for thecompany. The plan is either to construct a plant, open a distribution center, or do nothing. Fromthe plant construction, the company will gain 80,000Php if the market turns favorable, loss of10,000 if average, and loss of 50,000 if unfavorable. From opening a distribution center, thecompany will gain 40,000Php if favorable, gain 20,000Php if average, and loss of 30,000Php ifunfavorable. And if the decision is do nothing, the company will gain nothing regardless of themarket turnout. Then, he was able to determine further the probability of occurrence of eachtype of market. The probability of occurrence is 60%, 25%, and 40%, respectively. He also foundout that he can buy the information on what will really happen to the market for 2,000Php.a. What should be the analyst’s decision?b. How much gain or loss will he expect for the company?c. Should he buy the perfect information? Why or why not?d.…
- Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolutionThe ABC Company is making a production plan for the next year, given the sales forecast for the next year as: Quarter 1 2 3 4 Total Sales Forecast (units) 9,000 12,000 16,000 12,000 49,000 Currently, the firm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The firm estimates its inventory carrying cost to be $2 per unit of ending inventory per quarter and its hiring or layoff costs to be $1,600 per employee. The company currently has an inventory of 2,000 units and wishes to have an ending inventory of at least 1,000 units at the end of each quarter. The company does not plan to incur inventory shortages. Find the optimal production plan that minimizes the total cost by Excel solverThe current system for allocating budgets for the local depots of a national office-cleaning com- pany gives each depot a fixed sum of £35,000 plus an extra £500 for each corporate client in the area the depot covers. la) Express the budget allocation model as an equation and portray it graphically. (b) Use your equation from (a) to work out the budget allocations for the following depots: li) Ashford, which has 43 corporate clients (ii) Byfleet, which has 29 corporate clients liii) Carlton, which has 66 corporate clients (c) A new accountant at the company head office wants to alter the budget allocation model by reducing the fixed sum to £20,000 and increasing to £800 the extra for each corporate client. What changes will these alterations mean for the depots in (b)?
- AlwaysRain Irrigation, Incorporated would like to determine capacity requirements for the next four years. Currently two production lines are in place for making bronze and plastic sprinklers. Three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: YEARLY DEMAND 1 (IN 000s) 2 (IN 000s) 3 (IN 000s) 4 (IN 000s) Plastic 90 32 44 55 56 Plastic 180 15 16 17 18 Plastic 360 50 55 64 67 Bronze 90 7 8 9 10 Bronze 180 3 4 5 6 Bronze 360 11 12 15 18 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. Three bronze machines and only one…the gulf coast foundry is developing a long range strategic plan for buying scarp metal for its foundry oprations the foundry can buy scrap metal in unlimited quantities from two sources, Atlanta(A) and Birmingham (B), and it receives the scrap daily in railroad cars. the scrap is melted down, and lead lead and copper are extracted for use in the foundry processes each railroad car of scrap from source A yields 1 ton of copper and 1 ton of lead and cost $10,000. each railroad car of scrap from source B yields 1 ton of copper and 2 tons of lead and costs $15,000, if the foundry needs at least 2 and a half tons of copper and at least 4 tons of lead per day for the foreseeable future, how many railroad cars of scrap should be ( purchased per day from source A and source B to minimize the long range scrap metal cost?Cotton Island Fashions, a clothing producer, has generated a forecast for the next eightweeks. Demand is expected to be fairly steady, except for periods 3 and 4, which havehigher demands.Month 1 2 3 4 5 6 7 8 TotalForecast 1200 1200 1400 3000 1200 1200 1200 1200 11600The company typically hires seasonal workers to handle the extra workload in periods 3and 4. The cost for hiring and training a seasonal worker is $50 per worker, and thecompany plans to hire two additional workers and train them in period 3, for work in period4, and then lay them off (no cost for layoff). Develop an aggregate plan that uses steadyoutput from regular workers with added output from the two seasonal workers in period 4.The output rate for the seasonal workers is slightly less than that of regular workers, sotheir cost per unit is higher. The cost per unit for regular workers is $4 per unit, while costper unit for the seasonal workers is $5 per unit. Backlog cost is $1 per unit per period.