Please write the answers for all the questions and upload on Blackboard. You can use the Intternet to research and find answers. Problem 1 Before you do this In-Class Exercise: You should have read Chapter 3.3 and 3.4 You should have completed all the modules in Unit 1 Online Use the template: Template 1 Consider a new business venture, a small store selling refurbished laptops for students on Wabash Avenue. Devise an information Systems strategy for the business. Do a simple SWOT analysis - Start with Porter's Five Forces to analyze industry structure - Determine a competitive strategy based on your SWOT analysis and Porter's Five Forces - Draw the Value Chain for the business - Establish and draw a business process to sell refurbished laptops - Determine the information Systems required by the business process to fit your competitive strategy Problem 2 This problem should be solved using Excel. Vietnam Clothing Corporation (VCC), based in Hanoi, supply shirts and other logo items for many Colleges and Universities in USA and Western Europe. You are a Management Consultant hired to decide the best strategy for their sales and inventory using an application of your choice. You have: decided to use Microsoft Excel as your choice of application. You need to create an Eacel Model and complete a Scenario Analysis. Using the Excel Model that you have created, decide on the best strategy from three following scenarios that brings in the most profits for VCC. Use the data from "OCE 1 Data.xslx". Scenorio 1: What are the Costs, Revenues, and Profits of each Clothing Description and Grand Total (Format the answers in $ with two decimal places). Scenorio 2: If Ending inventory is less than or equal to 1 or Units Sold >35, increase basic scenario's Sale Price by $2. What are the Revenues, and Profits of each Clothing Description and Grand Total (format the answers in $ with two decimal places)? Scenario 3: If Shipping costs (shown as a tabie) are added using VLoOkup function and assuming Scenario 1, what are the Revenues, and Profits of each Clothing Description and Grand Total (Format the answers in $ with two decimal places). Problem 3 Read the Case Study: Is Time Running Out for Bed Bath \& Beyond? from the book and answer the questions below. The answer should be very detailed and not in a few sentences.: 3-13 Analyze Bed Bath \& Beyond using the competitive forces and value chain models. 3-14 Define the problem faced by Bed Bath \& Beyond? What management, organization, and technology factors contributed to the problem? 3-15 Evaluate the solution Bed Bath \& Beyond is trying to implement. Will it be effective? Why or why not? Please write the answers for all the questions and upload on Blackboard. You can use the Intternet to research and find answers. Problem 1 Before you do this In-Class Exercise: You should have read Chapter 3.3 and 3.4 You should have completed all the modules in Unit 1 Online Use the template: Template 1 Consider a new business venture, a small store selling refurbished laptops for students on Wabash Avenue. Devise an information Systems strategy for the business. Do a simple SWOT analysis - Start with Porter's Five Forces to analyze industry structure - Determine a competitive strategy based on your SWOT analysis and Porter's Five Forces - Draw the Value Chain for the business - Establish and draw a business process to sell refurbished laptops - Determine the information Systems required by the business process to fit your competitive strategy Problem 2 This problem should be solved using Excel. Vietnam Clothing Corporation (VCC), based in Hanoi, supply shirts and other logo items for many Colleges and Universities in USA and Western Europe. You are a Management Consultant hired to decide the best strategy for their sales and inventory using an application of your choice. You have: decided to use Microsoft Excel as your choice of application. You need to create an Eacel Model and complete a Scenario Analysis. Using the Excel Model that you have created, decide on the best strategy from three following scenarios that brings in the most profits for VCC. Use the data from "OCE 1 Data.xslx". Scenorio 1: What are the Costs, Revenues, and Profits of each Clothing Description and Grand Total (Format the answers in $ with two decimal places). Scenorio 2: If Ending inventory is less than or equal to 1 or Units Sold >35, increase basic scenario's Sale Price by $2. What are the Revenues, and Profits of each Clothing Description and Grand Total (format the answers in $ with two decimal places)? Scenario 3: If Shipping costs (shown as a tabie) are added using VLoOkup function and assuming Scenario 1, what are the Revenues, and Profits of each Clothing Description and Grand Total (Format the answers in $ with two decimal places). Problem 3 Read the Case Study: Is Time Running Out for Bed Bath \& Beyond? from the book and answer the questions below. The answer should be very detailed and not in a few sentences.: 3-13 Analyze Bed Bath \& Beyond using the competitive forces and value chain models. 3-14 Define the problem faced by Bed Bath \& Beyond? What management, organization, and technology factors contributed to the problem? 3-15 Evaluate the solution Bed Bath \& Beyond is trying to implement. Will it be effective? Why or why not