Entry Mode and Pricing

with the number set up, please fill in the excel sheet and show working

\begin{tabular}{|l|c|c|c|} \hline Cost of production & 4 & 4 & 4 \\ \hline & Domestic & \begin{tabular}{r} Mode A: \\ Foreign \\ Importer \\ Retailer \end{tabular} & \begin{tabular}{r} Modeign \\ Importer \\ Wholesaler \\ Retailer \end{tabular} \\ \hline Piccolo (Ex-factory) 100\% margin & 9.50 & 9.50 & 9.50 \\ \hline Tariff, Insurance \& Shipping Costs (18\%) & & & \\ \hline Importer pays (cost) & & & \\ \hline Importer's Mark-up (15\% of cost) & & & \\ \hline Wholesaler pays (cost) & & & \\ \hline Wholesaler's Mark-up (15\% of cost) & & & \\ \hline Retailer pays (cost) & & & \\ \hline Retailer's Mark-up (15\% of cost) & & & \\ \hline Consumer Price (with VAT 20\% in UK, 20\% in & & & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|} \hline Cost of production & 4 & 4 & 4 \\ \hline & Domestic & \begin{tabular}{r} Mode A: \\ Foreign \\ Importer \\ Retailer \end{tabular} & \begin{tabular}{r} Modeign \\ Importer \\ Wholesaler \\ Retailer \end{tabular} \\ \hline Piccolo (Ex-factory) 100\% margin & 9.50 & 9.50 & 9.50 \\ \hline Tariff, Insurance \& Shipping Costs (18\%) & & & \\ \hline Importer pays (cost) & & & \\ \hline Importer's Mark-up (15\% of cost) & & & \\ \hline Wholesaler pays (cost) & & & \\ \hline Wholesaler's Mark-up (15\% of cost) & & & \\ \hline Retailer pays (cost) & & & \\ \hline Retailer's Mark-up (15\% of cost) & & & \\ \hline Consumer Price (with VAT 20\% in UK, 20\% in & & & \\ \hline \end{tabular}