The ALBA Company produces a range of personal and laptop computers. Following is the MRP plan, Lot For Lot ordering policy for 2 items. Complete tables 1 and 2 for finished product and item A. You should include the completed tables in the answer book. Table 1 Item Week 2 3 4 5 6 7 89 10 Gross 780 810 Requirements Name: Finished Scheduled 50 50 Product Receipts LT = 1 Projected on Hand 70 week OQ=L4L Net Requirements Planned Order Receipt Planned Order Release Table2 Item Week 1 2 3 4 5 6 78 9 10 Gross 660 760 Requirements Scheduled Receipts Name: A Projected on Hand LT = 3 weeks 0Q=L4L Net Requirements Planned Order Receipt Planned Order Release

The ALBA Company produces a range of personal and laptop computers. Following is the MRP plan, Lot For Lot ordering policy for 2 items. Complete tables 1 and 2 for finished product and item A. You should include the completed tables in the answer book. Table 1 Item Week 2 3 4 5 6 7 89 10 Gross 780 810 Requirements Name: Finished Scheduled 50 50 Product Receipts LT = 1 Projected on Hand 70 week OQ=L4L Net Requirements Planned Order Receipt Planned Order Release Table2 Item Week 1 2 3 4 5 6 78 9 10 Gross 660 760 Requirements Scheduled Receipts Name: A Projected on Hand LT = 3 weeks 0Q=L4L Net Requirements Planned Order Receipt Planned Order Release

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

Given the following partial product tree, explode, offset, and determine the gross andnet requirements for components H, I, J, and K. There are other components, but theyare not connected to this problem. The quantities required are shown in parentheses.The master production schedule calls for the completion of 60 Hs in week 3 and 80 inweek 5. There is a scheduled receipt of 120 Is in week 2. There are 400 Js and 400 Ksavailable. All lot sizes are lot-for-lot
1. RBF, an emerging singer, is getting ready to cut his first album. The cost of recordingthe CD is Php 500,000 but copies are Php 500 apiece. If the album can be sold forPhp1,500 each, (a) how many CDs must be sold to break even? (b)What is thebreakeven point in dollars?RBF is confident that demand for his album will substantially exceed the break-evenpoint computed above. So, Mikey is contemplating having his album at a classier (andpricier) studio. The cost to record the CD would rise to Php 90,000. However, since thisnew studio works with very high volume, production costs would fall to Php 200 per CD.(c) What is the breakeven point for this new process?(d) Compare this process to the process proposed in the pre SHOW COMPLETE SOLUTION.
Item4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 eBookReferences Item 4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 The production planner for a private label soft drink maker is planning the production of two soft drinks: root beer (R) and sassafras soda (S). There are at most 12 hours per day of production time and 1,500 gallons per day of carbonated water available. A case of root beer requires 2 minutes of time and 5 gallons of water to produce, while a case of sassafras soda requires 3 minutes of time and 5 gallons of water. Profits for the root beer are $6.00 per case, and profits for the sassafras soda are $4.00 per case. The firm’s goal is to maximize profits. What is the time constraint? rev: 09_21_2020_QC_CS-229783 Multiple Choice 5R + 5S ≤ 720. 3R + 5S ≤ 720. 2R + 5S ≤ 720. 3R + 2S ≤ 720. 2R + 3S ≤ 720.
A linear programming computer package is needed. Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery schedule Model Month 1 Month 2 Small 2,100 1,200 Large 1,500 2,600 Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be…
Refer again to Problems( Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan. ). In addition to100 units of S, there is also a demand for 20 units of U, which isa component of S. The 20 units of U are…
20.- Indicate how much ATP (available to promise) exists during 5 periods whose orders are 80, 10, 10, 0 and 30 and whose MPS (Master Production Schedule) is 0, 100, 0 and 100 respectively, in addition to counting an initial inventory of 100 units a)20, 110, 100, 200, 170 b)-80, -10, -10, 90, 60 c)20, 80, 0, 70, 0 d) 20, 110, 100, 220, 190 A work center has a machine that operates 8 hours a day for 5 days a week. Historically utilization has been 85% and efficiency 110%. What is the capacity cup?
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.
The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead timefor A is three weeks and setup cost is $10. There is a carrying cost of $0.01 per unit perweek. Beginning inventory is 90 units.Week1 2 3 4 5 6 7 8 9 10Gross requirements 30 50 10 20 70 80 20 60 200 50Use the least total cost or the least unit cost lot-sizing method to determine when and forwhat quantity the i rst order should be released.
LPP Model Maximize P = 12x + 10y Subject to : 4x + 3y < 480 2x + 3y < 360 x, y > 0 Which of the following points (x, y) is feasible?
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 8. Assume lot-for- lot ordering. Below is information about the steppers and the quantity required for each parent. Item Lead Time On Hand Inventory Components Stepper 2 20 A(1), B(3), C(2) A 1 10 D(1), F(2) B 2 30 E(1), F(3) C 3 10 D(2), E(3) D 1 15 E 2 5 F 2 20 Develop a product structure diagram for Develop a net material requirements plan for
3. Irvine Consolidated Closets (ICC) builds and sells shelving for homes and offices. For a certain shelving unit, SS1, ICC has gross requirements of 500, 800, and 650 units in weeks 4, 5, and 6, respectively. The lead-time on the SS1 shelving unit is two weeks. ICC currently has 600 of the SS1 on hand and this product is ordered in lot sizes of 300, that is, the order in multiples of 300. a. Determine the MRP schedule for the SS1 unit over a time frame of weeks 1 through 6. When and for how many units should ICC place their orders for the SS1? b. A key component of the SS1 is the TT2. Each SS1 contains four TT2s. Currently TT2’s are ordered in lots of size 1000 and there are 800 on hand. TT2s have a one-week lead time. Determine the MRP schedule for the TT2 unit over a time frame of weeks 1 through 6. When and for how many units should ICC place their orders for the TT2? c. Suppose annual demand for the SS1 shelving unit is 32,500. ICC’s holding cost is $0.50 per week for each…
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.