sAlan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the sameproduction equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demandforecast for the next four months, in hours required to make each product is:PRODUCTAPRIL870670770Regular timeOvertimeMAY670770570JUNE870970770Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is madeand carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A.$4 for B, and $5 for CAPRIL1,570770Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A. $5for B, and S6 for C. The overtime premium is 50 percent of the regular time cost per hourThe number of production hours available for regular time and overtime isJULY1,2701,070920MAY1,300720JUNE1,8701,100JULY2,050960Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)Objective value

Given Details:ProductAprilMayJuneJulyA8706708701270B6707709701070C770570770920Regular…

Answered: Alan Industries is expanding its…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

Personnel Planning; TDABC Recent competitive pressures have caused National InsuranceCompany to examine policies regarding personnel planning. As a start, the company has decided toexperiment with and develop a time-driven ABC model for its claims processing center.A study of this support center indicates the following three primary activities: remote processingof customer claims, 0.5 hour; onsite processing of customer claims, 1.0 hour; and updating/maintaining customer records, 0.2 hour. Onsite processing is required for larger claims, while remote processing is done for smaller claims. (For onsite processing, assume—for simplicity—that the claimsprocessors use their own automobiles.) All claims will require that the customers’ records be updated.The claims processing center currently employs three full-time employees. Total annual cost ofthe center (salaries, depreciation, utilities, etc.) is estimated at $255,000. The net amount of availablepersonnel time per year for this…
Climate Control, Inc., makes expedition-quality rain gearfor outdoor enthusiasts. Management prepared a forecast ofsales (in suits) for next year and now must prepare a produc-tion plan. The company has traditionally maintained a levelworkforce strategy. All nine workers are treated like familyand have been employed by the company for a number ofyears. Each employee can produce 2,000 suits per month.At present, finished goods inventory holds 24,000 suits. Thedemand forecast follows: Use the Sales and Operations Planning with SpreadsheetsSolver in OM Explorer or develop your own spreadsheetmodels to address the following questions. a. Management is willing to authorize overtime in pe-riods for which regular production and current lev-els of anticipation inventory do not satisfy demand.However, overtime must be strictly limited to no morethan 20 percent of regular-time capacity. Managementwants to avoid stockouts and backorders and is notwilling to accept a plan that calls for shortages.…
A company is setting up an assembly line to produce 90 units per hour. The table below identifies the work elements, times, and immediate predecessors. Work Element Time (Sec.) Immediate Predecessor(s) A 25 - B 18 A C 20 A D 5 B, C E 12 C F 8 E G 16 D, F H 12 G Use one of the heuristic decision rules described in Table below to balance the assembly line so that it will produce 90 units per hour. Clearly state the decision rule you use and complete the below table using the selected rule. Decision Rule Logic Longest work element Picking the candidate with the longest time to complete is an effort to fit in the most difficult elements first, leaving the ones with short times to “fill out” the station. Shortest work element This rule is the opposite of the longest work element rule because it gives preference in workstation assignments to those work elements that are quicker. It can be tried…
How would you manually write a mathematical model this?
Tribal Systems, Inc., is opening a new plant and has yet todecide on the type of process to employ. A labor-intensiveprocess would cost $10,000 for tools and equipment and $14 for labor and materials per item produced. A more au-tomated process costs $50,000 in plant and equipment but has a labor/material cost of $8 per item produced. A fullyautomated process costs $300,000 for plant and equipmentand $2 per item produced. If process selection were basedsolely on lowest cost, for what range of production wouldeach process be chosen?
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Labor-Hours Required Department A B с (hours/unit) Product 1 Product 2 Hours Available Production 1.00 0.30 Profit contribution/unit $30.00 0.20 38.27 0.35 0.20 0.50 $15.00 (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. If required, round your answer to two decimal places. Product 1 Product 2 69.77 M 95 72.09 38 50 (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? Dept A What is the upper limit of what…
Tasty Tim’s Tasty Tim’s is a specialty taco restaurant. The following tasks are required for the successful assembly of a Tasty taco (times are in seconds per taco): Chop and trim meat – 30 Chop vegetables – 20 Grill meat – 240 Grill vegetables – 180 Prepare toppings - Lettuce - 10 - Tomato - 15 - Guacamole - 40 Assemble taco - Add meat - 5 - Add vegetables - 5 - Add cheese - 5 - Add toppings - 10 Wrap taco - 20 During the lunch hour, Tasty Tim’s encounters demand for 120 tacos. What is the labor content of one of Tasty Tim’s tacos?
Tasty Tim’s Tasty Tim’s is a specialty taco restaurant. The following tasks are required for the successful assembly of a Tasty taco (times are in seconds per taco): Chop and trim meat – 30 Chop vegetables – 20 Grill meat – 240 Grill vegetables – 180 Prepare toppings - Lettuce - 10 - Tomato - 15 - Guacamole - 40 Assemble taco - Add meat - 5 - Add vegetables - 5 - Add cheese - 5 - Add toppings - 10 Wrap taco - 20 During the lunch hour, Tasty Tim’s encounters demand for 120 tacos. A) What is the labor content of one of Tasty Tim’s tacos? B) What is the Takt time (in seconds/unit) takt time for Tasty Tim’s taco shop? C) In an ideal world, how many workers should Tim hire to make tacos? D) During off-peak afternoon hours, demand at Tasty Tim’s drops to 40 tacos each hour. How many employees should Tim schedule to work during the afternoon? Again, ignore any effects of idle time or inefficiency due to poor line balancing.
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
Tax Prep Advisers, Inc., has forecasted the following staffingrequirements for tax preparation associates over the next12 months. Management would like three alternative staffingplans to be developed. The company currently has 10 associates. No more than 10new hires can be accommodated in any month because oflimited training facilities. No backorders are allowed, andovertime cannot exceed 25 percent of regular-time capacityon any month. There is no cost for unused overtime capac-ity. Regular-time wages are $1,500 per month, and overtimewages are 150 percent of regular-time wages. Undertime ispaid at the same rate as regular time. The hiring cost is $2,500per person, and the layoff cost is $2.000 per person.a. Prepare a staffing plan utilizing a level workforce strategy,minimizing undertime. The plan may call for a one-timeadjustment of the workforce before month 1.b. Using a chase strategy, prepare a plan that is consistent withthe constraint on hiring and minimizes use of overtime.c.…
Accompany makes two products (1&2) each product requires time on two machines (A&B). specification for each product is as follows. Product1 product2 Processing time on Machine A (hrs/unit) 2 2 Processing time on Machine B (hrs/unit) 1 2 Material and labour cost ( ksh/unit) 14 15 Selling price (ksh/unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hours and on machine B is 260 hours. Formulate the linear programme which, when…
What written materials should the supervisor provide for new letter carriers in light of what Carol Burgess already provides? Carol Burgess is a letter carrier and a part-time trainer of letter carriers for the U.S. Postal Service in a major city on the west coast. She trains all new letter carriers in her service area, which encompasses the northern half of her state. Over the past five years she has trained 318 new letter carriers. Typically,the training is offered prior to the new letter carrier’s entry onto the job, although sometimes it occurs shortly thereafter.The training program typically encompasses both the orientation of new employees to the U.S. Postal Service and the development of specific skills needed by the new letter carrier. The latter involves practice in casing mail (i.e., sorting) to appropriate locations of a case in preparation for delivery,reading maps, determining appropriate sequencing of delivery, and customer relations. The total training program takes…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS