i Normal 1 No Spac... Heading 1 Heading 2 Title Font Paragraph 1.1.1.2.1.3.1.4.1.5.1 8.9.1. 10.11.1 Styles 13.1.14.1 12. 15.1.16 17.1.18.1.19 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 earch linal Paragraph Styles 200452GB1001100120 1400 1516 JCI . I No Spac... Heading Heading 2 Title Find Replace Select Dictate Editing Voice Appendix A - Equipment List Machine Type Operators to Run Machine Process 1 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 8,000 $23,000 2,000 $35,000 3,600 $23,000 1 1 1 1 1 4 1 2 2 Appendix B - Price and Costs per Loaf C Focus DO E BI i Normal 1 No Spac... Heading 1 Heading 2 Title Font Paragraph 1.1.1.2.1.3.1.4.1.5.1 8.9.1. 10.11.1 Styles 13.1.14.1 12. 15.1.16 17.1.18.1.19 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 earch linal Paragraph Styles 200452GB1001100120 1400 1516 JCI . I No Spac... Heading Heading 2 Title Find Replace Select Dictate Editing Voice Appendix A - Equipment List Machine Type Operators to Run Machine Process 1 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 8,000 $23,000 2,000 $35,000 3,600 $23,000 1 1 1 1 1 4 1 2 2 Appendix B - Price and Costs per Loaf C Focus DO E BI