Homework Help is Here – Start Your Trial Now!
Business
Accounting
A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato

A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato

Principles of Accounting Volume 2
Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter8: Standard Costs And Variances
Section: Chapter Questions
Problem 1EB: Bristol is developing material standards for her company. The operations manager wants grade A...
See similar textbooks
icon
Related questions
Question

Bakery

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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make.

Use Solver to calculate the optimal number of dozens of product to make. Be sure to save your work.
A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato
Transcribed Image Text:A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS