Question $1$: Labour Productivity

A company is considering two locations for manufacturing its products: Location X and Location Y$.$ The labour costs and production capacities at each location differ. Below are the details for each location:

Location X:

Labour cost per day: $$224$

Hours required per unit: $40$

Maximum production capacity: $1,000$ units per month Location Y:

Labour cost per hour: $$280$

Hours required per unit: $70$

Maximum production capacity: $1,200$ units per month

Question $1-1$

Calculate the labour cost per unit for each location.

Question $1-2$

Note: this answer does not require a calculation but an analysis of the information.

If the company plans to produce $900$ units per month, which location should they choose based on labour cost per unit?

Question $1-3$

Note: this answer does not require a calculation but an analysis of the information.

If the company plans to increase production to $1,100$ units per month, which location is the better option considering both labour costs per unit and productivity capacity?

A $$ocal emtrepreneur wants to upenn a volne manuracturng piant with a warehouse in Prince Edward County to supply the warehouses in the county most efficiently. Using the centre of gravity method, where should this manufacturer$/$warehouse be located?

$\backslash$table$[[,$X$,$Y$,$Projected # of Cases of Bottles$/$per month$],[$Vineyards$,18,18\mathrm{.}5,24],[$Three Dog Winery,$23,9,17],[$Waupoos Estates Winery,$23,8,10],[$Black Prince Winery,$17,12,37],[$Huff Estate Winery,$12,10\mathrm{.}5,12],[$TerraCello Winery,$11,9,18],[$Karlo Estates,$9\mathrm{.}5,4\mathrm{.}5,29],[$Sandbanks Winery,$7\mathrm{.}5,3\mathrm{.}5,16],[$Casa$-$Dea Winery,$6\mathrm{.}5,4,9],[$Traynor Family Vinyard,$7,6,34],[$Closson Chase Vineyards $8\mathrm{.}5,7\mathrm{.}5,,]]$

Calculate the X and Y co$-$ordinates to $1-$decimal place.

Question $3$: Staffing & Balancing Work Cells

A manufacturing facility produces $500$ units of a product in an $8-$hour shift. The total available time for production in $7\mathrm{.}5$ hours when accounting for breaks. If the total cycle time to produce one unit is $5$ minutes, calculate the takt$-$time and then determine the number of workers needed to staff the work cell to meet the production demand.

Question $3-1$ Takt Time

Calculate takt$-$time in seconds per unit

Question $3-2$ Workers Needed

Calculate the number of workers needed in the work cell.

Question $4$: Time Studies

A time study was conducted on a particular task performed by an operator in a manufacturing plant. The allowance factor is $15\%.$ The following times, in seconds, were recorded for ten cycles of the task:

$32,30,3,34,33,29,35,31,30,32$

Question $7$: Reliability with Redundancies

As VP of operations at Normoyle Engineering, you must decide which product design, design A or design B $,$ has the higher reliability. B is designed with backup units for components $R_3$ and $R_4.$ What is the reliability of each design?

Question $7-1$

What is the reliability for Design A$?$

Design A

$R_1,R_2,R_3,R_4$

$0\mathrm{.}990\mathrm{.}950\mathrm{.}9980\mathrm{.}995$

Question $7-2$

What is the reliability for Design B$?$

Design $B$

$R_1,R_2,R_3,R_4$

$0\mathrm{.}990\mathrm{.}950\mathrm{.}950\mathrm{.}99$

$0\mathrm{.}950\mathrm{.}99$

Question $7-3$

Which design is better?

Question $8$: Decision Tree

A company is developing a new product and has two design options to consider:

Design Option A: A simpler, less innovative product design that costs $$2$ million to develop. There is a $70\%$ chance that the product will perform well in the market, leading to profits of $$6$ million. If the product performs poorly $(30\%$ chance$),$ it will generate profits of only $$1$ million.

Design Option B: A more complex, highly innovative product design that costs $$4$ million to develop. If the product performs well $(60\%$ chance$),$ it will yield profits of $$12$ million. If it performs poorly $(40\%$ chance$),$ it will generate profits of $$2$ million.

Question $8-1$ Design Option A

Calculate the expected monetary value $($EMV$)$ for Design Option A$.$

Question $8-2$ Design Option B

Calculate the expected monetary value $($EMV$)$ for Design Option B$.$

Question $8-3$

Based on the expected monetary value $($EMV$),$ which design option should the company choose?

Question $9$: Upload your Excel document!