A new product is planned to be manufactured for the following four weeks. The demands for cach week are 520, 720, 520, and 620 units, respectively. The company has a steady workforce of 10 employees but can hire and fire temporary workers, if necessary. The extra costs of hiring and firing in any week are $200 and $400 per worker, respectively. A permanent worker can produce 12 units per week, and a temporary worker can only produce 10 units per week. The company can produce more than needed in any week and carry the surplus over to a following week at a holding cost of $50 per unit per week. Develop an optimal hiring/firing policy for the company over the four-week planning horizon. Write down your models by hand and then solve by Excel. Can you hire less temporary employees if cost per employee increases by 25% without changing the current optimal solution? If yes why? If not why and what will be the maximum increase that the current system can allow?

A new product is planned to be manufactured for the following four weeks. The demands for cach week are 520, 720, 520, and 620 units, respectively. The company has a steady workforce of 10 employees but can hire and fire temporary workers, if necessary. The extra costs of hiring and firing in any week are $200 and $400 per worker, respectively. A permanent worker can produce 12 units per week, and a temporary worker can only produce 10 units per week. The company can produce more than needed in any week and carry the surplus over to a following week at a holding cost of $50 per unit per week. Develop an optimal hiring/firing policy for the company over the four-week planning horizon. Write down your models by hand and then solve by Excel. Can you hire less temporary employees if cost per employee increases by 25% without changing the current optimal solution? If yes why? If not why and what will be the maximum increase that the current system can allow?

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

QUESTION TWO * Blue Inc. produces a product that has a 6 month demand cycle, as shown below. Each unit requires 10 worker hours to produce, at a labour cost of K6, 000 per hour regular rate or K9, 000 per hour overtime rate. The total cost per unit is estimated at K200, 000 but units can be subcontracted at a cost of K208, 000 per unit. There are currently 20 workers employed in the subject department, and hiring and training costs for additional workers are K300,000 per person; whereas layoff costs are K400,000 per person. Company policy is to retain a safety stock equal to 20% of the monthly forecast, and month's safety stock becomes the beginning inventory for the next month. There are currently 50 units in stock carried at a cost of K2, 000 per unit month. Unit shortage, or stockpots, has been assigned a cost of K20, 000 per unit month. February March April 400 100 21 21 168 May 200 22 176 June 300 20 January 300 Forecast demand 500 Work days 22 19 176 152 168 160 Work hour at 8…
QUESTION 1 According to the time-based strategy, check out this scenario. if the processing time is reduced from 2 hours per a product, to only 1 hour per product, the time to market will be longer and customer service is not enhanced O True O False QUESTION 2 Quantity Year 1 Year 2 J F M A M J JASOND Months O True O False O Not enough information Based on theabove figure, the demand pattern is seasonal in which you can notice that April month in year 2 has the highest possible demand value.
Q5) Metters Cabinets, Inc., needs to choose a production method for its new office shelf, the Maxistand. To help accomplish this, the firm has gathered the following production cost data. Metters Cabinets projects an annual demand of 24,000 units for the Maxistand. The Maxistand will sell for $120 per unit. Which process type will maximize the annual profit from producing the Maxistand? What is the value of this annual profit? Annualized fixed Variable costs (per unit) ($) cost of plant & Process type equip. LABOR MATERIAL ENERGY Mass Customization $1,260,000 30 18 12 Intermittent $1,000,000 24 26 20 Repetitive $1,625,000 28 15 12 Continuous $1,960,000 25 15 10
Question 16 MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost = SR 17 per unit per month Average pay rate = SR 10 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) Using excel, caleulate the total cost of the following plan : - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field ) Attach your solutions.
question 1 Terminator, Inc., manufactures a motorcycle part in lots of 250 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $280, for a total cost per completed unit of $430. The lead time to make the part is 3 weeks, and the annual demand is 4,200 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? nothing units. (Enter your response as an integer.) What is its value? $_______.(Enter your response as an integer.) b. How many units of the part are held, on average, as pipeline inventory? nothing units. (Enter your response as an integer.) What is its value? $________________ (Enter your response as an integer.)
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
14.May I know the correct option?
QUESTION 9 Consider a SKU with 276 picks forecasted during the planning horizon and an annual flow of 2000 ft. Suppose that: • the cost of picking from the forward fast-pick area is 1 minute per pick • the cost of picking from the reserve area is 4 minutes per pick • the cost of restocking the fast-pick area from reserve is 5 minutes per restock What is the labor efficiency of this SKU? Provide your answer to the nearest single decimal point.
Question 5 Terminator, Inc., manufactures a motorcycle part in lots of 150 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $320, for a total cost per completed unit of $470. The lead time to make the part is 2 weeks, and the annual demand is 3,800 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? __________________ units. (Enter your response as an integer.) What is its value? $___________________ (Enter your response as an integer.) b. How many units of the part are held, on average, as pipeline inventory? ________________ units. (Enter your response as an integer.) What is its value? $__________________________ (Enter your response as an integer.)
Q7.An example of a leading performance measure is: a. Number of new customers b. Production cycle time
Q3 The Muscat Chocolate Company produces all types of chocolate candy that is boxed before being sent to the retail outlets. After the chocolate has been poured, the candy production goes through all types of operation from adding fillings, shaping, decorating, coating, and the like, before being put into boxes, wrapped, and put into cartons. This production/assembly operation operates for 5 days/week, 8 hours/day. Weekly demand of boxes of the chocolates is shown in Table Q3. Production/packaging consists of 9 operations. These together with estimated time for completion, are given in Table Q3. Determine the following: (i) Draw the precedence diagram; (ii) The cycle time and theoretical number of workstations; (ii) The efficiency of the assembly line if the most tasks following rule/criteria is being followed. Table Q1 Weekly Demand Operations A B 6,100 Time (sec) Precedence 6. 8. A 9 B 11 12 B C. D A F 14 G 9 F 5 E 12 G, H
Problem 10 Valdez Motors Co. makes motorcycles. Management wants to overhead costs to plan its operations. A recent trade publication revealed that overhead costs tend to vary with machine hours. To check this, they collected the following data for the past 12 months. estimate Overhead Costs P 4,500 4,225 4,321 5,250 4,800 5,100 4,450 4,200 5,475 4,760 4,325 3,975 Month No. Machine Hours 175 170 3 160 4 190 5 175 200 160 7 150 9 210 10 180 11 170 12 145 Requirements 1. Use the high-low method to estimate the fixed and variable portion of overhead costs based on machine hours. 2. If the plant is planning to operate at a level of 200 machine hours next period, what would be the estimated overhead costs? 3. Use the method of least square to estimate the fixed and variable portion of overhead costs based on machine hours.