A B C D E F G H 1 J K 1 Helio Polymer Enterprises Spreadsheet Modeling Assignment 2 *As the operations manager, Margaret Wagoki has given you permission to add employees/resources to, and improve tasks for, the gunny bag production process. 3 *You cannot add available work hours (i.e., overtime or extra shift) 4 * Using the spreadsheet model below, fill in the blanks with equations (no hard coding), and add resources/improve tasks to the required stations to meet projected demand (100,000 bags/week). 5 *Explain your decision(s) in the space highlighted below (# of resources added; tasks improved, based on solution from previous spreadsheet) 6 000 7 Projected demand = 100,000 bags Processing time/task Total processing Cycle time (in Time available (in Time available in 8 Step # resources #tasks/bag** (in seconds) time/bag (in seconds) seconds/bag) hours/shift) seconds/week) Weekly Capacity Cutting* 1 2 2.5 5 40 10 Stitching 4 3 10 30 40 11 Printing 1 0.8 23 12 13 Notes: 14 *Cutting: There are actually two employees, but they are essentially acting as one resource. Two employees (i.e., one resource) are required to complete this step safely. 15 **Tasks: Cutting = cutting one side of material; Stitching = stitching one edge of the bag 16 17 Explain your decisions below (must provide detail explaining why resources were added and how tasks were improved): 18