Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. 1- How do you think each system can affect your procurement procedures/methods?

Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. 1- How do you think each system can affect your procurement procedures/methods?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
John Ozment, director of special projects and analysis for Ozment’s Corporation, is responsible for preparing corporate financial analyses and monthly statements and reviewing and presenting the economic impacts of proposed strategies to upper management. Data for such financial analyses are obtained from operations and financial databases through direct queries of Ozment’s department staff. Reports and charts for presentations are then prepared by hand and typed. Multiple copies are prepared and distributed to various users. The pressure on Ozment’s group has intensified as demand for more and more current information increases. A solution to this reporting problem must be found.The systems department wants to develop a proprietary software package to produce the reports automatically. The project would require the company to make a considerable programming investment. Ozment is concerned about the accuracy, completeness, and currency of data isautomatically produced reports. He has…
Please answer in excel format A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.
We have seen the importance of demand forecasting affecting supply chain decisions in many ways. How does the reliability of demand forecasting affect a model to place warehouses for customers? Knowing that there is no specific answer that is always appropriate, how good (measured in percent close) do forecasts have to be in order to be used for network modeling?
You manage a production line that operates using a monthly production cycle. There are five different products that could be made this month. However, you only have 500 hours of line capacity, so you must be careful which products you select to make in the production cycle. Making a product incurs two types of setup costs: (1) a material “tear down” cost (measured in dollars) and (2) downtime for line preparation (measured in hours). Any quantity up to the forecasted monthly demand can be sold. Additional production details are given in the table below: Product 1 Product 2 Product 3 Product 4 Product 5 Monthly Demand 1000 units 1100 units 1700 units 1600 units 1500 units Revenue (per unit) $150 $175 $155 $200 $225 Production Cost (per unit) $60 $70 $60 $100 $110 Set Up Cost $10000 $15000 $25000 $10000 $5000 Set Up Time 25 hrs 15 hrs 0 hrs 10 hrs 30 hrs Production Time (per unit) .1 hrs .12…
Copper Kettle Catering (CKC) is a full-service catering company that provides services ranging from box lunches for picnics or luncheon meetings to large wedding, dinner, or office parties. Established as a lunch delivery service for offices in 1972 by Wayne and Janet Williams, CKC has grown to be one of the largest catering businesses in Raleigh, North Carolina. The Williams’s divide customer demand into two categories: deliver only and deliver and serve. The deliver-only side of the business delivers boxed meals consisting of a sandwich, salad, dessert, and fruit. The menu for this service is limited to six sandwich selections, three salads or potato chips, and a brownie or fruit bar. Grapes and an orange slice are included with every meal, and iced tea can be ordered to accompany the meals. The overall level of demand for this service throughout the year is fairly constant, although the mix of menu items delivered varies. The planning horizon for this segment of the business is…
Given the following forecast and cost information, Regular time cost $ 40.00 per unitdetermine the total cost of a plan that uses regular time Overtime cost $ 60.00 per unitproduction output of 600 units per month, overtime is subcontracting cost $ 80.00 per unitused when needed up to a maximum of 60 units per holding cost $ 10.00 per unit per monthmonth, and subcontracting is used if additional units are needed to meet the forecast.Month Forecast1 5702 6003 6304 6505 6706 690Totals
Consider a three-firm supply chain consisting of a retailer, manufacturer, and supplier. The retailer's demand over an 8-week period was 90 units each of the first 2 weeks, 220 units each of the second 2 weeks, 280 units each of the third 2 weeks, and 400 units each of the fourth 2 weeks. The following table presents the orders placed by each firm in the supply chain. Notice, as is often the case in supply chains due to economies of scale, that total units are the same in each case, but firms further up the supply chain (away from the retailer) place larger, less frequent, orders. Week Retailer Manufacturer Supplier1 90 180 6202 90 0 03 220 440 04 220 0 05 280 560 1,3606 280 0 07 400 800 08 400 0 0 a) What is the bullwhip measure for the retailer? The bullwhip measure for the retailer is ??? (Enter your response rounded to two decimal places.) b) What is the bullwhip measure for the…
This type of operational planning may cover the medium‐term needs of the business including budgeting, the purchasing and supply system and organisation thereof, purchasing and supply methods, negotiation and development of human resources. (1) Strategic level planning. (2) Tactical or middle‐management planning. (3) Operations level planning. (4) Operational planning. (5) Short‐term planning. This is in fact a production or operations scheduling system and not an inventory control system. It eliminates the holding of inventory and is based on requiring suppliers to deliver materials of the right quality to the business on the day they are needed and where they are needed. (1) Cyclical‐ordering system. (2) Materials‐requirements planning. (3) Just in time. (4) System of fixed‐order quantities. (5) Quick response system.
Property DataAnswer the following questions about property data: Briefly describe how STR obtains raw property data. Identify the various metrics used by the hotel Industry, both the raw values, the KPIs, and the Percent Changes. Explain how metrics are calculated when it comes to multiple time periods. Compare the differences between how monthly and daily data is treated Identify “hints” that should be remember when working with the various metrics.