Reference no: EM131035633
Break-even analysis, CVP application using Internet tools 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.comicalc_break_even.htm
3. www.anz.com/aus/Small-Businessr/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 "Downloads" link to access the list of free spreadsheets and other files.
3. Scroll down the file list and open the file "Breakeven 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 "Contribution Income Analysis" available at www.jaxworks.com.
e. Dominic's now would like to understand the effect on operating income if cer¬tain changes in costs or volume occur. Use the "Contribution 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.
|
What does the income per billing percentage calculated
: Question - Based on your work in (2) above: (a) Would you recommend the adoption of ABC? Explain your answer. (b) What does the ‘income per billing' percentage calculated under the ABC approach tell you about these three accounting services
|
|
Operating leverage and break-even analysis
: OPERATING LEVERAGE AND BREAK-EVEN ANALYSIS Olinde Electronics Inc. produces stereo components that sell at P = $100 per unit. Olinde's fixed costs are $200,000, variable costs are $50 per unit, 5,000 components are produced and sold each year, EBI..
|
|
The arraylist class
: Create a class to represent a term in an algebraic expression. As defined here, a term consists of an integer coefficient and a nonnegative integer exponent. E.g.
|
|
Charge of developing system to perform high-volume
: You are in charge of developing a system to perform high-volume, repetitive processing of HMO group health insurance claims. Each claim must undergo 4 separate processing steps. Step 1 takes on average 85 seconds to complete. Step 2 takes on average ..
|
|
Calculate the break-even point in pizzas per month
: Calculate the break-even point in pizzas per month and print your results using the online break-even analysis tools - Calculate the break-even point in pizzas per month and print your results using the break-even chart analysis spreadsheet.
|
|
What is meant by an external entity in a process model
: Define what is meant by an external entity in a process model. How should an external entity
|
|
Constraints typically found when designing selection program
: What might happen with regard to turnover if staffing is not linked to the organization's strategy? In your view, are all elements of the design needed? What are the various constraints typically found when designing the selection program? How can th..
|
|
Degree of competition in the telephone industry
: When the Bell System was broken up, the old AT&T was split into a new AT&T and seven regional telephone companies. The specific reason for forcing the breakup was to increase the degree of competition in the telephone industry. AT&T had a monopoly..
|
|
Uses some form of the appeal to fear fallacy
: Please find a television commercial that uses some form of the "appeal to fear" fallacy and describe it. You shouldn't have to look for long. If you don't watch television you can do a search online for commercials.
|