3. Machine Supply Co. plans to open a new branch in Houston, TX to provide local...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Machine Supply Co. plans to open a new branch in Houston, TX to provide local support to its customers in the area. The company currently considers two locations (small and large) for its new branch. While the small location can store up to 500 units of product, the large one can store up to 1200 units (more than these amounts cannot be stored at any time). However, the large location costs an additional $1000 per month to rent compared to the small location. Transportation companies charge different amounts for small and large locations as provided in the table below. The expected demand in the greater Houston area is 52000 units and each unit costs $300. The inventory holding rate per year is 24%. Given the below information about two locations and transportation company. Which branch location should be chosen by Machine Supply CO.? NOTE: It is expected that the average inventory level in Memphis, TN (the source facility) will not be affected by these decisions. If you need any additional information, please note down your assumptions. (20 Points) Name Small Large Fixed Transportation Cost per Delivery $500 $950 In-Transit Time (days) 3 2 3. Machine Supply Co. plans to open a new branch in Houston, TX to provide local support to its customers in the area. The company currently considers two locations (small and large) for its new branch. While the small location can store up to 500 units of product, the large one can store up to 1200 units (more than these amounts cannot be stored at any time). However, the large location costs an additional $1000 per month to rent compared to the small location. Transportation companies charge different amounts for small and large locations as provided in the table below. The expected demand in the greater Houston area is 52000 units and each unit costs $300. The inventory holding rate per year is 24%. Given the below information about two locations and transportation company. Which branch location should be chosen by Machine Supply CO.? NOTE: It is expected that the average inventory level in Memphis, TN (the source facility) will not be affected by these decisions. If you need any additional information, please note down your assumptions. (20 Points) Name Small Large Fixed Transportation Cost per Delivery $500 $950 In-Transit Time (days) 3 2
Expert Answer:
Answer rating: 100% (QA)
To determine which branch location Machine Supply Co should choose we need to compare the total costs associated with each location Lets calculate the total costs for each location 1 Small Location Rent cost 0 Assuming no additional cost mentioned Transportation cost per unit 500 Transportation time 3 days Holding cost per unit per year 24 of 300 unit cost 72 Total units needed to meet demand 52000 units Total transportation cost 500 52000 units 26000000 Total holding cost 72 52000 units 3744000 Total cost 26000000 3744000 29744000 2 Large Location Rent cost 1000 per month Transportation cost per unit 950 Transportation time 2 days Holding cost per unit per year 72 Total units needed to meet demand 52000 units Total transportation cost 950 52000 units 49400000 Total holding cost 72 52000 units 3744000 Total rent cost 1000 12 months 12000 Total cost 49400000 3744000 12000 53156000 Based on the calculations the total cost ... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A major banking institution, Best Bank, plans to open a new branch office in Little-town. Preliminary estimates suggest that two tellers (and teller windows) should be provided, but this decision now...
-
1. The two taxes paid on most purchases are the amount of each tax is % and and the % respectively. 2. Use the "10% + 5%" method of estimating total cost. Estimated Rounded Cost Item Cost 10% 5%...
-
Exercise 11-11 presented data on y = chloride concentration in surface streams and x = roadway area. (a) Test the hypothesis H0: B1 = 0 versus H1: B1 = 0 using the analysis of variance procedure with...
-
A liquid mixture containing 70.0 mol of n -pentane and 30.0 mol of n -hexane initially at 46?C is partially vaporized at P = 1 atm in a single-stage distillation apparatus (Rayleigh still). The heat...
-
In complexity science, the movement of an organization as it changes from one attractor or mission statement to another is known as: A. Leverage. B. Bifurcation. C. Chaos. D. Order.
-
The following situations represent errors and frauds that could occur in financial statements. Required: State how the ratio in question would compare (higher, equal, or lower) to what the ratio...
-
Your investment of $10,000 grew to $11,800 in 4 years. What was the balance on the account at the end of two years? O a. $10,862.78 b. $10,900.00 O c. $11,362.60 O d. $11,321.70 O e. $11,266.00 Close
-
How much charge is represented by these number of electrons? (a) 6.482 10 17 (b) 1.24 10 18 (c) 2.46 10 19 (d) 1.628 10 20
-
The City Hall Debt Service Fund of the City of Monroe has been open for five years; it was created to service an $16,000,000, 3 percent tax-supported bond issue. As of December 31, 2014, this serial...
-
The following Spreadsheet is an example of such a model. Column B contains the inputs we have used so far for Honda. Column E contains dividend forecasts. In cells E2 through E5 we present the Value...
-
(20 points) Consider the following process definitions: def LECTURE = RAMBLE + EDUCATE def RAMBLE talk. RAMBLE + pause. RAMBLE def EDUCATE talk.EDUCATE + teach.LECTURE Give a formal derivation for...
-
Consider the problem of accurately eval- uating f(x)=e-1 for x 0 (say, |x| < 10-6). a) Use a Taylor series to find a degree-3 polynomial approximation to f(x). Use big-O notation to describe the...
-
For the variable-size subnetting, show (1) the sizes of the subnets and (2) the IP-address ranges for each subnet. d. Network 205.10.10.0/24 into the variable length subnets: Net-A, Net-B, Net-C,...
-
Three capacitors are connected as shown in the figure below. The total charge in the circuit is Qtot 1.5 x 10-10 C. (a) Show that the equivalent capacitance in the circuit is Ceq = 5 pF. (b) Deduce...
-
A standard AC motor, generating 10 horsepower at 1,800 revolutions per minute (rpm), is employed to operate a blower at 900 rpm through belt drive mechanisms, illustrated in Figure Q3. The driver and...
-
Suppose Green Network Energy needs to raise money to finance its new manufacturing facility, but their CFO does not think the company is financially capable of making the periodic interest payments...
-
a. Determine the amount of potatoes and green beans Maria should purchase each week for the casserole to minimize the ingredient costs while meeting nutritional, taste, and demand requirements....
-
The Oak Works is a family-owned business that makes handcrafted dining room tables and chairs. They obtain the oak from a local tree farm, which ships them 2,500 pounds of oak each month. Each table...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 7.5. Briefly describe how mixed BIP was applied in this...
-
What are the basic rights of the owner of a share of corporate stock? In what way are these basic rights commonly modified with respect to the owner of a share of preferred stock?
-
Explain the following terms: a. Stock transfer agent. b. Stockholders subsidiary ledger. c. Underwriter. d. Stock registrar.
-
On April 1,2008 , Sanders Construction paid \(\$ 10,000\) for equipment with an estimated useful life of 10 years and a residual value of \(\$ 2,000\). The company uses the doubledeclining-balance...
Study smarter with the SolutionInn App