The Clark School has been severely impacted by a statewide atback in funding for extracuricular activities...

  

Transcribed Image Text:

The Clark School has been severely impacted by a statewide atback in funding for extracuricular activities The school needs money bady and has settled on a door-40 door sale of food items by its students as the intial fund-raiser The goal is to ralse $5,000 00 for the purchase of new irstruments for the music program the plan ia for students to present a catalog to their parents and other potential customert, whe are asked to indicate their cholces and provide immediate piryment. Melissa Edwards. the individual n charge of fund-raising, has settied on cookie dough as the featured product Melssa has contracted with an organization that offers five flavors of dough, each in a two pound tub that sels for S.00 and $10.00 pertub The school keeps a specific percentage of the seling price SON in this instance as profit The organization delivers the cookie dough to their customers The principal has asked for a progress report midway through the fund-raiser. He wants to know whether the $5.00.00 goal has been met, and if not, how far the school is from meeting its goal. Here are the five favors and their sale price: Plavors Chocolate $8.00, Vanilla $20.00, Chocelate Chip S10.00, Sugar S8.00, Leman S10.00) Here are the student's names and what they have sold: lane Ayers 100 50 15 70 25 Tom Ties 14 75 18 80 10 im Bigger 50 34 10 65 Helen Oh 45 25 so 100 75 Bob Yea 10 19 35 100 100 Melissa 5 Using Excel you are to create a catalog that the students would use to enter the sale from each customer and what they ordered and the total of the sele for the cookie dough. Make this as functional as possibie Next, create a spreadsheet that computes the profit to date, check the profit against the intended goal and finaily, format the completed worksheet as a financial document to show the values Next, display the dotument showing the cell formulas Lastly, create a pie chart arida bar chart for each student and their total sales to date These 4 documents are to be printed out and handed in on Tuesday The Clark School has been severely impacted by a statewide atback in funding for extracuricular activities The school needs money bady and has settled on a door-40 door sale of food items by its students as the intial fund-raiser The goal is to ralse $5,000 00 for the purchase of new irstruments for the music program the plan ia for students to present a catalog to their parents and other potential customert, whe are asked to indicate their cholces and provide immediate piryment. Melissa Edwards. the individual n charge of fund-raising, has settied on cookie dough as the featured product Melssa has contracted with an organization that offers five flavors of dough, each in a two pound tub that sels for S.00 and $10.00 pertub The school keeps a specific percentage of the seling price SON in this instance as profit The organization delivers the cookie dough to their customers The principal has asked for a progress report midway through the fund-raiser. He wants to know whether the $5.00.00 goal has been met, and if not, how far the school is from meeting its goal. Here are the five favors and their sale price: Plavors Chocolate $8.00, Vanilla $20.00, Chocelate Chip S10.00, Sugar S8.00, Leman S10.00) Here are the student's names and what they have sold: lane Ayers 100 50 15 70 25 Tom Ties 14 75 18 80 10 im Bigger 50 34 10 65 Helen Oh 45 25 so 100 75 Bob Yea 10 19 35 100 100 Melissa 5 Using Excel you are to create a catalog that the students would use to enter the sale from each customer and what they ordered and the total of the sele for the cookie dough. Make this as functional as possibie Next, create a spreadsheet that computes the profit to date, check the profit against the intended goal and finaily, format the completed worksheet as a financial document to show the values Next, display the dotument showing the cell formulas Lastly, create a pie chart arida bar chart for each student and their total sales to date These 4 documents are to be printed out and handed in on Tuesday

Answer rating: 100% (QA)

1 Customer Name Flavours Price Pieces Total Chocolate 8 10 80 Vanilla 10 10 100 Chocolate Chip 10 10 ... View the full answer