Only algabric model with clear steps. no need for GAMSI just need the objective details, constriants, variables and inputsI do have GAMES free licene Case descriptionThe CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. Thecompany is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. Thecompany can produce air conditioners at six plants across the country and stock these units in any of four different candidatewarehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following tablealong with the monthly capacity and fixed cost of operating each plant.Plant 1Plant 2Plant 3Plant 4Plant 5Plant 6Warehouse 1Warehouse 2Warehouse 3Warehouse 4Warehouse 1$700$800$850$600$500$700DemandWarehouse 2$1,000$500$600Customer 1$40$60$55$80$800$600$600Warehouse 3$900$600$700$500$450$750Customer 2$80$50$40$30Customer 3$60$75$65$80The monthly demand from each customer is summarized next:Customer 1200Customer 2300Warehouse 4$1,200$700$500Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with themonthly fixed cost of operating each warehouse.$600$700$500Customer 4$90$40$60$50Fixed Cost$55,000$40,000$45,000$50,000$42,000$40,000Customer 3200Capacity300200300250350400Customer 5 Fixed Cost Capacity$40,000$50700$35$50,000500$80$35,000400$60$60,000600Customer 4150Impact onenvironment597689Impact onenvironment8795Customer 5250

The CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. The company is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. The company can produce air conditioners at six plants across the country and stock these units in any of four different candidate warehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following table along with the monthly capacity and fixed cost of operating each plant. Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Plant 6 Warehouse 1 $700 $800 $850 $600 $500 $700 Warehouse 2 $1,000 $500 $600 $800 $600 $600 Warehouse 3 $900 $600 $700 $500 $450 $750 Warehouse 4 $1,200 $700 $500 $600 $700 $500 Fixed Cost $55,000 $40,000 $45,000 $50,000 $42,000 $40,000 Capacity 300 200 300 250 350 400 Impact on environment 5 9 7 6 8 9 Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with the monthly fixed cost of operating each warehouse. Impact on

The CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. The company is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. The company can produce air conditioners at six plants across the country and stock these units in any of four different candidate warehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following table along with the monthly capacity and fixed cost of operating each plant. Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Plant 6 Warehouse 1 $700 $800 $850 $600 $500 $700 Warehouse 2 $1,000 $500 $600 $800 $600 $600 Warehouse 3 $900 $600 $700 $500 $450 $750 Warehouse 4 $1,200 $700 $500 $600 $700 $500 Fixed Cost $55,000 $40,000 $45,000 $50,000 $42,000 $40,000 Capacity 300 200 300 250 350 400 Impact on environment 5 9 7 6 8 9 Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with the monthly fixed cost of operating each warehouse. Impact on

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section11.4: Marketing Models

Problem 30P: Seas Beginning sells clothing by mail order. An important question is when to strike a customer from...

See similar textbooks

