iEx transports products from their three processing plants directly to three warehouses. Theproducts are processed in plants located in Athlone, Ballinasloe and Cavan. The warehousesare located in Kilkenny, Limerick, and Mayo.In line with the research supporting a shorter working week and higher productivity, theplants and warehouses operate on a FOUR-day week basis. Supply and demand are asfollows: Athlone can supply 120 units/week; Ballinasloe can supply 80 units/week; andCavan can supply 20 units/week. Demand is 60 units/week at Kilkenny, 120 units/week atLimerick and 40 units/week at Mayo. Daily Per unit shipping costs (in Euro) from theprocessing plants to each of the warehouses are displayed in the table below.ToKilkennyLimerickMayoFromAthlone48Ballinasloe637Cavan95Formulate the linear programming model of the iEx transportation problem to minimizethe daily total shipping cost.

Decision Variables: Suppose-Xij represents the product transportation between processing plants…

Answered: iEx transports products from their…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast demand 62 84 86 90 90 Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units/year Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity. Round your answers to the nearest whole number. Year 1 2 3 4 5 Extra capacity needed (units) Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number.…
Baker Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast Demand 119 132 133 137 136 Currently the manufacturer has ten machines that operate on a two-shift (eight hours each) basis. Twenty days per year are available for scheduled maintenance of equipment. Assume there are 250 workdays in a year. Each manufactured good takes 32 minutes to produce. What is the effective capacity of the factory? Round your answer down to the nearest whole number and use this answer in subsequent computations. units/year Given the five-year forecast, how much extra capacity is needed each year? Round your answers to the nearest whole number. Year 1 2 3 4 5 Extra capacity needed (units) Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number. Year 1 2 3 4 5 Additional machines…
Baker Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast Demand 131 150 151 154 153 Currently the manufacturer has ten machines that operate on a two-shift (eight hours each) basis. Twenty days per year are available for scheduled maintenance of equipment. Assume there are 250 workdays in a year. Each manufactured good takes 24 minutes to produce. What is the effective capacity of the factory? Round your answer down to the nearest whole number and use this answer in subsequent computations. units/year Given the five-year forecast, how much extra capacity is needed each year? Round your answers to the nearest whole number. Year 1 2 3 4 5 Extra capacity needed (units) Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number.
. The Newcoat Painting Company has for some time been experiencing high demand for its automobile repainting service. Because it has had to turn away business, management is concerned that the limited space available to store cars awaiting painting has cost them in lost revenue. A small vacant lot next to the painting facility has recently been made available for rental on a long-term basis at a cost of $10 per day. Management believes that each lost customer costs $20 in profit. Current demand is estimated to be 21 cars per day with exponential interarrival times (including those turned away), and the facility can service at an exponential rate of 24 cars per day. Cars are processed on a FCFS basis. Waiting space is now limited to 9 cars but can be increased to 20 cars with the lease of the vacant lot.Newcoat wants to determine whether the vacant lot should be leased. Management also wants to know the expected daily lost profit due to turning away customers if the lot is leased. Only…
The Blah Cafe operates a restaurant location in Fresno, CA where they serve food in an eclecticcasual blah whatever setting. Blah Cafe analyzes their operations in two seasonal periods – Spring& Summer being the first seasonal period and Fall & Winter being the second. The averagemonthly demand, with revenue and variable cost figures for both the seasonal periods is given in the data tableAs can be seen in the Table, demand is pretty high and robust in the Spring and Summer season,with demand falling in the Fall and Winter season.1. Help Blah Cafe develop an EXCEL spreadsheet model to determine the break-even point*demand quantity for each of the seasonal periods. Explain how you found the break-evenpoint. Should the restaurant be kept open during the Fall & Winter months? Explain.*At the Breakeven Point (demand), Total Revenue = Total Costs (or at Breakeven Point,Profit = zero). 2. Now given current demand for each season, what fixed cost will justify keeping therestaurant…
Gregory has started a small agricultural business that specialises in maize and sunflower seeds inGrey Town, KZN. His produce is AgriSA approved, and his organisation is looking to hire a supply chain management consultant given their impact and contribution to the local economy. You have been recruited by Gregory, assist him with the following questions: Gregory is uncertain as to which replenishment system he should use. Differentiate between the continuous review and periodic review models and suggest the most suited for him with the aid of at least two practical examples.Note: you are required to provide a paraphrased overview of the models before at least two practical examples are provided to support the choice.
Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. 1 2 3 4 5 86 90 Year Forecast demand Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. a. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units, year b. Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity, Round your answers to the nearest whole number. Year 1 Additional machines needed 2 1 24 Extra capacity needed (units) C. Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number. 4 3 4 5 PE
Baker Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. 5 2 3 4 123 125 127 126 Year Forecast Demand Currently the manufacturer has eight machines that operate on a two-shift (eight hours each) basis. Twenty days per year are available for scheduled maintenance of equipment. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. 1 106 a. What is the effective capacity of the factory? Round your answer down to the nearest whole number and use this answer in subsequent computations. Year Additional machines needed units/year b. Given the five-year forecast, how much extra capacity is needed each year? Round your answers to the nearest whole number. Year 1 2 3 Extra capacity needed (units) c. Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number. 1 2 3 4 5 5
Current total inventory level of a company (Ip) is 5,000 units, which are held at 4 different facilities (nE). Next year, the company plans to open 5 new facilities. Provide an estimate on the total future inventory level (IF) for the company. 27 11,250 units 4,472 units 7,500 units 8,944 units 5,590 units
List several alternatives for adjusting capacity. List severalalternatives for managing demand
Bienestar Company produces two types of get - well cards: scented and regular. Drivers for the four activities are as follows: Calculate the consumption ratios for the four drivers ( round to two decimal places).
Slopes & Sleds (S&S) makes skis, snowboards, and high- end sledding equipment. As shown below, the demand for its products is highly seasonal. The company employs 10 workers who can each produce 200 units of various equipment per month. The cost of regular production is $8 per unit, overtime $12, and subcontracting $16. Overtime is limited to regular production each period. Subcontracting is unlimited. Hiring and firing costs are $500 per worker. In- ventory holding costs are $2 per unit per month. Given the estimates of demand below, create an aggregate production plan for Slopes & Sleds using: a. the current workforce level (supplemented with overtime and subcontracting as needed), b. chase demand. Month DemandJanuary 6400February 7000March 1500April 500May 600June 1400July 1600August 2000September 1400October 1500November 5200December 6900

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS