1. Formulate linear programming (clearly state decision variables,objective, and constraints)2. Find the optimal solution using Excel Solver3. Do not solve graphically4. Answer all questions5. Attach your solver files and formulations. Problem 2The manager of a Burger Doodle franchise wants to determine how many sausage biscuits andham biscuits to prepare each morning for breakfast customers. The two types of biscuits requirethe following resources:BiscuitLabor (hr.)Sausage (Ib.)Ham (Ib.)Flour (Ib.)Sausage0.0100.100.04Ham0.0240.150.04The franchise has 6 hours of labor available each morning. The manager has a contract with alocal grocer for 30 pounds of sausage and 30 pounds of ham each morning. The manager alsopurchases 16 pounds of flour. The profit for a sausage biscuit is $0.60; the profit for a ham biscuitis $0.50. The manager wants to know the number of each type of biscuit to prepare each morningto maximize profit.Formulate a linear programming model for this problem.Solve the linear programming model developed in Problem 18 for the Burger Doodle restaurantby using the computer.a. Identify and explain the shadow prices for each of the resource constraints.b. Which of the resources constraints profit the most?c. Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausageavailable. Explain these sensitivity ranges.

Given, Biscuit Labor sausage ham flour Sausage 0.010 0.10 0.04 Ham 0.024 0.15 0.04

Answered: The manager of a Burger Doodle…

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

Apples are prepared in a process with two resources. The first resource has a capacity of 2.1 apples per minute. The capacity of the second resource is 4.4 apples per minute. The first resource has 1 worker and the second resource has 4 workers. One additional worker is hired who is as productive as the current workers. What is the new capacity of this process? _____ apples per minute
You work as the administrative manager in charge of the operations of the medical services office that brings together over 10 specialists from different health fields. Each specialist has about 5 administrative employees who help with coding, billing, customer service, and other administrative tasks. You supervise all administrative employees. For two months you have noticed that a series of conflicts have arisen between the employees you supervise, which you must address promptly to avoid escalation. These are the conflicts that have been identified: A new position has been opened to supervise night operations and two of the employees have requested it. However, both have resorted to demonstrating that the other does not have the capabilities to rise to the position. These interpersonal differences have resulted in a tense work environment.It has been rumored that one of the medical specialists is going to retire, so it is possible that he will put the five administrative employees…
In a job shop, effective capacity is only 79 percent of design capacity, and actual output is 53 percent of effective output. What design capacity would be needed to achieve an actual output of 11 jobs per week? What is its effective capacity? a. The Design Capacity needed to achieve the required actual job outputs Blank 1 (round to whole number) b. The Effective Capacity needed to achieve the required actual job outputs = Blank 2 (round to whole number) Blank 1 Add your answer
Rollmore, a non-union manufacturing company decides it needs input on improving its work processes and procedures and decides to create employee committees to provide general feedback about things such as work rules and organizational policies and practices in hopes of improving efficiency. Rollmore asks ten employees to serve on such committees. Rollmore asks these employees to bring to their meetings, which include management representatives, concerns and ideas from their coworkers. Rollmore schedules these committees to meet once a month for two hours and provides lunch and a conference room for the participants. Are these employee committees legal or illegal? Why or why not?
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the company’s products is grilled salmon in dill sauce with baby new potatoes and spring vegetables. During the most recent week, the company prepared 4,300 of these meals using 1,250 direct labor-hours. The company paid its direct labor workers a total of $11,250 for this work, or $9.00 per hour. According to the standard cost card for this meal, it should require 0.30 direct labor-hours at a cost of $8.50 per hour. Required: 1. What is the standard labor-hours allowed (SH) to prepare 4,300 meals? 2. What is the standard labor cost allowed (SH × SR) to prepare 4,300 meals? 3. What is the labor spending variance? 4. What is the labor rate variance and the labor efficiency variance?
DreamInflate is a balloon manufacturing company. Balloon manufacturing consists of seven work stations, each performing a single step as indicated in the table below. There are five workers manned for the seven work stations as shown. Assume the workers are paid $15 per Worker Task Sequence Processing Time (secs/balloon) Task Dye production Electrocharging Dipping (Cold and Hot) Mortar Dipping Balloon inflation and delaltexing Vulcanization Inspection/Testing 1 30 w1 20 3 35 W2 25 W3 30 W4 6. 45 W5 7 40 hour. Each balloon pack is sold for $6 and has a variable cost of $1. The company has fixed costs of $200 per hour. There is more demand than the overall production system can provide. Based on the information provided, answer the following questions: • What is the cost of direct labor for balloons? • How much profit does DreamInflate make every hour? (note that the cost of direct labor is also a variable cost). What would the profit of DreamInflate be if the variable costs were 10…
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…
The company has the following information about its two service departments and two production departments, Cutting and Assembly: Departments SquareFeet Number ofEmployees Maintenance Department 500 20 Cafeteria Department 1,400 10 Cutting Department 1,500 60 Assembly Department 7,100 20 What is the percentage (proportional) usage of the Maintenance Department by the Cutting Department?
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…
SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the company's products is grilled salmon with new potatoes and mixed vegetables. During the most recent week, the company prepared 4,000 of these meals using 960 direct labor- hours. The company paid its direct labor workers a total of $19,200 for this work, or $20.00 per hour. According to the standard cost card for this meal, it should require 0.25 direct labor-hours at a cost of $19.75 per hour. Required: 1. What is the standard labor-hours allowed (SH) to prepare 4,000 meals? 2. What is the standard labor cost allowed (SH x SR) to prepare 4,000 meals? 3. What is the labor spending variance? 4. What is the labor rate variance and the labor efficiency variance? (For requirements 3 and 4, indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Do not round intermediate calculations.) 1.…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS