I need help with the second page, I am stuck.
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 not an income statement item, also not calculated in cash flow). The rent for the said location is 567,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,200 17 days a week 52 weeks a year). In addition, Jerry is counting on having employees at all time in the store at an average pay of $15.15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues $ 1800, 800 COGS $ 76 COGS % Gross Profit $ Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Cost $ 952,882 EBITDAS Break Even point sales $ Jerry has supplied you with the following information: $484,484 $435, 154 371272 $88, 136 Sales Categories Pizza Subs Soda % to total sales 59% 36% 5% 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 1967, 00 2400 OXZOO 3,960 Operating cost Per Month Per Year Anticipated pay date Rent $5,583 Monthly-First week of the month Payroll $20, 679 $ 248.15 7. Weekly-Once a week Benefits and Taxes 21% Weekly-Once a week Utilities 500 6,000 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 POS Expense 100 1,200 Monthly-At the end of the month POS Lease 75 900 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 $24,024 Monthly In the middle of the month Office Supplies 100 Monthly In the middle of the month Professional fees TOO 1,200 Monthly In the middle of the month Insurance 2,500 Monthly-First week of the month Commission 20,200 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,987 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,500. 1.200 296. 52 283 1223, 123 52,882 Cash in Week 1 Week 2 Week 3 Week Weeks Beginning cash Sales 15, uod Total cash in Cash out 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 item not an income statement item, also not calculated in cash flow). The rent for the said location is 567,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,200 17 days a week 52 weeks a year). In addition, Jerry is counting on having employees at all time in the store at an average pay of $15.15 per hour. Jerry has contacted you to help him to determine the following on an annual basis Sales/Revenues $ 1800, 800 COGS $ 76 COGS % Gross Profit $ Gross margin % Variable Cost $ Contribution margin $ Contribution margin % Fixed Cost $ 952,882 EBITDAS Break Even point sales $ Jerry has supplied you with the following information: $484,484 $435, 154 371272 $88, 136 Sales Categories Pizza Subs Soda % to total sales 59% 36% 5% 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 1967, 00 2400 OXZOO 3,960 Operating cost Per Month Per Year Anticipated pay date Rent $5,583 Monthly-First week of the month Payroll $20, 679 $ 248.15 7. Weekly-Once a week Benefits and Taxes 21% Weekly-Once a week Utilities 500 6,000 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 POS Expense 100 1,200 Monthly-At the end of the month POS Lease 75 900 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 $24,024 Monthly In the middle of the month Office Supplies 100 Monthly In the middle of the month Professional fees TOO 1,200 Monthly In the middle of the month Insurance 2,500 Monthly-First week of the month Commission 20,200 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,987 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,500. 1.200 296. 52 283 1223, 123 52,882 Cash in Week 1 Week 2 Week 3 Week Weeks Beginning cash Sales 15, uod Total cash in Cash out 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
