BSBITU402 develope and use complex spreadsheets task 4 ( advance diploma in hospitality msnagment)

Assignment 1 1. Prepare a spreadsheet with the data in the previous table. 2. Present the spreadsheet in a format and presentation standard that you could use in a report to your manager rather than just a document for your own use. (It should look good and be easy to read). 3. Use zebra stripes to help make the data easier to read. 4. For headings and subheadings, use white text in a coloured cell. Dewlop and use wmples spreadsheets Version I.l March 24\"! 0 Training Resource Solutions Ill}I Ltd target-squirm BSBITU402 Develop and use complex spreadsheets l Assignment 2 Use the sample data provided in the scenario to create and present the following charts with the appropriate titles and labels. 1. A column chart of daily small parcel standard delivery data for the whole month. 2. A pie chart with total data of standard shipping and express shipping data. 3. A line chart with all six sets of data for the month. Assignment 3 Use the sample data provided in the scenario to determine the parcel quantities. Each delivery costs the business: small parcel $12.191 large parcel $15.20, documents $8.50, all for standard shipping. '2' Express shipping costs are an extra 30% on top of the standard shipping cost. '2' Customers are charged an extra 40% as a prot margin. Use the spreadsheet to calculate the total cost per day of the deliveries (to the business}, the total amount charged to the customers, the value of prot each day and monthly totals for the data. 0