Use the table below to answer the following question(s). In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. JA Profit Model B 2 What-If Demand Values 3 Data |20,000 |40,000 |55,000 60,000 |65,000 4 |Unit Price ($) |Unit Cost ($) Fixed Cost ($) Demand Quantity Produced |50 |25 |550,000 |60,000 |55,000 15 17 19 10 Which of the following is the Excel formula to determine the number of units sold? =B8 =MIN(0,B8,B9) =MAX(0,B8,B9) =MIN(B8,B9)
Q: Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current m...
A: Given- Month Projected Sales August 26,000 September 21,000 October 31,000
Q: The Wonderful Widget Company's earning have declined to the point where they need to reduce the numb...
A: When an employer eliminates a significant number of workers in order to cut company expenditures, th...
Q: Why is it important to avoid Type 1 Errors?
A: The null hypothesis can be stated as the typical statistical theory which recommends that no statist...
Q: The following network describes a transportation scenario in which there are four sources A, B, C, a...
A: Given data is
Q: Think of a specific mode of transportation in the Philippines. In no more than three (3) sentences f...
A: Due to increase industrialization and urbanization over time, the demand for transportation has als...
Q: What is Information Search Process (ISP)? Who initiated this method and how does the researchers ben...
A: Management information systems often called MIS systems can be stated as the division or department ...
Q: What are the essential parts of a successful HIPAA Security Compliance Program?
A: Assuring that all workers have access to the organization's formal HIPAA and confidentiality, polici...
Q: A systems specification document defines the project's scope and is sent to all key stakeholders for...
A: A systems specification document defines the system level functional and performance requirements, s...
Q: Calculate the Economic Order Quantities (EOQs) for the A items.
A: A item = Sample number 6 Annual usage (D) = 6500Ordering cost (O) = 50Holding cost (H) = 15 % of 97....
Q: Analyse the advantages and disadvantages of using process layout in a manufacturing plant. Provide r...
A: Process layout is the layout of the plant that helps the business to increase efficiency by arrangin...
Q: ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager of productions an...
A: Breakeven analysis for facility location is a method to determine the optimal location which has the...
Q: Cans are made in a process with two resources. The first resource has a capacity of 11 cans per seco...
A: Given: 1st resource capacity =11 cans/sec2nd resource capacity =10 cans/sec 1st resource has workers...
Q: Bakery A uses the newsvendor model to manage its inventory of bread loat Bakery A sels bread for $46...
A:
Q: Solve for the predicted values of y and the residuals for the following data. Advertising 12.5 3.7 2...
A: Given-
Q: Suppose that the crash cost is $10 million, normal cost is $8 million, normal project time is 10 yea...
A: Project crashing is a method used in project management to increase the project time by decreasing t...
Q: in determining which process technology to be used to improve operational efficiency. Provide with r...
A: In its broadest sense, operational efficiency refers to a company's capacity to provide high-quality...
Q: A manufacturing company needs a Pareto diagram for the analysis of the following design department c...
A: Given, Element Dollars(in thousands) Progress Review 10 Support Activities 13 Qualification...
Q: Prepare an arrow diagram and a list of earliest and latest starts and finishes , the tota float and ...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Which one of the following perils would be covered under the commercial property policy broad form b...
A: Commercial property insurance covers the repair or replacement of building and building property dam...
Q: A circus is scheduled to appear in a city on a given date. The profits obtained are heavily dependen...
A: Find the Given details below:
Q: In quality assurance, to monitor characteristics that have discrete values and can be counted, we ca...
A: Quality assurance is the process of preventing and controlling defects in the products and services ...
Q: What is the best way to create a generic diagram of a business process of your choosing AFTER ERP Sy...
A: Enterprise resource planning is described as the sort of software application that can be used by or...
Q: In what circumstances is it required to raise a process exception?
A: Process exception is a condition or a situation in the process strategy where the whole process or a...
Q: Is globalization a cure for poverty?
A: At the start of the 21st century, the world economy was estimated to be worth $60 trillion. Over 77,...
Q: Budget Surplus Case Study A small midwestern city has a $1 million budget surplus. Two groups imme-...
A: given, A small midwestern city has a $1 million budget surplus. Two groups imme- diately begin vying...
Q: a. Construct a time series plot. What type of pattern exists in the data? ( b. Develop the three-wee...
A: Here, we have the table data that represent time-series data, we have data values over some periods,...
Q: What is the minimum number of weeks required for completing the project? What is the latest possible...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Multiple choice need help in completing question 8 and 14. 8. The just-in-time inventory system i...
A: Cost of quality - is described as a process that permits an organization to specify the scope to whi...
Q: A company makes two products (1 and 2). Each product requires time on two machines A and B. The spec...
A: Given data is Product 1 processing time on machine A = 2 hrs/unit Product 1 processing time on machi...
Q: Mention the trade off involved in deciding to have a one large centrally located facility instead of...
A: To be determined: The trade-off involves in deciding to have one large centrally located facility in...
Q: Kathy was a member of a selection panel for an editorial position. Jean was one of the unsuccessful ...
A: Personal issues can negatively impact the environment at the workplace and can also impact the perfo...
Q: Week Demand of beef 1 500 2 550 3 600 4 720 5 780 6 800 Corresponding weights are W1...
A: An accuracy of the forecasting method can decide by identifying the MAD value of the each method. Hi...
Q: a) Draw network diagram representing the project b) Find total float & free float for each activity ...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Respond to the following - the importance of the location decision is sometimes massively overrated ...
A: To be determined: the importance of the location decision is sometimes massively overrated and the f...
Q: What are the different types of costs which you may have to bear on operating a warehouse?
A: Warehouse management is described as the processes that include the operations carried out in a ware...
Q: Explain 1-2 sentences Operating Risk Process Stoppage Health and Safety After Sales Service Failu...
A: Operational risk is related to the failure of any process, policies, systems or any kind of evets th...
Q: For this equation. Daniel and his family recently moved to California. Daniel wants to know which am...
A: given,
Q: Please try to solve in 30 minute A queueing system has an arrival rate of 45 visitors per hour (stan...
A: Given, Service rate s = 35 visitor per hour Standard deviation Ss = 20
Q: (d) A company has three factories. Each factory produces three different products (A, Band C). Facto...
A:
Q: Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBust...
A: Objective Functions and Constraints: Based on the given details, the objective funct...
Q: 1) To order less than 2,000 the vendor quotes S1.80 per piece. Orders between 2001 to 5,000 are $1.6...
A: 1. Given, Annual demand, d= 15000 pieces Ordering cost, o =$200 Inventory holding cost perc...
Q: (Use an excel sheet to show formulas used)
A: (a) Volume break even= Fixed cost/(revenue per unit- variable cost per unit) (b) Profit= Revenue*qua...
Q: Elucidate the importance of supply chain management in healthcare
A: In the healthcare industry, there is a pressing demand for better supply chain management. COVID-19 ...
Q: Max 1W + 1.25M s.t. 5W + 7M 3W + 1M 2W + 2M W, M 20 S 4,400 S 2,240 S 1,600 oz of whole tomatoes oz ...
A: Objective of the problem is to maximize profit. Each jar is of 10 ounces. Western Food Salsa (W)...
Q: can you give in details ,importance of work measurement
A: Work measurement is related to determining the time that is required to perform the work of the unit...
Q: A system operates for 11 consecutive hours. During this period, four failures occurred that, in tota...
A: The mean Time between Failures is the average time in which the system fails or breakdown.
Q: 13.20. Southwood Furniture Company is a U.S.-based furniture manufacturer that offshored all of its ...
A: Given: Annual Demand (D)= 715 Holding cost (H) =$1200 Ordering cost (S) =$6000
Q: In a fabric manufacturing factory, the quality control process using control charts from SPC. In an ...
A: Given samples-
Q: imple flow chart for applying a job
A: A job request is a arrangement that records factual education, communication information & profe...
Q: Set up the objective function and enumerate all the constraints, Define the decision variables of th...
A: After adding the information given in the question description, the table will be as follows. Total...
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. What are three recommendations you have to the VP of operations based on the attached optimal production plan? These three options must be based only on information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost), and resource constraints].You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
- The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should identify and explain at least 3 options. These three options must be based only with information present in the excel production plan, sensitivity report and components of LP modeling [decision variables, objective function (prices and variable cost) and resource constraints] The business memo should be 1 to 2 pages. A professionally written proper style and grammar are worth 50% of the grade. Your recommendations on the three options are worth 50%.XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
- Assume the maximum demand for Super is 600,000 barrels. What is the optimal maximum profit? Hints: There are six decision variables are as follows: R1: # of barrels of ingredient 1 used in Regular fuel R2: # of barrels of ingredient 2 used in Regular fuel R3: # of barrels of ingredient 3 used in Regular fuel S1: # of barrels of ingredient 1 used in Super fuel S2: # of barrels of ingredient 2 used in Super fuel S3: # of barrels of ingredient 3 used in Super fuel Some calculations you would need in the constraints: The total # of barrels for Regular would be R1+R2+R3. The total # of barrels for Super would be S1+S2+S3. The total # of barrels of Ingredient 1 would be R1+S1. The total # of barrels of Ingredient 2 would be R2+S2. The total # of barrels of Ingredient 3 would be R3+S3.A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.ssume the maximum demand for Super is 600,000 barrels. What is the optimal maximum profit? Hints: There are six decision variables are as follows: R1: # of barrels of ingredient 1 used in Regular fuel R2: # of barrels of ingredient 2 used in Regular fuel R3: # of barrels of ingredient 3 used in Regular fuel S1: # of barrels of ingredient 1 used in Super fuel S2: # of barrels of ingredient 2 used in Super fuel S3: # of barrels of ingredient 3 used in Super fuel Some calculations you would need in the constraints: The total # of barrels for Regular would be R1+R2+R3. The total # of barrels for Super would be S1+S2+S3. The total # of barrels of Ingredient 1 would be R1+S1. The total # of barrels of Ingredient 2 would be R2+S2. The total # of barrels of Ingredient 3 would be R3+S3.