Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill in the empty spots for these. Variable costs are there to help I do not think they need to be filled out Thank
Please fill in the empty spots for these.
Variable costs are there to help I do not think they need to be filled out
Thank you.
PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST 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 Flowers Other flowers Plants Vases % of sales 50% find $ 40% find $ 7% find $ 3% find $ COGS % 40% find $ 35% find $ 40% find $ 35% find $ ANTICIPATED PAY DATE Monthly fourth week Monthly fourth week Monthly fourth week Monthly fourth week Expense Rent Payroll Per month Per year Anticipated pay date Monthly week 1 Every other week start week 2 Every other week starts week 2 Monthly third week Monthly third week Monthly fourth week Monthly fourth week Benefits and taxes Utilities Telephone Computer maintenance Computer expense Computer lease Vehicle lease Vehicle fuel Merchandise supplies Office supplies Professional fees Insurance Marketing Credit card fee Miscellaneous Break even 22% 300 100 50 1200 75 4000 2000 3% 100 1200 2500 3% 3% 1800 Monthly week 1 Weekly Monthly third week Monthly third week Monthly fourth week Monthly week 1 Monthly second week Weekly Monthly week 1 Variable costs Credit card fees Marketing fees Merchandise supplies Rent Payroll B+T Utilities TELEPHONE Computer maintenance Computer expense Computer lease Vehicle lease Vehicle fuel Office supplies Professional fees Insurance Miscellaneous 150 150 150 150 150 650 650 2500 2500 2700 594 2700 594 300 100 50 100 75 333 333 38 208 150 38 38 100 38 100 38 208 150 Cash flow statement PLEASE SHOW FORMULAS AND HOW CAME UP WITH THE COST BEGINNING CASH 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 Week 1 5000 Week2 Week3 Week4 Week5Step 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