Please help me solve this table.Rockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C. B is made of three units of D and two of E. C is made of two units of F and two of E.The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.As the production manager, you need to figure out the MRP planning schedule.1. What is the bill of materials (product structure tree)?2. If 1,000 units of blue ray players are required in week 10, what is the MRP schedule? Specifically, when items are to be ordered and received. Assume we have no units of inventory on hand. 245678910111213141516171819202122232425262728293031323334353637383940414243444546474840Problem 2:ItemLT=Onhand=ItemRockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C.B is made of three units of D and two of E. C is made of two units of F and two of E.The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.As the production manager, you need to figure out the MRP planning schedule.|LT=Onhand=a. What is the bill of materials (product structure tree)?b. If 1,000 units of blue ray players are required in week 10, what is the MRP schedule? Specifically, when items are to be ordered and received.Assume we have no units of inventory on hand.PeriodItemLT=Onhand=Item|LT=Onhand=Item|LT=Onhand=Item|LT=Onhand=Gross requirementsScheduled receiptsOn hand from prior periodNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsOn hand from prior periodDNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsOn hand from prior periodNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsOn hand from prior periodNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsOn hand from prior periodNet requirementsPlanned order receiptsPlanned order releasesGross requirementsEScheduled receiptsOn hand from prior periodNet requirementsPlanned order receiptsPlanned order releasesF12H3I45L678M910NOPQRItem On-Hand Lead Time (Weeks)ABCDFFST

Material Requirements Planning (MRP) is a production planning, scheduling, and inventory control…

Rockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C. B is made of three units of D and two of E. C is made of two units of F and two of E. The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks. As the production manager, you need to figure out the MRP planning schedule. 1. What is the bill of materials (product structure tree)? 2. If 1,000 units of blue ray players are required in week 10, what is the MRP schedule? Specifically, when items are to be ordered and received. Assume we have no units of inventory on hand.

Rockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C. B is made of three units of D and two of E. C is made of two units of F and two of E. The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks. As the production manager, you need to figure out the MRP planning schedule. 1. What is the bill of materials (product structure tree)? 2. If 1,000 units of blue ray players are required in week 10, what is the MRP schedule? Specifically, when items are to be ordered and received. Assume we have no units of inventory on hand.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 31P

See similar textbooks

