Could you please help me solve this on excel with excel formulas? Samantha Kelly, a student at OU, plans to open a barbegue stand inside OU's Milam stadiumduring home games. There are seven home games scheduled for the upcoming season. Thefootball season is 14 weeks or 98 days long. She must pay the OU athletic department avendor's fee of $3,000 for the season. Her stand and other equipment will cost her $2,500 forthe season. She estimates that each chopped beef brisket sandwich she sells will cost her$1.75. She has talked to friends at other universities who sell food at games. Based on theirinformation and the athletic department's forecast that each game will sell out, she anticipatesthat she will sell approximately 675 chopped beef brisket sandwiches during each game.A) What price should she charge for a chopped beef brisket sandwich in order to break even forthe season.B) Write an analysis of your calculations and discuss what Samantha should do based on yourcalculations.

Break-even point: A point of sale where the total revenue generated by the company is equal to the…

A) What price should she charge for a chopped beef brisket sandwich in order to break even for the season. B) Write an analysis of your calculations and discuss what Samantha should do based on your calculations.

A) What price should she charge for a chopped beef brisket sandwich in order to break even for the season. B) Write an analysis of your calculations and discuss what Samantha should do based on your calculations.

Business Its Legal Ethical & Global Environment

10th Edition

ISBN:9781305224414

Author:JENNINGS

Publisher:JENNINGS

Chapter2: Business Ethics And Social Responsibility

Section: Chapter Questions

Problem 8QAP

See similar textbooks

Similar questions

