The Donald Fertilizer Company produces industrial chemicalfertilizers. The projected manufacturing requirements (in thousandsof gallons) for the next four quarters are 80, 50, 80, and 130,respectively. A level workforce is desired, relying only onanticipation inventory as a supply option. Stockouts and backordersare to be avoided, as are overtime and undertime.
a. Determine the quarterly production rate required to meettotal demand for the year, and minimize the anticipation inventorythat would be left over at the end of the year. Beginning inventoryis zero.
b. Specify the anticipation inventory that will be produced.
c. Suppose that the requirements for the next four quarters arerevised to 80, 130, 50, and 80, respectively. If total demand isthe same, what level of production rate is needed now, using thesame strategy as part (a)?
Please use excel solution and post the table in formulaauditing mode as well so that I may see how the cells were solved.Thank you!
