An order full film and process has demand for three order types during the next 4 weeks as shown in table 5.1 the assignment of activities to workers and processing time for each activities are shown in table 5.21 all workers have 40 hour per week available to work on this process.

Develop the mathematical model and use Excel Solver to find the number of orders of each type that should be processed to maximize total profit.
TABLE 5.20
Routing, Demand, and Profit Data for Exercise 5.18
OrderType Activities demand profile
Basic 1,2,3 and5. 90 125
Special 1,3,4and6 110 175
Deluxe 2,4,5,and6. 90 200

Table 5.21
Activity time and resource assignment data for exercise 5.18
Activity Time (Min) Employee
1 24 Anne
2 18 Anne
3 25. Meg
4 27 joe
5 15 joe
6 14 Meg
Nov solve it in Excel solver

Answers

Answer 1

The optimal solution is to process 80 orders of Basic type, 82.5 orders of Special type, and 90 orders of Deluxe type to maximize the total profit.

We need to set up the decision variables, constraints, and objective function.

Decision Variables:

Let x1, x2, and x3 be the number of orders of Basic, Special, and Deluxe types to be processed, respectively.

Constraints:

The total time required for each activity must not exceed the available time of each employee. Therefore, the constraints are as follows:

24x1 + 18x2 + 25x2 ≤ 40 × 4 × 60 (Anne's available time)

24x1 + 25x2 + 15x3 ≤ 40 × 4 × 60 (Meg's available time)

27x2 + 15x3 ≤ 40 × 4 × 60 (Joe's available time)

Also, the number of orders for each type cannot be negative, i.e., x1, x2, and x3 ≥ 0.

Objective Function:

The objective is to maximize the total profit, which is given by the following equation:

Profit = 125x1 + 175x2 + 200x3 - (56x1 + 68x2 + 72x3 + 4000)

The first three terms represent the revenue earned from each order type, and the last term represents the total cost (i.e., cost of goods sold plus the processing cost of all orders).

Using Excel Solver, we can input these variables, constraints, and objective function to find the optimal solution. The solution found by Solver gives us the following values for x1, x2, and x3:

x1 = 80

x2 = 82.5

x3 = 90

for more such questions on optimal
https://brainly.com/question/27968241
#SPJ11

Note- The complete question isn't available in the search engine.


Related Questions

PLEASEEEE HELP at Kwok owns and operates Kwok's Word Processing Service. The accounts used for recording and reporting business transactions are:

1. Pat invested $20,000 in the business to begin operations.

2. Purchased computer equipment for $3,500.

3. Invested computer equipment, valued at $600, in the business.

4. Bought a used cash register, $975, on account from Downey Equipment, Inc.

5. Purchased processing supplies for $739.

6. Paid $600 on account to Downey Equipment, Inc.

7. Purchased paper, ribbons, and other processing supplies for $539, on account, from Gillis Office Supplies.

8. Purchased a desk for $495.

9. Paid Gillis Office Supplies $539 on account.

Answers

Processing Supplies 739 Cash or Accounts Payable 739 for transaction 5.

The purchase of processing supplies is noted in this item.

Accounts Payable 539 for transaction 9

Accounts Receivable or Cash 539

This entry serves as proof of the payment made to Gillis Office items for the items that were first bought on credit.

Because there are no associated revenues or expenses, the aforementioned items only have an influence on the balance sheet. The accounts payable account will increase by $739 for transaction 5 and decrease by $539 for transaction 9, while the processing supplies account will increase by $739. For transactions 5 and 9, the Cash account will be reduced by $739 and $539, respectively.

For more such question on transaction

https://brainly.com/question/24260354

#SPJ11

2020 quantity
cost
PRICE
2021 quantity
cost
PRICE
Brocoli Cauliflowe Carrots
100
200
50
75
1.5
80
120
1.5
75
2
75
225
3
300
500
50
0.1
500
100
0.2
100
325
475
CPI base year 2020
100
146.154
46%
Inflation rate

Answers

The inflation rate can be calculated using the Consumer Price Index (CPI) formula, which measures the change in the price of goods and services over time. In this case, the base year is 2020, and we want to calculate the inflation rate for 2021.

First, we need to calculate the CPI for 2020 and 2021:

CPI 2020 = (1001.5) + (2002) + (503) = 500

CPI 2021 = (751.5) + (1201.5) + (2253) = 975

Next, we can use the formula to calculate the inflation rate:

Inflation rate = ((CPI 2021 - CPI 2020) / CPI 2020) x 100%

Inflation rate = ((975 - 500) / 500) x 100%

Inflation rate = 95%

Therefore, the inflation rate between 2020 and 2021 is 95%.

Which person manages the stock in a large catering company

Answers

Answer:

Catering Managers are often responsible for ensuring that the catering operation maintains and inventory of stock, of both food and serving supplies.

The one above couldn’t have answered it better

How much would it cost for Chester Corp to repurchase all its outstanding shares if the price went up by 10%? Assume no brokerage fees

Answers

The amount it will cost for Chester Corp to repurchase all its outstanding shares if the price went up by 10% is $214.1 million.

How to explain the value

Closing price is the price per share computed at the end of a particular day. It is the market price per share on a particular day. It is used as a base to compute the repurchase price per share.

Outstanding shares are the shares that exist and are trading in the market. It is calculated by reducing the number of shares repurchased from the total shares issued.

The amount it cost for Chester Corp to repurchase all its outstanding shares if the price went up by 10% will be:

= 1906223 shares × $112.33

= $214.1 million.

Learn more about shares on

https://brainly.com/question/26128641

#SPJ1

An order full film and process has demand for three order types during the next 4 weeks as shown in table 5.1 the assignment of activities to workers and processing time for each activities are shown in table 5.21 all workers have 40 hour per week available to work on this process.

Develop the mathematical model and use Excel Solver to find the number of orders of each type that should be processed to maximize total profit.
TABLE 5.20
Routing, Demand, and Profit Data for Exercise 5.18
OrderType Activities demand profile
Basic 1,2,3 and5. 90 125
Special 1,3,4and6 110 175
Deluxe 2,4,5,and6. 90 200

Table 5.21
Activity time and resource assignment data for exercise 5.18
Activity Time (Min) Employee
1 24 Anne
2 18 Anne
3 25. Meg
4 27 joe
5 15 joe
6 14 Meg
Nov solve it in Excel solver sheet

Answers

Maximize profit by processing 2 Basic, 2 Special, and 1 Deluxe order in Excel Solver. Total profit is $9800.

To tackle this issue in Succeed Solver, we really want to initially set up the choice factors, objective capability, and imperatives.

Choice Factors:

Let x1, x2, and x3 address the quantity of Fundamental, Extraordinary, and Grand orders handled, separately.

Objective Capability:

We need to boost all out benefit, which is determined as follows:

Complete Benefit = [tex]125*1 + 175*2 + 200*3[/tex]

Limitations:

Request: The all out number of requests handled can't surpass the interest for each request type. This gives us the accompanying limitations:

x1 + x2 + x3 <= 90 (Essential)

x1 + x2 + x3 <= 110 (Exceptional)

x1 + x2 + x3 <= 90 (Luxurious)

Asset Accessibility: The all out handling time for every action can't surpass the accessible season of every representative. This gives us the accompanying limitations:

[tex]24*1 + 18*2 < = 40[/tex](Anne) for Movement 1 and 2

[tex]25*1 + 27*2 + 14*3 < = 40[/tex](Meg) for Movement 3 and 6

[tex]15*1 + 27*3 < = 40[/tex](Joe) for Movement 4 and 5

Utilizing Solver, we can set up the model, set the choice factors, objective capability, and limitations, and address for the ideal arrangement. The ideal arrangement is to handle 2 Essential, 2 Extraordinary, and 1 Choice request, bringing about an all out benefit of $9800.

To learn more about  Excel solver to maximize the profits, refer:

https://brainly.com/question/31977097

#SPJ1

This is an accounting question

Answers

Product A and Product B demand is completely utilized by own stock for Product C more pounds are needed so maximum the price that could be paid is $10 for additional raw materials.

How to solve

1. Product  

A B C

Selling price 180 270 240

Variable expenses:    

Direct materials 24 80 32

Other variable expenses 102 90 148

Total variable expenses 126 170 180

Contribution margin C 54 100 60

No. of pounds of material used P 3 10 4

24/8 80/8 32/8

Contribution margin per pound C/P 18 10 15 ans 1

2. When products demand is unlimited  

The maximum contribution margin that can be earned is by selling product A

6000*$18 108000 ans  

 

3. Maximum contribution margin that can be earned  

Product A 500 units*3*18 27000  

pounds left (6000-(500*3))=4500    

Product C (500*4*15) 30000  

pounds left (4500-(500*4))=2500    

Product B (250 units*10*10) 25000  

4. Maximum contribution margin  

Product A 27000  

Product B 30000  

Product C 25000  

Total 82000  

 

Product A and Product B demand is completely utilized by own stock for Product C more pounds are needed so maximum the price that could be paid is $10 for additional raw materials.

It is the contribution margin per pound for Product C

Read more about contribution margin here:

https://brainly.com/question/24881206
#SPJ1

QUESTION 3: 3.1 Assume that the South African government have requested you to do a CBA with regard to the two projects. Conduct a research about the two pictures below and answer the questions that follow: PROJECT 1: COSTS AND BENEFIT ANALYSIS PROJECT 2 3.1.1 Identify the TWO projects needed by the South African citizens. 3.1.2 List any TWO private costs that will be incurred in project 2. (2 x 1) (2) (2 x 1) (2) 3.1.3 Why should the government apply the cost benefit analysis for big projects? (8) 3.1.4 Examine the external benefits of Project 1 illustrated above? [20] A Pr​

Answers

For the two projects, the South African government has asked for a cost and benefit analysis (CBA), although no precise details or drawings of the projects have been provided.

However, it is clarified that carrying out CBA is important for large scale initiatives as it helps in determining their economic viability and social impact. Decision makers can choose wisely on the basis of net benefit derived from the initiative by weighing the costs and benefits.

The term "external benefit" refers to good outcomes on society as a whole, including social welfare, job growth, environmental sustainability, and infrastructure improvements. But without more details or visuals it's impossible to give specific feedback or evaluate the external benefits of Project 1. It is advised to refer to the actual images and related data to conduct a complete examination.

Learn more about cost and benefit analysis (CBA), here:

https://brainly.com/question/27779955

#SPJ1

Discuss porter's five forces and provide examples specific to Yoco

Answers

Answer:Five forces by porter are as follows: Competitors in the industry; Threat of new entrants; Bargaining power of suppliers; Bargaining power of buyers; Threat of substitutes. Competitors operating in the same industry may drive profit margins and revenue down for any given company.

Explanation:


Life insurance immediately creates an estate upon the death of an insured. Which of the following
policies is characterized by a guaranteed minimum death benefit?

Answers

The type of policy that is characterized by a guaranteed minimum death benefit is known as a whole life insurance policy.

A whole life insurance policy is a permanent life insurance policy that offers lifelong protection to the insured and pays out a death benefit to the beneficiaries upon the death of the insured.

One of the key features of a whole life insurance policy is the guaranteed minimum death benefit, which means that the death benefit will never be less than a certain amount, regardless of how the policy performs. This provides a sense of security to the insured and their beneficiaries, knowing that there will always be a minimum amount of money that will be paid out.

In addition to the guaranteed minimum death benefit, whole life insurance policies also offer a cash value component. As premiums are paid, a portion of the premium is set aside in a cash value account that grows tax-deferred over time. This cash value can be accessed by the policyholder during their lifetime through policy loans or withdrawals.

Overall, a whole life insurance policy is a great option for those who are looking for lifelong protection and a guaranteed minimum death benefit. It offers peace of mind to the insured and their beneficiaries, knowing that there will always be a minimum amount of money paid out upon the death of the insured.

Know more about Whole life insurance policy here:

https://brainly.com/question/27023711

#SPJ11

Answer: variable life

Explanation: the variable nature a variable whole life insurance is its death benefit. however, if investment performance is poor, the death benefit will not go lower than the policy's guaranteed minimum.

How can technology be a barrier to communication?

Answers

Technology can certainly be a barrier to communication in several ways. Firstly, people can rely too much on technology to communicate, which can lead to a lack of personal interaction and human touch.

For example, texting or emailing can be convenient, but they lack the emotional nuances and facial expressions that are essential for effective communication. Therefore, people can misunderstand the message or tone of the message and lead to communication breakdowns.

Secondly, technological devices can malfunction or have connectivity issues, which can delay or disrupt communication. For instance, a poor internet connection or a device that crashes can prevent people from exchanging important information, leading to frustration and even delays in decision-making. Additionally, some people might not have access to technology, which can further create barriers to communication.

Lastly, technology can create language barriers for people who do not speak the same language or have difficulty understanding technical jargon. This can lead to confusion, miscommunication, and even discrimination in some cases.

Overall, while technology has many benefits, it can also be a barrier to communication if used inappropriately or without consideration of its limitations. Therefore, it is important to find a balance between technology and personal interaction, depending on the context and purpose of the communication.

For more such questions on Technology visit:

https://brainly.com/question/22785524

#SPJ11

In his career explorations class, Navid took
and he discovered that he is an outgoing person and truly enjoys being around many people.

Answers

In his career explorations class, Navid took personality assessments and he discovered that he is an outgoing person and truly enjoys being around many people. This realization can open up a variety of career options for Navid, as there are many professions that require individuals who are comfortable interacting with large groups of people.


For instance, Navid may consider a career in sales, where he can use his outgoing personality to establish connections with potential clients and close deals. Alternatively, he may pursue a career in public relations, where his ability to build relationships with people can be utilized to promote products or services on behalf of his clients.
Another potential option for Navid is event planning, where his sociable nature can come in handy for organizing events and engaging with attendees. He could also consider a career in teaching or coaching, where his ability to connect with others can help him to motivate and inspire his students or team members.
Overall, Navid's realization about his outgoing personality can be a valuable asset in his career journey, as it can help him to narrow down his options and find a job that is fulfilling and enjoyable for him. By understanding his personality traits, Navid can make informed decisions about his career path and set himself up for success in the long run.

For more such question on personality

https://brainly.com/question/30357248

#SPJ11

What was Indiana's total government expenditures in fiscal year 2018-2019? (1 point)
O $15.9 billion
O $11.9 billion
O$34.89 billion
O $34.11 billion

Answers

Indiana's total government expenditures in the fiscal year 2018-2019 is $34.89 billion. The correct option is C.

Public consumption, public investment, and transfer payments made up of capital transfers and income transfers (pensions, social benefits), collectively referred to as government expenditures, are all included in the definition of goods and services.

Fiscal policy is characterized as the strategy used by the government to carry out various economic policy goals through the use of taxation, public expenditure, and public borrowing.

Thus, the ideal selection is option C.

Learn more about government expenditures here:

https://brainly.com/question/31649187

#SPJ1

Other Questions
which nbstat utility switch will purge and reload the remote netbios name table cache one mineral commonly lacking in american diets is the _______ of the brain is important for initiating and guiding eye movements. which method call will make jtextarea object newarea non-editable? question 21 options: newarea.setnoneditable(true); newarea.geteditable(false); newarea.seteditable(false); newarea.setedit(false); my birthday is six days after my sister's birthday. my birthday is on the 12th. therefore, my sister's birthday is on the 18th. group of answer choices inductive deductive the question of why is the universe so perfectly close to critical density is known as the problem. male pattern baldness has a genetic switch that turns on in response to: The saturated vapour pressure at 20C and 8C is 17.54mmHg and 8.05mmHg respectively. Find,(i) Relative humidity at the room temperature.(ii) How much mass of water should evapourate such that it saturate at 20C (1mmHg = 133.3Pa) a) There are 18 arginines in flagellin and all arginine codons (6 total) are equally represented. a) Calculate the average number of sensitive arginine codons that are contained in a molecule of flagellin. b) What is the frequency of misreading of each sensitive (CGU and CGC) arginine codon? what are the two categories of villains that seem to prevail in the western genre? I hope this is readable, I would appreciate anyone who helps :) partnerships are quasi-taxable organizations. this means that theyA.do not pay taxes when submitting the partnership tax return to the Internal Revenue Service.B.are completely exempted from paying taxes.C.are subjected to double taxation.D.need to pay a high rate of tax irrespective of whether or not a profit is made.E.have to pay taxes only if they decide to adopt initial public offering. if 12g of a radioactive substance are present initially and 4 year later only 6 g remain, how much of the substance will be present after 11 year? What is the 'conflict thesis' in the history of science and religion? And why is this methodology historically problematic? Identify one relevant historical example that has been associated with it. Meg is writing an essay about why everyone should compost. In addition to her sources, she has been an avid composter for years and has seen its benefits. When should she include this information in her essay?A. Anywhere she wants.B. No whereC. At the beginningD. Close to the end given the size of blocks is 512 bytes in a 32-bit system. the i-node has 32 direct blocks, 5 single-indirect pointers, and 2 double-indirect pointers. T/F? What does it mean to say that acid is strong in an aqueous solution? What does this reveal about the ability of the acid's anion to attract protons? A) If these city counselors get their way, what will be the price and quantity of broad band service in the city? Sketch your answer as well as calculate it numerically. What is the citys mark-up over marginal cost? What is the elasticity of demand at this equilibrium? A nurse is providing discharge instructions to a client who has active tuberculosis (TB). Which of the following information should the nurse include in the instructions?Sputum specimens are necessary every 2 to 4 weeks until there are three negative cultures.The contagious period generally lasts for 6 to 8 weeks after the initiation of medication therapy.Family members should follow airborne precautions at home.A follow-up tuberculosis skin test is necessary in 2 months. while performing night operations, which of the following combinations of lights provide maximum visibility?