CASELEVEL OPERATIONSLevel Operations is a small company located in eastern Pennsylvania. It produces a variety of security devices and safes. The safes come in several different designs. Recently, a number of new customers have placed orders, andthe production facility has been enlarged to accommodate increased demand for safes. Production manager Stephanie Coles is currently working on a production plan for the safes. She needs a plan for each day of the week.She has obtained the following information from the marketing department on projected demand for the next five weeks.ModelWeekly QuantityS1120QuestionThe department operates five days a week. One complexity is that partially completed safes are not permitted; each cycle must turn out finished units.After discussions with engineering, Stephanie determined that the best production sequence for each cycle is S7-S8-S9-S1-S2.S2102What might Stephanie determine as the best production quantity per cycle for each day of the week?S748S890S925

Answered: Image /qna-images/answer/0670c7c1-8b04-40f7-9136-05a9f1a76c6d.jpg

Answered: CASE LEVEL OPERATIONS Level Operations…

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

The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the surrounding area. Vijay Gupta, road maintenance director, must submit a staffing plan for the next year based on a set schedule for repairs and on the city budget. Gupta estimates that the labor hours required for the next four quarters are 6,500 , 12,500 , 19,500 , and 10,000 , respectively. Each of the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $ 6,000 in wages per worker for regular time worked up to 500 hours, with an overtime pay rate of $ 19 for each overtime hour. Overtime is limited to 20 percent of the regular-time capacity in any quarter. Although unused overtime capacity has no cost, unused regular time is paid at $ 12 per hour. The cost of hiring a worker is $ 3,600 , and the cost of laying off a worker is $ 1,000. Subcontracting is not permitted. (Hint: When calculating the number of workers,…
A linear programming computer package is needed. The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown. Model Production Costs Labor Requirements (hours) Current Inventory Manufacturing Assembly Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the…
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the surrounding area. Vijay Gupta, road maintenance director, must submit a staffing plan for the next year based on a set schedule for repairs and on the city budget. Gupta estimates that the labor hours required for the next four quarters are 6,500, 13,000, 20,000, and 9,500, respectively. Each of the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an overtime pay rate of $18 for each overtime hour. Overtime is limited to 20 percent of the regular-time capacity in any quarter. Although unused overtime capacity has no cost, unused regular time is paid at $12 per hour. The cost of hiring a worker is $3,400, and the cost of laying off a worker is $1,600. Subcontracting is not permitted. (Hint: When calculating the number of workers, make sure to round up to…
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the surrounding area. Vijay Gupta, road maintenance director, must submit a staffing plan for the next year based on a set schedule for repairs and on the city budget. Gupta estimates that the labor hours required for the next four quarters are 6,000, 12,500, 20,000, and 9,500, respectively. Each of the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an overtime pay rate of $17 for each overtime hour. Overtime is limited to 20 percent of the regular-time capacity in any quarter. Although unused overtime capacity has no cost, unused regular time is paid at $12 per hour. The cost of hiring a worker is $3,400, and the cost of laying off a worker is $1,800. Subcontracting is not permitted. (Hint: When calculating the number of workers, make sure to round up to the…
Bob Carlton's golf camp estimates the following workforce requirements for its services over the next two years: Quarter 1 2 3 4 5 6 7 8 Demand (hrs) 4,300 6,400 3,200 5,000 4,500 6,300 3,600 5,000 Each certified instructor puts in 480 hours per quarter regular time and can work an additional 120 hours overtime. Regular-time wages and benefits cost Carlton $7,200 per employee per quarter for regular time worked up to 480 hours, with an overtime cost of $20 per hour. Unused regular time for certified instructors is paid at $15 per hour. There is no cost for unused overtime capacity. The cost of hiring, training, and certifying a new employee is $10,000. Layoff costs are $4,000 per employee. Currently 8 employees work in this capacity. a. Find a workforce plan using the level strategy that allows for no delay in service. It should rely only on overtime and the minimum amount of undertime necessary. What is the total cost of the…
Bob Carlton's golf camp estimates the following workforce requirements for its services over the next two years: Quarter 1 2 3 4 5 6 7 8 Demand (hrs) 4,300 6,400 3,200 5,000 4,500 6,300 3,600 5,000 Each certified instructor puts in 480 hours per quarter regular time and can work an additional 120 hours overtime. Regular-time wages and benefits cost Carlton $7,200 per employee per quarter for regular time worked up to 480 hours, with an overtime cost of $20 per hour. Unused regular time for certified instructors is paid at $15 per hour. There is no cost for unused overtime capacity. The cost of hiring, training, and certifying a new employee is $10,000. Layoff costs are $4,000 per employee. Currently 8 employees work in this capacity. a. Find a workforce plan using the level strategy that allows for no delay in service. It should rely only on overtime and the minimum amount of undertime necessary. What is the total cost of the…
The Scottville "Mill" produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0 below along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The Mill has two types of looms: dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The Mill has a total of 38 looms: 8 are dobbie and 30 are regular. The rate of production for each fabric on each type of loom is given in Table 1.1. The time to change over from producing one fabric to another is negligible and does not have to be considered. The Scottsville Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at…
The Toys-R-4-U Company has developed two new toys for possible inclusion in its productline for the upcoming Christmas season. Setting up the production facilities to beginproduction would cost $50,000 for toy 1 and $80,000 for toy 2. Once these costs arecovered, the toys would generate a unit profit of $10 for toy 1 and $15 for toy 2. Thecompany has two factories that are capable of producing these toys. However, to avoiddoubling the start-up costs, just one factory would be used, where the choice would bebased on maximizing profit. For administrative reasons, the same factory would be usedfor both new toys if both are produced. Toy 1 can be produced at the rate of 50 per hourin factory 1 and 40 per hour in factory 2. Toy 2 can be produced at the rate of 40 perhour in factory 1 and 25 per hour in factory 2. Factories 1 and 2, respectively, have500 hours and 700 hours of production time available before Christmas that could beused to produce these toys. It is not known whether these…
Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The optimum solution is: Number of trucks to be produced per day = ? (round your response to two decimal places).
Alvis Construction Supply Company has a department that manufactures wood trusses (wood frames used in the construction industry). The following information is for the production of these trusses for the month of February: Work-in-process inventory, February 1 4,300 trusses Direct materials: 100% complete $ 10,780 Conversion: 30% complete $ 15,558 Units started during February 18,300 trusses Units completed during February and transferred out 17,300 trusses Work-in-process inventory, February 29 Direct materials: 100% complete Conversion: 30% complete Costs incurred during February Direct materials $ 59,340 Conversion $ 92,392 Required Using the weighted-average method, calculate the following: 1-a. Costs per equivalent unit. (Round your answers to 4 decimal places.) 1-b. Cost of goods completed and transferred out. (Round "Cost per EU" to 4 decimal places. Round final answer to nearest whole dollars.) 1-c. Costs remaining in the…
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/75 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $275 and $225, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = nothing (round your response to two decimal places).

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