The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in gallons) for the next four quarters are60,000, 90,000, 90,000, and 140,000 respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts andbackorders 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 endof the year. Beginning inventory is 0.The quarterly production rate is 95000 gallons. (Enter your response as an integer.)b. Specify the anticipation inventory that will be produced. (Enter your responses as an integers.)QuarterAnticipationQuestion Viewer inventory (gallons)1234

Explanation for a: The quarterly production rate can be calculated by dividing the annual demand…

Answered: The Donald Fertilizer Company produces…

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)?
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
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)?
PLEASE PROVIDE DETAILED EXPLANATIONS
The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in gallons) for the next four quarters are 60,000, 90,000, 90,000, and 140,000 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 0. The quarterly production rate is 95000 gallons. (Enter your response as an integer.) b. Specify the anticipation inventory that will be produced. (Enter your responses as an integers.) 2 Quarter Anticipation inventory (gallons) 1 35000 3 4 40000 45000 0 c. Suppose that the requirements (in gallons) for the next four quarters are revised to 90,000, 140,000, 60,000, and 90,000 respectively. If total demand is the same, what…
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
. 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…
Please dont give answer in image format . Do type the answer !
The demand information is given below. Month Demand Jan Feb Mar Apr May Jun 1,900 2,900 4,800 5,800 5,800 1,950 A worker can produce 25 units per month. Assume that the beginning inventory in January is 800 units, and the firm desires to have 150 units of inventory at the end of June. a. 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 Demand Jan 1,900 Feb Mar Apr May Jun 2,900 4,800 5,800 5,800 1,950 Production 1100 2900 4800 5800 5800 2100 Ending inventory 800 0 150 Workforce 44 116 192 232 232 84 b. 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…
Helter Industries, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand. For the current four-month rolling schedule, there are three temps on staff and 12 full-time employees. The temps can be hired when needed and can be used as needed, whereas the full-time employees must be paid whether they are needed or not. Each full-time employee can produce 205 suits, while each part-time employee can produce 165 suits per month. Demand for bathing suits for the next four months is as follows: MAY JUNE JULY AUGUST 3,200 2,800 3,100 3,000 Beginning inventory in May is 403 (a complete two-piece includes both top and bottom) bathing suits. Bathing suits cost $40 to produce and carrying cost is 24 percent per year. Develop an aggregate plan that uses the 12 full-time employees each month and a minimum number of temporary employees. Assume that all employees will produce at their full potential each month. Calculate the inventory…
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 Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours? Table 1 demand forecast Month Demand (cases per month) January 600 February 800 March 1000 April 1500 May 2000 June 1700 July…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS