COMPUTER BASED INFO HOMEWORK #5 QUESTION 6

What is the Total Cost After Shipping (TCAS) when your input values match the input values in the provided image? Your answer must exactly match the output from excel. I.E. $1,152.00 MIS 2113 SP23 Homework 5 Description Background: The Price IBC Jewelry team has asked you to assist creating a program to quickly calculate sales. After consulting with the IBC team, you document the following process and develop the accompanying flow chart. Flowchart Information: The IBC team wants to make sure everything is flexible as possible; therefore, are variables are adjustable. The program needs to input the following variables: Amount of Jewelry (AOJ), Amount of Jewelry Discount (AOJD), Type of Jewelry (TOJ), Discount (D), Necklace Price (NP), Earring Price (EP), Watch Price (WP), Bracelet Price (BP), Shipping Price (SP) and Free Shipping (FS). If the Amount of Jewelry (AOJ) is greater than the Amount of Jewelry Discount (AOJD) then the customer receives a Discount (D) equal to the original input amount; otherwise, the Discount (D)=0. After determining the Discount (D), the program then calculates the Jewelry Price (JP). If the Type of Jewelry (TOJ) equals Necklace, then the Jewelry Price (JP) equals the Necklace Price (NP). If the Type of Jewelry (TOJ) equals Bracelet, then the Jewelry Price (JP) equals the Bracelet Price (BP). If the Type of Jewelry (TOJ) equals Earring, then the Jewelry Price (JP) equals the Earring Price (EP). Otherwise, the Type of Jewelry (TOJ) equals the Watch Price (WP). The program then calculates the Total Cost Before Discount (TCBD), the Discount Amount (DA), and the Total Cost After Discount (TCAD) based on the following calculations: TCBD=JPAOJDA=TCBDDTCAD=TCBDDA Due to increased shipping costs, the team wants to provide free shipping to certain purchases based on the Total Cost After Discount (TCAD). If the Total Cost After Discount (TCAD) is greater than or equal to Free Shipping (FS) the Shipping Price (SP) equals 0 ; otherwise, the Shipping Price (SP) is equal to the original input amount. The program should then calculate the Total Cost After Shipping (TCAS) by adding the Total Cost After Discount (TCAD) and the Shipping Price (SP). Lastly, the program needs to output the Amount of Jewelry (AOJ), Jewelry Price (JP), Total Cost Before Discount (TCBD), Discount Amount (DA), Total Cost After Discount (TCAD), Shipping Price (SP), and Total Cost After Shipping (TCAS). Excel: The team drafted a sample of what they want the interface to look like and need a button added so they may quickly calculate sales. What is the Total Cost After Shipping (TCAS) when your input values match the input values in the provided image? Your answer must exactly match the output from excel. I.E. $1,152.00 MIS 2113 SP23 Homework 5 Description Background: The Price IBC Jewelry team has asked you to assist creating a program to quickly calculate sales. After consulting with the IBC team, you document the following process and develop the accompanying flow chart. Flowchart Information: The IBC team wants to make sure everything is flexible as possible; therefore, are variables are adjustable. The program needs to input the following variables: Amount of Jewelry (AOJ), Amount of Jewelry Discount (AOJD), Type of Jewelry (TOJ), Discount (D), Necklace Price (NP), Earring Price (EP), Watch Price (WP), Bracelet Price (BP), Shipping Price (SP) and Free Shipping (FS). If the Amount of Jewelry (AOJ) is greater than the Amount of Jewelry Discount (AOJD) then the customer receives a Discount (D) equal to the original input amount; otherwise, the Discount (D)=0. After determining the Discount (D), the program then calculates the Jewelry Price (JP). If the Type of Jewelry (TOJ) equals Necklace, then the Jewelry Price (JP) equals the Necklace Price (NP). If the Type of Jewelry (TOJ) equals Bracelet, then the Jewelry Price (JP) equals the Bracelet Price (BP). If the Type of Jewelry (TOJ) equals Earring, then the Jewelry Price (JP) equals the Earring Price (EP). Otherwise, the Type of Jewelry (TOJ) equals the Watch Price (WP). The program then calculates the Total Cost Before Discount (TCBD), the Discount Amount (DA), and the Total Cost After Discount (TCAD) based on the following calculations: TCBD=JPAOJDA=TCBDDTCAD=TCBDDA Due to increased shipping costs, the team wants to provide free shipping to certain purchases based on the Total Cost After Discount (TCAD). If the Total Cost After Discount (TCAD) is greater than or equal to Free Shipping (FS) the Shipping Price (SP) equals 0 ; otherwise, the Shipping Price (SP) is equal to the original input amount. The program should then calculate the Total Cost After Shipping (TCAS) by adding the Total Cost After Discount (TCAD) and the Shipping Price (SP). Lastly, the program needs to output the Amount of Jewelry (AOJ), Jewelry Price (JP), Total Cost Before Discount (TCBD), Discount Amount (DA), Total Cost After Discount (TCAD), Shipping Price (SP), and Total Cost After Shipping (TCAS). Excel: The team drafted a sample of what they want the interface to look like and need a button added so they may quickly calculate sales