Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00

Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Mazoon Company sells 500 units resulting in $150,000 of sales revenue, $50,000 of variable costs, and $36,000 of :fixed costs. Breakeven point in units is None of the given answers .a O units 180 b O units 300 .c O units 72 d O units 100 .e O
You are thinking about opening an oil change shop. Your fixed costs will be $14,500 per month. You will charge customers $30 for a lube-oil-filter. The cost of materials is in addition to your fixed costs and is estimated at $10 per customer. How many customers must you have each month in order to break even?
Imagine designing a conjoint for your b-school's café. In particular, you're in charge of the daily pizza orders. Pizzas are tricky-while they're a simple food, they can be created in a zillion combinations. What factors should you test in terms of your fellow students' likely preferences? Wheat crust vs. white, thick vs. thin, plain cheese vs. sausage vs. sausage and green pepper vs. vegetarian (you get the picture). Design a conjoint that would result in identifying 2 or 3 popular slices that your café managers could order every morning. The student body knows you're responsi ble-how do you make most of them happy?
Parker Industries is a small company with a big name! Parker Industries is actually a one-person company that imports strands of LED lights from China and sells them through its website. Parker's only overhead is a storage unit for inventory that costs $125 a month and a $25 monthly fee for website hosting. Currently, Parker imports the lights for $.99 each (including inbound shipping) and sells them for $4.49. Parker also pays shipping expenses of $.50 per light strand. If Parker's shipping charges increased to $.75 a strand, what would happen? Breakeven volume would increase Variable cost would decrease Profit would increase Breakeven volume would decrease OO OO
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
a Tax Revenue ($) Refer to the above Laffer Curve diagram. Going into the sluggish U.S. economy of the early 1980s, economist Arthur Laffer and President Ronald Reagan maintained that that the economy was located at O tax rate d. O some level above tax rate b. O some level below tax rate b. O tax rate b. of Tax Rate (%)
Annie bought one dozen smartphones for 200,000 pesos with a discount of 5%. She sold half dozen at a price of 18,000 pesos per unit. However, a new model of smartphone became available in the market, so she sold the remaining half dozen at 12,000 pesos each unit. What was her profit or loss? Compute the following requirements: a. Gross profit rate b. Operating profit margin rate c. Net profit margin rate d. Return on investment
Ajax Manufacturing produces a single product, which takes 8.0 pounds of direct materials per unitproduced. Assume that it is currently at the end of the first quarter of the year, and there are 50,000pounds of material on hand. The company’s policy is to maintain an end-of-quarter inventoryof materials equal to 25 percent of the following quarter’s material requirements for production.How many units of product were produced in the first quarter of the year? Under the assumptionthat production will increase by 10 percent in the second quarter, what are the direct materialsrequirements (in pounds) for planned production in the second quarter?
please answer within 30 minutes.
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
Help me
One of the shortest,good definitios is meeting needs profitably