Course Project A
For Project A, you will
need to review the Course Project Instructions in Document Sharing. An Excel
template file can be also found in Doc Sharing. Use it to do your master
budget and supporting schedules. This project will help you learn and understand
what a master budget is and how it is prepared. When you have
completed Project A, upload it into the Dropbox. There will be a
discussion thread area in Weeks 4 and 5 that you can use to ask questions about
the project.
Grading Rubric for
Course Project (Part A)
Category
Points
%
Description
Documentation
& Formatting
10
10%
Project
worksheets will be done in Excel and will contain formulas to receive
maximum credit.
Organization
& Cohesiveness
10
10%
Calculations should
be organized and correctly labeled.
Editing
10
10%
Quality work will be
free of any spelling, punctuation, or grammatical errors.
Content
70
70%
A quality project will
have all required work completed and will be correct.
Total
100
100%
A quality
project will meet or exceed all of the above requirements.
See Syllabus, Due Dates for Assignments & Exams, for due date information.
Course Project B
Clark Paints: The Production Department has been
investigating possible ways to trim total production costs. One possibility currently
being examined is to make the paint cans instead of purchasing them. The
equipment needed would cost $200,000, with a disposal value of $40,000, and it
would be able to produce 5,500,000 cans over the life of the machinery. The
Production Department estimates that approximately 1,100,000 cans would be
needed for each of the next five years.
The company would hire three new employees. These three individuals would be
full-time employees, working 2,000 hours per year and earning $12.00 per hour.
They would also receive the same benefits as other production employees, 18% of
wages, in addition to $2,500 of health benefits.
It is estimated that the raw materials will cost 25¢ per can and that other
variable costs would be 5¢ per can. Since there is currently unused space in
the factory, no additional fixed costs would be incurred if this proposal is
accepted.
It is expected that cans would cost 45¢ each if purchased from the current
supplier. The company’s minimum rate of return (hurdle rate) has been
determined to be 12% for all new projects, and the current tax rate of 35% is
anticipated to remain unchanged. The pricing for a gallon of paint, as well as
the number of units sold, will not be affected by this decision. The
unit-of-production depreciation method would be used if the new equipment is
purchased.
Required:
1. Based on the above information and using Excel, calculate the
following items for this proposed equipment purchase:
Annual cash flows over the expected life of the
equipment;Payback period;Annual rate of return;Net present value; andInternal rate of return.
2. Would you recommend
the acceptance of this proposal? Why or why not? Prepare a short, double-spaced
Word paper elaborating and supporting your answer.
Note: A sample problem can be found in Doc Sharing
(Word document instructions and Excel document solution).
Grading Rubric for
Course Project (Part B)
Category
Points
%
Description
Documentation
& Formatting
6
10%
Project worksheets will
be done in Excel and will contain formulas to receive maximum credit. Work
will be appropriately cited.
Organization
& Cohesiveness
6
10%
Calculations should
be organized and correctly labeled. Also, for the Part B paper, a quality
paper will include an introduction of the company and industry. In a quality
project, the conclusion will summarize the strengths and weaknesses and their
recommendations.
Editing
6
10%
Quality work will be
free of any spelling, punctuation, or grammatical errors. Sentences and
paragraphs (where appropriate) will be clear, concise, and factually
correct.
Content
42
70%
A quality project will
have all required work completed and will be correct.
Total
60
100%
A quality
project will meet or exceed all of the above requirements.
See Syllabus, Due Dates
for Assignments & Exams, for due date information.
.next.ecollege.com/(NEXT(5d52716f34))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=389516756&courseItemType=CourseContentItem&#top”>.png” alt=”xx”>
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.
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 moreEach 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 moreThanks 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 moreYour 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 moreBy 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