A new dient of yours. Kate Perez wants open an ice cream shop near be downtown shopping center. She will selling Frozen POPS, Frozen los F Packs Sods and Bottled Water. Her grand opening will be June 1, 2023 POPS Katie needs help figuring out how her business will perform the first year in business. She has hired you as an independent consultant, prepare a cash proforma budget for her business venture. This is a spreadsheet that helps forecast income and expenses over a period of It can be used to plan and manage the business if done comectly Assignment Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations Use the file attached Excel Template-Perezpops.xls" as your starting point Download and use this file as the basis for your assignment. Do not make any changes to this pre-defined template items (this means start with the items that already included and that are expected in the spreadsheet). You may add your information to the existing sheets. You may add extra worksheets as needed as well update the template. Do not use a template from a previous semester-this is academic dishonesty and will be subject to disciplinary action Do not remove the Grading Criteria Worksheet Place the finished cash pro forma on a worksheet labeled "Cash ProForma Place all your case assumptions data on a separate worksheet. Label the worksheet "Assumptions" (note: each piece of data must appear in its own cel on the Assumption sheet) Place your start-up costs on a third worksheet labeled "Startup Costs" Create additional worksheets for your What if Scenario recommendation Events Appropriate Charts (graphs): You will be creating two separate charts so cale and label two additional worksheets for the charts (each chart will be in its own worksheet) Chart One-Monthly Product Revenue-this will show the monthly revenue for each of your five products for the entire year. Chart Two-Total Product Net Income"-You want to track the total product income for the year to determine any trends or projections in product sales Make sure both charts are formatted correctly (.e. appropriate title, legend where appropriate, data series property labeled) and they are appropriate for business use Information needed to complete assignment: Products: Specialty POPS, Frozen Ice, Soda and Bottle water. Product Selling Prices: POPS Fruit Explosion $4.75 Vanilla Vanilla $3.75 Chocolate Mousse $4.25 Mango Tangerine Surprise $4.25 Strawberry Crme $3.75 Pina Colada $4.75 Strawberry Kiwi $4.25 Orange Crme $3.75 Chocolate sea salt $4.25 Cookies & Crme $3.25 Pop Packs 12pk $48.00 6pk $24.00 Frozen Ice Medium $3.75 Large $4.25 Soda $1.95 a bottle Bottled Water-$1.25 a botte