stomers (one soft drink less for every beet sold). He will also have to purchase a beer licenin from the county woald go up. Should your friend offer beer to his customers? See figures page for key changes. You have been hired as a consultant to look at new business idea In this first part of the assignment, sou will complete an Excel Workbock to help Lan Draco, the owner decide whether it is a good idea to open The Dragou Fire Grill sells hotdogs, burzers, fries, and drinis. You fitt here te -emplete- cash pro-forma and two recommendations and two graphs. You will also have to state your opinion oa each of the three spreadsheets (Cash Pro-Forma, Marketing and Beer) after you have analyzed the results. Goals: 1. To develop a proficieacy using Microsott Excel To. graph information in Microsoft Excel To complete at Cash Pro-Forma spreadsheet 3. To duplicate a spreadsheet and make changes to the duplicated sheet to answer "What If" quentions. Content: Construct a monthly pro-forma canh budget for the owner for the firnt year of operations from the given template. DO NOT use a template form a previous semester - this is considered academic dishonesty and will be subject to disciplinary action. Place all your case Assamptions on one worksheet. Name the workeheet 'Assumptions' Note, each piece of data must appear in its own cell on the asmumptions heet Place your atart up costs on a second workaheet named "Startup Costs" Place the cash Pro Forma on another worksheet named Cash Pro-Forma Budget" Create two additional worksheets. These are required for your recommendations. Name ose "Marketing" and "Beer" Chart One - Monthly Product Revenue - this will diaplay the revenue by month for each of your four products. Make sure to give the chart a itile and format the colors, legend, and axis appropriately. Do not include your total reveaue. Chart Two - Net Income - This should be an attractive line graph. Make sure you don't include the totals - this will nagatively affect the mpact of the chart Make sure to give the chart a title and format the colors, Jekend, and axis appropriutely. Make sure that the charts arn formatted correctly, series are labeled and they are appropriate for business use. Technical: See table below for Initial Values for the Assumptions, Start Up Costs and Cash Pro-Forma aheets. Once you complete the Cash Pro-Forma thect and have checked it over, you will copy it twice. The first copy will be named Marketing and the second copy will be named Beer. Reconmendations