Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 Week5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Accounting

Authors: Charles T Horngren, John A Elliott

9th Edition

0131479725, 978-0131479722

More Books

Students also viewed these Accounting questions