Let's help new business partners Trish and Belle put their cash ow forecast together for an exciting new business venture, Cilantro. Trish is a chef and has been catering lunches for local businesses for the last couple years. Since catering has been successful todate, Trish has dreamed of opening a small restaurant that focuses on her business demographic, operating during the busy lunch-hour period. That way, she can also use the kitchen for other catering and event gigs during later afternoons, evenings and weekends (with future plans to host events in the small space). Trish doesn't want to do everything herself, so she's taking on a partner, Belle, as a 50% shareholder in this new business. Trish and Belle need to forecast their cash ow for the next 4-week period. Here's the information you gathered for the forecast: 0 Each partner is investing $20,000 in the business 0 Anticipating $6,000 in marketing costs for launch month (attribute to week 1) 0 The rst couple weeks (week 1 and week 2) will operate at half-capacity for a soft launch: a Open Monday to Friday lunch time; open 5 days per week 0 Labour approx. $240 per day 0 Approx. F&B sales $480 per day a Weeks 3 and 4: Open Monday to Friday lunch time, so 5 days per week a Labour (5 days) approx. $360 per day a Approx. F&B sales $960 per day Monthly utilities $3,500 and $5,000 insurance (usually 3rd Thursday of the month) Rent rst of the month at $3,250 Assume 13% tax on weekly sales a o 0 0 $500 in gift card sales by end of the month (no tax) 0 Approx. $300 in produce purchased regularly from a vendor every 2 weeks Instructions Using the information provided above, complete the following: 1. Complete the cash flow forecast for the 4-week period and answer the additional questions. (20 marks) - Use the Excel template provided, complete the cash ow forecast. 2. Research some restaurant cash flows. What financial information could be missing? What would you recommend to help make this forecast more precise or accurate? (6 marks) 3. Which expense is likely high because this is a new venture? (1 mark) 4. What are other ways to generate revenue that would increase cash inflows