Doog's Donuts produces five varieties of pastries, which are sold to a national grocery chain: muffins, donuts, cookies, cream puffs,

and fritters. Assume that Doog's operates a single shift for $1,900$ hours per year. The processing time per unit, setup time per lot, the

annual demand, and lot size are given in the table. Assume that the times given are for a work cell of four workers each.

DictureClick here for the Excel Data File

a$.$ Complete the table given below.

b$.$ Calculate the required capacity. $($The required capacity should be in terms of the number of work cells needed.$)$

Complete this question by entering your answers in the tabs below.

Required A

Required B

Calculate the required capacity. $($The required capacity should be in terms of the number of work cells needed.$)$

Note: Do not round intermediate calculations. Round up your answer to the next whole number.Doog's Donuts produces five varieties of pastries, which are sold to a national grocery chain: muffins, donuts, cookies, cream puffs,

and fritters. Assume that Doog's operates a single shift for $1,900$ hours per year. The processing time per unit, setup time per lot, the

annual demand, and lot size are given in the table. Assume that the times given are for a work cell of four workers each.

DictureClick here for the Excel Data File

a$.$ Complete the table given below.

b$.$ Calculate the required capacity. $($The required capacity should be in terms of the number of work cells needed.$)$

Complete this question by entering your answers in the tabs below.

Required A

Complete the table given below.