The Excel file should contain the solutions to the problems as well. However, whenever appropriate you should also submit a single spreadsheet with each problem in a different tab in case I need to see what went wrong in your problem so I can provide feedback. PLEASE DO NOT SUBMIT AN EXCEL FILE FOR EACH PROBLEM.

Problem $1.$ A work center consisting of three machines operates $40$ hours a week. In a four$-$week period, it actually worked $360$ hours and produced $470$ standard hours of work. Calculate the utilization and efficiency of the work center. What is the demonstrated weekly capacity of the work center?

Problem $2.$ Back schedule the following shop order. All times are given in days. Move time between operations is one day, and wait time is one day. Due date is day $150.$ Assume orders start at the beginning of a day and finish at the end of a day.

Operation Number Work Center Operation Time $($Days$)$ Queue Time $($days$)$ Arrival Date $($a$.$m$.)$ Finish Date $($p$.$m$.)$

$1011124$

$2013045$

$3015512$

stores