Year O Year 1 Year 2 Year 3 Year 4 Year 5 $50,000 $50,000 $50,000 $50,000 $50,000 Net economic $0 benefit Onetime costs $47,500 Recurring costs $0 $32,000 $32,000 $32,000 $32,000 $32,000

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...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Pine Valley Furniture
Pine Valley Furniture recently implemented
a new internship program and has begun recruiting interns from nearby university campuses. As part of this program, interns have
the opportunity to work alongside a systems
analyst. This shadowing opportunity provides invaluable insights into the systems
analysis and design process. Recently you
were selected for a six-month internship at
Pine Valley Furniture, and Jim Woo has been
assigned as your supervisor.
At an initial meeting with Jim Woo, he explains
that Pine Valley Furniture is currently involved
with two important systems development
projects, the customer tracking system and WebStore. The purpose of the customer tracking system is to enable the PVF marketing group
to track customer purchase activity and sales
trends better. The WebStore project will help
move the company into the twenty-first century
by facilitating online furniture purchases, with
an initial focus on corporate furniture buying.
During your meeting with Mr. Woo, he reviews
the documentation assembled for both systems.
Mr. Woo hands you a copy of the customer
tracking system’s economic feasibility analysis.
He mentions that he would like to modify the
spreadsheet to reflect the information provided
in the following table. Because you are familiar
with a spreadsheet product, you volunteer to
make the modifications for hima. How were Pine Valley Furniture’s projects initiated? What is the focus for each
of the new systems?
b. Modify the customer tracking system’s
economic feasibility analysis to reflect the
modifications mentioned in this case problem. Use a discount rate of 10 percent. After
the changes are made, what are the new
overall NPV, ROI, and break-even point?
c. Modify the worksheet created in part b
using discount rates of 12 and 14 percent.
What impact do these values have on the
overall NPV, ROI, and break-even point?
d. Jim Woo would like to investigate how
other online stores are targeting the business furniture market. Identify and evaluate two online stores that sell business
furniture. Briefly summarize your findings.

Year O Year 1 Year 2 Year 3 Year 4 Year 5
$50,000 $50,000 $50,000 $50,000 $50,000
Net economic $0
benefit
Onetime costs $47,500
Recurring costs $0
$32,000 $32,000 $32,000 $32,000 $32,000
Transcribed Image Text:Year O Year 1 Year 2 Year 3 Year 4 Year 5 $50,000 $50,000 $50,000 $50,000 $50,000 Net economic $0 benefit Onetime costs $47,500 Recurring costs $0 $32,000 $32,000 $32,000 $32,000 $32,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.