Concept explainers
Interpretation: The gross requirement
Concept Introduction:
The gross requirement schedule can be defined as the summation of the dependent and independent demand of the component before the total of the on-hand inventory and schedule receipts
Answer to Problem 41AP
The gross requirement of MPS −
Week | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |
MPS | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of processor | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of solar cell | 48 | 48 | 32 | 40 | 40 | 12 | 88 | 56 | 72 | 24 | |||
Gross requirement of LCD | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of button | 480 | 480 | 320 | 400 | 400 | 120 | 880 | 560 | 720 | 240 |
Explanation of Solution
Given information:
The lead time of four solar cells = 1 week
The lead time of one LCD = 1 week
The lead time of forty buttons = 2 weeks
The lead time of one processor = 3 weeks
The MPS of the product from week 8 to week 17 is given as −
Week | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |
MPS | 1200 | 1200 | 800 | 1000 | 1000 | 300 | 2200 | 1400 | 1800 | 600 |
The following method will be used to determine the gross requirement of the component processor −
- The multiplication of the production of CL by one will result in gross requirement of processor.
- The gross requirement will be phased back by three periods.
The following method will be used to determine the gross requirement of the component solar cell −
- The multiplication of the production of CL by four will result in gross requirement of solar cell.
- The gross requirement will be phased back by one period.
The following method will be used to be calculate the gross requirement of component LCD −
- The multiplication of the production of CL by one will result in gross requirement of LCD.
- The gross requirement will be phased back by one period.
The following method will be used to be calculate the gross requirement of component button −
- The multiplication of the production of CL by forty will result in gross requirement of button.
- The gross requirement will be phased back by two periods.
Now, the gross requirement of MPS can be given as −
Week | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |
MPS | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of processor | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of solar cell | 48 | 48 | 32 | 40 | 40 | 12 | 88 | 56 | 72 | 24 | |||
Gross requirement of LCD | 12 | 12 | 8 | 10 | 10 | 3 | 22 | 14 | 18 | 6 | |||
Gross requirement of button | 480 | 480 | 320 | 400 | 400 | 120 | 880 | 560 | 720 | 240 |
Hence, the gross requirement schedule is determined which will be used to determine the net requirement and planned order release of each component.
Want to see more full solutions like this?
Chapter 8 Solutions
Production and Operations Analysis, Seventh Edition
- Leather-All produces a line of handmade leather products. At the present time, the company is producing only belts, handbags, and attache cases. The predicted demand for these three types of items over a six-month planning horizon is as follows: Month No. of Belts Handbags Attache CasesWorking days1 22 2500 1250 2402 20 2800 680 3803 19 2000 1625 1104 24 3400 745 755 21 3000 835 1266 17 1600 375 45 The belts require an average of two hours to produce, the handbags three hours, and the attache cases six hours; all the workers have the skill to work on any item. Leather-All has 46 employees who each have a share in the firm and cannot be fired. There are an additional 30 locals that are available and can be hired for short periods at a higher cost. Regular employees earn $8.50 per hour on regular time, and $14.00 per hour on overtime. Regular time comprises a seven-hour workday and the regular employees will work as much overtime as is available. The additional workers are hired for…arrow_forwardJames Beerd bakes cheesecakes and Black Forest cakes. During any month, he can bake at most 65 cakes. The costs per cake and the demands for cakes, which must be met on time, are listed in Table 33. It costs 500 to hold a cheesecake, and 40¢ to hold a Black Forest cake, in inventory for a month. Formulate an LP to minimize the total cost of meeting the next three months’ demands. table 33 Month 1 Month 2 Month 3 Item Demand Cost/Cake ($) Demand Cost/Cake ($) Demand Cost/Cake ($) Cheesecake 40 3.00 30 3.40 20 3.80 Black Forest 20 2.50 30 2.80 10 3.40arrow_forwardElectrolux, a French company is planning to move the assembly of its refrigerators from France to Mexico. It takes 3 hours of labor to assemble a refrigerator, both in France and Mexico. Hourly labor rate in France is $ 25. Hourly labor rate in Mexico is $ 5. Holding cost in France per refrigerator per week is $ 2. In Mexico this is $ 1.5. In France orders are placed with factory weekly with lead time of 3 weeks. In Mexico orders are placed with factory weekly with lead time of 15 weeks. Weekly demand is 400 refrigerators with standard deviation of 100. It operates with in stock probability of 0.99 ( z = 2.33) What would be the change in total holding and labor cost per refrigerator by moving assembly from France to Mexico ? Show all formulas used, calculations and resultsarrow_forward
- In Lecture 5 we extended the newsvendor solution to the infinite horizon problem when there is no order lead time. Now suppose that the order lead time is L periods throughout the infinite horizon: if an order is placed at the beginning of period t, it arrives at the beginning of period t+L. Can we still extend the newsvendor solution to the infinite horizon problem in the case of backordering? Why or why not? Would your answer change in the case of lost sales? Why or why or not? I WANT LONG AND CLEAR EXPLANATION NOT AN 1 SENTENCE!!!!!!arrow_forwardA local outdoor vegetable stand has exactly 1,000 square feet of space to displaythree vegetables: tomatoes, lettuce, and zucchini. The appropriate data for theseitems are given in the following table.ItemTomatoes Lettuce ZucchiniAnnual demand 850 1,280 630(in pounds)Cost per pound $0.29 $0.45 $0.25The setup cost for replenishment of the vegetables is $100 in each case, and thespace consumed by each vegetable is proportional to its costs, with tomatoes requiring 0.5 square foot per pound. The annual interest rate used for computingholding costs is 25 percent. What are the optimal quantities that should be purchased of these three vegetables?arrow_forwardThe maintenance department in Ranchi Hospital uses 816 cases of liquid cleanser annually. Ordering costs are $12, carrying costs are $4 per case a year, and the new price schedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 cases will cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost $16 per case. Determine the optimal order quantity and the total cost.arrow_forward
- The campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.b. The bookstore manager has decided that it would be more economical if thedemand were the same each week. In order to even out the demand he limits weeklysales (to the annoyance of his clientele). Hence, assume that the total demand forthe 10-week quarter is still the same, but the sales are constant from week to week.Determine the optimal order policy in this case and compare the total holding andordering cost over the 10 weeks to the answer you obtained in part (a). (You may assume continuous time for the purposes of your…arrow_forwardThe campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.a. What is the optimal order policy during the 10-week quarter based on theSilver–Meal heuristic? Using this policy, what are the total holding and orderingcosts incurred over the 10-week period?arrow_forwardA book shop is planning to order calendars for sale starting in October. Only one order is placed. The calendars cost $1.50 and the shop sells them for $3 each. At the end of December, the shop reduces the calendar price to $1 and can sell all the surplus calendars at this price. The October-to-December demand can be approximated by a normal distribution with = 500 calendars and = 120 calendars.1. What inventory model should be used to determine the order quantity to maximize the total expected proÖt? Why?2. What is the optimal service level?3. How many calendars should the shop order so as to maximize the total expected proÖt?arrow_forward
- ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.a. How many pounds would a container have to hold in order for the company to Break Even?b. What would the total revenue be for this?c. The company finds out that to maintain the integrity of its containers, each container could only hold an average of 8,000 pounds. What would the company have to charge customers to make $5,000 in profit on each container?arrow_forward3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 poundsarrow_forwardI need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,