cpt109_lesson_19_solution

cpt109_lesson_19_solution - JANUARY INCOME Room service...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 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 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 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 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 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 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 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 Customer N Name Address/Organization City Postal code 9078 Sunningdale Golf Club Cross Road Sunningdale SL5 9RW 5690 Wentworth Golf Club Surrey High road...
View Full 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 / 14

cpt109_lesson_19_solution - JANUARY INCOME Room service...

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

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