I am having trouble with requirement 4-5. Please see the question and the all requirements listed. Please assist with an excel of 4-5.

I am having trouble with requirement 4-5. Please see the question and the all requirements listed. Please assist with an excel of 4-5.

Kind regards

The board of education for the Central Catskill School District is considering the acquisition of several minibuses for use in transporting students to school. Five of the school district’s bus routes are underpopulated, with the result that the full-size buses on those routes are not fully utilized. After a careful study, the board has decided that it is not feasible to consolidate these routes into fewer routes served by full-size buses. The area in which the students live is too large for that approach, since some students’ bus ride to school would exceed the state maximum of 45 minutes. The plan under consideration by the board is to replace five full-size buses with eight minibuses, each of which would cover a much shorter route than a full-size bus. The bus drivers in this rural school district are part-time employees whose compensation costs the school district $18,000 per year for each driver. In addition to the drivers’ compensation, the annual costs of operating and maintaining a full-size bus amount to $50,000. In contrast, the board projects that a minibus will cost only $20,000 annually to operate and maintain. A minibus driver earns the same wages as a full-size bus driver. The school district controller has estimated that it will cost the district $15,250, initially, to redesign its bus routes, inform the public, install caution signs in certain hazardous locations, and retrain its drivers.

A minibus costs $27,000, whereas a full-size bus costs $90,000. The school district uses straightline depreciation for all of its long-lived assets. The board has two options regarding the five full-size buses. First, the buses could be sold now for $15,000 each. Second, the buses could be kept in reserve to use for field trips and out-of-town athletic events and to use as backup vehicles when buses break down. Currently, the board charters buses from a private company for these purposes. The annual cost of chartering buses amounts to $30,000. The school district controller has estimated that this cost could be cut to $5,000 per year if the five buses were kept in reserve. The five full-size buses have five years of useful life remaining, either as regularly scheduled buses or as reserve buses. The useful life of a new minibus is projected to be five years also.

Central Catskill School District uses a hurdle rate of 12 percent on all capital projects.

Required:

1. Think about the decision problem faced by the board of education. What are the board’s two main alternatives?

2. One of these main alternatives has two options embedded within it. What are those two options?

3. Before proceeding, check the hint given at the end of the chapter, which explains and diagrams the school board’s alternatives. Suppose the board of education chooses to buy the minibuses. Create a net-present-value analysis of the two options for the five full-size buses. Should these buses be sold now or kept in reserve?

4. From your answer to requirement (3), you know the best option for the board to choose regarding the full-size buses if the minibuses are purchased. Now you can ignore the other option. Create a net-present-value analysis of the school board’s two main alternatives: (a) continue to use the full-size buses on regular routes or (b) purchase the minibuses. Should the minibuses be purchased?

5. Compute the internal rate of return on the proposed minibus acquisition.

Office King Corporation manufactures three different models of paper shredders including the waste container that serves as the base. While the shredder heads are different for the three models, the waste container is the same. The number of waste containers that Office King will need during the next five years is estimated as follows:

20×1 ……………………………………………………………………. 50,000

20×2 ……………………………………………………………………. 50,000

20×3 ……………………………………………………………………. 52,000

20×4 ……………………………………………………………………. 55,000

20×5 ……………………………………………………………………. 55,000

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more