Please answer #4 and #5 in excel format with the formulas showing. Screenshots work perfectly!

4. Nerula Bakeries, a fictional bakery, has the following demand requirements for its specialty cakes in the month of June. Specialty Care Graduation Cake Aniversary Care Wedding Cake 100 The labor skill requirements for making specialty cakes are high, and the process involves two critical operations-baking and decorating. The time required for each operation varies depending on the type of specialty cake. The standard labor hours per unit of skilled labor required for the three types of specialty cakes vary and are given in the following table: Standard Lator Hours per the foresch Operation Specialty Cake Balling Decorating Graduation Cake 10 20 Anniversary Cake 60 Wedding Cake Assuming an 8-hour work day with two shifts and 30 working days in the month of June, how many skilled workers would the bakery need to meet the demand requirements? If there is a capacity overload or underload in any of the work centers, what are some approaches you would take to level capacity? 5. The manufacturing sequence for two products that a company produces involves fabrication, assembly, and painting operations. Each operation requires 2 days to completely process a production lot before it can be moved to the next department. The processing times (in hours per unit) for both products at each of the three departments in terms of both labor and machine resources are given in the following table: Fabrication Assembly Libor Machine La Machine Labor Machine Product ? Product K2 1505 The available labor and machine capacities at each department are 800 hours of labor and 600 hours for each day of a 5-day workweek. For the upcoming workweek, the company has developed the following production schedule for the two products. Product Monday Tuesday Wednesday Thursday 400 300 200 200 K 400 100 200 100 100 Assuming no setup or changeover time, determine the capacity requirements for each product and the total load for each of the three departments for each day of the 5-day workweek. 6. An air compressor assembly department has four employees who each work 40 hours 4. Nerula Bakeries, a fictional bakery, has the following demand requirements for its specialty cakes in the month of June. Specialty Care Graduation Cake Aniversary Care Wedding Cake 100 The labor skill requirements for making specialty cakes are high, and the process involves two critical operations-baking and decorating. The time required for each operation varies depending on the type of specialty cake. The standard labor hours per unit of skilled labor required for the three types of specialty cakes vary and are given in the following table: Standard Lator Hours per the foresch Operation Specialty Cake Balling Decorating Graduation Cake 10 20 Anniversary Cake 60 Wedding Cake Assuming an 8-hour work day with two shifts and 30 working days in the month of June, how many skilled workers would the bakery need to meet the demand requirements? If there is a capacity overload or underload in any of the work centers, what are some approaches you would take to level capacity? 5. The manufacturing sequence for two products that a company produces involves fabrication, assembly, and painting operations. Each operation requires 2 days to completely process a production lot before it can be moved to the next department. The processing times (in hours per unit) for both products at each of the three departments in terms of both labor and machine resources are given in the following table: Fabrication Assembly Libor Machine La Machine Labor Machine Product ? Product K2 1505 The available labor and machine capacities at each department are 800 hours of labor and 600 hours for each day of a 5-day workweek. For the upcoming workweek, the company has developed the following production schedule for the two products. Product Monday Tuesday Wednesday Thursday 400 300 200 200 K 400 100 200 100 100 Assuming no setup or changeover time, determine the capacity requirements for each product and the total load for each of the three departments for each day of the 5-day workweek. 6. An air compressor assembly department has four employees who each work 40 hours