please assist using excel

Instructions: 1. All questions have to be answered using Microsoft Excel. 2. Create a single workbook with a separate worksheet for each question. 3. When you are done, save the workbook in the following format: Student number EBIAC3A Test 2 Opp 2 4. Submit your Test 2 answer sheet in Microsoft Excel format on VUTela. Question 1 (10) The See King Hotel's sales forecast for the next quarter, ending December 31st, indicates the following: Product Expected Sales Snapper 2,000 units Shrimp 3,500 units Calamari 5,200 units Inventories at the beginning, and desired quantities at the end of the quarter are as follows: Product October 1st December 31st Snapper 580 units 250 units Shrimp 160 units 150 units Calamari 130 units 180 units Draw up a Production budget in units for next quarter. Question 2 (15) The management of Yenza Ltd has received quotations on a new machine for one of its production departments. The cost price of the machine is R320,000 and the company's minimum required rate of return on investments is 14%. The following projected cash income figures have been compiled: End of Year 1 R75,000 End of Year 2 R87,000 End of Year 3 R75,000 End of Year 4 R62,000 Rago