You have recently been engaged by Dominicâ€™s Italian Cafe to evaluate the financial impact of adding g
77 % (289 Review)
You have recently been engaged by Dominicâ€™s Italian Cafe to evaluate the financial impact of adding gourmet pizza items to the menu. A survey of the clientele indicates that demand for the product exists at an average selling price of $18 per pizza. Fixed costs related to new equipment would be $12,000 per month. Variable costs for ingredients, labor, and electricity for the oven would average $6 per pizza. You decide that a good starting point is to conduct an initial break-even analysis on the new project. Knowing that many commercial Internet companies provide free downloads or online demos of their products for your evaluation and testing pleasure, you decide to conduct the break-even analysis using break-even calculators that have been located at several Web sites. Required: a. Calculate the break-even point in pizzas per month and print your results using the online break-even analysis tools at each of the following Web sites: 1. www.entrepreneur.com/calculators/breakeven.html 2. www.steinermarketing.com/calc_break_even.htm 3. www.anz.com/aus/Small-Business/Tools-Forms-And-Guides/Benchmark- Your-Business/Breakeven-Analyser/default.asp b. Calculate the break-even point in pizzas per month and print your results using the break-even chart analysis spreadsheet available at the following Web site: 1. Go to www.jaxworks.com, the Small Business Spreadsheet Factory. 2. Click on the ?oDownloads?? link to access the list of free spreadsheets and other files. 3. Scroll down the file list and open the file ?oBreakeven Simple Chart Analysis?? for Excel. c. Write a comparative analysis of each of the four tools that you used to calculate the break-even point. You might discuss strengths, weaknesses, usefulness, and user interaction for each tool. d. Dominicâ€™s now is interested in the amount of operating income available from the gourmet pizza operation if sales are initially expected to be 2,000 pizzas each month. Calculate the operating income and print your results using the Excel file ?oContribution Income Analysis?? available at www.jaxworks.com. e. Dominicâ€™s now would like to understand the effect on operating income if certain changes in costs or volume occur. Use the ?oContribution Income Analysis?? Excel spreadsheet to evaluate each of the following independent cases assuming sales are initially expected to be 2,000 pizzas each month: 1. Selling price is decreased by 10%, and pizza sales are expected to increase by 5%. 2. Selling price is increased to $20, and pizza sales are expected to decrease by 20%. 3. Higher-quality ingredients are used at a cost increase of $2 to $8 per pizza, and pizza sales are expected to increase to 2,200 pizzas per month. 4. A more efficient pizza oven is available that would reduce the electricity used in baking each pizza. Variable costs would be reduced to $5 per pizza. The more efficient oven would increase the fixed costs to $15,000 per month. f. Write a memo to Dominicâ€™s explaining the results of your analysis.
Your answer will be ready within 2-4 hrs. Meanwhile, check out other millions of Q&As and Solutions Manual we have in our catalog.
Crazy for Study is a platform for the provision of academic help. It functions with the help of a team of ingenious subject matter experts and academic writers who provide textbook solutions to all your course-specific textbook problems, provide help with your assignments and solve all your academic queries in the minimum possible time.
Disclaimer: Crazy For Study provides academic assistance to students so that they can complete their college assignments and projects on time. We strictly do not deliver the reference papers. This is just to make you understand and used for the analysis and reference purposes only.