Concept explainers
a
Interpretation: Number of bows at the end of fourth month is to be calculated.
Concept Introduction: Weighted average method is the method in which different numerical value is given to variable depending upon its importance. Higher the importance, larger is the numerical value given.
a
Explanation of Solution
All figures are in ‘000.
For month 1:
Calculation of average inventory::
Where,
Where,
Average inventory for 1st moth is 7500.
For month 2:
Calculation of average inventory::
Where,
Where,
Average inventory for 2nd month is25000.
For month 3:
Calculation of average inventory::
Where,
Where,
Average inventory for 3rd month is 32500.
For month 4:
Calculation of average inventory::
Where,
Where,
Average inventory for 2nd month is 32500.
Number of bows at the end of the month is 5000
b
Interpretation: The month that has the highest inventory is to be determined.
Concept Introduction: Weighted average method is the method in which different numerical value is given to variable depending upon its importance. Higher the importance, larger is the numerical value given.
b
Explanation of Solution
Fouth month has the highest inventory as ending inventory is 5000.
c
Interpretation: Total inventory cost is to be calculated.
Concept Introduction: Holding cost or inventory cost is the cost of warehousing in which unsold goods are kept. It includes transportation, warehousing, insurance etc.
c
Explanation of Solution
Cost of inventory = $1 per unit.
Total inventory cost is $85000
Want to see more full solutions like this?
Chapter 11 Solutions
Practical Operations Management
- 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?arrow_forwardScenario 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?arrow_forwardHotel Galway is a 50 room Boutique hotel in a pop-ular city break destination in Ireland. Until recently the hotel has priced each room at $120 for bed and breakfast. On aver-age 40 rooms are occupied every weekend. The variable cost of each occupied room is $30. Following an internal review man-agement has decided to try a revenue management approach, with rooms priced at $90 for bookings up to one week early and $180 for bookings within a week of their stay. It is esti-mated the hotel will sell 28 rooms at the lower price and 14 at the higher price. Variable costs will not change. Recommendwhich approach is the most feasible.arrow_forward
- The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=17751775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month…arrow_forwardThe president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=1775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month by…arrow_forwardThe president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=1775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month by…arrow_forward
- The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,100 February 1,700 June 2,100 March 1,600 July 1,700 April 1,900 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. Evaluate the following plans D and E. Plan D: Keep the current workforce stable at producing 1,600 units per month. In addition to the regular production, another 20% of the normal production units can be produced in overtime at an additional cost of $50 per unit. A warehouse now constrains the maximum allowable inventory on hand to 600 units or less. Note: Do not produce in overtime if production or inventory are adequate to cover demand.…arrow_forwardA manager is attempting to put together an aggregate production plan for the coming nine months. She has obtained forecasts of aggregate demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in months 3 and 4, and again in month 8, as can be seen below: The company has 20 permanent employees, each of whom can produce 10 units of output per month at a cost of $6 per unit. Inventory holding cost is $5 per unit per month, and back-order cost is $10 per unit per month. The manager is considering a plan that would involve hiring two people to start working in month 1, one on a temporary basis who would work until the end of month 5. The hiring of these two would cost $500. Beginning inventory is 0.Start with 20 permanent workers. Prepare a minimum cost plan that may use some combination of hiring ($250 per worker), subcontracting ($8 per unit, maximum of 20 units per month, must use for at least three consecutive months), and overtime…arrow_forwardThe president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,700 June 2,100 March 1,700 July 1,900 April 1,700 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement=18001800 units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in…arrow_forward
- Capacity planning requires a demand forecast for an extended period of time into the future. What concerns would you have regarding an extended forecast as a capacity planner?arrow_forwardThe production manager at Zam Tech has developed following aggregate forecast of its products: The manager has also assembled the following information to help in the development of the aggregate plans: The manager wants to use a level strategy with a combination of backlogs, subcontracting, overtime and inventory to handle variations in demand. There is no beginning inventory and the safety stock requirement is zero. Note that there should not be a backlog in the final period. Note that no decimal points, commas or spaces in all the answers. (a) What is the level total Production Rate? Answer units (b) What is the maximum quantity subcontracted and in which period? Quantity-Answer and Period-Answer (c) What is the maximum quantity backlogged and in which period? Quantity-Answer and Period-Answer (d) What is the total regular production cost? $Answer (e) What is the total overtime cost? $Answer (f) What is the total subcontracting cost? $Answer (g) What is the total…arrow_forwardThe planner at a company that makes garden tractors is about to prepare an aggregate production plan that will cover the next 6 months. She has collected the following information: Month Demand Forecast Above the available capacity through permanent workforce 1 1,000 2 1,000 3 2,000 4 3,000 5 4,000 6 1,000 Total: 12,000 Production per month = 20 units per worker Initial inventory = 500 units Desired ending inventory (at the end of month 6) = 0 units Cost: Hire cost = $500 per temporary worker Inventory = $10 per tractor per month Backorder = $150 per tractor per month The optimum aggregate plan is: Month 1 2 3 4 5 6 Total Forecast Demand above regular capacity 1,000 1,000 2,000 3,000 4,000 1,000 12,000 # of temporary workers required 50 50 100 150 200 50 Temp. Workers hired 25 25 50 75 0 0 Temp. workers laid off 0…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning