Design and Develop Complex Spreadsheets – Business Strategies

Case Study Essay:Mental Health – Nursing Assignment
September 10, 2019
Nursing Process applied to a Family – Nursing Assignment
September 10, 2019

Design and Develop Complex Spreadsheets – Business Strategies

Internal Code: MAS4133 Business Strategies Assignment Help Questions: Question 1:  Ms McGee requires you to design and prepare a template to use as an invoice to send to all customers who have booked tours with them. The company logo is required to be inserted. The template is to contain basic formulas. Question 2: You are to prepare invoices for those customers whose details are contained in the file CUSTOMERS. By entering the Account No, you should have the name and address of the customer appear. Each invoice is to be prepared on a separate sheet and the sheet is to be renamed each customer surname. Prepare invoices using linking and formulas (including VLOOKUP formulas) as follows: Question 3: You are required to set up a workbook which will record the commissions received by each of the two travel consultants employed by Tours R Us. Each consultant will be on a separate sheet, appropriately named. You are required to show the total quarterly sales and commission of each tour, together with the total sales and total commission received. On a separate sheet you are required to show the total quarterly sales for each consultant together with the total commission they received. Each consultant is expected to bring in over $120,000 worth of sales each quarter. Insert a formula which will give the reading ‘Target Met’ or ‘Target Not Met’ under each quarter. Question 4: You are to prepare a suitable chart showing each consultant’s quarterly sales figures. This chart is to be on a separate sheet and needs to be clearly labelled and formatted according to the company’s Style Guide. 38 total views, 3 views today


   

 

Leave a Reply

Your email address will not be published. Required fields are marked *