Alan 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:PRODUCTABCAPRIL770570670Regular timeOvertimeMAY570670470Because 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 C.Objective valueProduction can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.The number of production hours available for regular time and overtime isAPRIL1,470670JUNE770870670MAY1,300620JULY1,1701,070820JUNE1,770870JULY1,950990Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)

Find the given details below: Given…

Answered: Alan Industries is expanding its…

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

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…
1. A company wishes to estimate the profit from two new products. The estimated cost of producing the first product is €3 per unit and it is expected to sell for €5 per unit while the second product costs €5 per unit and is expected to sell for €8 per unit. The first product takes 1 hour of packaging time per day while the second one takes 2 hours of packaging time per day. The time taken for delivery of the first product is 2 hours while the second takes just 1 hour to deliver. The total time available in the packaging and delivery sections is 6 and 8 hours per day respectively. (a) Formulate the linear programming problem. (b) Solve the problem to find the optimum solution. Clearly label and show the feasible solution space on your diagram. (c) Over what range can the coefficient for the first product vary in the objective function before the current solution is no longer optimal? (d) Over what range can the coefficient for the second product vary in the objective function before…
2. Jamila wants to set up a manufacturing unit, so she meets with Rashid, a humanresource manager at her company. Rashid explains that in order to decide on thehuman resource needs for the unit, they should conduct a workflow analysis. Shesuggests they start by defining the outputs of the process. To do this, what shouldJamila define?A) the processes that will be involved in manufacturingB) the number of people required for productionC) the type of products that will need to be manufacturedD) the special equipment, facilities, and systems needed for productionE) the data and information needed by the work unit
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?
RASM is defined as Revenue per Available Seat Mile and is a common metric to understand flight performance across different routes. Based on the chart below, what would you expect to see in March on a YoY basis? 20 18 16 14 12 10 8 6 4 2 0 Jan-18 Feb-18 Mar-18 Apr-18 May-18 a) Weaker performance YoY b) Stronger performance YoY c) Identical performance YoY d) There are no indicators of performance Jun-18 RASM Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19
Log in to the site AClasses A https://docs.google.com/forms/d/e/1FAlpQLSeEKUjfCSyselenY4sxAC Adham, the head of human resources unit at XYZ School, has recently asked the mathematics coordinator to attend one of the mathernatics instructors' classes and evaluate her performance based on the following criteria: teaching skills, classroom management, knowledge in the material delivered, & communication skills. In this scenario, the performance management function is basically practiced by a(n) Outsourced HR expert Professional employer organization Line manager HR professional Recruiters who go to marathons or bike races that are attended by individuals the company is seeking are participating in Event recruiting Open houses Job posting Job fairs
Discuss the process used to overcome objections. This upcoming Tuesday will be the 3rd meeting the sales team from La Carva Luxury Bathtubs will be having with a prospect regarding bathtubs she would like to purchase. The sales team conducted a presentation five months ago to a group of prospects, which this prospect attended. While the prospect expresses great interest in the product, at the previous meetings she seems to have additional concerns regarding the bathtubs and was not able to come to a decision to make a purchase. This issue is becoming overwhelming, and the sales team intends to address this matter once and for all. Based on the listening technique in the LAER MODEL, how will this effectively address the prospect's objections? Explain. Please be mindful to use relevant personal selling and marketing concepts to support the claim.
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.…
How would you manually write a mathematical model this?
Please answer 6a and show working out
How did you calculate experimental and theoretical time periods? How did they differ in yourexperiment?
In a 50 bedded hospital a housekeeping team member’s task is to change linens every day across all the beds. This task is routine. She goes to the storage area for fresh linens on her floor and finds none. She goes to another floor, and perhaps another, and ultimately finds them, then returns to the task she was trying to accomplish in the first place. At the end of the shift, however, others would bet that this Team Member would not able to get everything done. Or she had to hurry to complete changeover across all the beds. Perhaps, the work left undone would invariably pass to someone else and would disrupt their work. How do you relate this case to types of waste in lean management or Kaizen? One basic concept of TQM is unwavering customer orientation or focus on customers both internal and external”- Explain

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS