Concept explainers
A local semiconductor firm, Superchip, is planning its workforce and production
levels over the next year. The firm makes a variety of microprocessors and uses
sales dollars as its aggregate production measure. Based on orders received and sales
sales for the next year by month is as follows:
Production Predicted Demand
Month Days (in $10,000)
January 22 340
February 16 380
March 21 220
April 19 100
May 23 490
June 20 625
July 24 375
August 12 310
September 19 175
October 22 145
November 20 120
December 16 165
Inventory holding costs are based on a 25 percent annual interest charge. It is anticipated
that there will be 675 workers on the payroll at the end of the current year and inventories
will amount to $120,000. The firm would like to have at least $100,000 of inventory at the
end of December next year. It is estimated that each worker accounts for an average of
$60,000 of production per year (assume that one year consists of 250 working days). The
cost of hiring a new worker is $200, and the cost of laying off a worker is $400.
a. Formulate this as a linear program.
b. Solve the problem. Round the variables in the resulting solution and determine
the cost of the plan you obtain.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- 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 April May June July August September Production Days 14 20 24 26 20 18 Forecasted Demand (in hundreds of cases) 75 100 200 140 100 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 objective…arrow_forwardGiven the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per month, and subcontracting is used if additional units are needed to meet the forecast Regular time cost $ 40.00 per unit Overtime cost $ 60.00 per unit (60 max) subcontracting cost $ 80.00 per unit holding cost $ 10.00 per unit per month month 1 forecast 563 month 2 forecast 608 month 3 forecast 648 month 4 forecast 668 month 5 forecast 666 month 6 forecast 688 Show in Excelarrow_forward2arrow_forward
- Given an actual demand this period of 100, a forecast value for this period of 130, and an alpha of 0.6, what is the exponential smoothing forecast for next period? (Round answer to the nearest whole number.) O A. 100 OB. 130 C. 82 O D. O E. 112 118arrow_forwardHanderson Corporation makes a product with the following standard costs: Direct materials Direct labor Variable overhead Standard Quantity or Hours 8.5 kilos 0.4 hours 0.4 hours Standard Price or The company reported the following results concerning this product in August. Actual output Raw materials used in production Purchases of raw materials Rate $ 6.00 per kilo $ 20.00 per hour $ 6.00 per hour 3,200 units 29,030 kilos 31,600 kilos Actual direct labor-hours 1,160 hours Actual cost of raw materials purchases $ 195,920 $ 22,736 Actual variable overhead cost $ 7,540 Actual direct labor cost The company applies variable overhead on the basis of direct labor-hours. The direct materials purchases variance is computed when the materials are purchased. The materials price variance for August is: Multiple Choice $5,440 Farrow_forwardA store has the following demand figures for the last four years: Year Demand 100 1 150 3 112 4 200 Given a demand forecast for year 2 of 100, a trend forecast for year 2 of 10, an alpha of 0.3, and a beta of 0.2, what is the demand forecast for year 3 using the exponential smoothing with trend method? 128 115 Ⓒ 135 Ⓒ 145arrow_forward
- CASE EIGHT GLASSES A DAY (EGAD) The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several "designer" flavors. Marketing manager Georgianna Mercer is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown in the following table (quantities are in tankloads). Month May Jun Jul Aug Sep Oct Total Forecast 50 60 70 90 80 70 420 Production manager Mark Mercer (no relation to Georgianna) has developed the following information. (Costs are in thousands of dollars.) Regular production cost $1 per tankload 60 tankloads Regular production capacity Overtime production cost Subcontracting cost Holding cost Backordering cost Beginning inventory Question $1.6 per tankload $1.8 per tankload $2 per tankload per month Backlogs are not allowed 0 tankloads Among the strategies being considered are…arrow_forwardThe 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…arrow_forwardThe table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.2, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,200 units. Forecast: Time Sales 5 years ago 1,140 4 years ago 1,220 3 years ago 1,450 2 years ago 1,090 Last year 1,150 (Do not round intermediate calculations, round your final answer to the nearest whole number.)arrow_forward
- 2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $7 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (use excel to show formulas for your calculations) Month Forecast 270 2 310 280 4 350 310 280arrow_forwardGiven the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680arrow_forwardMonth# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole numberarrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.