a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is 0. The quarterly production rate is 95,000 gallons. (Enter your response as an integer.) b. Specify the anticipation inventory that will be produced. (Enter your responses as an integers.) Quarter 3 45,000 5,000 4 Anticipation inventory (gallons) 10,000 c. Suppose that the requirements (in gallons) for the next four quarters are revised to 140,000, 60,000, 90,000, and 90,000 respectively. If total demand is the same, what level of production rate is needed now, using the same strategy as above? The new quarterly production rate is gallons. (Enter your response as an integer.) 0

a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is 0. The quarterly production rate is 95,000 gallons. (Enter your response as an integer.) b. Specify the anticipation inventory that will be produced. (Enter your responses as an integers.) Quarter 3 45,000 5,000 4 Anticipation inventory (gallons) 10,000 c. Suppose that the requirements (in gallons) for the next four quarters are revised to 140,000, 60,000, 90,000, and 90,000 respectively. If total demand is the same, what level of production rate is needed now, using the same strategy as above? The new quarterly production rate is gallons. (Enter your response as an integer.) 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

The Donald Fertilizer Company produces industrial chemi-cal fertilizers. The projected manufacturing requirements (inthousands of gallons) for the next four quarters are 90, 60,90, and 140, respectively. A level workforce is desired, relyingonly on anticipation inventory as a supply option. Stock-outs and backorders are to be avoided, as are overtime andundertime.a. Determine the quarterly production rate required to meettotal demand for the year, and minimize the anticipationinventory that would be left over at the end of the year.Beginning inventory is 0.b. Specify the anticipation inventory that will be produced.c. Suppose that the requirements for the next four quartersare revised to 60, 90, 140, and 90, respectively. If total de-mand is the same, what level of production rate is needednow, using the same strategy as part (a)?
. 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…
The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in thousands of gallons) for the next four quarters are 80, 50, 80, and 130, respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts and backorders are to be avoided, as are overtime and undertime.a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is zero.b. Specify the anticipation inventory that will be produced.c. Suppose that the requirements for the next four quarters are revised to 80, 130, 50, and 80, respectively. If total demand is the same, what level of production rate is needed now, using the same strategy as part (a)?
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 270
Jill wants you to consider a hybrid aggregate plan, usingup to the maximum overtime per employee for any periodwhere demand cannot be satisfi ed with the current regular-timeproduction and the available inventory. Back orders can occur.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources
Zan 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…
A small company produces recreational vehicles. The (in units): Mar Apr May Jun Jul Aug Sep 50 Total Month 359 Forecast 55 60 60 40 50 44 Use the following information: Regular labour cost $240 per unit Overtime labour cost $360 per unit Regular capacity 40 units per month, using 5 workers Overtime capacity 8 units per month Holding cost $30 per unit per month Back-order cost $100 per unit per month Beginning inventory Desired ending inventory 0 Hiring cost $2,000 per worker Develop the minimum cost production plan and compute its total cost.
12. Zan 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 $36,000 and variable costs of $1.75 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 $2.75 per bag. Part 2 a) The break-even quantity in units for the manual process = ______ bags (round your response to the nearest whole number). b) The revenue for…
Exercise 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?
In aggregate planning, if the beginning inventory for January is 500, the forecasted demand is 1800 and the safety stock is 450, what will be the production requirement in January? A. 1900 B. 1850 C. 1800 D. 1750
The demand information is given below. Month Jan Feb Mar Apr May Jun Demand 1,900 2,800 4,700 5,600 5,600 1,750 A worker can produce 25 units per month. Assume that the beginning inventory in January is 450 units, and the firm desires to have 300 units of inventory at the end of June. Use a chase production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". Month Jan Feb Mar Apr May Jun Demand 1,900 2,800 4,700 5,600 5,600 1,750 Production Ending inventory 450 Workforce Use a level production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". Month Jan Feb Mar…
A Company is interested in developing a quarterly aggregate production plan but they are not sure if a level strategy with backorders or a chase strategy would be better. They have the following information available regarding their production operation: Hiring workers Layoff workers Inventory holding Cost Stockout cost for backorders Production (Labor) cost Subcontracting cost Previous quarter's production Beginning inventoy Quarter forecasts are 2000, 6000, 4000, 5000, respectively. This problem has questions. Suppose that you want to use a level plan with backorders (one that produces at the average demand over the four quarters). Answer the next two questions using this plan. Do not round your intermediate calculations. Round your final answer to the nearest whole number. What would be your production rate each month? A. 4250 B. 3500 C. 4250, 3000, 4000, 5000 D. 2000, 6000, 4000, 5000 What is the ending inventory in Quarter 2 A. 500 B. 2250 C. 2500 D. 0 Suppose that you want to use…