Create a step-by-step excel, using the solver engine to generate the decision variablesolution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU CASE 3. Burger DoodleThe manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham biscuitsto prepare each morning for breakfast customers. The two types of biscuits require the following resources:Ham (lb)BiscuitSausageHamLabor (hr)0.0100.024Sausage (lb)0.100.15Flour (lb)0.040.04The franchise has 6 hours of labor available each morning. The manager has a contract with a local grocer for30 pounds of sausage and 30 pounds of ham each morning. The manager also purchases 16 pounds of flour.The profit for a sausage biscuit is $0.60; the profit for a ham biscuit is $0.50. The manager wants to know thenumber of each type of biscuit to prepare each morning in order to maximize profit.Required:6. How much extra sausage and ham is left over at the optimal solution point? Is there any idle labortime?7. What would the solution be if the profit for a ham biscuit were increased from $0.50 to $0.60?8. What would be the effect on the optimal solution if the manager could obtain 2 more pounds of flour?

Given data is Biscuit Labor hours Sausage lb Ham lb Flour lb Sausage 0.010 0.10 - 0.04 Ham…

Answered: Create a step-by-step excel, using the…

Create a step-by-step excel, using the solver engine to generate the decision variable solution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU

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

I need help with this!
Please Solve In 20mins
Develop a rich context model for increasing space capacity in refrigerators. Please be clear and detailed. See rich context model photo. Start by tailoring the generalized rich picture in the photo
P1 P4 P2 P3 P5 P5 P5 P6 ... P1 has a production rate of 15 units/hour, P2 = 30 units/hour, P3 = 10 units per hour, P4 = 4 units/hour, P5 = 1 unit(s) per hour for each P5 and P6 = 6 units per hour. Operation P4 occurs seperately from and simultaneously with operations P1-P3. Operation P5 has three parallel and identical lines; therefore, each part only needs to go through one of the three lines. Consider the following two independent improvements: Improvement 1: Change station P4 into two connected stations (P4-1 and P4-2, connected in series) that have process times of 4 min/unit and 6 min/unit respectively. Improvement 2: Add two additional P5 stations to give you 5 parallel and identical lines. Improvement 2 increases capacity because it improves the bottleneck. The new bottleneck is station P4 since the original bottleneck has a process time of The new yearly capacity would be units per year. a) Which of the two improvements will provide the largest increase in capacity? What is the…
Cost Per Thousand CPM An advertising campaign features two print ads. One ad generates 15,007 exposures and cost $5,329. The second ad generates 19,223 impressions and cost $8,583. Calculate Cost Per Thousand for the campaign as a whole. (Rounding: penny.)
Because of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 units
3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z? A) 28.73 B) 39.27 C) 0 D) 1E + 30 3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally? A) $0 B) $9.09 C) $29.00 D) $158.18
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…
To be effective, an organization must have clearly defined sets of goals and objectives. True lr false
9Q
The binary variables in the fixed cost models correspond to: A.) The number of units or products produced. B.) The total profit C.) The amount of labor hours D.) A process for which a fixed cost ovcurs
Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…