so the full instruction is updated and psoted, also, the answers to tvis supposed to be based on a previous worksheet. i attached the answers to the worksheet, 1-3 that is needed to answer this problem.
Situation/Story: You run an agricultural supply store and are setting up a spreadsheet that you will use each day. Worksheet 6 Problem #1 had seven products that you sell, and their prices. The spreadsheet is set up for a maximum of 10 customers in one day. The spreadsheet is set up so that, for each customer, you enter how much of each product they buy, and the spreadsheet will calculate a) The charge for each product, b) The total charge for each customer, c) The total amount of each product sold over the entire day, d) The total revenue for each product over the entire day, and e) The total revenue for the entire day. You also have a small "customer assistance" portion of the spreadsheet where you can enter how much money the customer has, and the spreadsheet will calculate how much molasses the customer can buy with that money. Specific Instructions and Information for You: I am providing the spreadsheet with all the necessary labels. I have also done some of the work for you. I have put XXXX in every cell where you need to enter a formula. You can look at the formulas I have done to assist You can manually enter whatever you want in the input columns. When grading I will change those to make sure the calculated cells change accordingly. You will need to do something extra for the formulas for two of the products - the liquid fertilizer and the topsoil. Why? Because the domain of these functions doesn't include x = 0 - the domain is (0,co) not [0,co). If you "plug in" x = 0 into your formulas from Worksheet 6, you will end up charging the customer some money even though they didn't buy anything. So, for these products you need to write a "piecewise function" so that the output (charge) is O whenever the input (amount purchased) is 0 (or any other non-positive number). Here's how you do that. (You might want to cut and paste the command into Excel and modify it accordingly.) = IF(input cell>0, your formula,0) Explanation. What happens here is that "Your formula" is only used if the value in your "input cell" is greater than 0. If not, the output will be 0. To make it more clear, if your formula is c = 3x + 100, and the input cell is E4, then this will look like... = IF(E4>0,3*E4+100,0) Gridlines cu immersive Reader Zoom LE Multiple Pages Zoom to 100% Page Width Navigation Pane New Window Arrange Split A Switch Windows Macros MAT 140 Worksheet 6 There is not textbook homework this week. Focus on this worksheet instead De at least 3 by Wednesday at close time, and more you can Input Output: Formula Last week you learned how to work with near functions. Now you apply what you leamed HINTS: Once you see how things work, you should be able figure out most of the requested formulas right away. If you have trouble, this is what you can do A) Make and input/output table. If you do it correctly you will see that the function is linear B) Use two points on your input/output table to calculate the slope and intercept and put the linear equation in slope intercept formy mx+b. That will be the formula you're trying to find e) Chicken wire costs $1.10 per foot. Find a formula for the charge in dollars) as a fanction of the amount of chick wire in feet purchased Input Output: Formula: Potting soil is $13 per bag Find a formula for the charpe in dollars) as a function of the amount of potting soil in bags purchased Input: Output Formula Topsoil costs $1.75 per cubic meter,plus $50 for the delivery. Find a formula for the charpe in dollars) as a function of the amount of topsoil in cubic meters purchased. Input Output: Formula 1. You work at an agricultural supply store and need to set up a simple order calculator. To do that you need to find formulas to use to calculate how much to charge a customer when they buy product For all of the following. It's okay to use as the input variable Always state what the inputs and outputs are, including the units being used Molasses costs $8 per gallon. Find a formula for the charge in dollars) as a function of the amount of molasses in gallons purchased Input Formula: b) Banana slps cost $10 per slip. Find a formula for the charge (in dollars) as a function of the number of banana slips purchased Input Output: Formula: 2. Using the appropriate formula from 11 above, what is the charge it 200 cubic meters of topsoil is purchased? Output 3. Suppose farmers coming to your store are always wanting to know how much molasses they can buy with the money they have that day. a) Using the appropriate formula from 11 above, how much molasses can someone buy with $447 b) Using the appropriate formula from #1 above, find a formula for the amount of molasses pallons) someone can buy as a function of the amount of money Idolars they have (NOTE: This will be the "inverse" of the molasses charge function from 11.) Formulary Com seed costs 65 cents per pound. Find a formula for the charge (in dollars) as a function of the amount of com seed fin pounds) purchased Input Output: Formula: Liquid fertilizer cost $6 per quirt, and is always sold with one S10 applicator no matter how many bottles are purchased. Find a formula for the charge in dollar) as a function of the amount of liquid fertilizer (in quarts) purchased 4. A utility company like WAPA) charges 51 cents per kwh ("lowatt-hour plus a line fee of $32.50. Find a formula for the charge in dollars as a function of the amount of power in wh used Input Homework worksheet 6 1-3 Formwer Rx+10y +0.65+ 6+1.10 + 13w Input:let customers purchase of topolven it costs 1.75 per m' and So in delivery charge Output: 1.75x50 Inpur: let customer gallons, piven it costs per gallon Outwe Formule Formula 1.75x50 2 200 ml of topsoil is purchased O1.75 (200) 50 O-35050 -400 Input:let customer purchases y banana lipd. given it costs $10 per slip Ouw 10y Formulare+10y 3) 44 - 5 X 55 gallons b) y 1/5 Input: let customer purchases pound of com seed, given it costs $0.65 per pound Output: 2.05 Formw8x+10y +0.65% Input: let customer purchases quarts of liqud fertilizer, given it costs $6 per quart Ouw: 6 Formula SeL 8x+10y +0.65% +60 Input let customer purchases for chicken wird, given it costs SL.10 per food Ougu: L.10 Formul&x+10y+0652 +6+1.10v Inpur: let customer purchases whaps of plotting soil, given it costs $13 per bag Our: 13 015 Xfx SUM(D4:013) D A F M 1 H O N C Molasses gallons Cost Cost $ Bananas slips Corn Seed pounds Cost Lig Fertilizer Cost Chicken Wire Cost Potting Soil $ quarts $ feet $ bags Cost $ Topsoil cubic meter Cost $ Total Sales per customer $ 0 O D 000K 0 0 XOXOXOX O OOOOX XOX xox XOX XX ODOC XOXOXOK XOOX 2 2,15 8,6 4,75 7 11 XOOX 000K XOOOX 0 16 17,2 68,8 38 56 88 80 40 24 XOOX XOOOK XXXX OOOX 000 OOOX 0006 XOOX XXXX XXXX XXXX XXX Xxxx XOOK Xxxx XXXX XOOX XOOOK 00 XXX XOX XXX XOXOX XXXX XXXX XOOX XOOX OOK XOCOK 70006 XOX XOOOX XOOK XOOK XOXOX XOOXX XXX XOOK XO006 XOOX XOOX XOOOX XOOOX X000x XOOOK xxxx YO 0000 XOXOOX 6 10 5 2 XOOX XOOOX XOXOXOX XXXX OOK 429 xo XOOOK S'ES XOOOX OOO XOOOK XOOK YOOOK OOK X000X XOOK XOOOK 000 1 2 Customer 3 4 1 5 2 6 3 7 4 8 5 9 6 10 7 11 12 13 10 14 15 Subtotals 16 today 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 total sales per day Customer Assistance $ Money 44 Gallons Molasses xox Sheet1 TO MacBook Pro This assignment goes along with Problems #1 and 3 on Worksheet 6. Situation/Story: You run an agricultural supply store and are setting up a spreadsheet that you will use each day. Worksheet 6 Problem #1 had seven products that you sell, and their prices. The spreadsheet is set up for a maximum of 10 customers in one day. The spreadsheet is set up so that, for each customer, you enter how much of each product they buy, and the spreadsheet will calculate a) The charge for each product, b) The total charge for each customer, c) The total amount of each product sold over the entire day, d) The total revenue for each product over the entire day, and e) The total revenue for the entire day. You also have a small "customer assistance" portion of the spreadsheet where you can enter how much money the customer has, and the spreadsheet will calculate how much molasses the customer can buy with that money. Specific Instructions and Information for You: I am providing the spreadsheet with all the necessary labels. I have also done some of the work for you. I have put XXXX in every cell where you need to enter a formula. You can look at the formulas I have done to assist You can manually enter whatever you want in the input columns. When grading I will change those to make sure the calculated cells change accordingly. You will need to do something extra for the formulas for two of the products - the liquid fertilizer and the topsoil. Why? Because the domain of these functions doesn't include x = 0 - the domain is (0,00) not [0, co). If you "plug in x = 0 into your formulas from Worksheet 6, you will end up charging the customer some money even though they didn't buy anything. So, for these products you need to write a "piecewise function" so that the output (charge) is o whenever the input (amount purchased) is 0 (or any other non-positive number). Here's how you do that. (You might want to cut and paste the command into Excel and modify it accordingly.) = IF(input cell>0, your formula,0) Explanation. What happens here is that "your formula" is only used if the value in your "input cell" is greater than 0. If not, the output will be 0. To make it more clear, if your formula is c= 3x + 100, and the input cell is E4, then this will look like. = IF(E4>0, 3*E4+100,0) Situation/Story: You run an agricultural supply store and are setting up a spreadsheet that you will use each day. Worksheet 6 Problem #1 had seven products that you sell, and their prices. The spreadsheet is set up for a maximum of 10 customers in one day. The spreadsheet is set up so that, for each customer, you enter how much of each product they buy, and the spreadsheet will calculate a) The charge for each product, b) The total charge for each customer, c) The total amount of each product sold over the entire day, d) The total revenue for each product over the entire day, and e) The total revenue for the entire day. You also have a small "customer assistance" portion of the spreadsheet where you can enter how much money the customer has, and the spreadsheet will calculate how much molasses the customer can buy with that money. Specific Instructions and Information for You: I am providing the spreadsheet with all the necessary labels. I have also done some of the work for you. I have put XXXX in every cell where you need to enter a formula. You can look at the formulas I have done to assist You can manually enter whatever you want in the input columns. When grading I will change those to make sure the calculated cells change accordingly. You will need to do something extra for the formulas for two of the products - the liquid fertilizer and the topsoil. Why? Because the domain of these functions doesn't include x = 0 - the domain is (0,co) not [0,co). If you "plug in" x = 0 into your formulas from Worksheet 6, you will end up charging the customer some money even though they didn't buy anything. So, for these products you need to write a "piecewise function" so that the output (charge) is O whenever the input (amount purchased) is 0 (or any other non-positive number). Here's how you do that. (You might want to cut and paste the command into Excel and modify it accordingly.) = IF(input cell>0, your formula,0) Explanation. What happens here is that "Your formula" is only used if the value in your "input cell" is greater than 0. If not, the output will be 0. To make it more clear, if your formula is c = 3x + 100, and the input cell is E4, then this will look like... = IF(E4>0,3*E4+100,0) Gridlines cu immersive Reader Zoom LE Multiple Pages Zoom to 100% Page Width Navigation Pane New Window Arrange Split A Switch Windows Macros MAT 140 Worksheet 6 There is not textbook homework this week. Focus on this worksheet instead De at least 3 by Wednesday at close time, and more you can Input Output: Formula Last week you learned how to work with near functions. Now you apply what you leamed HINTS: Once you see how things work, you should be able figure out most of the requested formulas right away. If you have trouble, this is what you can do A) Make and input/output table. If you do it correctly you will see that the function is linear B) Use two points on your input/output table to calculate the slope and intercept and put the linear equation in slope intercept formy mx+b. That will be the formula you're trying to find e) Chicken wire costs $1.10 per foot. Find a formula for the charge in dollars) as a fanction of the amount of chick wire in feet purchased Input Output: Formula: Potting soil is $13 per bag Find a formula for the charpe in dollars) as a function of the amount of potting soil in bags purchased Input: Output Formula Topsoil costs $1.75 per cubic meter,plus $50 for the delivery. Find a formula for the charpe in dollars) as a function of the amount of topsoil in cubic meters purchased. Input Output: Formula 1. You work at an agricultural supply store and need to set up a simple order calculator. To do that you need to find formulas to use to calculate how much to charge a customer when they buy product For all of the following. It's okay to use as the input variable Always state what the inputs and outputs are, including the units being used Molasses costs $8 per gallon. Find a formula for the charge in dollars) as a function of the amount of molasses in gallons purchased Input Formula: b) Banana slps cost $10 per slip. Find a formula for the charge (in dollars) as a function of the number of banana slips purchased Input Output: Formula: 2. Using the appropriate formula from 11 above, what is the charge it 200 cubic meters of topsoil is purchased? Output 3. Suppose farmers coming to your store are always wanting to know how much molasses they can buy with the money they have that day. a) Using the appropriate formula from 11 above, how much molasses can someone buy with $447 b) Using the appropriate formula from #1 above, find a formula for the amount of molasses pallons) someone can buy as a function of the amount of money Idolars they have (NOTE: This will be the "inverse" of the molasses charge function from 11.) Formulary Com seed costs 65 cents per pound. Find a formula for the charge (in dollars) as a function of the amount of com seed fin pounds) purchased Input Output: Formula: Liquid fertilizer cost $6 per quirt, and is always sold with one S10 applicator no matter how many bottles are purchased. Find a formula for the charge in dollar) as a function of the amount of liquid fertilizer (in quarts) purchased 4. A utility company like WAPA) charges 51 cents per kwh ("lowatt-hour plus a line fee of $32.50. Find a formula for the charge in dollars as a function of the amount of power in wh used Input Homework worksheet 6 1-3 Formwer Rx+10y +0.65+ 6+1.10 + 13w Input:let customers purchase of topolven it costs 1.75 per m' and So in delivery charge Output: 1.75x50 Inpur: let customer gallons, piven it costs per gallon Outwe Formule Formula 1.75x50 2 200 ml of topsoil is purchased O1.75 (200) 50 O-35050 -400 Input:let customer purchases y banana lipd. given it costs $10 per slip Ouw 10y Formulare+10y 3) 44 - 5 X 55 gallons b) y 1/5 Input: let customer purchases pound of com seed, given it costs $0.65 per pound Output: 2.05 Formw8x+10y +0.65% Input: let customer purchases quarts of liqud fertilizer, given it costs $6 per quart Ouw: 6 Formula SeL 8x+10y +0.65% +60 Input let customer purchases for chicken wird, given it costs SL.10 per food Ougu: L.10 Formul&x+10y+0652 +6+1.10v Inpur: let customer purchases whaps of plotting soil, given it costs $13 per bag Our: 13 015 Xfx SUM(D4:013) D A F M 1 H O N C Molasses gallons Cost Cost $ Bananas slips Corn Seed pounds Cost Lig Fertilizer Cost Chicken Wire Cost Potting Soil $ quarts $ feet $ bags Cost $ Topsoil cubic meter Cost $ Total Sales per customer $ 0 O D 000K 0 0 XOXOXOX O OOOOX XOX xox XOX XX ODOC XOXOXOK XOOX 2 2,15 8,6 4,75 7 11 XOOX 000K XOOOX 0 16 17,2 68,8 38 56 88 80 40 24 XOOX XOOOK XXXX OOOX 000 OOOX 0006 XOOX XXXX XXXX XXXX XXX Xxxx XOOK Xxxx XXXX XOOX XOOOK 00 XXX XOX XXX XOXOX XXXX XXXX XOOX XOOX OOK XOCOK 70006 XOX XOOOX XOOK XOOK XOXOX XOOXX XXX XOOK XO006 XOOX XOOX XOOOX XOOOX X000x XOOOK xxxx YO 0000 XOXOOX 6 10 5 2 XOOX XOOOX XOXOXOX XXXX OOK 429 xo XOOOK S'ES XOOOX OOO XOOOK XOOK YOOOK OOK X000X XOOK XOOOK 000 1 2 Customer 3 4 1 5 2 6 3 7 4 8 5 9 6 10 7 11 12 13 10 14 15 Subtotals 16 today 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 total sales per day Customer Assistance $ Money 44 Gallons Molasses xox Sheet1 TO MacBook Pro This assignment goes along with Problems #1 and 3 on Worksheet 6. Situation/Story: You run an agricultural supply store and are setting up a spreadsheet that you will use each day. Worksheet 6 Problem #1 had seven products that you sell, and their prices. The spreadsheet is set up for a maximum of 10 customers in one day. The spreadsheet is set up so that, for each customer, you enter how much of each product they buy, and the spreadsheet will calculate a) The charge for each product, b) The total charge for each customer, c) The total amount of each product sold over the entire day, d) The total revenue for each product over the entire day, and e) The total revenue for the entire day. You also have a small "customer assistance" portion of the spreadsheet where you can enter how much money the customer has, and the spreadsheet will calculate how much molasses the customer can buy with that money. Specific Instructions and Information for You: I am providing the spreadsheet with all the necessary labels. I have also done some of the work for you. I have put XXXX in every cell where you need to enter a formula. You can look at the formulas I have done to assist You can manually enter whatever you want in the input columns. When grading I will change those to make sure the calculated cells change accordingly. You will need to do something extra for the formulas for two of the products - the liquid fertilizer and the topsoil. Why? Because the domain of these functions doesn't include x = 0 - the domain is (0,00) not [0, co). If you "plug in x = 0 into your formulas from Worksheet 6, you will end up charging the customer some money even though they didn't buy anything. So, for these products you need to write a "piecewise function" so that the output (charge) is o whenever the input (amount purchased) is 0 (or any other non-positive number). Here's how you do that. (You might want to cut and paste the command into Excel and modify it accordingly.) = IF(input cell>0, your formula,0) Explanation. What happens here is that "your formula" is only used if the value in your "input cell" is greater than 0. If not, the output will be 0. To make it more clear, if your formula is c= 3x + 100, and the input cell is E4, then this will look like. = IF(E4>0, 3*E4+100,0)
