Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The wonderful company, SpaceZ, is a fictional company that makes its money by providing orbital services (aka, blasting rockets into space). They have an aggressive

The wonderful company, SpaceZ, is a fictional company that makes its money by providing orbital services (aka, blasting rockets into space). They have an aggressive marketing department trying to get all possible launches filled. There are 6 customers that the marketing department tracks. SpaceZ offers a range of services including manned spaceflight at various cost levels as shown below:

Orbital Services:

Service Code: ORB1

Description: Launch one satellite to low earth orbit; weighing less than 9 metric tons.

Short Description: Satellite: LEO

Fee: 65,000,000

Sales Commission: 0.1%

1st Stage Recovery: Land

Service Code: ORB2

Description: Launch one satellite to geostationary orbit; low earth orbit weighing less than 5.5 tons.

Short Description: Satellite: GSO

Fee: 67,000,000

Sales Commission: 0.12%

1st Stage Recovery: Land

Service Code: ORB3

Description: Launch one satellite to sun synchronous orbit; weighing less than 5 tons.

Short Description: Satellite: SSO

Fee: 72,650,000

Sales Commission: 0.12%

1st Stage Recovery: Sea

Service Code: ISS5

Description: Launch 5 tons of cargo to a space station; in an inclined orbit.

Short Description: Satellite: 5T

Fee: 76,137,129

Sales Commission: 0.09%

1st Stage Recovery: Sea

Service Code: MOON2

Description: Two space tourists to fly sound the moon accompanied by an experienced astronaut.

Short Description: Tourist: Moon

Fee: 98,000,000

Sales Commission: 0.13%

1st Stage Recovery: Land

If the 1st stage is recovery by sea then an additional $165,000 cost of recovery is taken into consideration before Sales Commissions are applied.

The company CODC is part owned by SpaceZ so no sales commissions are given to marketing for CODC launches.

Customers:

Code: ESAA

Name: Europe Systems Alternative Agency

Contact Name: Jean-Claude Junxer

Address: 23 Razor Road Belconnen ACT 2617

Launch 1: ORB1, 30/04/2019

Launch 2: ORB1, 31/10/2019

Code: NASHA

Name: National Air Space Hash Agency

Contact Name: Jimmy Briden

Address: 2 Mashup Drive Bruce ACT 2617

Launch 1: ORB3 28/04/2019

Launch 2: ISS5, 7/3/2020

Code: ASA

Name: Aussie Space Agency

Contact Name: Megan Clock

Address: Flat 31/a, Bax Units Stix st Marble bar 6760

Launch 1: None

Launch 2: None

Code: TICK

Name: Tick Incorporated

Contact Name: Mark Watson

Address: 87 Race drive Bathurst 2795

Launch 1: ORB1,2/3/2020

Launch 2: ORB2,19/3/2020

Code: BINC

Name: Byer Private Space Incorporated

Contact Name: Marillyn Hewson

Address: 212 Webly Drive Canowindra NSW 2804

Launch 1: MOON2, 12/12/2023

Launch 2: None

Code: CODC

Name: Corporate Space Trust

Contact Name: Zhang Chen

Address: 212 Scorch Drive Beltana SA 5730

Launch 1: ORB2, 21/3/2020

Launch 2: MOON2, 19/12/2023

Write a python code to build a system that helps with customer management by providing the following services:

Commission Report: It produces a commission report showing the commission that a customer generates for the currently scheduled launches.

If the 1st stage is recovery by sea, then an additional $165,000 cost of recovery is taken into consideration before Sales Commissions are applied. This is a way of encouraging salespersons to sell the cheaper land recovery services hence it is subtracted before commission is calculated.

Sample Commission calculation for ESAA ORB 1. (Land recovery)

65,000,000 * 0.1 /100 = $65,000

Commission is : $65,000

Sample commission calculation for NASHA ORB3 (sea recovery)

Because its a sea recovery we deduct 165,000 before the calculation

(72,650,000-165,000) *0.12/100 = $86,982

Commission is : $86,982

Sample commission calculation for CODC ORB3 (sea recovery)

Commission is : $0

Sample Output:

image text in transcribed

Example output Screen

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2018 Dublin Ireland September 10 14 2018 Proceedings Part 1 Lnai 11051

Authors: Michele Berlingerio ,Francesco Bonchi ,Thomas Gartner ,Neil Hurley ,Georgiana Ifrim

1st Edition

3030109240, 978-3030109240

More Books

Students also viewed these Databases questions