stock exchange and gained P 309,000.00 in three weeks. Compute the ROI for both investments and identify which one he should pursue the most.

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
Question
100%

Pls help me answer all items here. Tysm.

EXERCISE # 2
1. Solve the following problems.
1. Mr. Hiruzen Sarutobi invested P 200,000.00 for his trucking business. He was fortunate and earned 2%
increase from his current value of investment in two weeks. Meanwhile, he invested P 300,000.00 in
stock exchange and gained P 309,000.00 in three weeks. Compute the RO1 for both investments and
identify which one he should pursue the most.
2. Identify the Sales Growth Percent and compute the 5-year forecast.
2019
2000 2021
2022
Sales Growth Percent
Revenues
548,391.58 563,594.10
15.20
3. Compute the 5-month moving average and 7-month moving average of the data below.
33,000
49,000
56,000
44,000
38,000
45,000
51,000
55,000
53,000
43,000
36,000
47,000
51,000
58,000
60,00O
59,00O
50,00O
41,00O
Transcribed Image Text:EXERCISE # 2 1. Solve the following problems. 1. Mr. Hiruzen Sarutobi invested P 200,000.00 for his trucking business. He was fortunate and earned 2% increase from his current value of investment in two weeks. Meanwhile, he invested P 300,000.00 in stock exchange and gained P 309,000.00 in three weeks. Compute the RO1 for both investments and identify which one he should pursue the most. 2. Identify the Sales Growth Percent and compute the 5-year forecast. 2019 2000 2021 2022 Sales Growth Percent Revenues 548,391.58 563,594.10 15.20 3. Compute the 5-month moving average and 7-month moving average of the data below. 33,000 49,000 56,000 44,000 38,000 45,000 51,000 55,000 53,000 43,000 36,000 47,000 51,000 58,000 60,00O 59,00O 50,00O 41,00O
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
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.