Question: Using the Attachment 2-Caf Quarterly Budget template - Fund allocation page, allocate the funds for the quarter to the relevant areas and what you will
Using the Attachment 2-Caf Quarterly Budget template - Fund allocation page, allocate the funds for the quarter to the relevant areas and what you will purchase from existing or new suppliers. Make notes in the relevant column to support your choice and rationale. Add or delete rows as necessary and apply cell formatting and the use of formula functions as necessary. Submit the completed Fund Allocation.

AutoSave O Off) Attachment 2-Cafe Quarterly Budget (1) - Protected View . Search (Alt+Q) jaswinder sharma JS X File Home Insert Page Layout Formulas Data Review View Help Comments 1 Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G7 X V fx A B C D E F G H K L M N O P Q R 4 Income Food sales 36,000 36,000 52,000 6 Beverage sales 24,000 24,000 40,000 7 Catering fees 10,000 10,000 5,000 8 Total income 70,000 70,000 97,000 9 10 Cost of sales 11 Food purchases 15,000 15,000 24,000 12 Beverage purchases 5,000 5,000 12,000 13 Total cost of sales 20,000 20,000 36,000 14 15 Gross profit 50,000 50,000 61,000 16 17 Operating Expenses 18 Wages 17,000 17,000 21,000 19 Insurance 600 600 500 20 Utilities 2,000 2,000 2,000 21 Rent 5,000 5,000 5,000 22 Marketing 2,000 2,000 2,000 23 Phone 100 100 100 24 Live music 500 500 500 25 Repairs and maintenance 500 500 500 26 27 Total operating expenses 27,700 27,700 31,700 28 Net profit/loss 22,300 22,300 29,300 29 Budget Past information Fund allocation + Ready + 100% Type here to search O 9 X Rain coming ~ 9 1071) ENG 2:49 PM IN 5/03/2022
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
