Calculate the optimal number of dozens of product to make

Assignment Help Managerial Accounting

Reference no: EM132476843

Problem 1: 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	50	50	50	50
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		0.5	0
Labor Hours		0.5	0.4		0.4	0.6
		Used	Available
Flour	337.5			2000
Sugar	105			500
Eggs	220			1200
Butter	50			500
Chocolate Chips	50			600
Labor Hours	95			800
Profit	$312.50

Reference no: EM132476843

Questions Cloud

Determine and add all overhead amounts to obtain the total : Add all overhead amounts to obtain the total. Divide individual overhead amounts by budgeted production volume for each product to obtain overhead per unit

Characterize behavior of inflation in medium-run : If the level of expected inflation is formed so pe equals ?p?(-1), characterize the behavior of inflation in a medium-run equilibrium.

Growth of a nations standard of living : Property rights, how important is this for the growth of a nations standard of living?

Explain different ways in which californians can practice : List ALL of the differences between the U.S. federal government and the California state government in terms of the three branches (legislative, executive).

Calculate the optimal number of dozens of product to make : Complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make.

Explain competing solutions to the problem : Explain two competing solutions to this problem while addressing the responsibilities of each level of government (federal, state, and local) and the three.

Compute the accounts receivable turnover : Question - Selected data from Stuart Company. Compute the accounts receivable turnover for 2018. Compute the inventory turnover for 2018

What are the strengths of transformational leadership theory : What are the strengths and weakness of transformational leadership theory and leader-member theory (LMX)? How might your knowledge of the LMX theory help you.

Does the given website depict your topic accurately : Summarize the website and describe the important information presented. How does the information you find in the website compare to the information you have.

User Account

All Pages