Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Regular Demand Period Time Overtime Subcontract Forecast 1 40 15 5 50 2 30 15 5 60 3 40 20 5 60 30 units $100 $150 $250 $6 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number).

Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Regular Demand Period Time Overtime Subcontract Forecast 1 40 15 5 50 2 30 15 5 60 3 40 20 5 60 30 units $100 $150 $250 $6 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number).

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
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?
1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Companyâ€™s lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Companyâ€™s lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watchâ€™s annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watchâ€™s annual demand is 108. It can produce at a rate of 24 watches per month. Using the…
The following are historical demand data: YEAR SEASON ACTUALDEMAND 2011 Spring 203 Summer 144 Fall 382 Winter 565 2012 Spring 471 Summer 271 Fall 686 Winter 955 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.)
Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates? (Hint, you might want to use excel for this) period 1 2 3 4 5 6 7 8 9 10 13673 6640 2737 3486 141 13186) 5448 3485 7728 16591 8236 3316 855358 11 12 13 15 16 17 18 19 Demand Deseasonalized D₁ Demand D 3200 7658 4420 2384 3654 8680 5795 1953 4742 20 4472 4657 4956 5074 5157 5917 6646 6850 6791 6573 6363 6308 6932 7887 8662 8989 O Level-4696 Trend-343 O Level-3612. Trend-264 O Level 3629; Trend-263 O Level-2528: Trend-185
Source Available at: http://panmore.com/walmart-inventory-management [Accessed 18 July 2022] Reading the above, it becomes clear that good inventory management and forecasting can deliver supply chain success for and could ultimately lead to profitability and growth. In a report you are required to evaluate the importance of forecasting for Walmart Your report, must include but is limited to the following: • The importance of forecasting to Walmart. • Examine if a combination of both qualitative and quantitative forecasting may be best suited. • Argue the relevance of cloud-based forecasting for Walmart. NB: • The marks allocated next to each concept in the rubric below should serve only as a guide to the depth your discussion should cover. Your answer should be a minimum of 1 200 to a maximum of 1 500 words. Markers are to stop marking after the threshold of 1 500 words (two-and-a-half to three pages) has been reached. Please indicate the word count at the end of your answer. • You…
Given the following history, use a three-quarter moving average to forecast the demandfor the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar; 2ndquarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DECLast year 120 140 145 195 205 220 165 155 145 220 245 265This year 140 145 200 210 240 255
2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.
1) Describe a scenario that you have encountered recently as a consumer where a business has either under forecast or iver forecast demand for a product that you were planning to purchase. You will generally notice under forecasting if the product is out of stock or over forecasting if there is excess inventory for the item. Describe the imolications to the retailer,manufacturer, and broader supply chain. You can present your response through thr lens of your own discpline (accounting,mafketing,etc.) if you wish. 2) Give three examples from your life in which you may forecast the future. Highlight the importance of accurate forecasting in the three examples you provide.
After plotting the following demand data, a manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. Period, t At Actual 1 208 2 219 3 232 4 244 5 258 6 268 7 285 8 296 9 313 10 ? Use periods 1 to 4 to estimate the initial smoothed average and trend. Use a = 0.6 and b = 0.5 to develop forecasts for periods 6 through 10. (Round your answers to 2 decimal places.) What is the forecast for period 10?(round the answer to 2 decimal places)
National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a seven-month period is reported below: Sales (1000 units) Forecast Observation Month Yt Ft 1 February 19 2 March 18 3 April 15 4 May 20 5 June 18 6 July 22 7 August 20 8 September ? Use Excel to plot the data and forecast September sales using the following methods: The naïve forecast A three-month moving average Exponential smoothing with a smoothing coefficient of α = 0.2, assuming a February forecast of 19 A 3-month weighted moving average, with weights 0.60, 0.3, and 0.1. With 0.6 applied to the most recent past.
Year Sales 1) 123 2)118 3) 109 4) 112 5) 100 6) 110 7) 124 8)Determine the demand in Year 8 using a 3-month moving average using the sales table. Use weights of 0.40, 0.30 and 0.30