The demand for subassembly S is 140 units in week 7. Each unit of S requires 1 unit of T and 1 unit of U. Each unit of T requires 1 unit of V, 2 units of W, and 2 units of X. Finally, each unit of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 2 weeks to make X, 2 weeks to make Y, and 1 week to make Z. Click the icon to view the product structure and the time-phased product structure. Construct a gross material requirements plan (type 0 if the input box is not used). Item S Gross req Order release T Gross req Order release U Gross req Order release V Gross req Order release W Gross req Order release 1 2 3 Week 4 5 6 7 Lead Time (weeks) 2 2 2 3 x Gross req Order release 2 Y Gross req Order release 2 Z Gross req 1 Order release More Info Level The product structure. The time-phased product structure. 0 T(1) 1 S U(1) 2 V(1) W(2) X(2) Y(2) Z(3) V W T X S Y U Z 2 3 Time in weeks -co 6 7

The demand for subassembly S is 140 units in week 7. Each unit of S requires 1 unit of T and 1 unit of U. Each unit of T requires 1 unit of V, 2 units of W, and 2 units of X. Finally, each unit of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 2 weeks to make X, 2 weeks to make Y, and 1 week to make Z. Click the icon to view the product structure and the time-phased product structure. Construct a gross material requirements plan (type 0 if the input box is not used). Item S Gross req Order release T Gross req Order release U Gross req Order release V Gross req Order release W Gross req Order release 1 2 3 Week 4 5 6 7 Lead Time (weeks) 2 2 2 3 x Gross req Order release 2 Y Gross req Order release 2 Z Gross req 1 Order release More Info Level The product structure. The time-phased product structure. 0 T(1) 1 S U(1) 2 V(1) W(2) X(2) Y(2) Z(3) V W T X S Y U Z 2 3 Time in weeks -co 6 7

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 demand for subassembly S is 100 units inweek 7. Each unit of S requires 1 unit of T and 2 units of U.Each unit of T requires 1 unit of V, 2 units of W, and 1 unit ofX. Finally, each unit of U requires 2 units of Y and 3 units ofZ. One firm manufactures all items. It takes 2 weeks to makeS, 1 week to make T, 2 weeks to make U, 2 weeks to make V,3 weeks to make W, 1 week to make X, 2 weeks to make Y,and 1 week to make Z.a) Construct a product structure. Identify all levels, parents,and components.b) Prepare a time-phased product structure.
The demand for subassembly S is 90 units in week 7. Each unit of S requires 1 unit of T and 1 unit of U. Each unit of T requires 1 unit of V, 2 units of W, and 1 unit of X. Finally, each unit of U requires 1 unit of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 1 week to make X, 2 weeks to make Y, and 1 week to make Z. Construct a net material requirements plan using on-hand inventory (enter your responses as whole numbers). Week Lead Time Item 1 2 3 4 5 6 7 (weeks) S Gross req nothing 2 On hand nothing Net req nothing Order receipt nothing Order release nothing T Gross req nothing 1 On hand…
Courtney Kamauf schedules production of a popular Rustic Coffee Table at Kamauf Enterprises, Inc. The tablerequires a top, four legs, 18 gallon of stain, 116 gallon of glue, 2 shortbraces between the legs and 2 long braces between the legs, anda brass cap that goes on the bottom of each leg. She has 100 gallons of glue in inventory, but none of the other components. Allitems except the brass caps, stain, and glue are ordered on a lotfor-lot basis. The caps are purchased in quantities of 1,000, stainand glue by the gallon. Lead time is 1 day for each item. Schedulethe order releases necessary to produce 640 coffee tables on days5 and 6, and 128 on days 7 and 8.
The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers used to cover the requirements over all seven days of the week. The company has 6 cabs but needs all six of them on duty only on Fridays. The estimated requirements are as follows: Day Mon Tue Wed Thu Fri Sat Sun Requirements 6 4 4 4 6 3 3 Prepare a schedule that minimizes the total number of drivers needed and minimizes the amount of slack capacity. In case of ties for assignment, it is preferred to give weekend days off. Identify the slack capacity for each day of the week. In addition, please identify the number of people working less than full-time (i, e., working less than five days a week. This is employee scheduling program. No employee can be off on Friday and please do not change the requirement in the question. Thank you.
Item5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 eBookReferences Item 5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). He can only get 300 pounds of Colombian beans per week and 200 pounds of Dominican beans per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. The goal of Fine Coffees, Inc. is to maximize profits.What is the constraint for Dominican beans? Multiple Choice 12A + 8B ≤ 4,800. 8A + 4B ≤ 3,200. 8A + 12B ≤ 4,800. 4A + 8B ≤ 3,200. 4A + 8B ≤ 4,800.
Jenny Company produces two types of pants: long pants and short pants. The cost of making apair of short pants and a pair of long pants are RM 75 and RM 95 respectively. In one week, thecompany must produce at least 150 pants of each type. The minimum weekly production is 500pants. The short pants are sold for RM 120 each and the long pants for RM 150 each. Using thegraphical method, find:a. The number of short pants and long pants to be made in a week in order to minimise thetotal production cost.b. The profit made at the minimum weekly production cost.
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…
The demand for subassembly S is 110 units in week 7. Each unit of S requires 1 unit of T and 1 unit of U. Each unit of T requires 2 units of V, 2 units of W, and 2 units of X. Finally, each unit of U requires 1 unit of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 2 weeks to make T, 2 weeks to make U, 1 week to make V, 2 weeks to make W, 2 weeks to make X, 2 weeks to make Y, and 2 weeks to make Z. Part 2 In addition to 110 units of S, there is also a demand for 30 units of U, which is a component of S. The 30 units of U are needed for maintenance purposes. These units are needed in week 6. Modify the gross material requirements plan to reflect this change (type 0 if the input box is not used). Week Lead Time Item 1 2 3 4 5 6 7 (weeks) S Gross req enter your response here enter your response here enter your response here enter your response here enter your response…
Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.
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?
I need a detailed assistance to solve this problem: The Mantell Company makes softballs and baseballs. Softballs sell for $17 each, and baseball sell for $15 each. Making a ball of any kind requires leather, nylon, wood chips, labor and machine time. The requirements for each ball type and the resources available are show in the following table: Item Softball Requirement Baseball Requirement Available Resource Leather 6 ounces 4 ounces 6000 ounces Nylon 8 yards 3 yards 5000 yards Wood Chips 10 ounces 2 ounces 5000 ounces Labor 3 minutes 2 minutes 3600 minutes Machine 1 minute 1 minute 2000 minutes The company wishes to use LP to determine the optimal number of each type of ball to produce in order to maximize revenue. a) Write down the decision variables. b) Write down the optimization statement for the objective function. c) Write down the constraints.
Fast pls i will give u like for sure solve this question correctly in 5 min pls Solve the following Linear Programming problem: show all equations, work and a graph. Jason custom paints snowboards and snowmobiles as a hobby. It takes 4 hours to paint a snowmobile and 2 hours to paint a snowboard. The profit on a snowmobile is $35, and the profit on a snowboard is $10. Jason can only spend 20 hours a week on his painting business, and must paint at least 2 snowmobiles and 1 snowboard each week. How many snowmobiles and how many snowboards should Jason paint each week to maximize his profit?