Concept explainers
Interpretation:
Costs of level and chase demand production plans.
Concept Introduction:
Chase strategy is a strategy used by company to meet uncertain demands of customers. Company produces so much goods that there is enough inventory for end users. This strategy is used usually by companies to optimally reduce cost of inventory.
Answer to Problem 5PA
The total cost using chase strategy is $546,240.
Explanation of Solution
Given information:
Month | J | F | M | A | M | J | J | A | S | O | N | D |
Litres (1000s) | 200 | 120 | 75 | 40 | 15 | 7 | 5 | 10 | 30 | 70 | 120 | 130 |
Following is the step wise calculation of level strategy (Note − units in 1,000 liters)
Following is the calculation of holding inventory Holding inventory = Normal Production + On-hand inventory − Demand
Holding inventory = 100 + 90 − 200
Holding inventory / Shortage = 10
The holding inventory / shortage is 10 units
Following is the calculation of Normal Production cost Normal Production cost = Normal production
Normal Production cost = 90
Normal Production cost = $36,000
Following is the holding cost Holding cost = Holding inventory
Holding cost = 15
Holding cost = $450
Following is the total cost Total cost = Normal production cost + Holding inventory cost
Total cost = 36000 + 450
Total cost = $36,450
Following is the calculation of level strategy
J | F | M | A | M | J | J | A | S | O | N | D | |
Demand | 200 | 120 | 75 | 40 | 15 | 7 | 5 | 10 | 30 | 70 | 120 | 130 |
On-handDelivery | 100 | 0 | 0 | 11 | 65 | 140 | 223 | 308 | 388 | 448 | 468 | 438 |
Normal production | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 |
Holding inventory | 15 | 65 | 140 | 223 | 308 | 188 | 448 | 408 | 438 | 348 | ||
Units shortage | 10 | 30 | ||||||||||
Level strategy cost | ||||||||||||
Normalproduction | 36,000 | 36,000 | 34,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 |
Holding cost | 0 | 0 | 450 | 1950 | 4,200 | 6090 | 9240 | 11640 | 13,440 | 14040 | 13140 | 10440 |
Total cost | 36,000 | 36,000 | 34,450 | 37,950 | 40,200 | 42,090 | 41,240 | 47,640 | 49,440 | 50,040 | 49140 | 46,440 |
I | F | M | A | M | I | J | A | S | O | N | D | |
Demand | 200 | 120 | 75 | 40 | 15 | 7 | 5 | 10 | 30 | 70 | 120 | 130 |
On-handDelivery | 100 | 0 | 0 | 11 | 65 | 140 | 223 | 308 | 388 | 448 | 468 | 438 |
Normal production | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 |
Holding inventory | 15 | 65 | 140 | 223 | 308 | 188 | 448 | 408 | 438 | 348 | ||
Units shortage | 10 | 30 | ||||||||||
Level strategy cost | ||||||||||||
Normalproduction | 36,000 | 36,000 | 34,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 |
Holding cost | 0 | 0 | 450 | 1950 | 4,200 | 6090 | 9240 | 11640 | 13,440 | 14040 | 13140 | 10440 |
Total cost | 36,000 | 36,000 | 34,450 | 37,950 | 40,200 | 42,090 | 41,240 | 47,640 | 49,440 | 50,040 | 49140 | 46,440 |
Total cost 517,230The total cost using level strategy is $517,230 Following is the step wise calculation of chase strategy
(Note − units in 1,000 liters)
Following is the Overtime cost
Overtime cost = Normal production cost + Normal production cost
Overtime cost = 400 + 400
Overtime cost = 400 + 80
Overtime cost = $480
Following is the Undertime cost
Undertime cost = Normal production cost + Normal production cost
Undertime cost = 400 + 400
Undertime cost = 400 + 48
Undertime cost = $448
Following is the calculation of chase strategy
Chase Strategy
I | F | M | A | M | I | J | A | S | O | N | D | |
Demand | 200 | 120 | 75 | 40 | 15 | 7 | 5 | 10 | 30 | 70 | 120 | 180 |
On-handDelivery | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - |
Normal production | 90 | 90 | 75 | 40 | 915 | 7 | 5 | 10 | 30 | 70 | 90 | 90 |
Holding inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||
Units shortage | 10 | 30 | 30 | 90 | ||||||||
Chase strategy cost | ||||||||||||
Normalproduction | 36,000 | 36,000 | 30,000 | 16,000 | 6,000 | 2,800 | 2,000 | 4,000 | 12,000 | 28,000 | 36,000 | 36,000 |
Holding cost | 4,800 | 14,400 | 7,200 | 24,000 | 36,000 | 39,840 | 40,800 | 38,400 | 28,800 | 9,600 | 14,400 | 41,200 |
Total cost | 40,800 | 50,400 | 37,200 | 40,000 | 42,000 | 42,680 | 42,800 | 42,400 | 40,800 | 37,600 | 50,400 | 79,200 |
Chase strategy
I | F | M | A | M | I | J | A | S | O | N | D | |
Demand | 200 | 120 | 75 | 40 | 15 | 7 | 5 | 10 | 30 | 70 | 120 | 180 |
On-handDelivery | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - |
Normal production | 90 | 90 | 75 | 40 | 915 | 7 | 5 | 10 | 30 | 70 | 90 | 90 |
Holding inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||
Units shortage | 10 | 30 | 30 | 90 | ||||||||
Chase strategy cost | ||||||||||||
Normalproduction | 36,000 | 36,000 | 30,000 | 16,000 | 6,000 | 2,800 | 2,000 | 4,000 | 12,000 | 28,000 | 36,000 | 36,000 |
Holding cost | 4,800 | 14,400 | 7,200 | 24,000 | 36,000 | 39,840 | 40,800 | 38,400 | 28,800 | 9,600 | 14,400 | 41,200 |
Total cost | 40,800 | 50,400 | 37,200 | 40,000 | 42,000 | 42,680 | 42,800 | 42,400 | 40,800 | 37,600 | 50,400 | 79,200 |
Total cost = 5,46,240
The total cost using chase strategy is $546,240.
It is recommended for the company to use level strategy as its cost are less compared to chase strategy.
Want to see more full solutions like this?
- 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_forwardOn August, a light business bought $3600 worth of lamps. At the beginning of September, the store had $1400 in lights on hand, and by the end of September, it projected to have $1600 in lamps on hand to meet some of the forecasted October sales. And what's the August planned cost of goods sold?arrow_forward
- 1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270arrow_forwardCapacity 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_forwardAssume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast including trend for the next period.arrow_forward
- The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: month production days demand(in hundred of cases) April 14 75 May 20 100 June 24 200 July 26 140 August 20 100 September 18 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty’s production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and…arrow_forwardDevelop a production plan and calculate the annual cost for a firm whose demand forecast is: fall, 10,100; winter, 8,100; spring, 7,100; summer, 12,100. Inventory at the beginning of fall is 505 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock-outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; regular time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. In each quarter, produce to the full output of your regular workforce, even if that…arrow_forwardZan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zan has years of food processing experience, and Angela has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per bag of lettuce. They think a largely manual process will have monthly fixed costs of $40,000 and variable costs of $2.00 per bag. A more mechanized process will have fixed costs of $72,000 per month with variable costs of $1.25 per bag. They expect to sell the shredded lettuce for $3.00 per bag. a) The break-even quantity in units for the manual process = enter your response here bags (round your response to the nearest whole number). b) The revenue…arrow_forward
- . Case: Flamingo Educational Services Flamingo Educational Services, a company located in the Tema metropolis, is a nationwide market leader in the publishing and distribution of textbooks for first and second cycle schools. Somehow, Flamingo does not use forecasts for production planning. Instead, the operations manager decides which books to produce and the batch size, based on orders and the amounts in inventory. The books that have the fewest amounts in inventory get the highest priority. Demand is uneven, and the company has experienced being overstocked on some items and out of others. Being under-stocked has occasionally created tensions with managers of the retail bookstores the company works with. Flamingo is on the verge of losing a lucrative contract with the Ghana Education Service over a complaint that the books produced over the last four months have defective binding as well as slight but noticeable variations in print quality and sizes of the…arrow_forwardc. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.arrow_forwardExercise 3: Daily demand for a product of a computer manufacturer is 400,000 units. The company, on average, makes $150 net profit for each computer. The current fill rate is 86%. About 70% of their incomplete orders are back-ordered, and the rests are cancelled. The company is considering to improve the fill rate to 90% whose estimated daily additional operating cost (e.g.,improving the warehousing and transportation) is $2,000,000. What should be the minimum back-order cost to make this investment reasonable?arrow_forward
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPractical 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