Spreadsheet application

help them with the creation of estimates for his fence building business Below is some background information that will be useful in your creation of this spreadsheet solution: Fred's Pricing is calculated as a result of customer choices regarding fence height, fence material, length of fence, number of gates and whether or not the job is expedited (Yes/ No) to get done sooner. Fred offers three different height fences which are 3 feet, 6 feet and 8 feet tall. No other variations of . height are currently offered to customers. Fred offers customers a choice of materials for their fences. The three types of materials currently . offered include Cedar, Redwood and Timbertek. His current pricing system charges customers $10, $20 and $30 per sq foot foot of fence area respectively. (Note: square footage is found by multiplying the length of the fence times the height of the fence) In building fences, typical installations will have one or more gates for entry / exit. Due to the additional work and hardware required in building gates, his company charges $250 each per gate in addition to the square footage. In addition to the materials, Fred must also charge for labor in his estimates. His current rate is $90/ hour . for his current work crew. Due to scheduling issues and labor rules, his minimum labor charge is $500 After building quite a few fences in his many years of business, he estimates that the time it takes to build . a fence is .2 hours per linear foot for a 3 ft tall fence, .25 hours per linear foot for a 6 ft tall fence and .3 hours per linear foot for an 8 ft tall fence. These estimates are meant to account for all of the various aspects of labor involved in building fences Lastly, Fred offers his customers an option of expediting their job by working extended hours including weekends. For customers who choose this expedited option, he charges an additional 50% for the labor charges on the job. For those who do not choose the expedited option, there are no additional charges. Your task is to complete the following tasks: Sketch a spreadsheet application on paper for Fred's Fence Company. Be sure to identify what inputs are needed by the application, what outputs must be calculated by the application and what are the relevant business rules that must be incorporated into the spreadsheet. (Note: you will not turn in the paper 1. portion of this assignment) Hint: While it may be nice to calculate total cost as a single cell involving a long, complex equation, it ed to first calculate the various components involved in total cost and then sum those. help them with the creation of estimates for his fence building business Below is some background information that will be useful in your creation of this spreadsheet solution: Fred's Pricing is calculated as a result of customer choices regarding fence height, fence material, length of fence, number of gates and whether or not the job is expedited (Yes/ No) to get done sooner. Fred offers three different height fences which are 3 feet, 6 feet and 8 feet tall. No other variations of . height are currently offered to customers. Fred offers customers a choice of materials for their fences. The three types of materials currently . offered include Cedar, Redwood and Timbertek. His current pricing system charges customers $10, $20 and $30 per sq foot foot of fence area respectively. (Note: square footage is found by multiplying the length of the fence times the height of the fence) In building fences, typical installations will have one or more gates for entry / exit. Due to the additional work and hardware required in building gates, his company charges $250 each per gate in addition to the square footage. In addition to the materials, Fred must also charge for labor in his estimates. His current rate is $90/ hour . for his current work crew. Due to scheduling issues and labor rules, his minimum labor charge is $500 After building quite a few fences in his many years of business, he estimates that the time it takes to build . a fence is .2 hours per linear foot for a 3 ft tall fence, .25 hours per linear foot for a 6 ft tall fence and .3 hours per linear foot for an 8 ft tall fence. These estimates are meant to account for all of the various aspects of labor involved in building fences Lastly, Fred offers his customers an option of expediting their job by working extended hours including weekends. For customers who choose this expedited option, he charges an additional 50% for the labor charges on the job. For those who do not choose the expedited option, there are no additional charges. Your task is to complete the following tasks: Sketch a spreadsheet application on paper for Fred's Fence Company. Be sure to identify what inputs are needed by the application, what outputs must be calculated by the application and what are the relevant business rules that must be incorporated into the spreadsheet. (Note: you will not turn in the paper 1. portion of this assignment) Hint: While it may be nice to calculate total cost as a single cell involving a long, complex equation, it ed to first calculate the various components involved in total cost and then sum those