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?
5) Your t-shirt company currently uses a manual printing system to put designs on blank shirts (all equipment is paid for). The cost of goods sold is $8 and the retail price for the shirts is $25. You currently print 11,000 shirts/year with this equipment and that is the maximum capacity. You are considering investing in new equipment. You came across a semi-automated printing system for $30,000, plus you'll need to spend $5,000 for the electrician to update wiring and connect the equipment. To break even in one year, how many (total) shirts would you need to print next year?
please answer with proper explanation. i will give you upvote. Describe each component. What are the five functions that these components provide?
What do we mean by "High-volume products" and "Low-volume products"? Do "High-volume products" mean "easy to produce the product"? and "Low-volume products" mean "difficult to produce the product"? If "Yes," can we say the overhead cost will be less when we produce low-volume products than high-volume products?
Ian's monthly car payment is $292.34 Ian pays $112.98 every month for car insurance and he estimates he spends an average of $20 per month on car maintenance ends car gets 33 miles per gallon gas cost and 3.4 per gallon and Ian drives an average of about 873 miles per month estimate how much Ian spends on his transportation cost each month round your answer to the nearest whole dollar
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 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 (%)
A bakery sells pretzels. The fixed costs come to $8,750.00 per month. It costs 25 cents to make each pretzel, and the bakery charges $1.50 per pretzel. How many pretzels do they have to sell to break-even.
A firm produces three products. Product A sells for $60; its variable costs are $20. Product B sells for $200; its variable costs are $120. Product C sells for $25; its variable costs are $10. The forecasted sales (demand) for firms products are; 1000 units of A, 2000 units of B, and 10,000 units of C. The firm has fixed costs of $320,000 per year. Consider yourself as newly employed Operations Manager, determine the break-even point of the firm.
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