teacher has never taught us this/:
Polymer Enterprises Spreadsheet Modeling Assignment 2. As the operations Margaret Wagokihasve you perto deployees/sto, and improved for the antroduction You cannot add available work overtime retrash 4 Uhe spreadsheet model below,ful in the banks with some hard coding, and source/improve to the required to sto metrotted demand 100.000 En vecin the spaceted below of resources added to improved, based on solution from previous realisht Projecte demand 100,000 bags Processing mask Total procesin Cydet Tie van Time available in Step resource taska/ Tin second time/bag in scandal second how/ seconds) Weekly Capacity Cutting 1 25 5 40 10 Sting 10 30 40 Printing 1 0.1 23 ta 11 Notes 1 Cutting There are actually two employees, but they are only acting as an oor. Two employment required to complete rast sately 15 Taske Cutting cutting one side of material Sitching abtching one edge of the TO plain your des below must provide detall explaining will surces were added and hour taska were improved 19 20 21 22 23 24 25 26 22 1 Helio Para Enterprises Spreadsheet Medeling 2. Alth Whey permission to someone and we tasks for the prope dewable without the dihet nodd below in the worden over the demand Cuple your doch wieder ein from previous sheet) Profete demande 100.000 Preces Total Tine www Tie weten See reures in seconde) minced word/ how/ Otting 20 18 30 10 11 Pite 23 12 1 NEM 14 There are always but they are more come sepse 11 side of things plan your des below wide details where were added and how we 18 TE 2. As the operation manager, Margaret W.colhas vee you permission to employees/srces to the punya production process 2*You cannot add available work house overtime or extra si *Using the spreadsheet model below fail in the blank highlighted in yellow with equations (no hard codine), and add resources to the required stations to meet current demand (200 bar/week) Explan your decision in the space highlighted below of resources added) 7 Current demand -25,000 bags Processing time/task Total processing Cycle tire in Time available in There wailable in Step resources tasks/bag in seconds) time/bag in seconds) seconds/ha hours/s) seconds/week) Weekly Capacity 9 Cutting 225 30 Stitching 20 30 40 1 Printing 1 23 10 3 Notes 4 Cutting There are actually two employees, but they are essently acting as one resource. Two employees are required to complete this step safely *Tasks Cutting cutting one side of material, Stitching = stitching one edge of the bas Explain your decisions below (must provide detall explaining why resources were added: Polymer Enterprises Spreadsheet Modeling Assignment 2. As the operations Margaret Wagokihasve you perto deployees/sto, and improved for the antroduction You cannot add available work overtime retrash 4 Uhe spreadsheet model below,ful in the banks with some hard coding, and source/improve to the required to sto metrotted demand 100.000 En vecin the spaceted below of resources added to improved, based on solution from previous realisht Projecte demand 100,000 bags Processing mask Total procesin Cydet Tie van Time available in Step resource taska/ Tin second time/bag in scandal second how/ seconds) Weekly Capacity Cutting 1 25 5 40 10 Sting 10 30 40 Printing 1 0.1 23 ta 11 Notes 1 Cutting There are actually two employees, but they are only acting as an oor. Two employment required to complete rast sately 15 Taske Cutting cutting one side of material Sitching abtching one edge of the TO plain your des below must provide detall explaining will surces were added and hour taska were improved 19 20 21 22 23 24 25 26 22 1 Helio Para Enterprises Spreadsheet Medeling 2. Alth Whey permission to someone and we tasks for the prope dewable without the dihet nodd below in the worden over the demand Cuple your doch wieder ein from previous sheet) Profete demande 100.000 Preces Total Tine www Tie weten See reures in seconde) minced word/ how/ Otting 20 18 30 10 11 Pite 23 12 1 NEM 14 There are always but they are more come sepse 11 side of things plan your des below wide details where were added and how we 18 TE 2. As the operation manager, Margaret W.colhas vee you permission to employees/srces to the punya production process 2*You cannot add available work house overtime or extra si *Using the spreadsheet model below fail in the blank highlighted in yellow with equations (no hard codine), and add resources to the required stations to meet current demand (200 bar/week) Explan your decision in the space highlighted below of resources added) 7 Current demand -25,000 bags Processing time/task Total processing Cycle tire in Time available in There wailable in Step resources tasks/bag in seconds) time/bag in seconds) seconds/ha hours/s) seconds/week) Weekly Capacity 9 Cutting 225 30 Stitching 20 30 40 1 Printing 1 23 10 3 Notes 4 Cutting There are actually two employees, but they are essently acting as one resource. Two employees are required to complete this step safely *Tasks Cutting cutting one side of material, Stitching = stitching one edge of the bas Explain your decisions below (must provide detall explaining why resources were added
