PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST

Variable costs are there to help I do not think they need to be filled out

Income statement and cash flow Help

A store is in a 200 square feet area, the cost of the building the store is $200 per square feet

Rent for the store is 30,000$

Payroll for the store based on 1.5 people each day for 12 hours per day 5 days a week is 15$ for 52 weeks a year

Store is expected to sell 1000$ per day for 5 days a week for 52 weeks

Please help with the following on an annual basis based on the financial above and below

PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST

Sales and revenue

COGS $

COGS %

GM $

GM %

VARIBALE COST $

CONTRBUTION MARGIN $

CONTRIBUTION MARGIN %

FIXED COST

EBITDA

BREAK EVEN

PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST

Sales category	% of sales	COGS %	ANTICIPATED PAY DATE
Flowers	50% find $	40% find $	Monthly fourth week
Other flowers	40% find $	35% find $	Monthly fourth week
Plants	7% find $	40% find $	Monthly fourth week
Vases	3% find $	35% find $	Monthly fourth week

Expense	Per month	Per year	Anticipated pay date
Rent			Monthly week 1
Payroll			Every other week start week 2
Benefits and taxes		22%	Every other week starts week 2
Utilities	300		Monthly third week
Telephone	100		Monthly third week
Computer maintenance	50		Monthly fourth week
Computer expense		1200	Monthly fourth week
Computer lease	75
Vehicle lease		4000	Monthly week 1
Vehicle fuel		2000	Weekly
Merchandise supplies		3%	Monthly third week
Office supplies	100		Monthly third week
Professional fees		1200	Monthly fourth week
Insurance		2500	Monthly week 1
Marketing		3%	Monthly second week
Credit card fee		3%	Weekly
Miscellaneous		1800	Monthly week 1
Break even

Variable costs

Credit card fees	150	150	150	150	150
Marketing fees		650
Merchandise supplies			650
Rent	2500				2500
Payroll		2700		2700
B+T		594		594
Utilities			300
TELEPHONE			100
Computer maintenance				50
Computer expense				100
Computer lease				75
Vehicle lease					333
Vehicle fuel	333
Office supplies	38	38	38	38	38
Professional fees			100	100
Insurance	208				208
Miscellaneous	150				150

Cash flow statement

PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST

	Week 1	Week2	Week3	Week4	Week5
BEGINNING CASH	5000
sales
Total cash in
Accounts payable
COGS
VARIABLE COSTS
TOTAL VARIABLE COST
OPERATION EXPENSE / FIXED COST
TOTAL OPERATION EXPENSE / FIXED COST
TOTAL CASH OUT
NET CASH FLOW