Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Produced in dozens Demand in dozens Price/Dozen Cost/Dozen Profit/Dozen Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours Flour Sugar Eggs Butter Chocolate Chips Labor Hours Profit Cookies 50 600 $2.50 $1.80 $0.70 0.5 0.3 0.4 0.2 0.5 0.5 50 95 Cupcakes Muffins Donuts 50 50 50 500 400 300 $312.50 $3.25 $1.50 $1.75 Used Available 337.5 2000 105 500 11 220 1200 50 500 600 800 1.25 0.75 1 0.3 0 0.4 $3.50 $2.00 $1.50 1.75 0.3 1 0.25 0.5 0.4 $5.00 $2.70 $2.30 3.25 0.75 2 0.25 0 0.6 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. Produced in dozens Demand in dozens Price/Dozen Cost/Dozen Profit/Dozen Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours Flour Sugar Eggs Butter Chocolate Chips Labor Hours Profit Cookies 50 600 $2.50 $1.80 $0.70 0.5 0.3 0.4 0.2 0.5 0.5 50 95 Cupcakes Muffins Donuts 50 50 50 500 400 300 $312.50 $3.25 $1.50 $1.75 Used Available 337.5 2000 105 500 11 220 1200 50 500 600 800 1.25 0.75 1 0.3 0 0.4 $3.50 $2.00 $1.50 1.75 0.3 1 0.25 0.5 0.4 $5.00 $2.70 $2.30 3.25 0.75 2 0.25 0 0.6
Expert Answer:
Answer rating: 100% (QA)
Profit Calculation Each product has a selling price and a cost associated with it The difference bet... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The marketing vice president for Baxter Surgical Supplies Incorporated (BSSI), a manufacturer and distributor of medical supplies and equipment, was reviewing the company's method of compensation at...
-
Sound waves with frequency 3000 Hz and speed 343 m/s diffract through the rectangular opening of a speaker cabinet and into a large auditorium of length d = 100 m. The opening, which has a horizontal...
-
Kishkumen Company had the following capital structure at December 31, 2011 and 2012: The following additional information is available. (a) The conversion terms of the preferred stock and bonds at...
-
Air enters a nozzle steadily at 50 psia, 140F, and 150 ft/s and leaves at 14.7 psia and 900 ft/s. The heat loss from the nozzle is estimated to be 6.5 Btu/lbm of air flowing. The inlet area of the...
-
Suppose that revenue has the form where \(h\) can be chosen and \(x\) and \(y\) are random variables. The distribution of \(x\) and \(y\) is symmetric about \((0,0)\); that is, \(-x,-y\) has the same...
-
Under what conditions of bond issuance does a discount on bonds payable arise? Under what conditions of bond issuance does a premium on bonds payable arise?
-
A. Can we use human capital theory to explain "Age-Discrimination"? If so, how? B. Why do some firms prefer to hire younger workers, especially for entry level positions? C. Why do some firms...
-
Alpha Company receives.A note from one of its customers. It is a $20,000 60 day note at 9% interest (ordinary time). What will be the maturity value of the note when it is collected?
-
Write a for loop that prints firstNumber...-10. Ex: If the input is: -3 the output is: -3 -2 -1 0 import java.util.Scanner; public class ForLoops { public static void main(String[] args) { int...
-
Joe Graduated in Engineering 5 years ago. His Employer will give him a raise of $8,000 per year if he passes the PE exam. (10 pts (5 pts ea.)) a) Over a 30-year career, what is the present worth of...
-
What is the formula for calculating the heat transfer in a chemical process?
-
Why are Robinson and Winkel Triple considered a 'compromise' projections?
-
Two countries, Thailand and Vietnam, began to trade in two Goods in two goods, Cars and Motorcycles. We have Vietnam, where they produce 180 Cars and 100 Motorcycles per year. We also have Thailand,...
-
how well Amazon.com is currently performing and give examples of how it has used OB to enhance its effectiveness.
-
Design an integrator to integrate the signal in the frequency range of 1KHz to 20 KHz. Sketch the output for the sine wave of frequency of (a) 100Hz and (b) 10KHz
-
As water moves through the hydrologic cycle, water quality changes are common because of natural phenomena or anthropogenic pollution. Using Figure 11.1, describe how water-quality changes occur...
-
Leesburg, LLP, is evaluating the performance of three divisions: Lake, Sumter, and Poe. Using the data that appear on the next page, compute the economic value added by each division, and comment on...
-
At the beginning of last year, Diekow Productions set budgeted fixed overhead costs at $456,000. During the year, actual fixed overhead costs were $500,000. Using this information and the applicable...
-
Colletta Manufacturing purchased land next to its factory to be used as a parking lot. The expenditures incurred by company were as follows: purchased price, $600,000; brokers fees, $48,000; titles...
-
Consider a two-level system, with basis \(|1angle,|2angle\), and in this basis, a Hamiltonian with elements \(\left(\begin{array}{ll}1 & 1 \\ 1 & 1\end{array} ight)\). Use the first form of the...
-
Use the practical variational method for the same harmonic oscillator ground state energy, with trial wave function \(\psi_{a}(x)=e^{-a y^{2}}\).
-
Use the Ritz variational method for the harmonic oscillator, with trial wave functions \(\psi_{1}(x)=\) \(e^{-y^{2} / 2}, \psi_{2}(x)=e^{-y^{2}}, \psi_{3}(x)=e^{-2 y^{2}}\), where \(y=x \sqrt{m...
Study smarter with the SolutionInn App