and fritters. Assuming that Doog's operates a single shift for $1,800$ 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.

$?$

Click here for the Excel Data File

a$.$ Complete the table given below.

$\backslash$table$[[$Pastry$,\backslash$table$[[$Demand$],[$Forecast$],[($units$/$year$)]],\backslash$table$[[$Processing$],[$Time$],[($minutes$/$unit$)]],\backslash$table$[[$Lot Size$],[($# of pastries$)]],\backslash$table$[[$Setup Time$],[($minutes$/$setup$)]],\backslash$table$[[$Total$],[$Processing$],[$Time$],[$minutes$/$year$]],\backslash$table$[[$Number of$],[$Batches per$],[$Year$]],\backslash$table$[[$Total Setup$],[$Time$],[$minutes$/$year$]],\backslash$table$[[$Capacity$],[$Required$],[$minutes$/$year$]]],[$Muffins$,440,000,0\mathrm{.}10,400,20,440,000,,,],[$Donuts$,600,000,0\mathrm{.}10,300,5,,,,],[$Cookies$,1,000,000,0\mathrm{.}05,1,000,10,,,,],[$Cream puffs,$240,000,0\mathrm{.}20,200,20,,,,],[$Fritters$,180,000,0\mathrm{.}20,300,15,,,,],[,,,,440,000,0,0,0]]$

b$.$ Calculate the required capacity. $($The required capacity should be in terms of the number of work cells needed.$)($Do not round intermediate calculations. Round up your answer to the next whole number.$)$

Required capacity

cells