Decreased
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...
Related questions
Question
Media for settlement:
Excel (source or supporting data)
Question :
D. As a Field Operation, out of the three dealers, which one has Decreased battery sales? How to improve it.
E. If the profit of 1 pcs battery is Rp. 125,000, what is the total profit From the sale of batteries for the month of Jan - Oct with a note, in June and July there is a cashback of Rp. 25,000 for buyer
F. In your opinion, which of the three dealers is the best and the worst dealer
Transcribed Image Text:Battery Stock Data
Dealer Jan Feb Mar Apr May Jun
Jul Aug Sep Oct
Kyoto
20
15
10
16
15
16
15
12
Nagoya
8
10
15
12
8
Osaka
40
20
20
25
30
40
20
25
30
• Battery Sales Target Data
Dealer Jan Feb Mar Apr May Jun
Jul Aug Sep
Oct
Kyoto
10
8
9
9
9
10
9
9
9
10
Nagoya
6
4
5
5
5
6
5
5
5
6
Osaka
20
15
17
17
17
20
16
17
17
20
• Battery Sales Data
Dealer Jan Feb Mar Apr May Jun
Jul Aug Sep
5
Oct
Kyoto
Nagoya
12
7
10
12
15
10
8
11
7
5
6
9
6
7
7
4
Osaka
12
15
20
17
25
25
13
19
18
22
in
Transcribed Image Text:As the capital of the province of South Sulawesi, Makassar is the 8th largest
city in Indonesia. Main dealer Cikarang has 3 dealer networks in the city.
Following are dealer data:
Incoming/Customer Target Unit Data
Dealer Jan Feb Mar Apr May Jun
Kyoto 700 600 600 600 650 900 700 700 700 800
Nagoya 400 300 450 400 400 600 400 400 400 400
Osaka 1700 1600 1600 1600 1700 1700 1600 1600 1600 1600
Jul Aug Sep Oct
Incoming Unit/Customer Actual Data
Dealer Jan Feb Mar Apr May Jun
Kyoto 760 833 885 821 868
Nagoya 389 398 383 493 480
Osaka 1698 1614 1690 1620| 1753 1547 1816 1485 1568 1600
Aug Sep Oct
839 846 844 804 800
509 542 552 451
Jul
450
Service Advisor Actual Data
Dealer Jan Feb Mar Apr May Jun
Jul Aug Sep Oct
Kyoto
3
2
2
3
4
3
3
3
3
Nagoya
2.
2
2.
2.
2
2
Osaka
7
6
7
7
6
6
2.
2.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.