Question: A B C D E F G H 1 J K 1 Helio Polymer Enterprises Spreadsheet Modeling Assignment 2 * As the operations manager, Margaret
A B C D E F G H J K Helio Polymer Enterprises Spreadsheet Modeling Assignment As the operations manager, Margaret Wagoki has given you permission to add employeesresources to and improve tasks for, the gunny bag production process. You cannot add available work hours ie overtime or extra shift Using the spreadsheet model below, fill in the blanks with equations no hard coding and add resourcesimprove tasks to the required stations to meet projected demand bagsweekExplain your decisions in the space highlighted below # of resources added; tasks improved, based on solution from previous spreadsheet Projected demand bags Processing timetask Total processing Cycle time in Time available in Time available in Step # resources #tasksbagin seconds timebag in seconds secondsbag hoursshift secondsweek Weekly Capacity Cutting Stitching Printing Notes: Cutting: There are actually two employees, but they are essentially acting as one resource. Two employees ie one resource are required to complete this step safely. Tasks: Cutting cutting one side of material; Stitching stitching one edge of the bag Explain your decisions below must provide detail explaining why resources were added and how tasks were improved:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