Similar questions

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?
Phylis Ltd has the following transactions in respect of its goods during Dec 2015. Opening stock 78 units @ GH¢25 Dec 5 bought 250 units @ GH¢24 Dec 10 sold 175 units @ GH¢95 Dec 11 bought 140 units @ GH¢26 Dec 12 sold 200 units @ GH¢48 Dec 15 paid for printing GH¢7,200 Dec 16 bought 400 units @ GH¢20 Dec 22 sold 140 units @ GH¢85 Dec 22 commission to sales Executives GH¢ 20,000 Dec 23 sold 155 units @ GH¢40 Additional information; 1. The cost of carrying a unit material inwards was agreed at GH¢1.5 2. Out of the general administrative expenses of GH¢15,200 only GH¢3,700 had been paid during December. 3. The goods sold on December 23rd only 20% has been collected by the company as at close of the year-month 4. The outstanding balance of GH¢7,100 was paid on the 20th January 2021 You are required to: a. Write up the stores ledger card using the weighted average method of stock valuation. b. Prepare trading, profit and loss…
As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast of coal (in tonnes). Table 1, below, depicts the volume of coal sold by the mine for each of the 12 months of 2022.Table 1: Volume of coal sold monthly during 2022 Year Monthly volume (tonne s) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2022 21 23 34 37 40 51 54 50 48 36 39 42 1. Using the three-month weighted moving average method, calculate the monthly forecasts for April 2022 to January 2023 by assigning weights of 0.1, 0.3, and 0.6 (the oldest data to the most recent data, respectively) (Round off forecast values to one decimal place). 2. Calculate the mean absolute deviation (MAD) of the forecasts for April 2022 to December 2022 (Round off the answer to two decimal place). 3.
The following data structure and constraints exist for a magazine publishing company:a. The company publishes one regional magazine in each of four states: Florida (FL), South Carolina (SC), Georgia (GA), and Tennessee (TN).b. The company has 300,000 customers (subscribers) distributed throughout the four states listed in Problem 2a.c. On the first day of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer's state of residence (FL, SC, GA, TN):The company is aware of the problems associated with centralized management and has decided to decentralize management of the subscriptions into the company's four regional subsidiaries. Each subscription site will handle its own customer and invoice data. The management at company headquarters, however, will have access to customer and invoice data to generate annual reports and to issue ad hoc queries such…
Adelie Enterprises is exploring a new service to provide weekly delivery of grocery items to homes in the greater Greenwood area. The company’s customers place Web-based orders and Adelie’s team assembles and delivers the orders in specially designed cardboard boxes. Management, interested in locating a supplier that can provide boxes cheaply and efficiently, has discovered that each potential supplier’s ability to satisfy the company’s requirements is influenced by the level of demand. The following table provides Adelie’s vendor selection criteria, criterion weights, and rankings (1–10 with 10 being the highest) under the assumption that low, moderate,or high demand is generated for their service.a. Which supplier should be selected if there is low demand for Adelie’s new service? Which supplier should be selected under moderate demand assumptions? Under high demand assumptions?b. Which supplier is selected if Adelie evaluates each alternative using a Maximin decision criterion (see…
The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 5.
Walker Accounting Software is marketed to smallaccounting firms throughout the U.S. and Canada. Owner GeorgeWalker has decided to outsource the company’s help desk and isconsidering three providers: Manila Call Center (Philippines),Delhi Services (India), and Moscow Bell (Russia). The following table summarizes the data Walker has assembled. Which outsourc-ing firm has the best rating? (Higher weights imply higher impor-tance and higher ratings imply more desirable providers.) PX PROVIDER RATINGS CRITERION IMPORTANCEWEIGHT MANILA DELHI MOSCOWFlexibility 0.5 5 1 9Trustworthiness 0.1 5 5 2Price 0.2 4 3 6Delivery 0.2 5 6 6
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $4 (in thousands)is available for this promotional campaign. Based on- past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R2-12M2-9RM + 20R +37M, Where S = total sales R = amount spent on radio advertising M = amount spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. The problem is formulated as below: Max -2R2-12M²-9RM+20R+37M s.t. 1R+1M=0 Using Excel Solver, solve the above nonlinear optimization model. (a) What…
Emily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer. Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time. Emily knows that if any section of…
Timely Transport provides local delivery service for a number of downtown and suburban businesses. Delivery charges are based on distance and weight involved for each delivery: 10 cents per pound and 15 cents per mile. Also, there is a $10 handling fee per parcel.a. Develop an expression that summarizes delivery charges.b. Determine the delivery charge for transporting a 40-pound parcel 26 miles.
The Wilcox Manufacturing Company produces an item that is subject to wide seasonal fluctuations in sale. The forecasted demand for the next 6 months for the forthcoming year are given below: Jan 3000 Feb 5000 March 8000 April 9000 May 4000 June 2000 The firm must always meet the monthly demand requirements. It can fulfill the demand either by producing the required amount during the particular month or by producing only part of the required amount and making up the difference by using the overproduction (inventory) from previous months. The Accounting Department has estimated that it costs $2.00 to increase output by one unit from one month to the next and $1.00 to reduce output by one unit from one month to another. The monthly cost of storing 1 unit of product is $1.50. The warehouse capacity limits maximum inventory to 5000 units. The production capacity of Wilcox for any month is limited to 7000 units. The production schedule for the month of December in the…
The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75