QUESTION $1$

READ ALL OF THESE INSTRUCTIONS FULLY $-$ DO NOT SKIP THIS!

THESE INSTRUCTIONS APPLY TO ALL PROBLEMS SETS

You are required to submit MS Excel to support every answer you report in every assignment and specified questions on the exams. An explanation for what is meant by using MS Excel to accomplish your work is located in the course syllabus. Please be sure you read that to be sure you show your work correctly.

The truncation of values used in your calculations will result in a deduction of $50\%$ credit from the question. What does this mean? Say you calculate $"=11/3"$ in cell A$1$ and it returns $3\mathrm{.}666$begin mathsize $18$px style $6$ with bar on top end style. You also calculated $"=14/9"$ in cell A$2,$ which returns $1\mathrm{.}555$begin mathsize $18$px style $5$ with bar on top end style. You now need to multiply these two numbers. The correct method is to calculate $"=$A$1*$A$2"$ which returns $5\mathrm{.}7$begin mathsize $18$px style $037$ with bar on top end style. If you truncate and type values into a new formula, such as $"=3\mathrm{.}667*1\mathrm{.}556"$ it would return $5\mathrm{.}705852,$ which is an incorrect answer. If you were to continue to calculate using this incorrect value, you will likely end up with much more error in your answer and end up using incorrect values to make decisions. Even if your truncated calculation returns the correct answer to the designated number of decimal places, you will receive the deduction due to the potential for future calculation error. You must use the Excel calculation tools to determine all of your answers.

This question, and question $1$ on the other assignments, is where you will upload your MS Excel file. The file upload question on the exams will be randomly located.

Only one file can be uploaded, so be sure all of your work is consolidated into one Excel file. If you need assistance on how to create additional worksheets in your MS Excel workbook, please view the Excel Demo $-$ Excel Basics video again or contact the course TA for assistance.

Please be sure the question number and answer are clearly marked in your worksheet.

Data values$/$sets may be different on subsequent attempts. You will be graded based on the data values$/$sets of the last attempt.

You will not receive credit for any problem for which you do not show your work $-$ even correct answers.

Remember, these instructions apply to all assignments and exams!

If you have any questions about these instructions, please post it to the Discussion Board under "Course Administration Questions for Dr$.$ Leach" or send your question by email.

Attach FileNo file chosen

$0$ points

QUESTION $2$

Bakery ABC has $10$ ovens. Each oven can hold a single cake at a time and each cake takes $37$ minutes to bake. On average, how many cakes per hour can be baked at Bakery ABC? $($report your answer to $2$ decimal places$)$

$16\mathrm{.}22$

$5$ points

QUESTION $3$

A manufacturing process has $12$ workers and $6$ stations. The process is completed in the order given below. Where there are multiple workers within a station, each worker works independently on his$/$her own unit. Assume inventory buffers are allowed between each station.

Station Staffing Processing time$/$Activity time $($hours$/$unit$/$worker$)$

A $22\mathrm{.}20$

B $11\mathrm{.}25$

C $32\mathrm{.}00$

D $22\mathrm{.}60$

E $33\mathrm{.}00$

F $10\mathrm{.}75$

What is the maximum number of units per hour that can be produced? Assume they start the day with inventory at each station to work on$.($report your answer to $2$ decimal places$)$

$0\mathrm{.}77$

$5$ points

QUESTION $4$

A process requires $6$ tasks that must be performed in order. Currently there are $4$ employees that are equally skilled at each task. Employee $1$ is assigned tasks $1$ and $2,$ employee $2$ is assigned task $3,$ employee $3$ is assigned task $4,$ and employee $4$ is assigned to tasks $5$ and $6.$ The task times $($all in seconds$)$ are given in the process diagram below. For example, task $1$ requires $29$ seconds.

Suppose the system started without any work in process inventory $($i$.$e$.,$ an empty system$).$ How long would this process take to produce $22$ units $($in seconds$)?($report your answer as an integer$)$

$1519$

$5$ poA process requires $10$ tasks that must be performed in order. Currently there are $4$ employees that are equally skilled at each task. Employee A is assigned tasks $1$ and $2,$ employee B is assigned tasks $3,4$ and $5,$ employee C is assigned tasks $6,7$ and $8,$ and employee D is assigned tasks $9$ and $10.$ The task times $($all in seconds$)$ are given in the table.

Tasks Activity time $($seconds$)$

$156$

$242$

$339$

$432$

$561$

$628$

$735$

$847$

$941$

$1065$

Suppose the system started without any work in process inventory $($i$.$e$.,$ an empty system$).$ How long would this process take to produce $25$ units $($in seconds$)?($report your answer as an integer$)$