Annie Russell, a student at Tech, plans to open a hot dog stand inside Tech’s football stadium during home games. There are seven home games scheduled for the upcoming season. She must pay the Tech athletic department a vendor’s fee of $3,000 for the season. Her stand and other equipment will cost her $4,500 for the season. She estimates that each hot dog she sells will cost her $0.35. She has talked to friends at other universities who sell hot dogs at games. Based on their information and the athletic department’s forecast that each game will sell out, she anticipates that she will sell approximately 2,000 hot dogs during each game. What price should she charge for a hot dog in order to break even?
Joe sends a check for $218 to the University by July 1 of every year to cover the cost of two tickets for each of the 7 home games plus $50 for a parking permit. Joe has difficulty finding friends to accompany him to the games. However, he is adamant that he must go to the games because he has paid for the tickets. Friends insist that the cost of the tickets is a sunk cost and that the decision should be based on future costs that would be different between alternatives – going to the game and not going to the game. Friends have calculated the fuel for the 6-hour round trip costs $15 and two meals while away from home for the game can easily cost $30 or more. Required Write a list to Joe outlining the relevant costs associated with a trip to the game.
On December 15, Judy wrote a letter to David stating that she would sell to David all of the mine-run coal that David might wish to buy during the next calendar year for use at David’s factory, delivered at the factory at a price of $30.00 per ton. David immediately replied by letter to Judy, stating that he accepted the offer, that he would purchase all of his mine-run coal from Judy, and that he would need two hundred tons of coal during the first week in January. During the months of January, February, and March, Judy delivered to David a total of seven hundred tons of coal, for all of which David made payment to Judy at the rate of $30.00 per ton. On April 10, David ordered two hundred tons of mine-run coal from Judy, who replied to David on April 11 that she could not supply David with any more coal except at a price of $38.00 per ton delivered. David thereafter purchased elsewhere at the market price, namely $38.00 per ton, all of his factory’s requirements of mine-run coal for…
Henrietta, the owner of a very successful hotel chain in the Southeast, is exploring the possibility of expanding the chain into a city in the Northeast. She incurs $60,000 of expenses associated with this investigation. Based on the regulatory environment for hotels in the city, she decides not to expand. During the year, she also investigates opening a restaurant that will be part of a national restaurant chain. Her expenses for this are $54,400. She proceeds with opening the restaurant, and it begins operations on May 1. Determine the amount that Henrietta can deduct in the current year for investigating these two businesses. In your computations, round the per-month amount to the nearest dollar and use rounded amount in subsequent computations. a. The deductible amount of investigation expenses related to expansion of her hotel chain into another city? b. The deductible amount of investigation expenses related to opening a restaurant?
To support herself while attending school, Daun Deloch sold stereo systems to other students. During the first year of operations, Daun purchased the stereo systems for $260,000 and sold them for $370,000 cash. She provided her customers with a one-year warranty against defects in parts and labor. Based on industry standards, she estimated that warranty claims would amount to 2 percent of sales. During the year, she paid $4,020 cash to replace a defective tuner. Requireda. Prepare an income statement and statement of cash flows for Daun’s first year of operation. b. Based on the information given, what is Daun’s total warranties liability at the end of the accounting period?
On March 1, Marquette is approached by the developer of a large subdivision who wants to install an invisible fence in the yard of 1,200 homes he is constructing. The developer will contract with Marquette for the 1,200 fences on the condition that they are delivered within 30 days (March 31). This is not good timing for Marquette since they have recently signed a contract with Home Warehouse, a national home improvement chain and have been working at 100% capacity for several months. If Marquette accepts the builder’s order, it will lose 1,200 units that would normally be sold to one of its existing customers. When they tell the developer that they do not believe they can fill his order, he offers to reimburse the company for his “share” of the fixed manufacturing costs and will pay a $5,000 “bonus” on delivery. Since the sale to the developer will not incur any variable marketing costs, Marquette reconsiders accepting the developer’s order. What impact will accepting this order have…
Jenny Walters, who owns a real estate agency,bought an old house to use as her business office. Shefound that the ceiling was poorly insulated and thatthe heat loss could be cut significantly if six inchesof foam insulation were installed. She estimated thatwith the insulation, she could cut the heating billby $80 per month and the air-conditioning cost by$70 per month. Assuming that the summer seasonis three months (June, July, and August) of the yearand that the winter season is another three months(December, January, and February) of the year, howmuch can Jenny spend on insulation if she expects tokeep the property for five years? Assume that neitherheating nor air-conditioning would be required duringthe fall and spring seasons. If she decides to install theinsulation, it will be done at the beginning of May.Jenny’s interest rate is 6% compounded monthly.
To support herself while attending school, Daun Deloch sold stereo systems to other students. During the first year of operations, Deloch purchased the stereo systems for $138,000 and sold them for $258,000 cash. She provided her customers with a one-year warranty against defects in parts and labor. Based on industry standards, she estimated that warranty claims would amount to 6 percent of sales. During the year, she paid $1,480 cash to replace a defective tuner. Required a-1. Prepare an income statement for Deloch’s first year of operation. a-2. Prepare a statement of cash flows for Deloch’s first year of operation.
At Little Green Apple Produce the owner is considering buying a new large walk in cooler for fruits and vegetables. The new cooler cost $150,000. The annual maintenance cost will be $7,000 starting in year two (the first year will be covered under warrantee). An additional employee will be needed to stock the cooler. The employee will make $16/hr, and start part-time at 20 hours per week. Sale of produce will increase by $100,000 in year one and an additional 10% in year two and 15% in year three. The cost of produce will increase $30,000 in year one and is variable with sales. The part-time employees hours will vary based on additional sales in years two and three. The employee will receive raises of 4% annually and electricity will increase 3% a year. There is no inflation on any other item. Based on this information prepare a pro forma and calculate the project NPV using a 9% discount rate/hurdle rate and calculate the IRR. State if the project should be expected or rejected.…
Brittany is co-oping this semester at Regency Aircraft, which customizes the interiors of private and corporate jets. Her first assignment is to developthe specifications for a new machine to cut, shape, and sew leather or vinyl covers and trims. The first cost is not easy to estimate due to many options,but the annual revenue and M&O costs should net out at $15,000 per year over a 10-year life. Salvage is expected to be 20% of the first cost. Determine what can be paid for the machine now to recover the cost and an MARR of 8% per year under two scenarios:I: No outside revenue will be developed.II: Outside contracting will occur with estimated revenue of $10,000 the first year, increasing by $5000 per year thereafter. Solve using (a) tabulated factors, and (b) a spreadsheet and the GOAL SEEK tool.
Staci Valek began dabbling in pottery several years ago as a hobby. Her work is quite creative, and it hasbeen so popular with friends and others that she has decided to quit her job with an aerospace company andmanufacture pottery full time. The salary from Staci’s aerospace job is $3,800 per month.Staci will rent a small building near her home to use as a place for manufacturing the pottery. Therent will be $500 per month. She estimates that the cost of clay and glaze will be $2 for each finishedpiece of pottery. She will hire workers to produce the pottery at a labor rate of $8 per pot. To sell herpots, Staci feels that she must advertise heavily in the local area. An advertising agency states that it willhandle all advertising for a fee of $600 per month. Staci’s brother will sell the pots; he will be paid acommission of $4 for each pot sold. Equipment needed to manufacture the pots will be rented at a costof $300 per month.Staci has already paid the legal and filing fees…
Humana Hospital Corporation installed a new MRI machine at a cost of $750,000 this year in its medical professional clinic in Cedar Park. This state-of-the-art system is expected to be used for 5 years and then sold for $125,000. Humana uses a return requirement of 15% per year for all of its medical diagnostic equipment. As a bioengineering student currently serving a coop semester on the management staff of Humana Hospital Corporation in Louisville, Kentucky, you are asked to determine the minimum revenue required each year to realize the expected recovery and return. If the AOC is expected to be $80,000 per year, what is the total revenue required to provide for recovery of capital, the 15% return, and the annual expenses? -258917 -343654 -285197 -334654