Johnson's Artisan Bakery isexperimenting with two new croissantrecipes. One recipe calls for 302.5 gramsof bread flour and 30 grams of butter,while the other calls for 375 grams ofbread flour and 43 grams of butter. Thefirst recipe would yield $2.5 percroissant, and the second would yield$3.2 per croissant. Although the chefslike both recipes, they agree that sincethe second recipe requires more butter,they should probably only make half asmuch as the first. On a typical day,Johnson's would stock 20 kilograms ofbread flour and 2 kilograms of butter.Formulate a linear programming modelthat maximizes the profit.

Linear programming model helps to identify the optimal value based on the consideration of all given…

Answered: Johnson's Artisan Bakery is…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

George Fine, owner of Fine Manufacturing, is consideringthe introduction of a new product line. George has consideredfactors such as costs of raw materials, new equipment, andrequirements of a new production process. He estimates that thevariable costs of each unit produced would be $8 and fi xed costswould be $70,000.(a) If the selling price is set at $20 each, how many unitshave to be produced and sold for Fine Manufacturingto break even? Use both graphical and algebraicapproaches.(b) If the selling price of the product is set at $18 per unit,Fine Manufacturing expects to sell 15,000 units. Whatwould be the total contribution to profi t from this productat this price?(c) Fine Manufacturing estimates that if it off ers the productat the original target price of $20 per unit, the companywill sell about 12,000 units. Which pricing strategy—$18per unit or $20 per unit—will yield a higher contributionto profi t?(d) Identify additional factors that George Fine shouldconsider in deciding…
2. Analyze the situation and answer the following questions. Ed and Barbara Bonneau started their wholesale sunglass distribution firm 30 years ago with $1,000 of their own money and $5,000 borrowed from a country banker in Ed’s hometown. The firm grew quickly, selling sunglasses and reading glasses to such companies as Wal-Mart, Eckerd Drugs, and Phar-Mor. In addition, the Bonneaus enjoyed using the company to do good things. For example, they had a company chaplain, who was available when employees were having family problems, such as a death in the family.Although the company had done well, the market had matured recently and profit margins narrowed significantly. Wal-Mart, for example, was insisting on better terms, which meant significantly lower profits for the Bonneaus. Previously, Ed had set the prices that he needed to make a good return on his investment. Now, the buyers had consolidated, and they had the power. Ed didn’t enjoy running the company as much as he had in the…
Williams & Williams Co. produces plastic spray bottles and wants to earn a before-tax profit of$200,000 next quarter. Variable cost is $0.50 per bottle, fixed costs are $400,000, and the selling priceis $1 per bottle. How many bottles must the company sell to meet its profit goal?
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
4.1REQUIREDStudy the information given below and calculate the following if the sales manager’s proposal is accepted:4.1.1 Break-even quantity.4.1.2 The number of units that must be sold to achieve the company’s profit objective. INFORMATIONSirloin Enterprises manufactures a product that sells for R9 each. The company presently produces and sells 90 000 units per year. Total variable manufacturing costs and selling costs are R405 000 and R81 000 (10% of sales) respectively. Fixed costs are R226 440 for manufacturing overheads and R97 200 for selling and administrative activities.The sales manager has proposed that the price be increased to R10.80 per unit. The company’s profit objective is 10% of sales. 4.2 ENO Ltd, a pharmaceutical company, is seeking finance for the development of a vaccine aimed at reducing the spread the Corona virus. The company is seeking funding only from the public in the form of equity as well as long-term borrowing.In light of the above, critically discuss…
The Ace Company sells a single product at a budgeted selling price per unit of $20. Budgeted fixedmanufacturing costs for the coming period are $10,000, while budgeted fixed marketing expenses forthe period are $24,000. Budgeted variable costs per unit include $2 of selling expenses (commission)and $4 of manufacturing costs. What is the budgeted operating income if the anticipated sales volumefor the period is (1) 10,000 units, and (2) 15,000 units? (Round answers to the nearest whole number.)
Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. * a. 75 b. 480 c. 500 d. 20 2. The amount of your product that you will need to produce and sell to cover total costs of production. * a. Break even sales volume b. Sales volume percentage c. Sales volume
Note :write the equations seperately A firm is making two products A & B. Each unit of A incurs a cost of production to the tune of $150 and that of B incurs a cost of $200. Product A carns a profit of $15/unit and B gets $20/unit. The estimated monthly demand of both A & B is at maximum 500 units. Monthly production budget is set at $50.000.How many units of A & B should the firm make in order to maximize profit. Conduct sensitivity analysis and answer the following questions: 1. State the optimal solution. 2. What is the objective function value? 3. Find out the range of profit for A in the objective function for which the above solution remains optimal.
6. Laura is trying to decide whether to sell her knitted hats on Etsy, at a holiday bazaar, or in a local boutique. Demand could be 0 hats/month, 10 hats/month, or 20 hats/month. Given the payoff matrix below, what is her decision under equally likely? Demand = 0 Demand = 10 Demand = 20 Etsy -$70 $80 $230 Bazaar -$60 $90 $240 Boutique -$80 $70 $220 Select one: a. Etsy and boutique. b. Etsy only. c. Etsy and bazaar. d. Bazaar and boutique. e. All 3 are equally good. f. Bazaar only. g. None of them are good options. h. Boutique only.
Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 17 and changing the objective function coefficient for Product_3 to 10? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 12 7 1E+30 $B$3 Product_2 175 0 8 1E+30 9 $B$4 Product_3 0 −1.5 8 3 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 Fill the blanks Applying the 100% rule _________________ because the total change in the objective function coefficients ______________ 100%
Louis Clark, the new administrator for the surgical clinic, was trying to figure out how to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities expense based on square footage for each department, to allocate administration expense based on direct costs, and to allocate laboratory expense based on direct costs, and to allocate laboratory expense based on tests. What would the results be?
Widgetco produces widgets at plant 1 and plant 2. Itcosts 20x1/2 to produce x units at plant 1 and 40x1/3 toproduce x units at plant 2. Each plant can produce as manyas 70 units. Each unit produced can be sold for $10. Atmost, 120 widgets can be sold. Formulate an NLP whosesolution will tell Widgetco how to maximize profit.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS