Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra Layout References Mailings Review View Help Sh SALT A Aa A - A-D-A- AaBbcc Aabbcc AaBbc Aabbcc AaB 1 Normal 11 No Spac... Heading 1 Heading 2 Title Find - Replace Select- Dictate Sensitivity 5 Paragraph Styles Editing Voice Sensitivity Problem 1: if the factory only has capacity for 50 machines, how many machines of each type should be installed to maximize the number of loaves produced per hour for the commercial bread bakery? Use the data provided in Appendix A to calculate your solution. Please show your work and insert your results in the table below. (5 Marks) If you use Excel, provide the Excel file with your submission. For those of you who want the challenge, consider learning and using the Excel add-in "Solver" for this problem (using Solver is not required). Machine Type Number of Machines Sieving Machine Mixer/Kneader Dough Divider Proofer Folder/Molder Dough Conveyor Oven Packaging/Bagger Bread Conveyor Slicer Total Machines D Focus BE Canada ENC O w Sa o 5 6 7 8 9 2 E R Bread Factory Assignment 20200703 - Saved to this PC- neha gn Layout References Mailings Review View Help - A A Aa- Po E ALT * A-D-A-D- | T Normal I No Spac... Heading Heading 2 Find Replace Select Title ht Paragraph Styles Editing 2 Problem 2: If Weston's had the room to buy additional machines which two machines should they purchase. Using the Break-Even Analysis with the data found in Appendix A and Appendix B, calculate how many units and how many sales dollars will it take to pay for the new machinery. (6 marks) Provide your recommendations of which type of machine and how many should Weston's Bakery purchase. Provide your explanation and justification for your recommendation. Be careful to recommend only the machines that are needed, this is not necessarily those with the lowest breakeven point. (4 marks) Please show your work. If you use Excel, provide the Excel file with your submission Machine Type Breakeven (in units) Breakeven in dollars) Bread Conveyor Dough Conveyor Dough Divider Folder/Molder Mixer/Kneader Oven Packaging/Bagger Proofer Sieving Machine Slicer glish (Canada) Focus ch 0 w V Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra ND sign Layout References Mailings Review View Help IT Find - A A Aa- PoE- EE A * A-D-A ---- AaBbced AaBbCcDc AaBbci AaBbcc AaB 11 Normal 11 No Spac.. Heading 1 Heading 2 Title Replace Select Dictate Sens ant Paragraph Styles Editing Voice Sens 5. Problem 3: Design the optimal layout of the factory to have the most efficient flow of material and people though it. Copy and paste the machine card and building infrastructure blocks from Appendix D onto the factory plan found in Appendix E. One card will represent the number of the machines needed for that process In Appendix Cis a flow chart of the process simplified and your can watch the process capture in the very first "How its Made" episode found at this link, https://www.youtube.com/watch?v=BUUWWWACA. When laying out the factory, consider the process and place the cards and blocks carefully according to needs of the factory and its processes. Use only one card to represent the process regardless of the number of machines you will need, for example, 1 Proofer card may represent 4 Proofer machines Please do not change the size of the cards and blocks. (6 marks) Below, share what you considered and the logic you applied as to the placement of the cards and blocks. 4 marks) lish Canada Focus ch O W 5 & Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra ND Layout References Mailings Review View Help Share - - ALT - A Aa- Po 2A-D-A- AaBbcc Aabbcc AaBb AaBbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Find - Replace Select Title Dictate Sensitivity Paragraph Styles Editing Voice Sensitivity Appendix A - Equipment List Machine Type Operators to Run Machine Process Bread Conveyor Dough Conveyor Dough Divider Folder/Molder Mixer Kneader Oven Packaging/Bagger Proofer Sieving Machine Slicer Output per Hour (in Capital Cost loaves) per Machine 6,000 $20,000 9,000 $20,000 2,000 $43,000 1,000 $47,000 1,000 $28,000 20,000 $200,000 3,600 $27,000 BODO $23,000 2,000 $35,000 3,600 $23,000 1 1 1 1 1 1 4 1 2 2 Appendix B-Price and Costs per Loaf Sale Price Variable Labour Costs (wages, benefits, overtime, vacation, etc.) Variable Material Costs (plastic bags, cartons, etc.) $1.25 $0.75 SOP5 per loaf per loaf per loaf Appendix C - Bread Making Process Flowchart th Canada D'Focus ES O W do ENG 5 8 Factory Assignment 20200703 - Saved to this PC- o search ne References Mailings Review View Help AO ALT A- AaBbced AaBDCD AaBbc AaBbcc AaB T Normal 1 No Spac... Heading 1 Heading 2 Title Find - Replace Select Paragraph Styles - 2 - Editing 6 TIUVICI Sieving Machine Slicer vou 2,000 YZU, $35,000 $23,000 2 3,600 2 Appendix B-Price and Costs per Loaf Sale Price Variable Labour Costs (wages, benefits, overtime, vacation, etc.) Variable Material Costs (plastic bags cartons, etc.) $1.25 $0.75 $0.25 per loaf per loaf per loaf Appendix C-Bread Making Process Flowchart Sieving > Kneading Dividing Proofing Molding > Conveying Baking Conveying Slicing Bagging D Focus Ba Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra Layout References Mailings Review View Help Sh SALT A Aa A - A-D-A- AaBbcc Aabbcc AaBbc Aabbcc AaB 1 Normal 11 No Spac... Heading 1 Heading 2 Title Find - Replace Select- Dictate Sensitivity 5 Paragraph Styles Editing Voice Sensitivity Problem 1: if the factory only has capacity for 50 machines, how many machines of each type should be installed to maximize the number of loaves produced per hour for the commercial bread bakery? Use the data provided in Appendix A to calculate your solution. Please show your work and insert your results in the table below. (5 Marks) If you use Excel, provide the Excel file with your submission. For those of you who want the challenge, consider learning and using the Excel add-in "Solver" for this problem (using Solver is not required). Machine Type Number of Machines Sieving Machine Mixer/Kneader Dough Divider Proofer Folder/Molder Dough Conveyor Oven Packaging/Bagger Bread Conveyor Slicer Total Machines D Focus BE Canada ENC O w Sa o 5 6 7 8 9 2 E R Bread Factory Assignment 20200703 - Saved to this PC- neha gn Layout References Mailings Review View Help - A A Aa- Po E ALT * A-D-A-D- | T Normal I No Spac... Heading Heading 2 Find Replace Select Title ht Paragraph Styles Editing 2 Problem 2: If Weston's had the room to buy additional machines which two machines should they purchase. Using the Break-Even Analysis with the data found in Appendix A and Appendix B, calculate how many units and how many sales dollars will it take to pay for the new machinery. (6 marks) Provide your recommendations of which type of machine and how many should Weston's Bakery purchase. Provide your explanation and justification for your recommendation. Be careful to recommend only the machines that are needed, this is not necessarily those with the lowest breakeven point. (4 marks) Please show your work. If you use Excel, provide the Excel file with your submission Machine Type Breakeven (in units) Breakeven in dollars) Bread Conveyor Dough Conveyor Dough Divider Folder/Molder Mixer/Kneader Oven Packaging/Bagger Proofer Sieving Machine Slicer glish (Canada) Focus ch 0 w V Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra ND sign Layout References Mailings Review View Help IT Find - A A Aa- PoE- EE A * A-D-A ---- AaBbced AaBbCcDc AaBbci AaBbcc AaB 11 Normal 11 No Spac.. Heading 1 Heading 2 Title Replace Select Dictate Sens ant Paragraph Styles Editing Voice Sens 5. Problem 3: Design the optimal layout of the factory to have the most efficient flow of material and people though it. Copy and paste the machine card and building infrastructure blocks from Appendix D onto the factory plan found in Appendix E. One card will represent the number of the machines needed for that process In Appendix Cis a flow chart of the process simplified and your can watch the process capture in the very first "How its Made" episode found at this link, https://www.youtube.com/watch?v=BUUWWWACA. When laying out the factory, consider the process and place the cards and blocks carefully according to needs of the factory and its processes. Use only one card to represent the process regardless of the number of machines you will need, for example, 1 Proofer card may represent 4 Proofer machines Please do not change the size of the cards and blocks. (6 marks) Below, share what you considered and the logic you applied as to the placement of the cards and blocks. 4 marks) lish Canada Focus ch O W 5 & Bread Factory Assignment 20200703 - Saved to this PC- neha dhingra ND Layout References Mailings Review View Help Share - - ALT - A Aa- Po 2A-D-A- AaBbcc Aabbcc AaBb AaBbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Find - Replace Select Title Dictate Sensitivity Paragraph Styles Editing Voice Sensitivity Appendix A - Equipment List Machine Type Operators to Run Machine Process Bread Conveyor Dough Conveyor Dough Divider Folder/Molder Mixer Kneader Oven Packaging/Bagger Proofer Sieving Machine Slicer Output per Hour (in Capital Cost loaves) per Machine 6,000 $20,000 9,000 $20,000 2,000 $43,000 1,000 $47,000 1,000 $28,000 20,000 $200,000 3,600 $27,000 BODO $23,000 2,000 $35,000 3,600 $23,000 1 1 1 1 1 1 4 1 2 2 Appendix B-Price and Costs per Loaf Sale Price Variable Labour Costs (wages, benefits, overtime, vacation, etc.) Variable Material Costs (plastic bags, cartons, etc.) $1.25 $0.75 SOP5 per loaf per loaf per loaf Appendix C - Bread Making Process Flowchart th Canada D'Focus ES O W do ENG 5 8 Factory Assignment 20200703 - Saved to this PC- o search ne References Mailings Review View Help AO ALT A- AaBbced AaBDCD AaBbc AaBbcc AaB T Normal 1 No Spac... Heading 1 Heading 2 Title Find - Replace Select Paragraph Styles - 2 - Editing 6 TIUVICI Sieving Machine Slicer vou 2,000 YZU, $35,000 $23,000 2 3,600 2 Appendix B-Price and Costs per Loaf Sale Price Variable Labour Costs (wages, benefits, overtime, vacation, etc.) Variable Material Costs (plastic bags cartons, etc.) $1.25 $0.75 $0.25 per loaf per loaf per loaf Appendix C-Bread Making Process Flowchart Sieving > Kneading Dividing Proofing Molding > Conveying Baking Conveying Slicing Bagging D Focus Ba