What is the following?

Beginning cash:

Sales:

Total cash in:

Hard cover books:

Soft cover books:

Magazines:

Newspapers:

Rent:

Payroll:

Benefits and Taxes:

Utilities:

Telephone:

Computer Maintenance:

Computer Lease:

Merchandise Supplies:

Office Supplies:

Professional fees:

Insurance:

Marketing:

Credit Card Fees:

Miscellaneous:

Total cash out:

Net Cash flow:

Spring 2020 Date: 3/23/20 Name: The size of the book store in south station, Boston is 350 square feet and it requires about $200 per square foot in renovation, fixtures and equipment (balance sheet item). The rent for the said location is $35,000 per year. The store is open 7 days a week 20 hours per day. The store sales per day are $1,250 (7 days a week 52 weeks a year). There is 1 employee at all time in the store at an average pay of $18 per hour. You were contacted to determine the following on an annual basis Sales/Revenues $ COGS $ COGS% Gross Profit $ Gross margin % Total other Variable Cost $ Contribution margin $ Contribution margin % Fixed Cost $ EBITDA Break Even point sales $ You were supplied with the following information: Sales Categories Hard cover books Soft cover books Magazines News papers % to total sales 30% 35% 5% COGS% 57.20% 55% 30% 25% Anticipated pay date Monthly-In the middle of the month Monthly-second week of the month Monthly At the end of the month Monthly At the end of the month 30% Per Month Per Year 20% Operating cost Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance Computer Lease Merchandise Supplies Office Supplies Professional fees Insurance Marketing Credit Card Fees Miscellaneous 300 150 100 75 Anticipated pay date Monthly-First week of the month Weekly-Once a week Weekly-Once a week Monthly-In the middle of the month Monthly-In the middle of the month Monthly At the end of the month Monthly-In the middle of the month Monthly-In the middle of the month Monthly In the middle of the month Monthly-In the middle of the month Monthly-First week of the month Monthly At the end of the month Weekly-Once a week Monthly At the end of the month 2% 50 1,200 2,500 2% 3% 1,800 *middle of the month is week 3 **end of the month is week 4 Please forecast the store's cash flow for 5 weeks average. The beginning cash is $2,000. Spring 2020 Date: 3/23/20 Name: Cash in Week 1 Week 2 Week 3 Week 4 Week 5 Beginning cash Sales Total cash in Cash out Payables (Variable cost and Fixed cost) Hard cover books Soft cover books Magazines Newspapers Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance Computer Lease Merchandise Supplies Office Supplies Professional fees Insurance Marketing Credit Card Fees Miscellaneous Total cash out Net Cash flow