Master production scheduleWeekLeatherFabric117672226232065424625197061770Total labor hours required for each work center by weekWork Center12345SewingAssemblyAdjust all answers to one decimal point using the Decrease Decimal Function60.00.00 0Problem 1: A firm makes car seats for an automaker in two varieties: leather and fabric. Thestandard labor hours for these are 1.2 and 1.0 hours, respectively. The seats are made in twowork centers, sewing and assembly, where the average percentage of work has been 55 percentfor sewing and 45 percent for assembly. Given the MPS for the next six weeks, calculate thelabor hours needed in each of the two work centers.WeekLeatherFabric117672226232065424625197061770

Answered: Master production schedule Week Leather…

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

Planners for a company that makes several models of skateboards are about to prepare theaggregate plan that will cover six periods. They have assembled the following information.Period 1 2 3 4 5 6 TotalForecast 200 200 300 400 500 200 1,800CostsOutputRegular time = $2 per skateboardOvertime = $3 per skateboardSubcontract = $6 per skateboardInventory = $1 per skateboard per period on average inventoryBack orders = $5 per skateboard per periodThey now want to evaluate a plan that calls for a steady rate of regular-time output,mainly using inventory to absorb the uneven demand but allowing some backlog. Overtimeand subcontracting are not used because they want steady output. They intend to start withzero inventory on hand in the first period. Prepare an aggregate plan and determine its costusing the preceding information. Assume a level output rate of 300 units (skateboards) perperiod with regular time (i.e., 1,800/6 = 300). Note that the planned ending inventory iszero. There are 15…
Jane Reed bakes breads and cakes in her home for parties and other affairs on acontract basis. Jane has only one oven for baking. One particular Monday morningshe finds that she has agreed to complete five jobs for that day. Her husband Johnwill make the deliveries, which require about 15 minutes each. Suppose that shebegins baking at 8:00 A.M.Job Time Required Promised Time1 1.2 hr 11:30 A.M2 40 min 10:00 A.M.3 2.2 hr 11:00 A.M.4 30 min 1:00 P.M.5 3.1 hr 12:00 NOON6 25 min 2:00 P.M.Determine the sequence in which she should perform the jobs in order tominimizea. Mean flow time.b. Number of tardy jobs.c. Maximum lateness.
A1 Credit provides credit information to its customersthroughout the country, 24 hours per day. Credit representativesanswer customer calls and provide information. Based on demandpatterns, the estimated number of representatives needed duringfour-hour time periods of each day are shown in the table. Employees work shift s of eight consecutive hours, and shift scan start at the beginning of any of the six periods shown inthe table. Assume this schedule will be repeated day aft er day,so that someone starting at 8 pm will contribute to the need forrepresentatives in the midnight–4 am time period. Th e supervisorhas been instructed to schedule employees so that all demandscan be met with a minimum possible number of employees.(a) Formulate an LP to minimize the number of representativesneeded.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution.
A leatherworks factory has two punch presses for punching holes in the various leathergoods produced in the factory prior to sewing. Suppose that 12 different jobs must beprocessed on one or the other punch press (i.e., parallel processing). The processingtimes (in minutes) for these 12 jobs are given in the following table.Job 1 2 3 4 5 6 7 8 9 10 11 12Time 26 12 8 42 35 30 29 21 25 15 4 75Assume that both presses are initially idle. Compare the performance of SPT andLPT (longest processing time) rules for this example. (In parallel processing the nextjob is simply scheduled on the next available machine.)
How much influence can the employee requirements for one, two, or three days have on the weekly sched-ule in the employee scheduling example? Explore this in the following questions:a. Let Monday’s requirements change from 17 to 25in increments of 1. Use SolverTable to see how thetotal number of employees changes.b. Suppose the Monday and Tuesday requirementscan each, independently of one another, increasefrom 1 to 8 in increments of 1. Use a two-waySolverTable to see how the total number ofemployees changes. c. Suppose the Monday, Tuesday, and Wednes-day requirements each increase by the same amount, where this increase can be from 1 to 8in increments of 1. Use a one-way SolverTableto investigate how the total number of employeeschanges.
Labors Hours Required (Hours/Unit) Department Product 1 Product 2 Hours Available Overtime Available Overtime Cost A 1 0.35 100 10 18 B 0.3 0.2 36 6 22.5 C 0.2 0.5 50 8 12 Profit Contribution/Unit 30 15 X1 X2 Production Constraints Used Available Dept A Hours Dept B Hours Dept C Hours Dept A Overtime (XA) Dept B Overtime (XB) Dept C Overtime (XC) Objective: Profit Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is $18 in department A, $22.50 in department B, and $12 in department C. What are the optimal production quantities using the avallable overtime? What is the…
A college provides free tutoring services for its students 7 days a week, and the daily requirements for tutors are: Day M T W Th F S Su Requirements 5 4 7 3 6 3 4 Find the minimum number of tutors required if each tutor works 4 days a week and has 3 consecutive days off. Give preference to Saturday and Sunday off in case of a tie. (Hint: Look for group of 3 days with the lowest requirements). Specify the work schedule for each tutor. How much slack does your schedule generate for each day?
Manufacturing Aggregate Planning Manufacturers Inc. (MI) currently has a labor force of 10, which can produce 600 units per period. The labor cost is now $5000 per period per employee. The company has a long-standing rule that does not allow it to make use of any overtime. In addition, the product cannot be subcontracted, due to the specialized nature of the machinery that MI uses to produce it. As a result, MI can only increase/decrease production by hiring or laying off employees. The cost is $10000 to hire or lay off an employee. Inventory carrying costs are $200 per unit for any unsold items at the end of the period. The inventory level at the beginning of period 1 is 400 units. The forecast demand is 700 in period 1,600 in period 2,450 in period 3, 250 in period 4,500 in period 5, and 550 in period 6. a.) Compute the costs of the Chase Demand Strategy. b.) Compute the costs of the Level Strategy c.) Compare the costs of the two strategies. Which one is superior?
The topic is about Quantitive analysis and decision making. Problem: A firm just completed a new plant that will producemore than 500 different products, using morethan 50 different production lines and machines.The production scheduling decisions are criticalin that sales will be lost if customer demands arenot meet on time. If no individual in the firmhas experience with this production operationand if new production schedule must begenerated each week, why should the firmconsider a quantitative approach to theproduction scheduling problem?
A) What is the theoretical minimum number of workstations? a. 3 workstations b. 3.5 workstations c. 3.83 workstations d. 4 workstations e. 5 workstations B) Which of the following statements is FALSE? a. Tasks A, B, and C can be started as soon as possible. b. All of the tasks A, B and C should be finished first before task F can be started. c. All of the tasks A through H should be finished first before task I can be started. d.All of the tasks B, E, C and F should be finished first before task H can be started. Answer the two questions please.
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: a. Compute the partial productivity measures for chemical for the four periods. b. Compute the partial productivity measures for labor for the four periods.
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: c. Compute the total factor productivity for the four periods.

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