4. XYZ Brownies is a culinary business that specializes in making brownie cakes with various flavors and variants, where the products are spread across various regions of East Java. XYZ Brownies only produces in one place, namely in Malang. During March 2022 XYZ Brownies made 18,000 Brownies. The current effective brownie production capacity is 22,000 brownies. During March in 1 week XYZ Brownies only produces from Monday - Friday. So that in 1 month only production for 20 days. In 1 day XYZ Brownies employs 3 people who are directly responsible for making brownies. In 1 day each worker each works for 8 hours. The production line required to make brownies is designed to produce 50 brownies per hour. Define A. What is the utilization and efficiency of the ability of the brownie production? B. What should XYZ Brownies do based on the result in number (a) ? C. If in April 2022 the company wants to increase efficiency to 100%, what strategy should XYZ brownies take, if it is planned to make brownies with the same production capacity as in March 2022, namely 22,000 Brownies?

4. XYZ Brownies is a culinary business that specializes in making brownie cakes with various flavors and variants, where the products are spread across various regions of East Java. XYZ Brownies only produces in one place, namely in Malang. During March 2022 XYZ Brownies made 18,000 Brownies. The current effective brownie production capacity is 22,000 brownies. During March in 1 week XYZ Brownies only produces from Monday - Friday. So that in 1 month only production for 20 days. In 1 day XYZ Brownies employs 3 people who are directly responsible for making brownies. In 1 day each worker each works for 8 hours. The production line required to make brownies is designed to produce 50 brownies per hour. Define A. What is the utilization and efficiency of the ability of the brownie production? B. What should XYZ Brownies do based on the result in number (a) ? C. If in April 2022 the company wants to increase efficiency to 100%, what strategy should XYZ brownies take, if it is planned to make brownies with the same production capacity as in March 2022, namely 22,000 Brownies?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please answer the following in an organized way and showing steps. Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table: Fliptop Model Tiptop Model Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 The profit for either model is $1,000 per lot. a. What is the linear programming model for this problem? b. Using Microsoft Excel's Solver, find the optimal solution. How many Fliptop models and how many Tiptop models should be produced? What is the maximum profit? c. Will there be excess capacity in any resource? Use Excel's Solver and run a sensitivity report to answer the following questions: d. Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called? e. What is the shadow price (dual price) for the plastic constraint and how…
For the linear program Max 2A+3B s.t 1A+2B≤6 5A+3B≤15 A,B≥0 Find the optimal solution using the graphical solution procedure. What is the value of the object function at the optimal solution?
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $12 $13 2 $9 $10 $9 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 500 900 700 If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many units of each…
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the optimal objective function value for this problem?
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 Which parameter is most sensitive to an increase in its value?
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the allowable range for the right-hand-side for Resource C?
The problem in Example 12.8 assumes that the heaviest demand occurs in the second (post-April) phase ofselling. It also assumes that capacity is higher in thesecond production opportunity than in the first. Supposethe situation is reversed, so that the higher capacity andmost of the demand occur in the first phase. Make somereasonable assumptions for the resulting input parameters, and then solve for the optimal production plan. Doyou get qualitatively different results? Which situationwould you rather face if you were ShirtTails?
Hot Oven daily requirements of 70 g of protein, 1 g calcium, 12 mg iron, and 3000 calories are needed for a balanced diet. The following foods are available for consumption with the cost and nutrients per 100 g as shown. protien (g) calories calcium(g) iron(mg) cost (ghc) brown bread 12.0 246 0.1 3.2 0.5 cheese 24.9 432 0.2 0.3 20 butter 0.1 793 0.03 0.0 1.0 baked beans 6.0 93 0.05 2.3 0.25 spinach 3.0 26 0.1 2.0 0.25 The objective of the Hot Oven is to find a balanced diet with minimum cost.a) Formulate a linear programming model for this problem. b) Use solver to find optimal solution and sensitivity report. c) Management have asked you to determine the optimal solution. Write your answer in a form of a report to be submitted to the management. d) Advice the management about objective function value corresponding to your answer in (b)
Max −A + 2B s.t. -2A + 3B ≤ 8 (Constraint 1) 6A - 2B ≤ 5 (Constraint 2) A + B ≤ 5 (Constraint 3) A ≥ 1 (Constraint 4) A, B ≥ 0 SHOW ALL CALCULATION STEPS a) Solve the LP Model using the graphical method. Label your graph completely (and upload your graph as a jpg). State your optimal solution and objective function value. b) Calculate the Slack/Surplus for each constraint. c) Calculate the Shadow/dual Prices for each constraint.
Objective Function: Maximize what? or Minimize what? Ana’s Café does a large lunchtime carry out business. The café offers two burrito specials: Mild and Spicy. The profit on one serving of Mild is $0.58, while the profit on one serving of Spicy is $0.45. Each serving of Mild requires 0.15 pounds of beef, 0.36 cups of beans, and 3 ounces of salsa. Each serving of Spicy requires 0.30 pounds of beef, 0.40 cups of beans, 2 ounces of salsa and 5 ounces of special hot sauce. Today, Ana checked her pantry and found out that she only has 8.5 pounds of beef, 13 cups of beans, 95 ounces of salsa, and 125 ounces of hot sauce available. Demand for both types of burritos is unlimited. What should Ana do for lunch?
Jenny Company produces two types of pants: long pants and short pants. The cost of making apair of short pants and a pair of long pants are RM 75 and RM 95 respectively. In one week, thecompany must produce at least 150 pants of each type. The minimum weekly production is 500pants. The short pants are sold for RM 120 each and the long pants for RM 150 each. Using thegraphical method, find:a. The number of short pants and long pants to be made in a week in order to minimise thetotal production cost.b. The profit made at the minimum weekly production cost.
For the linear program Max 4A + 5B s.t. 1A + 2B ≤ 6 7A + 5B ≤ 35 A, B ≥ 0 find the optimal solution using the graphical solution procedure. What is the value of the objective function at the optimal solution? at (A, B) =