cpt_109_midterm-solution

cpt_109_midterm-solution - Automatic Date This is a summary...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Automatic Date This is a summary of BOS1 Excel Automatic Filename Autumn 2007 BOS1-E Week 16 Exercise 3 Excel 2003 Cocktail Bar Summary Report Product Sales price Sales Net Revenue Analysis I Analysis II Analysis III Analysis IV Coffee Hot Drink € 5.0 1861 IV V VI VII VIII IX Tea Hot Drink € 4.5 1442 IV V VI VII VIII IX Hot chocolate Hot Drink € 3.0 1162 IV V VI VII VIII IX Coca Cola Cold Drink € 4.0 936 IV V VI VII VIII IX Orangina Cold Drink € 3.5 1674 IV V VI VII VIII IX Ice Tea Cold Drink € 2.0 1020 IV V VI VII VIII IX Decaf Coffee Hot Drink € 3.0 1760 IV V VI VII VIII IX Bottled Water Cold Drink € 3.0 1143 IV V VI VII VIII IX Cold Drink Total I I X Hot Drink Average II II Best selling III III XI Net Revenue Number of products V.A.T. Rate 19.6% Hot Drink XII Hot product XIII Cold Drink XII Cold Product XIII Product Category % of sales Number of Products Coca Cola Ice Tea Bottled Water Orangina Hot chocolate Tea Decaf Coffee Coffee 0 400 800 1200 1600 2000 € - € 2,000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/19/2008 for the course CPT CPT 109 taught by Professor A.sisini during the Fall '08 term at Franklin CH.

Page1 / 3

cpt_109_midterm-solution - Automatic Date This is a summary...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online