Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bully $7.00 Cowboy Vegetarian $5.75 $4.00 Revenue #tacos made Revenue Costs Profit un ion T lo = Constraints: Resources Resources Used Available boy Vegetarian wage

image text in transcribed
image text in transcribed
Bully $7.00 Cowboy Vegetarian $5.75 $4.00 Revenue #tacos made Revenue Costs Profit un ion T lo = Constraints: Resources Resources Used Available boy Vegetarian wage rate labor (mins/taco) total labor hours total labor costs ingredient cost/taco total ingredient costs 8 $3.10 IN $ L ODA IT + ol .5 cups 0.5 cup meat/taco total meat cheese/taco total cheese Sauteed Vegatables/taco Total sauteed vegetables 1 cup 2,500 oz 2.00 You just inherited a taco restaurant that specializes in Bully, Cowboy, and vegetarian tacos. You peruse the records and determine that each Bully taco generates $7 in revenue, each Cowboy taco generates $5.75 in revenue, and each vegetarian taco generates $4 in revenue, Bully tacos utilize 2 minutes of labor, the ingredients total $4 per taco, they use 2 ounces of meat each and 5 cup of cheese. Cowboy tacos utilize 1.25 minutes of labor, have ingredient costs of $3.10 per pizza, use 1.75 ounces of meat, and 5 cups of cheese. Vegetarian tacos utilize 2 minutes of labor, have an ingredient cost of $3.00 per taco, use zero ounces of meat, use 1 ounce of assorted sauted vegetables and use 1 cup of cheese. Your wage rate for laboris $10/hour. Your total supplies of meat each week is 7,500 ounces. Your total cheese supplies each week are 2,500 cups. Your total sauted vegetable supply each week is 2,000 ounces. Finally, the hours your restaurant is open each week is 72 and you employ four workers for each hour you are open. No sauteed vegetables are used for any tacos other than the vegetarian. Use the information above to set up your Excel sheet to determine the number of Bully, Cowboy, and vegetarian tacos to make each week that will maximize profit while staying within the specified constraints (using Solver). This question is worth 25 points. Partial credit can be obtained

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Auditing Practices In Africa

Authors: Mariaan Roos, Lesley Stainbank

1st Edition

1928357431, 978-1928357438

More Books

Students also viewed these Accounting questions

Question

5. Have you stressed the topics relevance to your audience?

Answered: 1 week ago