Problem $3-6($Algo$)$

Doog's Donuts produces five varieties of pastries, which are sold to a national grocery chain: muffins, donuts, cookies, cream puffs, and fritters. Assuming that Doog's operates a single shift for $1,450$ 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.

$\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$]]],[$Muffins$,540,750,0\mathrm{.}10,350,22\mathrm{.}4,],[$Donuts$,587,500,0\mathrm{.}10,250,11\mathrm{.}9,],[$Cookies$,1,216,000,0\mathrm{.}05,950,12\mathrm{.}1,],[$Cream puffs,$387,500,0\mathrm{.}20,250,35\mathrm{.}3,],[$Fritters$,267,500,0\mathrm{.}20,250,17\mathrm{.}9,],[,,,,,]]$

$$