Similar questions

Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion?
SOLVE THE LPP - SIMPLEX METHOD Max.: P= 30x1 + 70x2 S.t.: x1 + 2x2 ≤ 20 x1 +5x2 ≤ 35 x1 and x2 ≥ 0
Three types of gasoline are manufactured by a company – Regular, Super, and Extra. Regular should have at least 11percent additive 1 and 17 percent additive 2. Super should have at least 13 percent additive 1 and 22 percent additive 2. Extra should have at least 17 percent additive 1 and 19 percent additive 2. These are made by using two crudes – A and B. Crude A cost $28 per barrel and is 14 percent additive 1 and 18 percent additive 2. Crude B costs $30 per barrel and is 20 percent additive 1 and 24 percent additive 2. The demand for Regular is projected to be 1,000 barrels, while each of the others has a demand of 2,000 barrels. Formulate this as a linear programming problem to minimize cost while meeting all constraints. Remember to carefully define all decision variables and do not forget to indicate the optimal answer! (Blending application)
Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price change on a software product. Currently, 40,000 units of the product are sold each week for $45 apiece. The variable cost of the product is $5. The most likely case appears to be that a $10 rebate will increase sales 30%, and half of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 20%.a. Given all other assumptions, what increase in sales from the rebate would make the rebate and price cut equally desirable?b. Dataware does not really know the increase in sales that will result from a rebate or price cut. However, the company is sure that the rebate will increase sales by between 15% and 40% and that the price cut will increase sales by between 10% and 30%. Perform a sensitivity analysis (two-way data table) that could be used to help determine Dataware’s best decision.
NASA must determine how many of three types of objects to bring on board the space shuttle. The weight and benefit of each of the items are given in the file P06_42.xlsx. If the space shuttle can carry up to 2,000 pounds of items 1 through 3, how many of each item should be taken on the space shuttle, assuming that at least one of each is necessary? Number of each item to be included Item 1 Item 2 Item 3 Number included NASA data Data on items Item 1 Item 2 Item 3 Benefit 20 15 12 Weight 500 400 300
The file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year period. a. Fit an exponential trend line to these data. b. By what percentage do you estimate that the company will grow each month? c. Why cant a high rate of exponential growth continue for a long time? d. Rather than an exponential curve, what type of curve might better represent the growth of a new technology?
J&J has given you $12 million to spend on advertising Huggys diapers during the next 12 months. Atthe beginning of January, Huggys has a 30% market7.9 Conclusion 401share. During any month, 10% of the people whopurchase Huggys defect to brand X, and a fraction0.2a1y2 of customers who usually buy brand X switchto Huggys, where a is the amount spent on advertisingin millions of dollars. For example, if you spend $4million during a month, 40% of brand X’s customersswitch to Huggys. Your goal is to maximize J&J’saverage market share during the next 12 months,where the average is computed from each month’sending share. Determine an appropriate advertisingpolicy. (Hint: Make sure you enter a nonzero trialvalue for each month’s advertising expense or Solvermight give you an error message.)
a wine maker has a stock of three different wines with the following characteristics Wine proofs acids(%) specific gravity stock(gallons) A 27 .32 1.70 20 B 33 .20 1.08 34 C 32 .30 1.04 22 A dry table wine should be between 30 and 31 degree proof, it should contain at least 0.25% acid and should have a specific gravity of at least 1.06. The wine maker wishes to blend the three types of wine to produce as large a quantity as possible of satisfactory dry table wine. However, his stock of wine A must be completely used in the blend because further storage would cause it to deteriorate. What quantities of wines of B and C should be made in the blend. Formulate this problem as LP model. a wine maker has a stock of three different wines with the following characteristicsWine proofs acids(%) specific gravity stock(gallons)A 27 .32 1.70 20B 33 .20 1.08 34C 32 .30 1.04 22 A dry table wine…
Confederate Express Service is attempting to determinehow its shipping costs for a month depend on the numberof units shipped during a month. For the last 15 months, thenumber of units shipped and total shipping cost are given inTable 24 (file Ship.xls). Units TotalMonth Shipped Shipping Cost1 300 $1,0602 400 $1,3803 500 $1,6404 200 $7405 300 $1,0606 350 $1,1907 460 $1,5208 480 $1,5809 120 $54010 760 $2,42011 580 $2,20012 340 $1,47013 120 $79014 100 $72015 500 $1,960
Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below: Year XT PC Sales Revenue($’000,000) All Industry PC Sales Revenue($’000,000,000) 1 2.4 4.6 2 5.9 8.6 3 15.5 10.7 4 27.8 14.8 5 35.9 18.5 6 38.1 19.4 Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect). B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion?C. Advise management at Integrated Products Corporation (IPC) which of the twosales estimates from parts A and B above…
Use the table below to answer the questions that follow and caculate the Expected Monetary Value(EMV) of the different outcomesDECISION TABLE WITH CONDITIONAL VALUESSTATE OF NATUREFAVORABLE OUTCOME UNFAVORABLE OUTCOMEALTERNATIVES ($) ($)Start a big Company 2,000,000 -500,000Start a small company 800,000 -200,000Build Nothing 0 0Probabilities 0.3 0.7Calculate the following The EMV Maximin criterion Maximax criterion Minimax criterion
solve a and b The following table shows the rank attained by male and female officers in the NewYork City Police Department (NYPD).a) Do these data indicate that men and women are equitably represented at all levelsof the department? Test using a p-value approach. Male FemaleOfficer 21,900 4281Detective 4058 806Sergeant 3898 415Lieutenant 1333 89Captain 359 12Higher ranks 218 10 b) There are far more men than women in the police force in general. However, the NYCPolice Commission has set itself certain goals with respect to the positions of the femalesamong its ranks. Across the females they aim to target the same proportion by rank asthey do among the males. The target proportions by category are:(1) Officer – 70% (2) Detectives – 15% (3) Sargent – 10%(4) Lieutenant – 3% (5) Captain – 1% (6) Higher – 1%Conduct a test to determine whether the proportions,…