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 thesolution

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 thesolution

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

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.
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.
Spring and Summer Fashions, a clothing producer, has generated a forecast for the next eight weeks.Demand is expected to be fairly steady, except for periods 3 and 4, which have higher demands.Period 1 2 3 4 5 6 7 8 TotalForecast 1,200 1,200 1,400 3,000 1,200 1,200 1,200 1,200 11,600The company typically hires seasonal workers to handle the extra workload in periods 3 and 4. Thecost for hiring and training a seasonal worker is $50 per worker, and the company plans to hire twoadditional workers and train them in period 3, for work in period 4, and then lay them off (no cost forlayoff). Develop an aggregate plan that uses steady output from regular workers with added outputfrom the two seasonal workers in period 4. The output rate for the seasonal workers is slightly lessthan that of regular workers, so their cost per unit is higher. The cost per unit for regular workers is$4 per unit, while cost per unit for the seasonal workers is $5 per unit. Backlog cost is $1 per unitper period.
Always Rain Irrigation, Inc., would like to determine capacity requirements for the next four years to make three types of bronze sprinklers: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next 4 years as follows: Yearly Demand in 000's: Year 1, Year 2, Year 3, Year 4: Bronze 90: 7, 8, 9, 10 Bronze 190: 3, 4, 5, 6 Bronze 360: 11, 12, 15, 18 The machines needed for the bronze sprinklers require two operators, and can produce up to 12,000 sprinklers. Three bronze machines and only one injection molding machine are available. What are the capacity requirements for the next four years, assume that there is no learning? Capacity: Year 1, Year 2, Year 3, Year 4: Demand for bronze sprinklers: Percentage of capacity used: Machine requirements: Labor requirements:
The Scottville "Mill" produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0 below along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The Mill has two types of looms: dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The Mill has a total of 38 looms: 8 are dobbie and 30 are regular. The rate of production for each fabric on each type of loom is given in Table 1.1. The time to change over from producing one fabric to another is negligible and does not have to be considered. The Scottsville Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at…
The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: month production days demand(in hundred of cases) April 14 75 May 20 100 June 24 200 July 26 140 August 20 100 September 18 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty’s production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and…
Wine Accessories Inc. (WAI) produces two models of corkscrews, the standard model and a deluxe model. WAI follows a level aggregate plan, producing 20,000 corkscrews per month, or 5000 corkscrews per week. Th e MPS is developed in weekly time periods. Th e forecasts for each model and the projected available are shown in the next two tables. Th e replenishment order quantity is 2000 units for the standard model and 1000 units for the deluxe model. Note that you can place multipleorders if a single order is insuffi cient to cover the forecast (you can produce 4000 units of the standard model if necessary, or 2000 or 3000 units of the deluxe model). Remember that total weekly production is limited to 5000 corkscrews. Develop an MPS for each of the products.
A linear programming computer package is needed. The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown. Model Production Costs Labor Requirements (hours) Current Inventory Manufacturing Assembly Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the…
The 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 ﬁrm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The ﬁrm 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 solver
Tybee Industries Inc. uses a job order cost system. The following data summarize the operations related to production for January, the first month of operations: a. Materials purchased on account, $29,800. b. Materials requisitioned and factory labor used: Job Materials Factory Labor 301 $ 2,960 $2,775 302 3,620 3,750 303 2,400 1,875 304 8,100 6,860 305 5,100 5,250 306 3,750 3,340 For general factory use 1,080 4,100 c. Factory overhead costs incurred on account, $5,500. d. Depreciation of machinery and equipment, $1,980. e. The factory overhead rate is $54 per machine hour. Machine hours used: Job Machine Hours 301 25 302 36 303 30 304 72 305 40 306 25 Total 228 f. Jobs completed: 301, 302, 303 and 305. g. Jobs were shipped and customers were billed as follows: Job 301, $8,250; Job 302, $11,200; Job 303, $15,000. Required: 1. Journalize the entries to record the…
Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men’s and 125 women’s models to be shipped during the first month and 200 men’s and 150 women’s models to be shipped during the second month. Additional data are shown: Model Production Costs Current Inventory Men’s $120 20 Women’s 90 30 The company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this problem as a linear programming model so that a production schedule can be established in order to minimize production and inventory costs and satisfies the labor-smoothing,…
Carlos Cavalas, the manager of Echo Products’ Brazilian Division, is trying to set the production schedule for the last quarter of the year. The Brazilian Division had planned to sell 70,070 units during the year, but by September 30 only the following activity had been reported: Units Inventory, January 1 0 Production 71,100 Sales 63,700 Inventory, September 30 7,400 The division can rent warehouse space to store up to 30,500 units. The minimum inventory level that the division should carry is 2,800 units. Mr. Cavalas is aware that production must be at least 4,440 units per quarter in order to retain a nucleus of key employees. Maximum production capacity is 44,200 units per quarter. Demand has been soft, and the sales forecast for the last quarter is only 19,500 units. Due to the nature of the division’s operations, fixed manufacturing overhead is a major element of product cost. Required: 1a. Assume that the division is using variable costing. How many…