{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cpt109_lesson_19_solution

cpt109_lesson_19_solution - JANUARY INCOME Room service...

Info icon This preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
JANUARY INCOME Room service 12,000.00 Restaurant 22,000.00 Café 32,000.00 Bar 25,000.00 Total income 91,000.00 EXPENDITURE Salaries 30,000.00 Fixed costs 15,000.00 Variable costs 40,000.00 Total expenditure 85,000.00 GROSS PROFIT 6,000.00
Image of page 1

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

View Full Document Right Arrow Icon
FEBRUARY INCOME Room service 14,000.00 Restaurant 22,000.00 Café 31,000.00 Bar 26,000.00 Total income 93,000.00 EXPENDITURE Salaries 30,000.00 Fixed costs 15,000.00 Variable costs 41,000.00 Total expenditure 86,000.00 GROSS PROFIT 7,000.00
Image of page 2
MARCH INCOME Room service 15,000.00 Restaurant 23,000.00 Café 30,000.00 Bar 24,000.00 Total income 92,000.00 EXPENDITURE Salaries 30,000.00 Fixed costs 15,000.00 Variable costs 38,000.00 Total expenditure 83,000.00 GROSS PROFIT 9,000.00
Image of page 3

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

View Full Document Right Arrow Icon
SUMMARY INCOME Room service 26,000.00 Restaurant 44,000.00 Café 63,000.00 Bar 51,000.00 Total income 184,000.00 EXPENDITURE Salaries 60,000.00 Fixed costs 30,000.00 Variable costs 81,000.00 Total expenditure 171,000.00 GROSS PROFIT 13,000.00
Image of page 4
JANUARY FEBRUARY INCOME INCOME Room service 12,000.00 Room service 14,000.00 Restaurant 22,000.00 Restaurant 22,000.00 Café 32,000.00 Café 31,000.00 Bar 25,000.00 Bar 26,000.00 Total income 0.00 Total income 0.00 EXPENDITURE EXPENDITURE Salaries 30,000.00 Salaries 30,000.00 Fixed costs 15,000.00 Fixed costs 15,000.00 Variable costs 40,000.00 Variable costs 41,000.00 Total expenditure 0.00 Total expenditure 0.00 GROSS PROFIT 0.00 GROSS PROFIT 0.00 MARCH SUMMARY INCOME INCOME Room service 15,000.00 Room service 0.00 Restaurant 23,000.00 Restaurant 0.00 Café 30,000.00 Café 0.00 Bar 24,000.00 Bar 0.00 Total income 0.00 Total income 0.00 EXPENDITURE EXPENDITURE Salaries 30,000.00 Salaries 0.00 Fixed costs 15,000.00 Fixed costs 0.00 Variable costs 38,000.00 Variable costs 0.00 Total expenditure 0.00 Total expenditure 0.00 GROSS PROFIT 0.00 GROSS PROFIT 0.00
Image of page 5

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

View Full Document Right Arrow Icon
Autumn 2006 BOS2-E Week 7 Exercise 1 Excel 2003 GARDEN SUPPLIES SUNNINGDALE INVOICE N° 17036 Customer N° 4101 VII VIII IX X Date: XI CODE QUANTITY DESCRIPTION UNIT PRICE COST M345 4 I II III M101 2 I II III S233 6 I II III T405 1 I II III TOTAL EXCL. VAT IV V.A.T. 7.6% V TOTAL INCL. VAT VI ROBINSON'S GARDEN SUPPLIES, 1223 Elm Park Road, Sunningdale Tel: 181 675 22 05 Fax: 181 675 33 02
Image of page 6
Price table on: 3/1/2006 Code Description Price Excl. VAT T405 Lawn mower 1,879.00 T567 Lawn mower with automatic starter 2,345.00 M101 Tractor / 2 Horse Power 3,870.00 M345 Tractor / 5 Horse Power 6,578.00 S233 Electric shears 2,671.00
Image of page 7

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

View Full Document Right Arrow Icon
Customer N° Name Address/Organization City Postal code 9078 Sunningdale Golf Club Cross Road Sunningdale SL5 9RW 5690 Wentworth Golf Club Surrey High road Virginia Water GU25 4LS 4100 Sunningdale Inn Windsor Ave Sunningdale SL5 9RX 4101 Ascot Race Course 204 Station Road Ascot SL3 2LF
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '08
  • A.Sisini
  • Sector Excavation Excavation Structure Structure, Plumbing Plumbing Electricity, Plumbing Electricity Electricity

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern