( please i really neeed this..i will post the best review )

content :

Construct a monthly pro-forma cash budget for the owner for the first 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 Assumptions on one worksheet. Name the worksheet "Assumptions" Note, each piece of data must appear in its own cell on the assumptions sheet Place your start up costs on a second worksheet 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 one "Marketing" and "Beer". Chart One Monthly Product Revenue this will display the revenue by month for each of your four products. Make sure to give the chart a title and format the colors, legend, and axis appropriately. Do not include your total revenue. Chart Two Net Income - This should be an attractive line graph. Make sure you dont include the totals this will negatively affect the impact of the chart. Make sure to give the chart a title and format the colors, legend, and axis appropriately. Make sure that the charts are 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 sheets. Once you complete the Cash Pro-Forma sheet 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. Recommendations The owner is asking to explore some business recommendations. Show your friend how these recommendations would affect the cash budget by recreating the pro-forma for each scenario. You do not have to start from scratch. But note that these are completely independent proformas within the same workbook. They must update accordingly from the Assumptions worksheet using absolute values. All items on the Cash Pro-Forma, Marketing and Beer Sheets are the result of formulas. Just having numbers on these sheets will not get you credit for the assignment. Insert 2 to 3 sentences under the Cash Flow for Month 1 on each sheet. Explain if it is a good idea to adopt this plan and why. Use Total Net Income to judge whether this is a good plan. Compare each recommendation (Marketing and Beer) against the Total Net Income from the Cash Pro-Forma. Recommendation One - Marketing: The owner feels fairly comfortable that he doesn't have to spend more than the original advertising budget, since the grill advertises heavily in the area, and there are only a few other concession stands/food service locations on the boardwalk. Nevertheless a former school friend owns a marketing agency and told your friend that he can guarantee him more customers per hour if he would enter an annual marketing agreement with his company costing an additional monthly service fee. Would it be a good idea to increase the marketing budget? See figures page for key changes.

The owner is also unsure if he should sell beer at the grill. He thinks he can sell a beer to many customers (except on Sundays when no beer can be sold) and it seems to be lucrative because beer is a high ticket item. Unfortunately your friend is afraid that he would cannibalize his soft drink sales with the beer customers (one soft drink less for every beer sold). He will also have to purchase a beer license from the county and his monthly insurance costs would go up. Should your friend offer beer to his customers? See figures page for key changes

Opening Month May Additional Cash Reserves $ 16,000 ITEM PRICE COST DEMAND Hot Dogs $4.00 $1.14 3/4 Burgers $6.00 $2.85 2/3 Fries $2.75 $1.35 5/8 Drinks $1.95 $0.85 1/1 Hours daily (T-F) 9 Hourly customers (T-F) 11 Hours daily (S-S) 14 Hourly customers (S-S) 16 Employees (T-F) 1 Employees (T-F) 2 EXPENSE MONTHLY Mgr. Yearly $45,000 Kiosk Monthly Rent $4750 Asst. Yearly $30,000 Electricity Monthly $389 Hourly Wage $10.75 Advertising Monthly $800 Growth Rate 2.25% Telecom Monthly $260 Winter Sales Decrease 40% Insurance Monthly $355 Summer Sales Increase 75% Owner's Equity $25,000 Tax Rate 33% Kitchen Equipment $4550 POS System $4000 Initial Inventory $5200 Initial Ads $ 1900 Store Fixtures $6195 Licenses $3300 Rent Deposit $3000 Initial Insurance $475 Weeks in a Month 4.2 Loan APR% and Term 9.5% 6 Years Marketing Additional $1200 Marketing Additional 3 Advertising Expense Customers per hour Beer License $3500 Beer Insurance increase $400 Beer Demand 1/3 Beer Cost $4.00 Beer Price $7.00 Every Beer sold decreases Soda sales by 1 except on Sunday when no Beer is sold Opening Month May Additional Cash Reserves $ 16,000 ITEM PRICE COST DEMAND Hot Dogs $4.00 $1.14 3/4 Burgers $6.00 $2.85 2/3 Fries $2.75 $1.35 5/8 Drinks $1.95 $0.85 1/1 Hours daily (T-F) 9 Hourly customers (T-F) 11 Hours daily (S-S) 14 Hourly customers (S-S) 16 Employees (T-F) 1 Employees (T-F) 2 EXPENSE MONTHLY Mgr. Yearly $45,000 Kiosk Monthly Rent $4750 Asst. Yearly $30,000 Electricity Monthly $389 Hourly Wage $10.75 Advertising Monthly $800 Growth Rate 2.25% Telecom Monthly $260 Winter Sales Decrease 40% Insurance Monthly $355 Summer Sales Increase 75% Owner's Equity $25,000 Tax Rate 33% Kitchen Equipment $4550 POS System $4000 Initial Inventory $5200 Initial Ads $ 1900 Store Fixtures $6195 Licenses $3300 Rent Deposit $3000 Initial Insurance $475 Weeks in a Month 4.2 Loan APR% and Term 9.5% 6 Years Marketing Additional $1200 Marketing Additional 3 Advertising Expense Customers per hour Beer License $3500 Beer Insurance increase $400 Beer Demand 1/3 Beer Cost $4.00 Beer Price $7.00 Every Beer sold decreases Soda sales by 1 except on Sunday when no Beer is sold