Excel functionality addressed: Learn some Excel basics, including how to enter numbers and text, how to use some basic formulas, how to format and present your analysis in a business report Business topics addressed: Construct a simple bill-of-materials and then use this bill-of-materials to set a budget for purchasing. Janet Anderson manages Ascend Ladders, Inc. Ascend makes and sells ladders used primarily in workshops (consumers or small businesses). Ascend buys parts from metal fabricating shops. These parts include the ladder rungs, sides, feet, nuts and bolts. Janet's employees then assemble and sell the ladders to retailers. She started her company five years ago and since then she has only sold her ladders to retail stores in Northeast Wisconsin. Janet's annual sales in Northeast Wisconsin have stabilized at 6,000 ladders. To grow her business, she has started to look at expanding sales into new regions. If Janet expands her geographic sales area, then of course she must be prepared to assemble more ladders, which means buying more inventory and spending more cash. Janet has asked you to develop a spreadsheet that will help her look at information. Janet wants to see spreadsheet information that: 1. Allows her to evaluate different amounts of ladders that could be produced, so that the current base of 6,000 ladders might increase to potentially 8,500 ladders. 2. For purchasing, she needs to purchase ladder components based on the number of ladders she plans to assemble, and she wants the spreadsheet to indicate how many parts to purchase at various amounts of ladders that could be assembled. 3. She wants to set a budget for purchasing inventory, and this budget will also be tied to the number of ladders that could be assembled, ranging up to 8,500 ladders. Your task for this homework assignment is to develop a spreadsheet for Janet and then submit a group report that answers five questions posed in this assignment. So start a blank document, headed with the names of your group members. Answer the five questions on this document, Each answer should be conveyed in a complete sentence; a major aspect of this course is to train you to properly report numeric results. To clarify, getting the right number is only a portion of what will be graded. Also for each answer, you will need to copy and paste portions from Excel into your homework. These homework-submission guidelines, using complete sentences, including figures, and including the correct units, apply to all homework assignments in this course, not just to this assignment. HWI-1 Excel functionality addressed: Learn some Excel basics, including how to enter numbers and text, how to use some basic formulas, how to format and present your analysis in a business report Business topics addressed: Construct a simple bill-of-materials and then use this bill-of-materials to set a budget for purchasing. Janet Anderson manages Ascend Ladders, Inc. Ascend makes and sells ladders used primarily in workshops (consumers or small businesses). Ascend buys parts from metal fabricating shops. These parts include the ladder rungs, sides, feet, nuts and bolts. Janet's employees then assemble and sell the ladders to retailers. She started her company five years ago and since then she has only sold her ladders to retail stores in Northeast Wisconsin. Janet's annual sales in Northeast Wisconsin have stabilized at 6,000 ladders. To grow her business, she has started to look at expanding sales into new regions. If Janet expands her geographic sales area, then of course she must be prepared to assemble more ladders, which means buying more inventory and spending more cash. Janet has asked you to develop a spreadsheet that will help her look at information. Janet wants to see spreadsheet information that: 1. Allows her to evaluate different amounts of ladders that could be produced, so that the current base of 6,000 ladders might increase to potentially 8,500 ladders. 2. For purchasing, she needs to purchase ladder components based on the number of ladders she plans to assemble, and she wants the spreadsheet to indicate how many parts to purchase at various amounts of ladders that could be assembled. 3. She wants to set a budget for purchasing inventory, and this budget will also be tied to the number of ladders that could be assembled, ranging up to 8,500 ladders. Your task for this homework assignment is to develop a spreadsheet for Janet and then submit a group report that answers five questions posed in this assignment. So start a blank document, headed with the names of your group members. Answer the five questions on this document, Each answer should be conveyed in a complete sentence; a major aspect of this course is to train you to properly report numeric results. To clarify, getting the right number is only a portion of what will be graded. Also for each answer, you will need to copy and paste portions from Excel into your homework. These homework-submission guidelines, using complete sentences, including figures, and including the correct units, apply to all homework assignments in this course, not just to this assignment. HWI-1