please complete complete both question number one and question number two. And calculate these numbers into excel.

You work as a supply chain manager for Primo Caf Inc. Primo Caf is a small-sizec llianufacturer of stylish coffee makers. The company has three distinct coffee makers that it produces. The Bean Boiler is Primo Cafe's most basic model. The main materials used in manufacturing the Bean Boiler are aluminum and plastic. There are lots of suppliers for these materials. At present, Primo Cafe's total cost for producing a Bean Boiler is $13 per unit and the prodwit is competitively priced at $20 per unit. There are lots of other coffee makers that are very similar to the Be3n Bolier on the market. Still, sales of the Bean Boiler are very stable. The company reliably sells 24,625 to 25,375 units of this product per month. The Eamily Man is Primo Caf's mid-market offering. Primo Cafe manufactures most of the Family Man in-house, but buys the glass pot and the electronics that control the on/off function and the timer. At present, final assembly of the inhouse manufactured parts and the purchased sub-components occurs at Primo Caf's facility in Grand Rapids. Totai cost for producing the Family Man is currently $32 per unit and each unit is sold for \$34.99. The Family Man's sleek, artistic design and range of unique colors helps to distinguish it from a wide selection of similar products offered by competitors. Prices for direct competitors range from $25 to $45. Sales of the Family Man range from 19,400 to 20,600 units per month. The Caffissime is Primo Cafe's high-end offering. Primo Caf produces the external casing for the Caffissimo in-house, but buys all.of the important subcomponents from external suppliers. The most important sub-components for the Caffissimo are the gauges that regulate the temperature and pressure of the water as it is forced through the coffee grounds. The proper working of these gauges ensure that the Caffissimo produces a perfect cup of coffee at brewing. The Caffissimo's design is a closely held company secret. The machine has won industry awards both in terms of its coffee making process and its external looks. Currently, the Caffissime costs $375 to produce and sells for 5600. Because of the relatively high price and unique design, demand for the Caffissimo is difficult to predict. Over the past year, demand has ranged from 8,500 to 11,500 units per month. QUESTION \#4 - Foreign Exchange Rate Primo Caf has long relationship with Techno-Gadgets Limited to produce the temperature and pressure gauges that go into the Caffissimo. However, Techno-Gadgets recently underwent gir ownershig change and since then, the quality of their products has declined. Elise, Primg's CEO and founder, is in negotiations with Techno-Gadgets to resolve the issue, but, in the meantime, you have been tasked with looking for new potential suppliers. Your search has led you to two overseas companies: Kyoto Jechtepics inc. and Aleseyte. Engineering GmbH. Kyoto Tectonics inc. is located in Japan and quotes you a price of 1,600(1,600 Japanese Yen) per gauge. Alleseute. Engineering GmbH is located in Germany and quotes you a price of 618.00 (18 Euro) per gauge. In order to help determine which company has the best cost structure, you have collected the following information. - Current USD/JPY exchange rate: $1=110 - Expected USD/JPY exchange rate in six months: $1=90 - Current USD/EUR exchange rate: $1=60.80 - Expected USD/EUR exchange rate in six months: $1=110 Marco wants to move quickly and lock up a contract with Alleseute, Engineering immediately. Elise is inclined to give Techno-Gadgets six months to resolve its issues. At that point, she is interested in inking a deal with Kyoto Tectonics. Apply exchange rate calculations as presented in class to complete the question below. Complete all caiculations in the excel file that you will upload with your exam. 1. Calculate the current and future total cost for each supplier in USD. 2. Marco wants a recommendation on what Primo Cat should do. Given the information above and what you know about the product you are sourcing - what would you recommend? Why? \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Allesgute Engineering } \\ \hline Current & Future \\ \hline & \\ \hline & \\ \hline \end{tabular} You work as a supply chain manager for Primo Caf Inc. Primo Caf is a small-sizec llianufacturer of stylish coffee makers. The company has three distinct coffee makers that it produces. The Bean Boiler is Primo Cafe's most basic model. The main materials used in manufacturing the Bean Boiler are aluminum and plastic. There are lots of suppliers for these materials. At present, Primo Cafe's total cost for producing a Bean Boiler is $13 per unit and the prodwit is competitively priced at $20 per unit. There are lots of other coffee makers that are very similar to the Be3n Bolier on the market. Still, sales of the Bean Boiler are very stable. The company reliably sells 24,625 to 25,375 units of this product per month. The Eamily Man is Primo Caf's mid-market offering. Primo Cafe manufactures most of the Family Man in-house, but buys the glass pot and the electronics that control the on/off function and the timer. At present, final assembly of the inhouse manufactured parts and the purchased sub-components occurs at Primo Caf's facility in Grand Rapids. Totai cost for producing the Family Man is currently $32 per unit and each unit is sold for \$34.99. The Family Man's sleek, artistic design and range of unique colors helps to distinguish it from a wide selection of similar products offered by competitors. Prices for direct competitors range from $25 to $45. Sales of the Family Man range from 19,400 to 20,600 units per month. The Caffissime is Primo Cafe's high-end offering. Primo Caf produces the external casing for the Caffissimo in-house, but buys all.of the important subcomponents from external suppliers. The most important sub-components for the Caffissimo are the gauges that regulate the temperature and pressure of the water as it is forced through the coffee grounds. The proper working of these gauges ensure that the Caffissimo produces a perfect cup of coffee at brewing. The Caffissimo's design is a closely held company secret. The machine has won industry awards both in terms of its coffee making process and its external looks. Currently, the Caffissime costs $375 to produce and sells for 5600. Because of the relatively high price and unique design, demand for the Caffissimo is difficult to predict. Over the past year, demand has ranged from 8,500 to 11,500 units per month. QUESTION \#4 - Foreign Exchange Rate Primo Caf has long relationship with Techno-Gadgets Limited to produce the temperature and pressure gauges that go into the Caffissimo. However, Techno-Gadgets recently underwent gir ownershig change and since then, the quality of their products has declined. Elise, Primg's CEO and founder, is in negotiations with Techno-Gadgets to resolve the issue, but, in the meantime, you have been tasked with looking for new potential suppliers. Your search has led you to two overseas companies: Kyoto Jechtepics inc. and Aleseyte. Engineering GmbH. Kyoto Tectonics inc. is located in Japan and quotes you a price of 1,600(1,600 Japanese Yen) per gauge. Alleseute. Engineering GmbH is located in Germany and quotes you a price of 618.00 (18 Euro) per gauge. In order to help determine which company has the best cost structure, you have collected the following information. - Current USD/JPY exchange rate: $1=110 - Expected USD/JPY exchange rate in six months: $1=90 - Current USD/EUR exchange rate: $1=60.80 - Expected USD/EUR exchange rate in six months: $1=110 Marco wants to move quickly and lock up a contract with Alleseute, Engineering immediately. Elise is inclined to give Techno-Gadgets six months to resolve its issues. At that point, she is interested in inking a deal with Kyoto Tectonics. Apply exchange rate calculations as presented in class to complete the question below. Complete all caiculations in the excel file that you will upload with your exam. 1. Calculate the current and future total cost for each supplier in USD. 2. Marco wants a recommendation on what Primo Cat should do. Given the information above and what you know about the product you are sourcing - what would you recommend? Why? \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Allesgute Engineering } \\ \hline Current & Future \\ \hline & \\ \hline & \\ \hline \end{tabular}