BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and BCP3. These chemicals are produced intwo production processes known as zone and man. Running the zone process for an hour costs $52 and yields four units of BCP1,three unit of BCP2, and two unit of BCP3. Running the man process for one hour costs $25 and yields two unit of BCP1 and two unit ofBCP2. To meet customer demands, at least twenty five units of BCP1, twenty units of BCP2, and five units of BCP3 must be produceddaily.Assuming a linear relationship, use the Excel Solver to determine the optimal mix of processes zone and man to minimize costs andmeet BC Petrol daily demands. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the 1decimal place.)Decision for zoneDecision for manTotal costBCP1BCP2BCP3Produced

Here, first, I will formulate a Linear programming model, the total cost is to be minimized, In this…

Assuming a linear relationship, use the Excel Solver to determine the optimal mix of processes zone and man to minimize costs and meet BC Petrol daily demands. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the 1 decimal place.) Decision for zone Decision for man Total cost BCP1 BCP2 BCP3 Produced

Assuming a linear relationship, use the Excel Solver to determine the optimal mix of processes zone and man to minimize costs and meet BC Petrol daily demands. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the 1 decimal place.) Decision for zone Decision for man Total cost BCP1 BCP2 BCP3 Produced

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

Related questions

Q: The short-run aggregate supply is most likely to shift down when actual output: A) exceeds potential…

A: The Short-Run Aggregate Supply (SRAS) curve is a graphical representation that shows the…

Q: Problem 1 Dr. Song will go to McDonald's for dinner tonight. After studying operations research, he…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: Drawing inspiration from the list of “Typical Analytical Services” and “Typical Commodities…

A: Food safety is a basic concern within the public health segment, pointing to secure consumers from…

Q: he following data below gives information for ABCO building supplies. Cost of goods sold last year…

A: Inventory Turnover Ratio is calculated with the help of following formula Inventory Turnover Ratio…

Q: Company QXL has generated $1 million in gross sales for Q4, 2021, which is 5% higher than its gross…

A: The case is about a person named W who is a financial planner that has suggested a client to invest…

Q: Revenue per Available Room (RevPar) and Average Daily Rate (ADR)? Why is RevPar lower than ADR

A: Revenue per available room (RevPar) and average daily report (ADR) are metrics used in the…

Q: -Choose the best answer. Which of these is a raw material that can be bought or sold with little…

A: Raw materials can definitely be bought and sold with variations. The details are discussed as…

Q: According to case study above, which strategy is being used by Ikea? Conduct your own research and…

A: IKEA is retailer companies, which deal with the designing and selling of the ready to assembly…

Q: A $45,000 investment in a new conveyor system is projected to improve throughput and increasing…

A: Net Present Value (NPV) is the difference between the present value of cash inflows and the present…

Q: HOICE MAKING 8. True or False: Group IDD service settings typically offer a person many…

A: Human resource management is the aspect of management that is concerned with managing, supporting,…

Q: What role does demand variability play in the Wilson Approach, and how can it be managed…

A: Demand variability plays a significant role in the Wilson Approach, also known as the Economic Order…

Q: snip

A: Ending inventory = on hand inventory-demand next week-plan for production of additional unitsEnding…

Q: Suppose the production manager is asked to reduce the safety stock of this item by 60 percent. If…

A: In inventory management, the term "safety stock" refers to the additional inventory that a business…

Q: Free for this situation and indicate whic ld he select. What would Miles's decision be based on…

A: Baye's decision rule could be referred to as a statistical approach based on the quantification of…

Q: The table below provides the aggregate plan of messanger bags produced by Timbuk2. It is known that…

A: Given aggregate plan-

Q: Imagine you are in charge of making the decision to lease orbuy a fleet of trucks for the moving…

A: The significance of a make or buy decision in an organization are: 1. When a company makes its…

Q: Aggregate supply curve slopes downward from left to right Select one: True False

A: Aggregate supply curve is being used to showcase the growth or the real sell quantity of the or sell…

Q: LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four…

A: Find the Calculation methods below: As per the transportation-Aggregate planning method, the…

Q: Home Country as Largest Production Country Monstansa is Yellowstone’s most important location. It is…

A: 1. International Modes of Entry Case StudiesGermanyExample 1: Walmart in GermanyMode of Entry: Joint…

Q: The process outputs from three suppliers are shown in the table. The customer is striving to achieve…

A: Supplier X¯ s Ppk 1 203 2 1.167 2 204.5 3 0.611 3 206 4 0.333

Concept explainers

Optimization Models

Optimization models are mathematical models that help organizations determine the best way to allocate scarce resources to achieve specific objectives. These models can be used to solve a wide variety of problems, from finding the most efficient route for a delivery truck to determining the optimal mix of products to stock in a store.

Question

BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and BCP3. These chemicals are produced in
two production processes known as zone and man. Running the zone process for an hour costs $52 and yields four units of BCP1,
three unit of BCP2, and two unit of BCP3. Running the man process for one hour costs $25 and yields two unit of BCP1 and two unit of
BCP2. To meet customer demands, at least twenty five units of BCP1, twenty units of BCP2, and five units of BCP3 must be produced
daily.
Assuming a linear relationship, use the Excel Solver to determine the optimal mix of processes zone and man to minimize costs and
meet BC Petrol daily demands. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the 1
decimal place.)
Decision for zone
Decision for man
Total cost
BCP1
BCP2
BCP3
Produced

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduce the question:

VIEW

Step 2: Formulate an LP:

VIEW

Step 3: Prepare the spreadsheet model and solve it:

VIEW

Solution

VIEW

Step by step

Solved in 4 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Need final answer try to answer it in 30 minute
Vartan Information Technologies has a division called Useless Transistors. It is considering an « overhaul » of Useless Transistors’ operations or moving Useless overseas. Inventory management is receiving considerable attention. Vartan collected data for the years 2014, 2015, and a forecast for 2016. This data is provided below. What would be Useless Transistors’ weeks of supply for 2015? Projected 2014 2015 2016 Sales $127,890,000 $148,900,000 $192,340,000 Beginning Inventory $3,897,234 $5,467,983 $6,183,230 Ending Inventory $5,467,983 $6,183,230 $4,654,129 Cost of Goods Sold $16,876,400 $20,376,548 $22,346,786 Group of answer choices
A Shoe retailer wants to add a new brand in his shoe outlet. When this new product will added an additional weekly payment of $5500 will be required. Variable cost is $5/product and selling price is $11/product. Find the operating profit generated if 2100 units are sold in a week? A)$12,600 B)$4,800 C) $6,800 D) $7,100
Company DEF has a choice of two machines to purchase. They both make the same product which sells for P10. Machine A has FC of P5,000 and a per unit cost of P5. Machine B has FC of P15,000 and a per unit cost of P1. Under what conditions would you select Machine A?
Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.