Jerry Smith has found a location on Tremont Street in Boston to open a pizza and sub shop. The store size is 1,200 square feet and it requires about $100 per square foot in renovation, fixtures and equipment (balance sheet item). The rent for the said location is $65,000 per year, Jerry is planning to be open 7 days a week 15 hours per day Jerry projects the store sales per day to be $2.2007 days a week 52 weeks a year), in addition, Jerry is counting on having 3 employees at all time in the store at an average pay of $15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues COGS $ COGS Gross Profit Gross margin Variable Costs Contribution margins Contribution margin Fixed Costs EBITDAS Break Even point sales $ Jerry has supplied you with the following information: Sales Categories to total sales COGS Anticipated pay date Monthly in the middle of the month Monthly-second week of the month Monthly At the end of the month Subs Soda 35% 5% 30% Operating cost Per Month Per Year Anticipated pay date Monthly-First week of the month Payroll Weekly-Once a week Benefits and Taxes Weekly-Once a week 500 Monthly in the middle of the month lephone 200 Monthly in the middle of the month mputer Maintenance 100 Monthly At the end of the month mputer Expense 1.200 Monthly At the end of the month mputer Lease 75 Monthly in the middle of the mont hicle Lease 330 Monthly-First week of the month icle Fuel 200 Weekly-Once a week chandise Supplies Monthly in the middle of the mon e Supplies 100 Monthly in the middle of the mom essional fees 1.200 Monthly in the middle of the mor ance Monthly-First week of the month mission 2.5% Monthly At the end of the mont ting 25.000 Monthly At the end of the mont Card Fees 2.9% Weekly-Once a week aneous 1,800 Monthly At the end of the mon middle of the month is week 3 end of the month is week 4 addition Jerry has asked you to forecast the store's cash flow for 5 weeks average. The beginning cash is $6,000. Beginning cash Sales Looo Total cash in Cashout Payables (Variable cost and Fixed cost) Pizza Subs Soda Credit card fees Merchandise Supplies Commission Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance Computer Expense Computer Lease Vehicle Lease Vehicle Fuel Marketing Office Supplies Professional fees Insurance Miscellaneous Total cash out Net Cash flow Jerry Smith has found a location on Tremont Street in Boston to open a pizza and sub shop. The store size is 1,200 square feet and it requires about $100 per square foot in renovation, fixtures and equipment (balance sheet iem). The rent for the said location is $65.000 per vear. Jerry is planning to be open 7 days a week 15 hours per day Jerry projects the store sales per day to be $2,200 (7 days a week 52 weeks a year). In addition, Jerry is counting on having 3 employees at all time in the store at an average pay of $15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues $ COGS $ Gross Profits Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Cost $ EBITDA $ Break Even point sales $ Jerry has supplied you with the following information: % to total sales 60% Sales Categories Pizza Subs Soda COGS% 40% 40% 30% Anticipated pay date Monthly In the middle of the month Monthly-second week of the month Monthly At the end of the month 5% Per Year Per Month 20% Operating cost Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance 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 mont Monthly-At the end of the month Monthly At the end of the month Monthly-In the middle of the mo the month 500 200 100 1,200 Analysi 1 Instru Gross Profit $ Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Costs EBITDAS Break Even point sales $ Jerry has supplied you with the following information: Sales Categories % to total sales Pizza 60% Subs 35% 5% Soda COGSX 40% Anticipated pay date Monthly in the middle of the month Monthly-second week of the month Monthly At the end of the month 40% 30% Operating cost Per Month Per Year Anticipated pay date Rent Monthly-First week of the month Payroll Weekly-Once a week Benefits and Taxes 20% Weekly-Once a week Utilities 500 Monthly in the middle of the month Telephone 200 Monthly in the middle of the month Computer Maintenance 100 Monthly At the end of the month Computer Expense 1.200 Monthly At the end of the month Computer Lease 75 Monthly in the middle of the month Vehicle Lease 330 Monthly First week of the month Vehicle Fuel 200 Weekly-Once a week Merchandise Supplies 3% Monthly in the middle of the month Office Supplies 100 Monthly-In the middle of the month Professional fees 1,200 Monthly in the middle of the month Insurance 2,500 Monthly-First week of the month Commission 2.5% Monthly At the end of the month Marketing 25,000 Monthly At the end of the month Credit Card Fees 2.9% Weekly-Once a week Miscellaneous 1,800 Monthly At the end of the month *middle of the month is week 3 **end of the month is week 4 In addition Jerry has asked you to forecast the store's cash flow for 5 weeks average. The beginning cash is $6,000 Jerry Smith has found a location on Tremont Street in Boston to open a pizza and sub shop. The store size is 1,200 square feet and it requires about $100 per square foot in renovation, fixtures and equipment (balance sheet item). The rent for the said location is $65,000 per year, Jerry is planning to be open 7 days a week 15 hours per day Jerry projects the store sales per day to be $2.2007 days a week 52 weeks a year), in addition, Jerry is counting on having 3 employees at all time in the store at an average pay of $15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues COGS $ COGS Gross Profit Gross margin Variable Costs Contribution margins Contribution margin Fixed Costs EBITDAS Break Even point sales $ Jerry has supplied you with the following information: Sales Categories to total sales COGS Anticipated pay date Monthly in the middle of the month Monthly-second week of the month Monthly At the end of the month Subs Soda 35% 5% 30% Operating cost Per Month Per Year Anticipated pay date Monthly-First week of the month Payroll Weekly-Once a week Benefits and Taxes Weekly-Once a week 500 Monthly in the middle of the month lephone 200 Monthly in the middle of the month mputer Maintenance 100 Monthly At the end of the month mputer Expense 1.200 Monthly At the end of the month mputer Lease 75 Monthly in the middle of the mont hicle Lease 330 Monthly-First week of the month icle Fuel 200 Weekly-Once a week chandise Supplies Monthly in the middle of the mon e Supplies 100 Monthly in the middle of the mom essional fees 1.200 Monthly in the middle of the mor ance Monthly-First week of the month mission 2.5% Monthly At the end of the mont ting 25.000 Monthly At the end of the mont Card Fees 2.9% Weekly-Once a week aneous 1,800 Monthly At the end of the mon middle of the month is week 3 end of the month is week 4 addition Jerry has asked you to forecast the store's cash flow for 5 weeks average. The beginning cash is $6,000. Beginning cash Sales Looo Total cash in Cashout Payables (Variable cost and Fixed cost) Pizza Subs Soda Credit card fees Merchandise Supplies Commission Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance Computer Expense Computer Lease Vehicle Lease Vehicle Fuel Marketing Office Supplies Professional fees Insurance Miscellaneous Total cash out Net Cash flow Jerry Smith has found a location on Tremont Street in Boston to open a pizza and sub shop. The store size is 1,200 square feet and it requires about $100 per square foot in renovation, fixtures and equipment (balance sheet iem). The rent for the said location is $65.000 per vear. Jerry is planning to be open 7 days a week 15 hours per day Jerry projects the store sales per day to be $2,200 (7 days a week 52 weeks a year). In addition, Jerry is counting on having 3 employees at all time in the store at an average pay of $15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues $ COGS $ Gross Profits Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Cost $ EBITDA $ Break Even point sales $ Jerry has supplied you with the following information: % to total sales 60% Sales Categories Pizza Subs Soda COGS% 40% 40% 30% Anticipated pay date Monthly In the middle of the month Monthly-second week of the month Monthly At the end of the month 5% Per Year Per Month 20% Operating cost Rent Payroll Benefits and Taxes Utilities Telephone Computer Maintenance 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 mont Monthly-At the end of the month Monthly At the end of the month Monthly-In the middle of the mo the month 500 200 100 1,200 Analysi 1 Instru Gross Profit $ Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Costs EBITDAS Break Even point sales $ Jerry has supplied you with the following information: Sales Categories % to total sales Pizza 60% Subs 35% 5% Soda COGSX 40% Anticipated pay date Monthly in the middle of the month Monthly-second week of the month Monthly At the end of the month 40% 30% Operating cost Per Month Per Year Anticipated pay date Rent Monthly-First week of the month Payroll Weekly-Once a week Benefits and Taxes 20% Weekly-Once a week Utilities 500 Monthly in the middle of the month Telephone 200 Monthly in the middle of the month Computer Maintenance 100 Monthly At the end of the month Computer Expense 1.200 Monthly At the end of the month Computer Lease 75 Monthly in the middle of the month Vehicle Lease 330 Monthly First week of the month Vehicle Fuel 200 Weekly-Once a week Merchandise Supplies 3% Monthly in the middle of the month Office Supplies 100 Monthly-In the middle of the month Professional fees 1,200 Monthly in the middle of the month Insurance 2,500 Monthly-First week of the month Commission 2.5% Monthly At the end of the month Marketing 25,000 Monthly At the end of the month Credit Card Fees 2.9% Weekly-Once a week Miscellaneous 1,800 Monthly At the end of the month *middle of the month is week 3 **end of the month is week 4 In addition Jerry has asked you to forecast the store's cash flow for 5 weeks average. The beginning cash is $6,000