Question: possibly I am man aging a store. there is a kind of ca ke (A) that requires 200g of flo ur, 25g of fat, and

possibly I am man aging a store. there is a kind of ca ke (A) that requires 200g of flo ur, 25g of fat, and 4 e ggs, and another type of ca ke (B) that requires 100g of flo ur, 50g of fat, and 5 eggs.Today, I have 5kg of flo ur, 1kg of fat, and 150 e ggs in the store. Assume that there is no shortage of the other ingredients used in making the cakes. The profits of cakes A and B are $8 per unit and $12 per unit, respectively. Suppose I want to make at least 30 cakes today regardless of the type. postulating that every cakes made today can be sold, how many cakes A and B should be made to maximize your total daily profit?

-Formulate the problem into a linear program, and find the optimal solution using Excel solver.

-Find the shadow prices for flour, fat, and egg using the Excel solver and briefly interpret their economic implications.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Crane Library, a nonprofit organization, presented the following statement of financial position and statement of activities for its fiscal year ended February 28, 2024. Assets Current Assets Cash...

Can you please show the excel for this. possibly I am man aging a store. there is a kind of ca ke (A) that requires 200g of flo ur, 25g of fat, and 4 e ggs, and another type of ca ke (B) that...

Develop and present chapter 1 (PM Using Earned Value) from the text. You will need to provide an activity and/or post a few questions from the chapter to be discussed. You will need to present the...

Hewlett-Packard's Global Account Management Hewlett-Packard, one of the Silicon Valley pioneers, was one of the first B2B companies to global account management structure for their major...

undefined PART 2 ORGANIZATIONAL PURPOSE AND STRUCTURAL DESIGN 84 marketing, not only on the home market but also as a step towards building up an export division. 'By introducing a divisional...

Allegheny Ludlum Steel! Question: What is your overall evaluation of Allegheny Ludlum Steel's productivity improvement program? Discuss the productivity improvement program at Allegheny Ludlum in...

Yum Deli operates a chain of 10 hospitals in the Los Angeles area. Its central food-catering facility, Yum - man, prepares and delivers meals to the hospitals. It has the capacity to deliver up to...

I need four strong questions based on this reading 134 AT THE DARK END OF THE STREET Martin Luther King, Jr., later called the "thingification" of white supremacy. By walking hundreds of miles to...

The Author provides several plausible options for strengthening a company's competitive position. I would like for each of you to look closely at vertical integration strategies. Pick one of the two...

Just about everyone who has a smartphone wants to be able to bring it to work and use it on the job. And why not? Employees using their own smart- phones would allow companies to enjoy all the same...

What reinvestment rate assumptions are built into the NPV, IRR, and MIRR methods? Give an explanation (other than because the text says so) for your answer.

The partial pressure of oxygen in equilibrium with pure liquid lead and pure liquid PbO at 1200 K is 3.83 x 10-9 bar. If SiO2 is added to the liquid PbO such that equilibrium po, for the pure...

Which rule is included in the Code of Professional Conduct? A . Encroachment. B . Incompatible Occupations. C . Offers of Employment. D . Integrity and Objectivity.

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...