35 * X V f* 1196000 A B C D E F G H K L M N O P 1 Problem 3.6 Demand Forecast Processing Time Lot Size (# Setup Time 2 Pastry (units/year) (min/unit) of pastries) (min/setup) 3 Muffins 316,000 0.10 200 23 4 Donuts 246,000 0.10 100 11 5 Cookies 1,196,000 0.05 800 12 6 Cream Puffs 150,500 0.20 100 24 7 Fritters 306,000 0.20 400 20 CO 9 10 11 12 13 14 15Doog'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,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. AspictureClick here for the Excel Data File a. Complete the table given below. Total Demand Processing Number of Total Setup Capacity Pastry Forecast Time Lot Size Setup Time Processing (# of pastries) (minutes/setup) Time Batches per Time Required (units/year) (minutes/unit) minutes/year Year minutes/year minutes/year Muffins 440,000 0.10 400 20 Donuts 600,000 0.10 300 5 Cookies 1,000,000 0.05 1,000 10 Cream puffs 240,000 0.20 200 20 Fritters 180,000 0.20 300 15b. Calculate the required capacity. (The required capacity should he in terms of the number of work cells needed.) {Do not round intermediate calculations. Round up your answer to the next whole number.)