Wiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs per shipment (labor, transportation, and utilities) are listed in the following table. Sales projections range from 500,000 to 600,000 shipments per year. Location Denver Santa Fe Salt Lake City Annual Fixed Costs $4,800,000 $4,500,000 $3,200,000 Variable Costs per Shipment $4.55 $6.20 $7.50 a. Plot the total cost curves for all the locations on a single graph. b. Which city provides the lowest overall costs?

Wiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs per shipment (labor, transportation, and utilities) are listed in the following table. Sales projections range from 500,000 to 600,000 shipments per year. Location Denver Santa Fe Salt Lake City Annual Fixed Costs $4,800,000 $4,500,000 $3,200,000 Variable Costs per Shipment $4.55 $6.20 $7.50 a. Plot the total cost curves for all the locations on a single graph. b. Which city provides the lowest overall costs?

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

Explain the terms flow rime and lateness.
A construction company Y is considering to participate in the tendering process forbuilding a toll bridge. The duration of the construction project is 5 years. The successfultenderer is allowed to collect toll from the bridge users after the completion of the projectand subsequently will be responsible for maintaining the bridge. The expected cash flowtransactions from this project are as follows:• Receive bank loan of RM 2,000,000 now• Annual material expenses of RM 200,000 in year 1 and expected to increase by RM20,000 per year until year 5• Annual bridge maintenance cost of RM 70,000 from year 6 until end of bridge life• Annual bank loan payment of RM 500,000 starting from the first year until at theend of year 10• Progress payment received from the government: RM 4,000,000 (end of year 3)and RM 8,000,000 (end of year 5)• Toll revenue of RM 500,000 per year from year 6 until year 10 a) Construct cash flow diagram to summarize the above transactions. b) Another company is interested…
If property management have to go the resident home for checking what possible problem does the property management will face and how to due with ? i hope you can ans me thank you
2
Explain break-even analysis, using both the graphic and algebraic approaches.
What is the relationship between the aggregate plan andthe master production schedule?
Mrs. Johnson failed to renew her sales associates license last year. Her license is now on inactive status. What can Mrs. Johnson do to reactivate her license? О Simply pay the renewal fee online. Complete the required continuing education, submit a renewal application and pay the renewal fee. Retake the 63-hour pre-license course, pass the state licensing exam, and apply for a new license. Submit a renewal application online. There are no reactivation fees required.
Define and Illustrate STEEP analysis
What will happen to financial results if a specified level of activity or volume changes?
Please do not give solution in image format thanku
What is the procedure of the construction electronic invoicing/
For many firms, inventory usage is not uniformthroughout the year but instead follows some seasonal pattern. Can the EOQ model be used in thissituation? If so, how?