Posted: February 26th, 2024
Operations Management homework help
Assessment Brief
Lutz Brewery brews three brands of beers: Lutz Lager, Lutz Light, Lutz Ultralight. Lager sells for $12 per barrel, Light sells for $10 and Ultralight sells for $14 per barrel. Producing a barrel of Lager requires 8 pounds of corn and 4 pounds of hops. Producing a barrel of Light requires 2 pounds of corn, 6 pounds of rice, and 3 pounds of hops. Producing a barrel of Ultralight requires 1 pounds of corn, 8 pounds of rice, and 2 pounds of hops. The brewery has 5000 pounds of corn, 3000 pounds of rice, and 4000 pounds of hops. To supply demand from established customers, Lutz brewery should produce at least 200 barrels of each product.a) Assuming a linear relationship, use Excel Solver to determine the optimal mix of Lager, Light and Ultralight that maximizes Lutz Brewery’s revenue.b) Conduct sensitivity analysis and interpret results.Problems: Binary Integer ModelsProduction planning department of Graystar Prefabricated Homes Company has to decide which types of homes to produce for the next period. They have four prefabricated homes (A,B,C and D). Each home uses three different materials, lumber, particleboard and drywall. The table given below shows the expected profits for each house, the amount of materials used in house and the available quantities of these materials.ABCDAvailableProfit20,00017,00021,00024,000Lumber107111025Particle Board547620Drywall21.532.56Formulate the problem, to determine which house(s) should be produced to maximize the profit.SOLVER 4Problems: Transportation AnalysisSweetland Sugar &Co. produces cane sugar in its four plants in Charlotte, Kansas City, Indianapolis and Flagstaff. These plants serve five major markets, New York, Chicago, St. Louis, Las Vegas and Seattle. The capacities of each plant, demands of each market and the transportation costs of sending a ton sugar from a plant to a market are given in the table below. The company seeks to develop a plan to minimize the transportation costs. Your task is to find the total transportation cost and the amounts of sugar sent from each plant to distribution centers and from each distribution center to markets using Excel Solver.FromPlantsTo MarketsSupply(Tons)New YorkChicagoSt. LouisLas VegasSeattleCharlotte$16$13$12$22$2516Kansas City$20$11$6$15$1817Indianapolis$10$8$8$17$1913Flagstaff$25$18$15$8$1519Demand(tons)15,00012,0009,00014,00013,000NOTE: The numbers shown here as SUPPLY and DEMAND are CORRECT – Please solve with THESE inputs.SOLVER 5Problems: Binary Integer ModelsProduction planning department of Graystar Prefabricated Homes Company has to decide which types of homes to produce for the next period. They have four prefabricated homes (A,B,C and D). Each home uses three different materials, lumber, particleboard and drywall. The table given below shows the expected profits for each house, the amount of materials used in house and the available quantities of these materials.ABCDAvailableProfit20,00017,00021,00024,000Lumber107111025Particle Board547620Drywall21.532.56Formulate the problem, to determine which house(s) should be produced to maximize the profit.SOLVER 6Problems: Network Models100 Points1) Formulate and solve a spreadsheet model for the maximum flow problem, shown below, where node A is the source, node F is the sink, and arc capacities are numbers in parentheses shown next to arcs.[img src="file:///C:/Users/Lori/AppData/Local/Temp/OICE_B18BFDC8-4CD2-4AF2-83A0-3C6D17B991A2.0/msohtmlclip1/01/clip_image002.gif" alt="" width="462" height="294">[img src="file:///C:/Users/Lori/AppData/Local/Temp/OICE_B18BFDC8-4CD2-4AF2-83A0-3C6D17B991A2.0/msohtmlclip1/01/clip_image004.gif" alt="" width="642" height="294">SOLVER 7Problems: Nonlinear ProblemsFrigid Air company produces three different types of industrial refrigerators; A, B and C. The production capacity of the plant is 1000 units per week. Sales department calculates the unit prices for these products as follows, A= $1000, B= $1200, C=$1500. The manufacturing costs for these products are calculated by the following formulas:For A= 200A + A2For B = 250B + B2For C = 350C + C2How should the production be allocated in order to maximize profit?(Hint: Production numbers should be integers)SOLVER 8Problems: Queuing ProblemsBank of Ohio in Zanesville has a single drive-in teller window. Customers arrive at the window about every 10 minutes on average with an exponential distribution or the hourly arrival rateis λ = 6. It take an average of five minutes (exponentially distributed) to complete each customer orderor the hourly service rate is μ = 12. You are asked following tasks:Determine·Expected number of customers in the system, including those being served.·Expected number of customers in the queue, excluding those being served.·Expected waiting time in the system, including service time, for an individual customer.·Expected waiting time in the queue, excluding service time, for an individual customer.·Utilization factor·The probability that waiting time in the system exceeds 0.25 hours (15 minutes)· The probability that waiting time in the queue exceeds 0.25 hours (15 minutes)·The probability that the system has 5 customers in the systemSOLVER 9Problem: Computer SimulationJack Williams operates a small mechanics shop in his hometown, Lima, Ohio. He works six days a week, Monday thru Friday, 10:00 AM to 6:00 PM and Saturdays from 9:00 AM to 12:00 PM. On a regular weekday, customers’ arrival time is exponentially distributed with a mean of 45 minutes and service time is also exponentially distributed with a mean of 35 minutes. Simulate Jack Williams’ shop for 100 customer arrivals to estimate Average Time in Line and Average Time in System.
How Do I Choose the Right Writer?
We match you with a writer based on your subject and academic level, but you can also request a preferred writer if you have worked with someone before. Browse writer profiles or let our system pick the best fit for your needs. Each writer brings specialized knowledge in their field, ensuring subject-matter expertise for your assignment. Students looking for an essay writer can review qualifications to find their perfect match. Our team ensures every writer is vetted for expertise, so you are always in good hands.
Order | Check Discount
Tags: Written Essay Hub, USA Assignment Answers Examples, UK, Research Essay Pro