The Westfall Company has a contract to produce 10,000 garden hoses for a large discount chain....

The Westfall Company has a contract to produce 10,000 garden hoses for a large discount chain. Westfall has four different machines that can produce this kind of hose. Because these machines are from different manufacturers and use differing technologies, their specifications are not the same.

Machine	Fixed Cost to Set Up Production Run	Variable Cost Per Hose	Capacity
1	750	1.25	6000
2	500	1.50	7500
3	1000	1.00	4000
4	300	2.00	5000

Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. Submit your Excel Solver file.

Hint: Some combination of the machines will be used to achieve the objective. All machines may or may not be used.

Solutions

Expert Solution

Total Cost = 13250

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

As the summer intern for a company that manufactures nozzles for garden hoses, you are working...

As the summer intern for a company that manufactures nozzles for garden hoses, you are working on a project involving adjustable hose nozzles. Your design calls for a rotating head that has a number of cylindrical plugs that can be inserted into the hose opening. On a particular setting, the speed of the water passing around the plug is 7 times as large as the speed of the water in the hose. Determine the ratio of the plug radius (rplug)...

Grande Stores is a large discount catalog department store chain. The company has recently expanded from...

Grande Stores is a large discount catalog department store chain. The company has recently expanded from six to 43 stores by borrowing from several large financial institutions and from a public offering of common stock. A recent investigation has disclosed that Grande materially overstated net income. This was accomplished by understating accounts payable and recording fictitious supplier credits that further reduced accounts payable. An SEC investigation was critical of the evidence gathered by Grande’s audit firm, Montgomery & Ross, in...

a) Bargain Town is a large discount chain. The management wishes to compare the performance of...

a) Bargain Town is a large discount chain. The management wishes to compare the performance of its credit managers in Ohio and Illinois, by comparing the mean dollar amount owed by customers with charge accounts in both two states. A small mean is desirable. Suppose that Bargain Town randomly selected the following small samples. Sample of Ohio accounts Sample of Illinois accounts no=10 no= 6 yo = $124 y1 = $68 s2o= 1681 s2o= = 484 Assuming that equal variances,...

Luxury Ltd is a large company that manufactures and sells wooden garden furniture. It has been...

Luxury Ltd is a large company that manufactures and sells wooden garden furniture. It has been very active in acquisition in recent years and acquired three small companies in the last few years. Mr. Yung, the CEO, determines to let the three companies running as autonomous investment center, as Division A, B and C respectively, each responsible for different specific product groups. The most recent sales and operating data for the three divisions are given below (In million dollars): Operating...

Lee Flower Company is a flower producer located in Auburn. It has a large contract with...

Lee Flower Company is a flower producer located in Auburn. It has a large contract with Wal-Mart to supply azaleas to the stores in the southeast region of the country. From past sales data, it has become evident that the larger, healthier plants sell better than the smaller plants. Thus, the flower producer wants to improve the growing process so that they will have larger, healthier azaleas. Wal-mart is very tough on their suppliers to provide healthy azaleas because they...

Your consulting company has been selected as a finalist for a large consulting contract with a...

Your consulting company has been selected as a finalist for a large consulting contract with a very prestigious company. The job will pay very well and will lead into other more profitable projects. As part of the selection process, you have been requested to prepare a one page summary to present your deployment plan and project launch for a waste minimization project to be given to the executive team at the company. Please review the information below and prepare a...

A gardener has a very large garden that has a problem with caterpillars. The caterpillars eat holes...

A gardener has a very large garden that has a problem with caterpillars. The caterpillars eat holes in the leaves of plants and can damage fruits and vegetables. The gardener randomly selects 10 holes left by the caterpillars and measures the diameter in milimeters (mm). 14 9 10 11 12 10 7 15 8 12 Assume that the diameter of hole left by caterpillars is normally distributed. (a) Use these measurements to calculate a 90% confidence interval for µ, the mean diameter...

Construction Engineering question: Produce a environmental management plan Company has been awarded the contract for a...

Construction Engineering question: Produce a environmental management plan Company has been awarded the contract for a bridge replacement, including 2km approach resurfacing on each side and has placed you and your team in charge. Produce a environmental management plan. Thanks!!

Your friend has a large garden and grows fresh fruit and vegetables to be sold at...

Your friend has a large garden and grows fresh fruit and vegetables to be sold at a local “farmer’s market.” Your friend comments, “I hired a college student who was on summer vacation to help me this summer and my production more than doubled. Next summer, I think I’ll hire two or maybe three helpers and my output should go up more than three- or fourfold.” a. How could it be true that your friend hired a helper (double the...

XX company budgeted 10,000 units for production during 2019. It has capacity to produce 12,000 units....

XX company budgeted 10,000 units for production during 2019. It has capacity to produce 12,000 units. Fixed factory overhead is allocated to production. The following estimated costs were provided for 10,000 units: Direct material $ 70,000 Direct labor 300,000 Variable manufacturing overhead 40,000 Fixed factory overhead costs 50,000 Total $ 460,000 All fixed costs are unavoidable. XX received an offer from another company to manufacture the 10,000 units for $39, for the same quality. In this case, when XX compares...

Subjects