Question #1

Formulate a chase sales and operations plan for a company with the following predicted demand: Q Month 1 2 3 4 5 6 Total Demand 17,700 8,700 8,100 16,500 18,300 12,300 81,600 The beginning workforce is 405 employees. The monthly output per employee is 150 units. The cost to hire and lay off a worker are $1,000 and $4,000, respectively. The cost to carry an item in inventory for one month is estimated at $11, and the stockout cost is $45 per unit. Show the production schedule, the inventory levels, and the changes in workforce from period to period. Compute the plan's cost. Construct the chase sales and operations plan (enter your responses as whole numbers). Month 1 2 3 4 5 6 Total Demand 17,700 8,700 8,100 16,500 18,300 12,300 81,600 Production Ending Inventory Stockouts Workers Hires Layoffs The cost of the chase sales and operations plan is $ . (Enter your response as a whole number.) Determine whether the following is a feasible sales and operations plan. Assume that the company has 56,500 labor hours available during the next planning period time horizon. |.'_l~ Product Units Standard Hours Demanded (In hoursfunlt) A 30,500 0.85 B 6,500 0.65 C 13,500 1.20 D 28,000 0.40 The total labor hours required by these four products for the next quarter is . (Enter your response as a whole number.) The sales and operations plan V feasible. is is not A process is designed to produce 1,900 units per hour. The process has a scrap rate of 2.5% and a 7% inherent inefficiency. Assuming that the actual output of the process is 1,575 units per hour, what is the process design capacity, available capacity, actual capacity, capacity utilization, efficiency and the output gap for this process? The design capacity is units per hour. (Enter your response as a whole number.) The available capacity is units per hour. (Enter your response rounded to one decimal place.) The actual capacity is units per hour. (Enter your response rounded to one decimal place.) The capacity utilization is |%. (Enter your response rounded to one decimal place.) The efficiency is |%. (Enter your response rounded to one decimal place.) The output gap measure is |%. (Enter your response rounded to one decimal place and include a minus sign.)A company believes that its demand for the next six months is as follows: 91 Month 1 2 3 4 5 6 Total Demand 7,000 5,000 9,000 4,500 10,000 9,500 45,000 The output per worker per month is 50 units. The per worker hiring and lay off costs are $2,000 and $2,000, respectively. There is no beginning inventory, and the starting workforce is 225. It cost the company $15 to carry an item in inventory each month, and the stockout costs is estimated to be $50 per unit. Develop a level sales and operations plan for this rm. Develop the monthly production schedule and show the labor workforce and inventory levels. Finally, compute the cost of the plan. Construct the production table. Note that a negative beginning inventory denotes a stockout that is carried forward (enter your responses as whole numbers). Month Demand Blsecielr'rltigg Production grim?\" stockouts 1 7,000 2 5,000 3 9,000 4 4,500 5 10,000 6 9,500 Construct the labor table. Note that at the start of the planning process 225 workers are employed (enter your responses as whole numbers.) Month Workers Hires Layoffs requlred 1 2 3 4 5 6 The total plan cost is $ . (Enter your response as a whole number.) Item A has a gross requirement of 2,300 in week 5. Currently, there are 100 Item A's on hand with a scheduled receipt of 1,800 items in week 3. The lead time for item A is 2 weeks with an order quantity of 900. Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). Week 0 1 2 3 4 5 6 Item A LT = 2 Quantity: FOQ = 900 Gross Requirements Scheduled Receipts Projected on Hand 100 Net Requirements Planned Order Receipts Planned Order Releases