PLEASE ANSWER STEP BY STEP AND ON EXCEL Contois Carpets is a small manufacturer of carpeting for home and office installations. Production capacity, demand, production cost per square yard (in dollars), and inventory holding cost per square yard (indollars) for the next four quarters are shown in the network diagram below.50600300500400ProductionCapacitiesProductionNodesBeginning1 InventoryBeginningInventory2Quarter 12 ProductionQuarter 1Production3Quarter 23 ProductionQuarter 2Production4Quarter 34 Production.Quarter 3Production5Quarter 45 ProductionQuarter 4ProductionProduction CostPer Square Yard025Inventory Costper Square Yard33Production(arcs)DemandNodesQuater 1Demand0.250.256Quater 16 DemandQuarter 2Demand0.257Quarter 27 Demand8Quarter 3Demand0.254008Quarter 3Demand.9Quarter 4Demand5004009Quarter 4Demand40010Ending10 InventoryEndingInventory100Demand.℗ Develop a linear programming model to minimize cost. (Let x,, be the number of square yards of carpet which flows from node/ to node j.)Mins.t.Beginning Inventory FlowQuarter 1 Production FlowQuarter 2 Production FlowQuarter 3 Production FlowQuarter 4 Production FlowQuarter 1 Demand FlowQuarter 2 Demand FlowQuarter 3 Demand FlowQuarter 4 Demand FlowEnding Inventory Flowxij≥0 for all i, j.Solve the linear program to find the optimal solution (in dollars).(X16X261 X371 X48X591 X671 X781 X89X910) =with cost $

Linear programming is a mathematical technique that is also used in operations management…

Answered: Develop a linear programming model to…

MARKETING 2018

19th Edition

ISBN:9780357033753

Author:Pride

Publisher:Pride

Chapter14: Marketing Channels And Supply Chain Management

Section14.1: Taza Cultivates Channel Relationships With Chocolate

Problem 1VC

See similar textbooks

Similar questions

Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. ITI Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 7'000 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000 Select one: a. None of the above b. 106.67 c. 108.00 / d. 92.59
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000
The following is a description of some data requirements for a chain of hypermarkets. (a) A company manufactures one or more cakes, and each cake is manufactured and marketed by exactly one company. (b) Cakes are sold in hypermarkets. Each hypermarket has a unique identification. Every hypermarket sells one or more cakes, but some hypermarkets do not sell every cake. (c) Cake sales must be recorded by invoice, which are kept as a record by the hypermarket. An invoice clearly identifies the cake, chief, and customer, as well as the date it is filled. (d) Chief produces cakes for customer. A Chief can produce one or more cakes for a customer and a customer can get one or more invoices, but a invoice is written by only one chief. (e) Cake manufacturer companies may have long-term contracts with hypermarkets and a hypermarket can contract with zero, one, or more companies. Each contract is uniquely identified by a contract number. Draw the appropriate entity-relationship (E-R)…
K As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $1.75 $1.00 $0.75 Variable Cost $0.70 $0.90 $0.30 $0.35 % of Revenue 24 26 30 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $280.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $280.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $(round your response to two decimal places).
Consider the supply chain illustrated below: Manufacturer Distributor Wholesaler Retailer Last year the retailer's weekly variance of demand was 190 units. The variance of orders was 490, 610, 730, and 1,320 units, for the retailer, wholesaler, distributor, and manufacturer, respectively. (Note that the variance of orders equals the variance of demand for that firm's supplier.) a) The bullwhip measure for the retailer is decimal places.) b) The bullwhip measure for the wholesaler is two decimal places.) (Enter your response rounded to two (Enter your response rounded to c) The bullwhip measure for the distributor is ☐. (Enter your response rounded to two decimal places.) d) The bullwhip measure for the manufacturer is two decimal places.) e) In this supply chain, the bullwhip effect. (Enter your response rounded to appears to be contributing the most to the
1. Superior Wire, Inc. produces and sells special types of wire used in a variety of telecommunication applications. The firm's initial growth came from sales of a new wire that was used by cellular telephone service companies when setting up transmission stations. However, growth in that market has slowed. Moreover, at present, most of the other products offered by the firm are similar to those available from a variety of other suppliers. Angelina Stowe, the marketing manager for the company, recently scheduled a meeting with the company president to discuss problems of falling profits. Stowe expressed concern that the company did not have a specific person responsible for identifying new products. The president pointed out that few other firms in their industry had such a position and generally argued that new product thinking was the responsibility of everyone in the firm. After further discussion, the president agreed to let Stowe send out a memo to all company employees…
Thinking tools service assembles customized personal computers from generic parts. Formed and operated by part-time Svci students paulette cruz and maureen luis, the company has had steady growth since it started. The company assembles computers mostly at night, using part time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below A. Use exponential smoothing with smoothing parameter a=0.2 to compute the demand forecast for january (period 13) B. Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for january (period 13). C. Paulette believes that there is an upward trend in the demand, the initial forecast is 37 and the trend over this period is 0 units. Use…
If Exxon uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is 110 barrels of crude oil. Beginning inventory and purchases Barrels Barrel cost Total cost Beginning inventory: Jan 1 129 $ 96 $ 12,384 March 1 54 102 5,508 June 1 69 99 6,831 September 1 79 91 7,189 December 1 54 104 5,616 385 $ 37,528 Cost of ending inventory Cost of goods sold
Imagine that you own a bakery! Your bakery sells cookies and brownies only. To run your bakery successfully, you must determine the production cost for each item, as well as, your maximum production cost for each day. Create a business plan for your bakery! Your business plan must include the following: • The cost to produce a cookie • The cost to produce a brownie • Your maximum production costs per day • The system of inequalities that describes these restrictions • A graph of your system including the shaded solution region
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is about $5. RW i gures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year.Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days.a. What is the economic order quantity?b. What is the reorder point?
Kelley, Inc. provided the following account balances for 2018: Cost of Goods Sold (Cost of sales) Beginning Merchandise Inventory Ending Merchandise Inventory $1,300,000 330,000 350.000 Calculate the average number of days that inventory was held by Kelley, Inc. during 2018. (Assume 365 days in a year. Round your intermediate calculations and final answer to two decimal places.) O A. 191.10 days O B. 92.64 days O C. 95.55 days O D. 98.38 days
The earnings of the organization can be considerably impacted by buyers and supply chain management. Anorganization may spend up to 50% of its sales revenue on the acquisition of goods and services, including rawmaterials.You are employed as a purchasing director at Food Lovers in Durban, South Africa. Transportation helps people in those various locations to trade and conduct business with one another by movingpeople and things to different neighborhoods, cities, states, and countries.Examine any FIVE (5) factors that Food Lovers should consider when selecting mode of shipment, carrier and routing.

SEE MORE QUESTIONS

Recommended textbooks for you

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS