Bags & Box Cereals produces two types of cereals: basic and premium. Each type is sold in box of 100 grams and bags of 200 grams. The company has 4 machines that can package 200,000 boxes, and each machine requires three operators. The company has 5 machines that can package 150,000 bags, and each machine requires four operators. The table below shows the forecasted demand for the next four years. 2 3 4 Вох 100g Bag 200g Вох 100g 50000 70000 100000 120000 Cereal Basic 45000 60000 80000 100000 Cereal 40000 50000 60000 70000 Premium Bag 200g 35000 40000 45000 50000 What is the labor requirement for production of boxes in year 3?
Q: PM Computer Services produces personal computers from component parts it buys on the open market.…
A: a). To meet the demand for each month the production schedule for PM which will minimize total cost…
Q: c. Formulate Linear Optimization Models for the following: i. A company has been given a tender to…
A: Find the Given details below: Given details: 1 2 3 4 Supply 1 21 16 25 13 11 2 17 18 14…
Q: A company manufactures iron cutting machines. Investment amount made with respect to the machine It…
A: a.) Total expenses and expenses per unit for manufacturing machines:(YEM method) Particulars…
Q: A manufacturing company of wood products makes tables and chairs. It primarily uses two machines,…
A: Given Information: I. Decision Variables: Let x = no. of doors to be manufactured for…
Q: RVW (Restored Volkswagens) buys 30 used VW's at each of two car auctions each week held at different…
A: Find the Given details below: Given details: Repair shops Used car lots L1 L2 L3 S1 350…
Q: PT Ceria wants to assign its flagship manager to five offices located in five different countries…
A: Work\Job Singapore Japan Philiphines Hongkong Vietnam Abi 18 26 16 18 11 Adi 15 21 8 20 13 Ali…
Q: Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database…
A: solve this problem by setting up a linear program in Excel and solving using Excel -> Solver as…
Q: XYZ Corporation operates two plants, each of which has a capacity of 110 units per day. Each day,…
A: [A] Units should ship Customer A Customer B Customer C Customer D Plant1 20 0 0 90 Plant 2…
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have…
A: wheat warehouse capacity = 20,000 bushels Inventory beginning of month 1= 6,000 bushels bought and…
Q: Pi Basic Variables | Quantity 4 4 2 y S1 S2 4 -1 S2 1 1 1 Zj Pi Zi 16 4 -4 2 4 The pivot column in a…
A: Given -
Q: A manufacturing firm has four plants and wants to find the most efficient means of meeting the…
A: Given data is
Q: A company produces a product at two plants, 1 and 2. The unit production cost and production…
A: Given information, Production Cost Unit Capacity Plant 1(period 1) 33 7 Plant 1(period 2)…
Q: (d) A company has three factories. Each factory produces three different products (A, Band C).…
A:
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Given Order policy=150 Opening inventory=100
Q: Given the linear program Max 3x+4y S.T. -x+2y/=0 A. Write the…
A:
Q: A wood products firm uses available time at the end of each week to make goods for stock.Currently,…
A: Excel model: Formula: Solver input: Answer: Number of chopping board = 0 Number of knife…
Q: A firm has prepared the following binary integer program to evaluate a number of potentia goal is to…
A:
Q: Please answer this using EXEL AND SOLVER ADD IN. Include and identify decision variables, objective,…
A: O = overtime , RE = regular employees, H = holding cost RP = Regular production, D = demand…
Q: During the next production period, The Diego Garcia Furniture Company is considering producing…
A: As per the sensitivity report, the allowable decrease for objective coefficient (Profit) for…
Q: A factory produces four products, D, C, B, A, using two machines Mand M. The time taken and the cost…
A: First Calculate Profit per unit for each product. Unit Profit of product = Unit selling price – unit…
Q: describe the specific internal control weakness (s) in the system that causes or contributes to the…
A: The answer is as below:
Q: How to solve descision tree using Analytical Solver for the assignment below Chelsea Bush is an…
A: a) Chelsea should run in the NH essential. On the off chance that she progresses admirably, at that…
Q: The John Adams Brewing Company has breweries in three cities; the breweries can supply the following…
A: Given Information: Since the supply and demand are not balanced, a dummy variable needs to be…
Q: 3.4-11. Larry Edison is the director of the Computer Center for Buckly College. He now needs to…
A: Find the Given details below: Time Periods covered by shifts - Full Time Time of day…
Q: 2. Dwight Melody is the manager of a large farm with 1,000 acres of arable land. For greater…
A: Weather Dry Moderate Damp Probability 0.3 0.5 0.2 Crop 1 20 35 40 Crop 2 22.5 30 45 Crop…
Q: RVW (Restored Volkswagens) buys 30 used VW's at each of two car auctions each week held at different…
A: Find the given details below: Given details: Repair shops Used car lots L1 L2 L3 S1 350…
Q: Botany weaving was established in 1934 in Dublin Ireland and it is now an approved supplier of…
A: Find the Given details below: Given details: Plant Nano Seat Fabrics Ultra Curtains Capacity…
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: The AC company decides to open a new factory to satisfy increasing demand. They already have four…
A: Logistics management is described as the process or means of seamlessly moving raw materials, parcel…
Q: A steel manufacturing company at Balakong has operating hours from 7.45am to 5.45 pm. It also…
A: Here, for each day, I would determine the available hours for each day, then, I would subtract the…
Q: Bags & Box Cereals produces two types of cereals: basic and premium. Each type is sold in box of 100…
A: Given Information: About box of 100 grams 4 machines can package 200,000 boxes which means that,…
Q: Determine the distribution for the company so as to minimize the cost of transportation using least…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database…
A:
Q: There are other details about the problem which will be added later. Giapetto started formulating a…
A: The answer is as below:
Q: throughout the country. These are job shops that handle a variety of outpatient surgical procedures.…
A: For the sequence, B-C-D-A-E the job completion time is as follows: 1
Q: A specialist vehicle manufacturer in the U.K. produces two types of minibuses according to order: a…
A: One worker can make = 150 / (48+8) One worker can make = 2.679 units Hence, we will have to…
Q: Mr. Moola, the owner of Moola Farms is attempting to decide which of three crops he should plant on…
A: a)in case of substantial rainfall: Crop A= 7000*0.2 = 1400 Crop B= 2500*0.2 = 500 Crop C= 4000*0.2…
Q: MacDonald opens an 800 acre farm to raise wheat, beef, and alfalfa. He is planning his activities…
A:
Q: . Develop a network representation of this problem. b. Develop a linear programming model that can…
A: a) the network representation of the above case is shown as under- The Supplies for Northern Gas…
Q: RVW (Restored Volkswagens) buys 30 used VW's at each of two car auctions each week held at different…
A: As per the information given, RVW buys 30 used VWs at each of two car auctions each week held at…
Q: Salvador Apparel Company in Barcelona, Spain, has three production departments and two service…
A: The step-down allocation is as follows:
Q: A local television station plans to drop three Friday evening programs at the end of the season.…
A: Find the Given details below: Given details: 5-6 PM 6-7 PM 7-8 PM Home Improvement $…
Q: A local television station plans to drop three Friday evening programs at the end of the season.…
A:
Q: Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company…
A:
Q: Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines…
A: Please note that as per guidelines, we can solve 3 subparts in one post. Please post the remaining…
Q: Brady Corporation produces cabinets. Each week, itrequires 90,000 cu ft of processed lumber. The…
A: Let ‘a’ be the number of cubic feet of grade 1 lumber by purchasing. Let ‘b’ be the number of cubic…
Q: LP PROBLEM: Ozark Farms uses at least 800 lb. of special feed daily. The special feed is a mixture…
A: Given data is
Given Information:
Box of 100 grams
4 machines can package 200,000 boxes
which means that,
Labor requirement for one machine is 3 operators
Bag of 200 grams
5 machines can package 150,000 bags
Labor requirement for one machine is 4 operators
Step by step
Solved in 2 steps with 3 images
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.A barge company moves CoB freight between Memphis and New Orleans. Each barge tow is limited to 15 barges. The round trip takes 6 days. Forecasts call for 37 round trip tows per month. How many towboats does the company need to satisfy this demand? (Assume a month is 30 days.)A manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheet
- A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.A company blends and bottles an energy drink in various flavors for college students. The aggregate forecast for the next four quarters (1 year) in thousands of gallons is as follows: Quarter Demand forecast per 1000 gallons 1 4002 7003 8504 650Each employee works 550 standard straight-time hours each quarter. On average, it takes 27 hours to produce and package 1 unit (1,000 gallons). Straight-time labor costs $6.00/hour; overtime labor costs $9.00/hour. Inventory holding cost is approximately $4.50/unit (1,000 gallons) per quarter, based on ending inventory per quarter. Due to the extremely hot weather, there is no initial inventory on hand to start the first quarter. Management wants a constant workforce (no hiring and no layoffs). Managers have also decided to always round the number of employees needed to the next integer, i.e., 37.2 yields 38 employees. Using a level strategy program, what will the annual labor cost be if only 30 employees are available and overtime is used?City Sod is a small business that sells and lays sod (rolled strips of grass). The owner has devised a forecasting procedure based on demand history from previous years plus projection of demand in recent weeks. The forecast for the next six weeks, in labor hours of sod laying, is 850 870 950 910 970 870 CmTently, City Sod has a staff of sod layers consisting of five crew chiefs and 15 laborers. A crew chief lays sod along with the laborers, but also directs the crew. The owner has decided on the following staffing policies: A two-week backlog will be accmnulated before adding staff. Plans are based on a 40 hour work week; overtime is used only to absorb weather or other delays and employee absence or resignations. The ideal crew size is one crew chief and four laborers. Devise a hiring plan for the first three weeks. In your answer, assmne a current backlog of 1,480 labor hours of sod-laying orders. Does City Sod follow a chase-demand or level-capacity strategy of…
- Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
- LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:The local supermarket buys lettuce each day to ensure very fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $4 a box. The lettuce is sold for $10 a box and the dealer that sells old lettuce is willing to pay $1.50 a box. Past history says that tomorrow’s demand for lettuce averages 250 boxes, with a standard deviation of 34 boxes. How many boxes of lettuce should the supermarket purchase tomorrow?The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…