Excel File Edit View Insert Format Window Tools Data Help 100% A Home Layout Charts Tables SmartArt Formulas Data Review Edit Font Alignment Arial Fill A A- 12 abc- Wrap Text B I Clear Paste Merge F40 fx A B D E F H. 1 Chapter 1, Question 3 2 Su Chan manages a popular restaurant called the Bungalow. Her P&L for the month of March is as follows. Su has a meeing with the owner of the Bungalow next week, so she decided to create a pie chart showing the percentage of her costs in relation to her total sales (see the following diagram). 3 4 5 6 7 Revenue S Proft 50% 100,000.00 34,000.00 40,000.00 21,000.00 95,000.00 5,000.00 100.0% 34.0% 40.0 % 21.0% 95.0% 5.0% F&B Expense 8 Other Labor Expense Other Expense Total Expenses F&8 expense expenser 34.0% 210% 10 11 S Labor expense 430% 12 Profit 13 14 15 At the mooting with the owner, Su s asked to change the information on the pio chart to reflect the next month's projections. The owner suggests that April revenue and costs. 16 should be as follows: 17 18 19 % 20 Revenue S 120.000.00 100.0% 37.0% 33.0% 18.0% 88.0% 13.0% F&B Expense Labor Expense Other Expense Total Expenses 21 44,000.00 40,000.00 21,000.00 105,000.00 15,000.00 22 Insert Pie Chart Here 23 24 25 Profit 26 27 28 heingthene.numbar 30 the nuner's.nendt nanentane anine to ha hinher.nuiner than thatinMach2 Ru q1 Q2 Q 3 Q5 Q4 Q6 Q7 Q 8 q 10 Q9 Normal View Ready 29 MacBoc Excel File Edit View Insert Format Tools Data Window 12 Home Charts Layout Tables SmartArt Formulas Data Review Edit Font Allignment Arial FR A A 12 abc Wrap Te B Clear Paste Merg F40 fx A D H 28 Using these numbers, is the owner's profit percentage going to be higher or lower than that in March? By 29 how much? 30 31 Answer 32 33 34 35 % 36 Revenue 37 S 120,000.00 44,000.00 50,000.00 19.000.00 113,000.00 7,000.00 100.0% 37.0% 42.0% 16.0% 94.0% 6.0 % F&B Expense Labor Expense Other Expense Total Expenses 38 Insert Pie Chart Here 39 40 41 Profit S 42 43 44 45 46 Using these numbers, is the owner's profit percentage going to be higher or lower than that in March? By how much? 47 48 Answer 49 Which set of projections has more reasonable goals? 50 51 $2 53 54 Answer 55 56 57 58 59 6O Q2 Q4 as Q3 Q 6 Q 7 Q 9 Normal View Ready