Question

In: Advanced Math

WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the...

WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the purchase of additional trucks, of which three sizes are available. A large truck costs $150,000 and will return the equivalent of $15,000 per year to profit. A medium-sized truck costs $90,000 and will return the equivalent of $12,000 per year. A small truck costs $50,000 and will return the equivalent of $9,000 per year. WeHaul has maintenance capacity to service either four large trucks, five medium-sized trucks, or eight small trucks, or some equivalent combination. WeHaul believes that it will be able to hire a maximum of seven new drivers for these added trucks. The company cannot spend more than one/half of the total funds it actually spends to purchase medium-sized trucks. (Hint: this is not necessarily one half of the total funds it has allocated for the purchase of additional trucks).   

You must submit your linear programming formulations and show the linear programming software solution to this problem to receive credit. If you solve this using another linear programming approach, you may submit that instead of the software solution.   

a) Formulate a linear programming model to be used for determining how many of each size of truck to purchase if the company wants to maximize its profit. Ignore the time value of money. Provide the linear programming variables, the objective function, and the constraints for the problem.

b) At optimality, how much profit will result and what is the optimal combination of trucks? You must submit your linear programming formulations and show the linear programming software solution to this problem to receive credit. If your answer is in fractional units of trucks that is acceptable – do not round to whole number of trucks.

c) Using your sensitivity analysis output, provide two sensitivity analysis interpretations. One must be for the objective function and one must be for one of the constraints. You must provide the source of your answers from the sensitivity analysis output.

d) Now suppose that there is a requirement that WeHaul must purchase at least two small trucks for each medium size truck. Also, the number of larger trucks cannot be more than the total number of medium and small trucks. Write the constraint(s) for this requirement. However, you do not need to resolve the problem.

Solutions

Expert Solution


Related Solutions

WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the...
WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the purchase of additional trucks, of which three sizes are available. A large truck costs $150,000 and will return the equivalent of $15,000 per year to profit. A medium-sized truck costs $90,000 and will return the equivalent of $12,000 per year. A small truck costs $50,000 and will return the equivalent of $9,000 per year. WeHaul has maintenance capacity to service either four large trucks,...
Zepol Company is planning to produce 600,000 power drills for the coming year. The company uses...
Zepol Company is planning to produce 600,000 power drills for the coming year. The company uses direct labor hours to assign overhead to products. Each drill requires 0.75 standard hour of labor for completion. The total budgeted overhead was $1,777,500. The total fixed overhead budgeted for the coming year is $832,500. Predetermined overhead rates are calculated using expected production, measured in direct labor hours. Actual results for the year are: Actual production (units) 594,000 Actual variable overhead $928,000 Actual direct...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
In December 20.8, Finch Limited was planning its financial needs for the coming year. As a...
In December 20.8, Finch Limited was planning its financial needs for the coming year. As a first indication, the firm’s management required a pro forma Statement of Financial Position as at 31 December 20.9 to gauge the financial needs at that time. Estimated financial condition as at 31 December 20.8 was reflected in this Statement of Financial Position : ASSETS R Non-current assets    451 800 Property, plant and equipment    843 000 Accumulated depreciation   (434 600) Other non-current assets       43 400...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year....
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 65%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year...
24. Taylor Trucking is considering purchasing a new truck. It is expected the truck will increase...
24. Taylor Trucking is considering purchasing a new truck. It is expected the truck will increase annual revenues by $31,000 and increase annual expenses by $19,800 including depreciation. The truck will cost $110,000 and will have a $2,000 salvage value at the end of its useful life. Compute the annual rate of return. 20% 20.7% 10% 10.2% 23. Evergreen Co. is contemplating the purchase of a new machine that has expected annual net cash inflows of $25,000 over its 3...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with a mean of 60 thousand miles and a standard deviation of 10 thousand miles. Complete parts​ (a) through​ (d) below. a. What proportion of trucks can be expected to travel between 48 and 60 thousand miles in a​ year? b. What percentage of trucks can be expected to travel either less than 40 or more than 75 thousand miles in a​ year? c. How...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with a mean of 50 thousand miles and a standard deviation of 12 thousand miles. Complete parts​ (a) through​ (c) below. a. nbsp What proportion of trucks can be expected to travel between 34 and 50 thousand miles in a​ year? The proportion of trucks that can be expected to travel between 34 and 50 thousand miles in a year is . 4082. ​(Round to...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with...
A trucking company determined that the distance traveled per truck per year is normally​ distributed, with a mean of 80 thousand miles and a standard deviation of 10 thousand miles. How many miles will be traveled by at least 70​% of the​ trucks? The number of miles that will be traveled by at least 70​% of the trucks is ___miles. ​(Round to the nearest mile as​ needed.) d. What are your answers to parts​ (a) through​ (c) if the standard...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT