1. The company has been sourcing and importing its coffee beans from Brazil and Columbia. However, with increasing exports, the market has increasingly become competitive. Some of the company's managers recently travelled to some South East Asian countries for a holiday and discovered that the Asian coffee is equally high quality and appealing. Based on their report, the management wants to develop a coffee pricing model for importing coffee beans from two Asian countries - Vietnam and Indonesia. Consider the following information; Current Import per year Approximately 260 kg of Coffee Beans per year; imported from Brazil Total landed cost in Australia (Approx.) $18.75 per kg Bean's Coffee's wholesale 25% margin Wholesale price $25 per kg plus GST Retail price $29 per kg inclusive of GST By importing coffee beans from Vietnam, the company aims to set their Retail Price at $22.95 per KG. Traders in Vietnam and Indonesia have quoted prices of AUD $8.80 and $7.90 respectively. Assuming the that the sea freight rate is approximately $4 per kg coffee bean bag from Vietnam and $2.80from Indonesia, and the import duty at 5%, design spreadsheets that can provide a clear shipping port to the market pricing structures based on both the markets. Create appropriate formulas and format cells that shows a sequential/stepped calculation of prices from supplier to retail including company's margins, wholesale and retail prices. This spreadsheet will be presented to the management. Ensure that you follow the style guide and organisational requirements as described in Assessment Task 1. Consult with your trainer/assessor (Manager roleplay) to confirm and clarify the tasks and templates