Reference no: EM131430847
1. Antonio’s Pizza is considering adding hot wings to their menu. Under consideration are two options – Make the wings from scratch with uncle Tony’s secret sauce or Buy the wings frozen and already sauced from an outside supplier. For each of the two new options, the selling price to the customer will be $10.50 per dozen wings.
The Make option would require acquisition of a new stove top at a cost of $5,000. Cost per dozen wings are estimated as $2.00 for labor and $2.85 for ingredients.
The Buy option would require the acquisition of a fryer at a cost of $2,000. The cost to purchase the wings from an outside supplier would be $6.50 per dozen.
a. Set up spreadsheet models to calculate total profit for each option. Construct your models as demonstrated in the notes and podcasts.
Quantity sold is the decision variable - assume that every dozen made or purchased will be sold.
b. Use your models to answer the questions below (do separately for Make & Buy).
Note: only one model needs to be created for each option to complete all of these questions. Tables and graphs created for ii and iii will change when the model inputs are changed to do c. but if you have your Tables and graphs created correctly, they can be evaluated without issues.
If you are more comfortable copying the models to use for each question, make sure they are well organized and labelled clearly.
i. Use the Goal Seek function in Excel to determine the break-even quantity.
ii. Create a one-way table, using Excel’s Data/What-If/ Data Table tool, to demonstrate the sensitivity of profit to changes in selling price per salad. Use selling prices of 9.50, 10.00, 10.50, 11.00 and 11.50 in your tables.
iii. Create a graph of the sensitivity results from part ii. (scatterplot)
c. Graph the total Profit lines for both options on one graph showing how their profits change over a quantity range from 0 to 2,500 units. Set price back to $10.50 per unit for each option when determining input for this graph.
Discover your employees are stealing your office supplies
: You discover your employees are stealing your office supplies and a computer with a monitor and printer. How will you handle this? Internally within your business or call the police? How will you prevent it from happening in the future, including the..
|
Find an employment law case concerning
: Search the internet to find an employment law case concerning an alleged Title VII violation that was decided within the last 5 yrs. In one or two paragraphs, explain the main components of the case and state applicable federal, state, or local emplo..
|
What are the expected marginal costs
: Imagine that you are trying to decide whether to cross a street without using the designated crosswalk at the traffic signal. What are the expected marginal benefits of crossing?
|
What are some of the ethical dilemmas that can arise
: ed on the readings in Chapter 6, what are some of the ethical dilemmas that can arise due to: personal morality/religious beliefs; responsibility priorities; undertaking moral/social issues as part of business operations, etc.
|
Construct your models as demonstrated in notes and podcasts
: Antonio’s Pizza is considering adding hot wings to their menu. Under consideration are two options – Make the wings from scratch with uncle Tony’s secret sauce or Buy the wings frozen and already sauced from an outside supplier. Set up spreadsheet mo..
|
Earthlings to colonize the planet
: Mars rovers have collected enough data to give us a good picture of what the red planet is like. It has CO2, liquid water, strong sun light, and various minerals in the soil. If human decides to bring some earthlings to colonize the planet, what..
|
Identify which aspects of the law are negative incentives
: What behaviour is the Chinese government attempting to promote with these types of incentives? Identify which aspects of the law are negative incentives and which are positive incentives.
|
How much money would the person earn on average
: Suppose X is the amount of money a person earns in an hour where? p(X = $5) =0.2, p(X =$10) = 0.1, p(X=$15) =0.5 and p(X=$20) = 0.2. How much money would the person earn on average
|
Gene for cystic fibrosis
: Cystic fibrosis is an autosomal recessive condition. A couple who are both carriers (heterozygous) for the gene for cystic fibrosis have two children who have cystic fibrosis. N= noncystic fibrosis allele, n= cystic fibrosis allele
|