Question: Step 1 IF How would you like to plan your wedding? = By Venue [ Select ] [show, hide] venue options and [ Select ]

Step 1

IF How would you like to plan your wedding? = By Venue [ Select ] ["show", "hide"] venue options and

[ Select ] ["show", "hide"] options for By Wedding Date;

Then

IF Venue = Williamsburg Gardens [ Select ] ["show", "hide"] Advance Notice Required: 30 Days ,

Then

Calculate first possible venue availability like this: advance notice calendar date [ Select ] [">=", "<"] Now() + 30 days ,

ElseIF Venue = Sunny Isles [ Select ] ["show", "hide"] Advance Notice Required: 60 Days ,

Then

Calculate first possible venue availability like this: advance notice calendar [ Select ] [">=", "<"] Now() + 60 days ,

ElseIF Venue = Kings Country Club [ Select ] ["show", "hide"] Advance Notice Required: 90 Days ,

Then

Calculate first possible venue availability like this: advance notice calendar [ Select ] [">=", "<"] Now() + 90 days .

ElseIF How would you like to choose your venue = Wedding Date [ Select ] ["show", "hide"] wedding date calendar ,

and

[ Select ] ["show", "hide"] options for By Venue ;

Then

If wedding date < Now() + 30 days show venue available as [ Select ] ["Williamsburg", "Sunny Isles", "King's Country Club", "Williamsburg and Sunny Isles", "Williamsburg and King's Country Club", "Sunny Isles and King's Country Club", "Williamsburg, Sunny Isles, and Kings Country Club", "None Available"] ,

ElseIF wedding date >= Now() + 30 days AND < Now() + 60 show venue availability as [ Select ] ["and", "or", "Williamsburg", "Sunny Isles", "King's Country Club", "Williamsburg and Sunny Isles", "Williamsburg and Kings Country Club", "Sunny Isles and King's Country Club", "Williamsburg, Sunny Isles, King's Country Club", "None Available"] ,

ElseIF wedding date >= Now() + 30 days AND < Now() + 90 show venue availability as [ Select ] ["Williamsburg", "Sunny Isles", "King's Country Club", "Williamsburg and Sunny Isles", "Williamsburg and King's Country Club", "Sunny Isles and King's Country Club", "Williamsburg, Sunny Isles, and King's Country Club"] ,

ElseIF wedding date >= Now() + 90 show venue availability as [ Select ] ["Williamsburg", "Sunny Isles", "King's Country Club", "Williamsburg and Sunny Isles", "Williamsburg and King's Country Club", "Sunny Isles and King's Country Club", "Williamsburg, Sunny Isles, and King's Country Club", "None Available"] ,

Step 2

If "Venue" = Williamsburg gardens [ Select ] ["AND", "OR"] "Final Venue Choice" is not the same, then show "Are you sure this is your venue choice? You selected a different venue earlier. "

ElseIf "Venue" = Sunny Isles [ Select ] ["AND", "OR"] "Final Venue Choice" is not the same, then show "Are you sure this is your venue choice? You selected a different venue earlier."

ElseIf "Venue" = King's Country Club [ Select ] ["AND", "OR"] "Final Venue Choice" is not the same, then show "Are you sure this is your venue choice? You selected a different venue earlier."

Step 3

IF Final Venue Choice is [ Select ] ["blank", "not blank"] ,

Then

[ Select ] ["show", "hide"] the fields "Cost Per Hour" and "Number of Hours" ,

Then

IF Number of Hours is [ Select ] ["blank", "not blank"] ,

Calculate [ Select ] ["venue", "wedding date", "Cost Per Hour"] * [ Select ] ["venue", "wedding date", "Number of Hours"] ,

Then [ Select ] ["show", "hide"] Total Cost ,

Then calculate Required Deposit as [ Select ] ["Cost Per Hour", "Number of Hours", "Total Cost"] * [ Select ] ["Cost Per Hour", "Number of Hours", ".05", ".1", ".5"] .

Step 4

IF Deposit Cleared is [ Select ] ["blank", "not blank"] ,

AND

Deposit Cleared = No ,

AND

"Credit Score" is [ Select ] [">=", "<", ">= OR <"] 600

Then Move Forward with this Client = No,

Elseif Deposit Cleared = Yes ,

AND

Credit Score is [ Select ] ["<", ">=", ">= OR <"] 600 ,

Then Move Forward with this Client = Yes.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!