Question
PROJECTEDSALESBUDGET2018 MONTH SALES JANUARY 67500 FEBRUARY 37500 MARCH 40500 APRIL 35500 MAY 32500 JUNE 37500 JULY 31500 AUGUST 35500 SEPTEMBER 37500 OCTOBER 32500 NOVEMBER 42500
PROJECTEDSALESBUDGET2018
MONTH
SALES
JANUARY
67500
FEBRUARY
37500
MARCH
40500
APRIL
35500
MAY
32500
PROJECTEDSALESBUDGET2018 | |
MONTH | SALES |
JANUARY | 67500 |
FEBRUARY | 37500 |
MARCH | 40500 |
APRIL | 35500 |
MAY | 32500 |
JUNE | 37500 |
JULY | 31500 |
AUGUST | 35500 |
SEPTEMBER | 37500 |
OCTOBER | 32500 |
NOVEMBER | 42500 |
DECEMBER | 67500 |
TOTALINCOME | 500,000 |
LESSCOGS(CostofGoodsSold) | 150,000 |
=GROSSPROFIT | 350,000 |
PROJECTEDANNUALEXPENSESBUDGET2018 | |
WAGES | 125,000 |
PERMITS/LICENSES | 2000 |
RENT | 25000 |
INSURANCE | 11500 |
MARKETING/WEBSITE | 10500 |
ELECTRICITY | 12500 |
GAS | 12500 |
WATER | 11500 |
RATES | 12500 |
PHONE | 12500 |
INTERNET | 9500 |
CLEANING | 10,000 |
TOTALEXPENSES | 255,000 |
NETPROFIT | 95000 |
These changes are as follows:
Increase in wages 5%
Increase in COGS by 3% in
Increase in expenses by 2%
Increase in sales by 12%
PROJECTED SALES BUDGET Year 4 | |
MONTH | SALES |
JANUARY | |
FEBRUARY | |
MARCH | |
APRIL | |
MAY | |
JUNE | |
JULY | |
AUGUST | |
SEPTEMBER | |
OCTOBER | |
NOVEMBER | |
DECEMBER | |
TOTAL INCOME | |
LESS COGS (Cost of Goods Sold) | |
GROSS PROFIT | |
PROJECTED ANNUAL EXPENSES BUDGET 2018 | |
WAGES | |
PERMITS / LICENSES | |
RENT | |
INSURANCE | |
MARKETING / WEB SITE | |
ELECTRICITY | |
GAS | |
WATER | |
RATES | |
PHONE | |
INTERNET | |
CLEANING | |
OTHER EXPENSES | |
TOTAL EXPENSES | |
NET PROFIT |
Part A: Present Budget Draft
You are to arrange a meeting time and date with the owner of VIT caf (assessor who will play the role of the owner of VIT caf) to discuss your draft budget. The purpose of this meeting is to:
Present your budget and negotiate your budget for approval
Discuss any changes with income and expenditure priorities with the VIT owner
Compromise where appropriate, and include changes as negotiated with your manager (trainer) and your peers (classmates)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started