Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period)

Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period)

Name: Lot sizingA producer with one product faces the following forecasted d
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Lot sizingA producer with one product faces the following forecasted demand for the next 10 weeks:week1. 2. 3. 4.5. 6.7.8. 9.10Requirement30127211244235307568Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each tim

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

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
Lake Stevens Marina has estimated that fixed costs per month are $350,000 and variable cost per dollar of sales is $0.30 . The selling price per dollar of sales is: $1.00 Determine the effect on the break-even point in sales dollars considering each of the following independently. 1. Total fixed costs increase to $365,000. Break-even point = ÷ = 2. Variable costs decline to $0.25 per sales dollar. Break-even point = ÷ = 3. The anticipated sales volume increases to $1,100,000. Break-even point = ÷ = Comment on the BEPs from the above analyses in questions 1,2,3.
The Toys-R-4-U Company has developed two new toys for possible inclusion in its productline for the upcoming Christmas season. Setting up the production facilities to beginproduction would cost $50,000 for toy 1 and $80,000 for toy 2. Once these costs arecovered, the toys would generate a unit profit of $10 for toy 1 and $15 for toy 2. Thecompany has two factories that are capable of producing these toys. However, to avoiddoubling the start-up costs, just one factory would be used, where the choice would bebased on maximizing profit. For administrative reasons, the same factory would be usedfor both new toys if both are produced. Toy 1 can be produced at the rate of 50 per hourin factory 1 and 40 per hour in factory 2. Toy 2 can be produced at the rate of 40 perhour in factory 1 and 25 per hour in factory 2. Factories 1 and 2, respectively, have500 hours and 700 hours of production time available before Christmas that could beused to produce these toys. It is not known whether these…
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…
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 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
Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity. Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is Month Demand Forecast January 600 February 800 March 900 April 600 May 400 June 300 July 200 August 200 September 300…
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…
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…
Supertronics, Inc., would like to know how the firm’s profit-ability is altered by product mix. Currently, product mix isdetermined by giving priority to the product with the highestper-unit contribution margin (defined as the difference be-tween price and material cost). Details on the Supertronicsproduct line, including processing time at each workstation,follow:a. Assume that Supertronics has 5,500 minutes of capacityavailable at each workstation each week. Develop a linearprogram to define the production mix that maximizescontribution margin.b. Solve your formulation using a computer package such asPOM for Windows. c. Given your solution for part (b), which machine is thebottleneck?d. How would your formulation and solution in part(b) change if 50 units of each product were alreadycommitted to customers and thereby had to beproduced?
A publisher has a fixed cost of $250,000 associated with the production of a college mathematics book. The contribution to profit and fixed cost from the sale of each book is $6.25. (a) Determine the number of books which must be sold in order to break even. (b) What is the expected profit if 50,000 books are sold?
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.