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 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)60007 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*122.554010 Stitching 4310304011 Printing 10.8231213 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 1617 Explain your decisions below (must provide detail explaining why resources were added and how tasks were improved): 18

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!