11. Excercise_template_ENG_EXAM Excel File Edit View Insert Format Tools Data Window Help @s. Home Insert Draw Page Layout Formulas Data Review View X Cut Calibrl (Body) 11 AA- B A. Format Wap Text General Copy Merge & Centre G21 G H International Business Planning Name Short Name Namely Production factory indirect costs FIND Raiolan etimas Production factory Director Rallisia Adminitative Direct Costs ADMD Administracija Tema Administrative inrect Costs ADM ALL Administracija neticama You just took a position of junior fast in the Me holding that consist of semi-independent Business Units (each Bu has own management, nevertheless is same entity is order to get into the business, you received a tak to calculate a Cost Price of the Newspapers b) Ful Cost Price of Newpages Price of New papers in cost-plus pricing the di How would you use orice descrimination in order to maximize your sales? Caleviate indicates: Gross Pront & Gross Profit Marin -Operating Pot & EBIT, Net Profa & Net Proft Murg For simplicity renons we assume that interest rates are from Turnover per year, Advertising & Promotions contre feed 100 000 eur per year per Business unit. Transportation costs are 0.023 EUR/Unit We assume that company well 1300 units of newspaper year. Alable Salaries Country General Commer Marketing Finance Finance Lorem HR Mana Productio Productio Workers Cleaning Cleaning Sales Man 10 11 12 13 14 17 18 19 Transport Mans Company Business 21 22 23 24 Media Holding Newspapers comme TV units.al Equipmen 25 26 Price TurnoverNet Sales Computer Forklift Machinere Main 27 28 29 30 31 32 factory Factory Physical distribution Cost of Sales Cos per unit Grow Profit Net Sales COS! Comunid internet CostPrice task + O 26 Excel File Edit View Insert Format Tools Data Window Help 11. Excercise_template_ENG_EXAM_for_ Review Formulas Data Home Insert View Draw Page Layout Calibrl (Body) 11 XO Wrap Text General Copy Paste B 1 U Merge & Centre Format G21 fx C D 32 33 34 35 36 37 38 39 Premier Factory Officerent Faciliteter Raw materia Paper link Water Glue 40 41 44 E-commerce TV Gross Profit Net Sales.co Research and development Advertising Promotion Selling General Administrative per Operating Profit ITEN Gross Profit Morgan interest Corporate income Tax Net Pro Net Praft Maren rull Cost Prica Factory Co Dinco Salaries Insurance Row material Eolament Carporate Events Communication Indirect costs Slaves Cars invece Equipment Corporate Events Communication Premis 46 68 49 SO 51 52 54 55 SE 57 58 59 60 61 62 SGAA Direce Docs 64 65 66 67 Solid rece Cors Eguren Corporate Connon CostPrice task 26 Excel File Edit View Insert Format Tools Data Window Help 11. Excercise_template_ENG_EX Home Draw Page Layout Formulas Data Review View Insert Cut Calibri (Body) 11 . Wrap Text General Copy Paste 8 I U E33 Format % Merge & Centre G21 fx F G 54 55 S6 57 Salaries Cors rance quiment Corporate Events Communication Premier 62 SGEA Derivano 8308333CE SREB Salaries Inc Cars Ement Corporate Events Communication Alleated Company Costs Total Company Sales Cars 24 25 78 77 71 79 00 Corporate Event Camareti Premes Bu At we do not have about other tower,heally located costus Atacadut HUE Casti Product Price Couples Cost Price O 26 Inil Merge & Centre % ) 20 00 00 .0 Conditional Format Cell Formatting as Table Styles Inso Skal komentar 31 inch winess in alt in each Business Unit 512 in eachines Unit 62 Busine Unit Available data Salaries County General Director General Director of Business Unit Comercial Director of Marketing Manager of Finance Controller er bu Finance Director Logisticmager HR Manager Production Director Production site Workerulegarters/Editors Osning personnel on factory Cleanine personnel in the ottie Sales Manares 300 000 per year 75.00 per your so per year 400 per year 3500 per year 80000 Dryer 3500 per yer 200 per year 5000 per year 20000 per year 10000 per yer 2000 per year 700 per year 20000 per 1 1 1 1575 2 in each reu Transport Manarament card Company car B Trips only for directions 700 per per month 60 per month socorary common butpat Equipment Irene Computers For per compet/perfor soojemple managers so per month Total investment 10 years 1000000 depreciation 20000 Machineries Mas madinare Communication internet TV 10000 esinduded in rent Premios: Factory rent Dieren Folies Electricity/heating watel 2500 per month 10000 per month 1500 per month lotice Raw materials paper 10 per 5000 unit 300 per 20000 units S per 1000 units 20 10000 nits Water ... A P 11. Excercise_template_ENG_EXAM Excel File Edit View Insert Format Tools Data Window Help @s. Home Insert Draw Page Layout Formulas Data Review View X Cut Calibrl (Body) 11 AA- B A. Format Wap Text General Copy Merge & Centre G21 G H International Business Planning Name Short Name Namely Production factory indirect costs FIND Raiolan etimas Production factory Director Rallisia Adminitative Direct Costs ADMD Administracija Tema Administrative inrect Costs ADM ALL Administracija neticama You just took a position of junior fast in the Me holding that consist of semi-independent Business Units (each Bu has own management, nevertheless is same entity is order to get into the business, you received a tak to calculate a Cost Price of the Newspapers b) Ful Cost Price of Newpages Price of New papers in cost-plus pricing the di How would you use orice descrimination in order to maximize your sales? Caleviate indicates: Gross Pront & Gross Profit Marin -Operating Pot & EBIT, Net Profa & Net Proft Murg For simplicity renons we assume that interest rates are from Turnover per year, Advertising & Promotions contre feed 100 000 eur per year per Business unit. Transportation costs are 0.023 EUR/Unit We assume that company well 1300 units of newspaper year. Alable Salaries Country General Commer Marketing Finance Finance Lorem HR Mana Productio Productio Workers Cleaning Cleaning Sales Man 10 11 12 13 14 17 18 19 Transport Mans Company Business 21 22 23 24 Media Holding Newspapers comme TV units.al Equipmen 25 26 Price TurnoverNet Sales Computer Forklift Machinere Main 27 28 29 30 31 32 factory Factory Physical distribution Cost of Sales Cos per unit Grow Profit Net Sales COS! Comunid internet CostPrice task + O 26 Excel File Edit View Insert Format Tools Data Window Help 11. Excercise_template_ENG_EXAM_for_ Review Formulas Data Home Insert View Draw Page Layout Calibrl (Body) 11 XO Wrap Text General Copy Paste B 1 U Merge & Centre Format G21 fx C D 32 33 34 35 36 37 38 39 Premier Factory Officerent Faciliteter Raw materia Paper link Water Glue 40 41 44 E-commerce TV Gross Profit Net Sales.co Research and development Advertising Promotion Selling General Administrative per Operating Profit ITEN Gross Profit Morgan interest Corporate income Tax Net Pro Net Praft Maren rull Cost Prica Factory Co Dinco Salaries Insurance Row material Eolament Carporate Events Communication Indirect costs Slaves Cars invece Equipment Corporate Events Communication Premis 46 68 49 SO 51 52 54 55 SE 57 58 59 60 61 62 SGAA Direce Docs 64 65 66 67 Solid rece Cors Eguren Corporate Connon CostPrice task 26 Excel File Edit View Insert Format Tools Data Window Help 11. Excercise_template_ENG_EX Home Draw Page Layout Formulas Data Review View Insert Cut Calibri (Body) 11 . Wrap Text General Copy Paste 8 I U E33 Format % Merge & Centre G21 fx F G 54 55 S6 57 Salaries Cors rance quiment Corporate Events Communication Premier 62 SGEA Derivano 8308333CE SREB Salaries Inc Cars Ement Corporate Events Communication Alleated Company Costs Total Company Sales Cars 24 25 78 77 71 79 00 Corporate Event Camareti Premes Bu At we do not have about other tower,heally located costus Atacadut HUE Casti Product Price Couples Cost Price O 26 Inil Merge & Centre % ) 20 00 00 .0 Conditional Format Cell Formatting as Table Styles Inso Skal komentar 31 inch winess in alt in each Business Unit 512 in eachines Unit 62 Busine Unit Available data Salaries County General Director General Director of Business Unit Comercial Director of Marketing Manager of Finance Controller er bu Finance Director Logisticmager HR Manager Production Director Production site Workerulegarters/Editors Osning personnel on factory Cleanine personnel in the ottie Sales Manares 300 000 per year 75.00 per your so per year 400 per year 3500 per year 80000 Dryer 3500 per yer 200 per year 5000 per year 20000 per year 10000 per yer 2000 per year 700 per year 20000 per 1 1 1 1575 2 in each reu Transport Manarament card Company car B Trips only for directions 700 per per month 60 per month socorary common butpat Equipment Irene Computers For per compet/perfor soojemple managers so per month Total investment 10 years 1000000 depreciation 20000 Machineries Mas madinare Communication internet TV 10000 esinduded in rent Premios: Factory rent Dieren Folies Electricity/heating watel 2500 per month 10000 per month 1500 per month lotice Raw materials paper 10 per 5000 unit 300 per 20000 units S per 1000 units 20 10000 nits Water ... A P