here its the right answered please just provide me an explanation of how did you get this number with an calculation(24, 33, 33, 18, 10) APart APart FG(2 required)BACPeriodPlanned order releasesPeriodPlanned order releasesPeriodGross requirementsScheduled receiptsProjected Available Balance 30Part GLT=1Q = multof 25SS-10 Planned order releasesC111D32020D2228EG3315203LLFF4441510HG5554Complete the following Problem: For material (part) G, calculate the gross requirements, PAB, andplanned order releases.Enter the PROJECTED AVAILABLE BALANCE for periods one (1) through five (5). If PAB is zero,enter 0.

Product structure is the hierarchical representation of the finished product and the components…

Complete the following Problem: For material (part) G, calculate the gross requirements, PAB, and planned order releases. Enter the PROJECTED AVAILABLE BALANCE for periods one (1) through five (5). If PAB is zero, enter 0.

Complete the following Problem: For material (part) G, calculate the gross requirements, PAB, and planned order releases. Enter the PROJECTED AVAILABLE BALANCE for periods one (1) through five (5). If PAB is zero, enter 0.

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

Add two (2) new customers, two (2) old customers and two (2) new POS transactions. SalesID InvoiceNo TransDate Item Description Color Size qty Price StoreID YearID Brand Name Address CurrID YEARVAL 82605 10828 06-Dec-09 8720400000227 REGULAR CIGARS 1 21.74 TCS 2009 HENRI WINTERMANS Yetty BDS 2009 47075 45036325 26-Aug-08 POSTCARDS POSTCARDS 1 1.4 CS 2008 Guenna BDS 2008 4590 60007295 14-Jan-08 3707-11-6 BLOUSES BLK/MLT L 1 586 CC 2008 GOTTEX Yankee CORAL REEF HOTEL USD 2008 4599 60007301 15/1/2008 3007-319-18 PANTS CORAL XS 1 200 CC 2008 CUT LOOSE Quigly YEARWOOD RD BLK ROCK USD 2008
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
Reorder PointConsider an economic order quantity case where annual demand D = 1,000 units, economic order quantity Q = 200 units, the desired probability of not stocking out P = .95, the standard deviation of demand during lead time σL = 25 units, and lead time L = 15 days. Determine the reorder point. Assume that demand is over a 250-workday year.
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month periodwere as follows:Month Sales (000 units)Feb. 19Mar. 18Apr. 15May 20Jun. 18Jul. 22Aug. 20a. Plot the monthly data on a sheet of graph paper
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
Problem 7 Lynne Chappell manages the inventory of supplies in a large hospital. To determine which items should be closely monitored, Lynne decided to use the ABC classification schemeto group the items on the basis of their value. Asthe following table shows, she took a random sample of20 items and recorded the annual usage and unit cost ofeach. How should each item be classified?Inventory Item Unit cost(in U.S.dollars) AnnualUsageP21 $80 800A12 $400 70K43 $50 100S54 $60 90C25 $50 130D76 $30 170E27 $20 200F38 $300 90H19 $520 120Q10 $10 100R82 $20 80G65 $80 70L71 $220 200M94 $70 80V45 $15 60T62 $30 180I17 $20 80W22 $300 90O37 $700 85N88 $5 100
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
2. A manager then obtained 10 lists of items with their following unit cost and gets the peso value in annual basis. By doing the A-B approach you will need to multiply the annual demand for t particular items to its unit costs as follows: Item Number Annual Demand Unit Cost Annual Peso Value 1 3,500 360 2 2,000 70 3 5,400 500 4 2,500 100 5 1,200 70 6 2,000 1,000 7 1,200 210 8 2,000 4,000 9 10,000 10 10 1,500 200 Item Number Annual Peso Classification % of item Value 2/3 % of annual Peso Value
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability