Home / Questions / Problem 1 Angelo Cappellini owner of Pop’s Pizza is trying to get a handle on the costs fo...
Problem 1 Angelo Cappellini, owner of Pop’s Pizza, is trying to get a handle on the costs for his business. Angelo estimates the fixed costs per year to be $130,000, based on his lease, utilities, employee costs, and other overhead costs. He has calculated his variable cost for each unit of pizza produced to be $3. a. [Sheet ‘Problem 1a’] Angelo is considering selling pizzas for $8 each. At that unit price, how many pizzas will he need to sell to break even (Profit is the difference between Revenue and Total Cost, and breaking even occurs when Profit is $0)? Use Goal Seeking in Excel to find your answer. b. [Sheet ‘Problem 1b’] Angelo’s business is open 11 hours per day 300 days per year, and he sells an average of 9 pies per hour. Assuming he sells pizzas at $8 each, will Angelo turn a profit? If so, how much profit will Angelo make? Problem 2 Due to rising costs, Angelo is exploring the possibility of changing the price of his pizzas, but he knows that doing so may have an impact on the amount pizzas he sells and as such on his profits. Angelo has figured out that his fixed costs have increased to $135,000 and his variable cost for each pizza has risen to $3.15. The ‘Problem 2’ sheet in your Excel workbook has the input values for a Data Table that shows profitability based on different Unit Prices and Quantities Sold. After creating your data table, apply Conditional Formatting that highlights any profits below $0 red, any profits between $0 and $15000 yellow, and profits above $15000 green.
Feb 10 2020 View more View Less
Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.52 million. The fixed asset will be de...
May 29 202015. A monopsony hires ____________ workers than that would be hired in a competitive labor market.a. moreb. fewerc. the same number of d. the highest number of
May 04 2021Aisha has a 401(k) retirement plan through her employer. She earns a salary of $70,000/year. Her employer will match her contributions âdollar-for-dollarâ up to 5% of...
May 14 2021What ethical conflicts may exist if business employees fly on certain airlines just to receive benefits for their personal frequent-flyer programs?
Jul 03 2021What is the neoclassical and behavior perspective on people's food consumption choices?
Jul 09 2021Glen Smith contracted with Dave Watson, a common carrier, to transport 720 hives of live bees along with associated equipment from Idabel, Oklahoma, to Mandan, North Dako...
Aug 04 2021Apply the inverse transformation method as indicated below to generate three random observations from the uniform distribution between −10 and 40 by using the following u...
Aug 06 2020Unlike saturated fatty acids, the tails of unsaturated fatty acids incorporate one or more ________.a. phosphate groupsb. glycerolsc. double bondsd. single bonds
Jun 27 20214- Question 3 [Soalan 3] a) Xezton Co. is an electronic manufacturing company supplying components to a computer production company. In peak seasons, a container of parts...
Apr 11 2021Define a matrix organization.
Apr 18 2021