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 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
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?
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?
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?
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 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.
Joint Products Choi Company manufactures two skin care lotions, Smooth Skin and Silken Skin,from a joint process. The joint costs incurred are $420,000 for a standard production run that generates 180,000 pints of Smooth Skin and 120,000 pints of Silken Skin. Smooth Skin sells for $2.40 perpint, while Silken Skin sells for $3.90 per pint.Required1. Assuming that both products are sold at the split-off point, how much of the joint cost of each production run is allocated to Smooth Skin using the relative sales value method?2. If no separable costs are incurred after the split-off point, how much of the joint cost of each productionrun is allocated to Silken Skin using the physical measure method method?3. If separable processing costs beyond the split-off point are $1.40 per pint for Smooth Skin and $0.90 perpint for Silken Skin, how much of the joint cost of each production run is allocated to Silken Skin usinga net realizable value method?4. If separable processing costs beyond the…
A chocolate maker has annual demand of 250,000 pounds per year. It costs $1.25 to store a pound of chocolate for a year, and $350 to produce a batch. Use the economic lot size 3. formula to find the number of batches to be produced annually. Round to the nearest whole number of batches.
Adidas is an athletic company designs and manufacturesseveral athletic things. Football is one of the company'sproducts that sells for $40 per unit. Total fixed costs relatedto the manufacturing of the football are $150,000 per monthand variables costs involved in manufacturing are $ 15 per unit. 1-Compute the number of footballs to be sold to earn atarget profit of $30.000.?
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.