You run an agricultural supply store and are setting up a spreadsheet that you will use each
Question:
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,∞) not [0,∞). 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 0 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)
Introduction to Accounting An Integrated Approach
ISBN: 978-0078136603
6th edition
Authors: Penne Ainsworth, Dan Deines