A 307. A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers withoutshortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below showsthe capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer.Factory/CapacityA/180 unitsB/160 unitsC/110 unitsFactoryABCRequirement-225 unitsCustomer1Customer 113750✔Answer is complete but not entirely correct.Shipping Costs ($/unit)Customer115110✔✓Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain toenter "0" wherever required.)30✔45✔0✔600 XCustomer3Shipping Costs ($/unit)Customer 2X Answer is complete but not entirely correct.Totalcost150✔150 x0✓Requirement-75 unitsWhat is the total cost of meeting customer requirements each day?11610Customer11108Requirement-150 units

Answered: Image /qna-images/answer/0bff12cc-2614-4a68-8194-5e731d9404b1.jpg

A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Factory/Capacity A/180 units B/160 units C/110 units Factory A B C Customer 1 Total cost Customer 1 13 7 5 Requirement-225 units 0✔ 115✔ 110✔ Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) X Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer 2 600 30✔ 45✔✔ 330 0✔ Customer 3 Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer 2 150 150 x 0 What is the total cost of meeting customer requirements each day? Requirement-75 units 11 6 10 Customer 3 11 10 8 Requirement-150 units

A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Factory/Capacity A/180 units B/160 units C/110 units Factory A B C Customer 1 Total cost Customer 1 13 7 5 Requirement-225 units 0✔ 115✔ 110✔ Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) X Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer 2 600 30✔ 45✔✔ 330 0✔ Customer 3 Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer 2 150 150 x 0 What is the total cost of meeting customer requirements each day? Requirement-75 units 11 6 10 Customer 3 11 10 8 Requirement-150 units

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

QUESTION 12 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the answer using the criterion of minimax regret? Alternatives Large Inventory Small Inventory Probability O A) -$2,000 O B) $130,000 O C) $0 O D) $20,000 O E) $153,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 .30
Q. Hotel California has 160 rooms. The hotel has an ample low-fare demand at the room rate of $200 per night, but the demand from the high-fare class which pays $450 per night on average, is uncertain. Table below shows the number of high-fare rooms that were booked during the past 30 days. How many rooms should Hotel California protect for high-fare customers to maximize its expected revenue? Number of high-fare rooms Frequency 0 5 1 3 2 6 3 8 4 4 5 1 6 1 7 2 Total=30
Ch 11 Q10
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
D & R A1 10 - 6 Question 10. Minimum Variance Commodity Hedge Choc Full of Good Inc., a producer of powdered hot chocolate, has just received a large order that will require the purchase of 800 metric tons of cocoa in 3 months. The current spot price of cocoa is US $3,055 per metric ton. The standard deviation of the change in spot cocoa price is 0.2. Mr. Dulce, the CFO of Choc Full, is considering a minimum-variance hedge of this future cocoa purchase using the three-month cocoa futures contract. The contract size is 10 metric tons. The standard deviation of the change in cocoa futures price is 0.25. The covariance between the change in the spot and futures cocoa price is 0.035. The annually compounded interest rate faced by the company is 5%, the three-month storage cost is $2.5 per metric ton, and the convenience yield is $0.5 per metric ton. What is the estimated effectiveness of this minimum variance hedge?
Discussion: IT risk control measures.
QUESTION 15 The Sweet Success Bakery sells 800 cakes at a price of $20 per cake. Its total economic costs for producing 800 cakes are $4,800. The Sweet Success Bakery's economic profits are O $4,800. $11,200. $16,000. indeterminate from this information.
Question THREE: Suppose you are given a set of data for output at a company which manufactures detergents over a period of time. You have determined a relation between total operating cost and the quantity produced and is given by the linear regression model as follows: TC=20,000+2,500Q, where TC=Total Operating Cost (in $) per annum and Q = Quantity produced per annum Required: i. Determine the total operating cost in the event that quantity of production is at 4,500, 12,500 and 7,000units. ii. What do you think would be your reservations in relaying on the linear regression model for budgetary planning purposes?
Q7 what are the different way in which an offer terminates
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
Q.3.2 Mpho is an avid seamstress and want to sew and sell high quality, reusable,designer face masks during the current Covid-19 pandemic. She will design andsew the masks herself and use her automatic embroidery machine to put her logoon each mask sold. With the help of her son, deliveries will be made all overGauteng within 3 days of placing the order. Every mask will have a unique threelayer design with adjustable straps to ensure comfort and fit. Mpho’s only expenseis the material needed to sew the masks and delivery costs. At this stage, Mpho’starget market is limited to Gauteng.Draw a diagram to illustrate the transformation process of Mpho’s new business.Be sure to include all relevant elements, headings and arrows to indicate the flowof products/ services.
Question 7 The major stated advantage of maquiladoras is to lower costs of taxation. True False