Jad's Food Company (JFCo) produces three types of ketchup (K1, K2, and K3) and three types...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jad's Food Company (JFCo) produces three types of ketchup (K1, K2, and K3) and three types of hot sauce (H1, H2, and H3) at its plant in Khasab, Musandam, for sale throughout Oman only. The company owns 800 OR of labor hours, 1000 machines hours, and 2000 Sq Ft space of the plant. The company sets its minimum expected profit to 5000 OMR. The excel file 'Jad's Food Company T2' shows all constraints coefficients and the products prices per box. The optimization problem for JFCo without risk case has been solved for you in the excel file. For risk minimization problem, you are given the prices variation over 8 years for all products. Instructions: Please report answer report' and 'sensitivity report' only. Each question is independent and has no relation with other questions which means deal with the original case to handle each question. When you resolve the model, please do this in a separate excel-sheet (name it as the question number. For example, if you need to resolve the model in question 1, name the excel-sheet Q1) in the same excel file because you can only upload one excel file to Moodle. 1. Download "Jad's Food Company T2 excel file from Moodle. Save this file as "Test2_Yourname". 2. Based on the question above, please set up the optimization problem in excel-sheet named "Original' for with risk case. 3. What do you expect to happen to the optimal mix of products with risk case by looking at the prices variation over 8 years for all products? Answer: 4. What mix of products JFCo would decide to produce to minimize risk? How this results differ from without risk case? Justify. Answer: 5. Interpret any reduced cost value you find (one value is enough)? Answer: 6. What would happen if the prices of H1 and H2 products increase by 100% at the same time? Answer: 7. What would happen to the optimal solutions (minimum risk) if labor hours increase by 40 hours? Answer: 8. What would happen to the optimal minimum risk if space in Sq. Ft decreases to 1000 Sq. Ft? Answer: 9. What would happen to the optimal minimum risk if machine hours increase by 740 hours? Answer: 10. JFCo business analytical team found that the company can still do well with reducing the minimum expected profit to 4860 OMR. What would happen to the optimal solutions (minimum risk, product mix, and constraints) in this case? Answer: 11. JFCo has again consulted Mr. John in order to improve business performance and reduce the risk. Mr. John again recommended that JFCo either has to enhance productivity of labor or buy more machine. Do you agree with Mr. John? Please justify your answer? Answer: 12. Oman Government has initiated multiple programs to support food production in Oman. JFCo was given to choose one option from the following two programs, please fully analyze each option and then recommend the best option for JFCo and why: (Hint: you should compare the total benefit with the total cost to the company in each option) A. Subsidize hiring 5 additional workers Answer: B. Subsidize buying 5 additional machine Answer: 13. JFCo has decided to account differently for the history of price variations as it believes that most recent variations in prices more impact their business and associated risk than older variations. Therefore, they assign new weights (instead of just 1) to price variations over the 8 years as follows. How could this decision affect the optimal mix of products and optimal minimum variation? Justify your answers and provide reasons for changes if any. Year 12 3456 7 8 Weight 0.50511220 30 40 Answer: Decision variable definitions: K=boxes of ketchup to produce H= boxes of hot sauce to produce Decision variables: Objective function: Gross Margin (OR/BOX) Constraints: Labor (hour) Machine (hour) Space (Sq. Ft) Price Varriations over years Y₁ Y2 Y3 Y4 Y5 Y6 Y7 Y8 FORFATTE Y1 Y2 Y3 Y4 Y5 Y6 Y7 YB 33333333 Y4 Y6 Y7 Y8 Gross Returns (OR) Decision variables: Constraints Objective function: Gross Margin (OR/BOX) Kgs MIN DEVIATIONS Kgs 2400.0 K1 0.0 10.0 0.5 3.0 10.0 K1 K1 K1 7.2 5.0 1.0 5.0 8.0 10.0 13.0 7.0 Jad's Food Company JFCo (Without Risk) K2 0.0 5.5 1.5 2.0 5.0 K2 9.5 8.8 12.0 10.0 9.0 11.00 13.0 10.1 K2 K2 K3 0.0 3.0 1.5 1.0 3.0 K3 15.0 6.0 1.0 11.9 13.0 5.0 13.0 4.0 K3 K3 H1 145.5 7.5 1.0 3.0 7.0 H1 H1 H1 1.5 6.5 3.7 5.0 2.0 7.2 4.2 2.0 H2 327.3 4.0 2.0 1.5 3.0 H2 H2 H2 33.0 13.0 49.5 15.0 27.0 24.4 46.0 3.1 Jad's Food Company JFCo (With Risk) H3 0.0 2.0 2.5 1.0 1.5 H3 9.9 9.0 3.0 7.0 10.0 9.0 8.0 79 H3 H3 Eqn 800.0 927.3 2000.0 Type Cz Con. Lvl 800.0 1000.0 2000.0 Jad's Food Company (JFCo) produces three types of ketchup (K1, K2, and K3) and three types of hot sauce (H1, H2, and H3) at its plant in Khasab, Musandam, for sale throughout Oman only. The company owns 800 OR of labor hours, 1000 machines hours, and 2000 Sq Ft space of the plant. The company sets its minimum expected profit to 5000 OMR. The excel file 'Jad's Food Company T2' shows all constraints coefficients and the products prices per box. The optimization problem for JFCo without risk case has been solved for you in the excel file. For risk minimization problem, you are given the prices variation over 8 years for all products. Instructions: Please report answer report' and 'sensitivity report' only. Each question is independent and has no relation with other questions which means deal with the original case to handle each question. When you resolve the model, please do this in a separate excel-sheet (name it as the question number. For example, if you need to resolve the model in question 1, name the excel-sheet Q1) in the same excel file because you can only upload one excel file to Moodle. 1. Download "Jad's Food Company T2 excel file from Moodle. Save this file as "Test2_Yourname". 2. Based on the question above, please set up the optimization problem in excel-sheet named "Original' for with risk case. 3. What do you expect to happen to the optimal mix of products with risk case by looking at the prices variation over 8 years for all products? Answer: 4. What mix of products JFCo would decide to produce to minimize risk? How this results differ from without risk case? Justify. Answer: 5. Interpret any reduced cost value you find (one value is enough)? Answer: 6. What would happen if the prices of H1 and H2 products increase by 100% at the same time? Answer: 7. What would happen to the optimal solutions (minimum risk) if labor hours increase by 40 hours? Answer: 8. What would happen to the optimal minimum risk if space in Sq. Ft decreases to 1000 Sq. Ft? Answer: 9. What would happen to the optimal minimum risk if machine hours increase by 740 hours? Answer: 10. JFCo business analytical team found that the company can still do well with reducing the minimum expected profit to 4860 OMR. What would happen to the optimal solutions (minimum risk, product mix, and constraints) in this case? Answer: 11. JFCo has again consulted Mr. John in order to improve business performance and reduce the risk. Mr. John again recommended that JFCo either has to enhance productivity of labor or buy more machine. Do you agree with Mr. John? Please justify your answer? Answer: 12. Oman Government has initiated multiple programs to support food production in Oman. JFCo was given to choose one option from the following two programs, please fully analyze each option and then recommend the best option for JFCo and why: (Hint: you should compare the total benefit with the total cost to the company in each option) A. Subsidize hiring 5 additional workers Answer: B. Subsidize buying 5 additional machine Answer: 13. JFCo has decided to account differently for the history of price variations as it believes that most recent variations in prices more impact their business and associated risk than older variations. Therefore, they assign new weights (instead of just 1) to price variations over the 8 years as follows. How could this decision affect the optimal mix of products and optimal minimum variation? Justify your answers and provide reasons for changes if any. Year 12 3456 7 8 Weight 0.50511220 30 40 Answer: Decision variable definitions: K=boxes of ketchup to produce H= boxes of hot sauce to produce Decision variables: Objective function: Gross Margin (OR/BOX) Constraints: Labor (hour) Machine (hour) Space (Sq. Ft) Price Varriations over years Y₁ Y2 Y3 Y4 Y5 Y6 Y7 Y8 FORFATTE Y1 Y2 Y3 Y4 Y5 Y6 Y7 YB 33333333 Y4 Y6 Y7 Y8 Gross Returns (OR) Decision variables: Constraints Objective function: Gross Margin (OR/BOX) Kgs MIN DEVIATIONS Kgs 2400.0 K1 0.0 10.0 0.5 3.0 10.0 K1 K1 K1 7.2 5.0 1.0 5.0 8.0 10.0 13.0 7.0 Jad's Food Company JFCo (Without Risk) K2 0.0 5.5 1.5 2.0 5.0 K2 9.5 8.8 12.0 10.0 9.0 11.00 13.0 10.1 K2 K2 K3 0.0 3.0 1.5 1.0 3.0 K3 15.0 6.0 1.0 11.9 13.0 5.0 13.0 4.0 K3 K3 H1 145.5 7.5 1.0 3.0 7.0 H1 H1 H1 1.5 6.5 3.7 5.0 2.0 7.2 4.2 2.0 H2 327.3 4.0 2.0 1.5 3.0 H2 H2 H2 33.0 13.0 49.5 15.0 27.0 24.4 46.0 3.1 Jad's Food Company JFCo (With Risk) H3 0.0 2.0 2.5 1.0 1.5 H3 9.9 9.0 3.0 7.0 10.0 9.0 8.0 79 H3 H3 Eqn 800.0 927.3 2000.0 Type Cz Con. Lvl 800.0 1000.0 2000.0
Expert Answer:
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date:
Students also viewed these accounting questions
-
The Zanello Company manufactures telecommunications equipment at its plant in Ottawa, Ontario. The company has marketing divisions throughout the world. A Zanello marketing division in Vienna,...
-
The Questron Company manufactures telecommunications equipment at its plant in Scranton, Pennsylvania. The company has marketing divisions throughout the world. A Questron marketing division in...
-
The Questron Company manufactures telecommunications equipment at its plant in Scranton, Pennsylvania. The company has marketing divisions throughout the world. A Questron marketing division in...
-
A ball is dropped from a high rise platform at t = 0 starting from rest. After 6 seconds another ball is thrown downwards from the same platform with a speed v. The two balls meet at t = 18s. What is...
-
Textbook publishers hope to maximize profits. Authors, however, face very different incentives. Authors are typically paid royalties, which are a specified percentage of total revenue from the sale...
-
Suppose Procter & Gamble (P&G) learns that a relatively new startup company Method (www. methodhome.com) is gaining market share with a new laundry detergent in West Coast markets. In response, P&G...
-
Jerome M. Eisenberg is an antiquities dealer and a self-proclaimed expert in classical antiquities with a doctorate in Roman, Egyptian, and Near Eastern art. Maurice E. Hall Jr. is an art dealer who...
-
John Palmer and Henry Morrison formed the limited partnership of Palmer & Morrison for the management of the Huntington Hotel and filed an appropriate certificate in compliance with the limited...
-
Let G = (N,A) be an undirected graph. (a) Suppose the arcs of G have with nonnegative weights. Explain how you could modify Dijkstra's algorithm (not G) to find a shortest path from a designated node...
-
1. Assume you are Vince Brofft and want to lead the change to save the plant. Describe how you would enact the first three stages outlined in Exhibit 15.2 of the text. 2. Describe three tactics you...
-
A projectile is thrown from a point O on the ground at an angle 45 from the vertical and with a speed of 5 ?2 m/s . The projectile at the highest point of its trajectory splits into two equal parts....
-
You are working as a security expert in an e-commerce enterprise. Your company recently decided on a short-term collaboration with a small business named BuyMe, and the following issue arose....
-
A ball is thrown horizontally from the top of a 20-m high hill. It strikes the ground at an angle of 45. With what speed was it thrown? 20 m 45
-
How has technology been used to reinforce and perpetuate systems of oppression in your community, specifically in relation to race and ethnicity? How do these actions affect the daily lives and...
-
In the fleet purchase options analysis tool covered in class, one of the costs included was the 'lost interest on capital funds'. What does this refer to, and why would it be included in such an...
-
Government has three primary functions. It should provide for military defense of the nation. It should enforce contracts between individuals. It should protect citizens from crimes against...
-
ance (Section 209) This test: 100 point(s) possible This question: 6 point(s) possible What is the nominal annual rate of interest compounded monthly if a 12-year loan of $49,500 is repaid by monthly...
-
Discrete sample spaces: suppose there are N cable cars in San Francisco, numbered sequentially from 1 to N. You see a cable car at random; it is numbered 203. You wish to estimate N. (See Goodman,...
-
Refer to the Cox Cable and Wire-Company case. In the role of Meredith, design a spreadsheet that will evaluate the profitability of any particular production and delivery schedule. a. Find a machine...
-
Refer to the Medical Supplies for Banjul case. Design a spreadsheet that will enable you to request the required funds from your team's finance officer, order supplies from the home office, and...
-
Refer to the Retirement Planning case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
A running mountain lion can make a leap 10.0 m long, reaching a maximum height of 3.0 m. a. What is the speed of the mountain lion just as it leaves the ground? b. At what angle does it leave the...
-
The moon completes one (circular) orbit of the earth in 27.3 days. The distance from the earth to the moon is 3.84 10 8 m. What is the moons centripetal acceleration?
-
A soccer player takes a free kick from a spot that is 20 m from the goal. The ball leaves his foot at an angle of 32, and it eventually hits the crossbar of the goal, which is 2.4 m from the ground....
Study smarter with the SolutionInn App