Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
For business Midterm Assessment Task brief & rubrics Task The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2
For business Midterm Assessment Task brief & rubrics Task The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the computational questions but evaluate application of theory. . In the computational part, you are asked to apply the calculations and knowledge of spreadsheets studied in class to the scenarios provided. In the written part, make reference to the theory studied in class and provide examples to support your points. You must upload the written answers and the spreadsheet via Turn-it-in. Save your documents with the filename: Axcccxx (where xocoo is your last name) (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.) Questions: (Each question is 20% of the assignment) Part One 1 in the table below are the euro-dollar exchange rates for the first ten days of September 2018. The data shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline. USD 10/09/2018 1,0971 09/09/2018 1,1026 08/09/2018 1,0835 07/09/2018 1,0695 06/09/2018 1,0653 05/09/2018 1,0422 04/09/2018 1,0247 03/09/2018 1,0361 02/09/2016 1,0132 01/09/2018 1,0060 2. Your company manufactures and exports electric generators. The table below shows a series of models and their price in Euros. Create the table in excel. Insert the dollar rate on the 01/09/2018 In the cell below "Dollar rate". Create a formula that allows you to see all the prices of the models in dollars; If the dollar rate changes, the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 10/09/2018. 3 In the column marked difference, show the difference in dollars between the two dates. Date Date Dollar rate Dollar rate Model Price in dollars Difference Price in dollars 300 VRG 625 RTM 475 GRM 200 GRM 650 MTY 600 RTM 500 MTY Price in euros 46900 66700 96100 122600 164900 214400 247300 Part two 4 Create a memo in Word. Comment on the trend shown in question 1 above. During the first 5 days, was the euro rising or falling? And during those 10 days? 5. Most of your exports to the US belong to the model 600 RTM. The experience shows that if the price of this product rises over 215000 dollars, the exported units will be reduced. If this product is priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your company's exports? For business Midterm Assessment Task brief & rubrics Task The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the computational questions but evaluate application of theory. . In the computational part, you are asked to apply the calculations and knowledge of spreadsheets studied in class to the scenarios provided. In the written part, make reference to the theory studied in class and provide examples to support your points. You must upload the written answers and the spreadsheet via Turn-it-in. Save your documents with the filename: Axcccxx (where xocoo is your last name) (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.) Questions: (Each question is 20% of the assignment) Part One 1 in the table below are the euro-dollar exchange rates for the first ten days of September 2018. The data shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline. USD 10/09/2018 1,0971 09/09/2018 1,1026 08/09/2018 1,0835 07/09/2018 1,0695 06/09/2018 1,0653 05/09/2018 1,0422 04/09/2018 1,0247 03/09/2018 1,0361 02/09/2016 1,0132 01/09/2018 1,0060 2. Your company manufactures and exports electric generators. The table below shows a series of models and their price in Euros. Create the table in excel. Insert the dollar rate on the 01/09/2018 In the cell below "Dollar rate". Create a formula that allows you to see all the prices of the models in dollars; If the dollar rate changes, the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 10/09/2018. 3 In the column marked difference, show the difference in dollars between the two dates. Date Date Dollar rate Dollar rate Model Price in dollars Difference Price in dollars 300 VRG 625 RTM 475 GRM 200 GRM 650 MTY 600 RTM 500 MTY Price in euros 46900 66700 96100 122600 164900 214400 247300 Part two 4 Create a memo in Word. Comment on the trend shown in question 1 above. During the first 5 days, was the euro rising or falling? And during those 10 days? 5. Most of your exports to the US belong to the model 600 RTM. The experience shows that if the price of this product rises over 215000 dollars, the exported units will be reduced. If this product is priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your company's exports
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started