we need to put this info in a spreadsheet using excel or sheets

Ice Cream Store Budget You have inherited an ice cream store, which includes all furniture and equipment. You have $10,000 monthly to spend on running your store. Your job is to come up with a monthly budget plan. You will need to decide how to spend your money on employees, ice cream, supplies, and advertising. You may complete this project either by hand with a calculator or by using the sample spreadsheet.

Create your monthly budget spreadsheet using the costs listed below. If you would like to add something that is not on the list, you may estimate or research its monthly cost.

Consider: How many employees will you need? How many flavors of ice cream will you have and of what flavors? What supplies will you need? How will you advertise?

Task: Create a budget for an average month. You should do the following: List your items. List the number of each item. List the cost of a single unit of each item. List the total cost of that item (number of items x cost). List the percentage of your total monthly funds ($10,000) that you will be spending on each item. You should be able to explain your budget choices and the benefits of your expenditures vs. possible limitations.

Costs

Employee costs: Skilled employee (40 hours/week) = $2250/month Unskilled employee (40 hours/week) = $1750/month

Food and supply costs: Monthly supply of one plain ice cream flavor (vanilla, chocolate, strawberry) (12 gallons of a single flavor): $120 Monthly supply of one fancy ice cream flavor (cookies and cream, cookie dough, others of your choice) (12 gallons of a single flavor): $140 Monthly supply of cups and containers: $100 Monthly supply of napkins and plastic spoons: $50 Monthly supply of cones: $250 Monthly supply of ice cream toppings (cherries, nuts, whipped cream, hot fudge): $600 Are there other items you would like to add? Please estimate/research the cost.

Advertising costs: 30-second TV ad to run throughout the month: $1050 Monthly website costs: $250 Local newspaper ad to run for a month: $100

needs to be in a spreadsheet

You will be graded on the following:

• A list of items in a spreadsheet and their costs
• Each items cost is related to the total and represented as a percentage
• The percentage is calculated using excel
• Each items cost summed and represented as a total at the bottom of the spreadsheet
• A word document is also attached explaining why you chose to include the items you did, why you did not include other items, and the benefits and limitations of each choice.

for Ice Cream Store Budget You have inherited an ice cream store, which includes all furniture and equipment. You have $10,000 monthly to spend on running your store. Your job is to come up with a monthly budget plan. You will need to decide how to spend your money on employees, ice cream, supplies, and advertising. You may complete this project either by hand with a calculator or by using the sample spreadsheet. Create your monthly budget spreadsheet using the costs listed below. If you would like to add something that is not on the list, you may estimate or research its monthly cost. Consider: How many employees will you need? How many flavors of ice cream will you have and of what flavors? What supplies will you need? How will you advertise? Task: Create a budget for an average month. You should do the following: List your items. List the number of each item. List the cost of a single unit of each item. List the total cost of that item (number of items x cost). List the percentage of your total monthly funds ($10,000) that you will be spending on each item. You should be able to explain your budget choices and the benefits of your expenditures vs. possible limitations. Costs Employee costs: Skilled employee (40 hours/week) = $2250/month Unskilled employee (40 hours/week) = $1750/month Food and supply costs: Monthly supply of one plain ice cream flavor (vanilla, chocolate, strawberry) (12 gallons of a Costs Employee costs: Skilled employee (40 hours/week) = $2250/month Unskilled employee (40 hours/week) = $1750/month Food and supply costs: Monthly supply of one plain ice cream flavor (vanilla, chocolate, strawberry) (12 gallons of a single flavor): $120 Monthly supply of one fancy ice cream flavor (cookies and cream, cookie dough, others of your choice) (12 gallons of a single flavor): $140 Monthly supply of cups and containers: $100 Monthly supply of napkins and plastic spoons: $50 Monthly supply of cones: $250 Monthly supply of ice cream toppings (cherries, nuts, whipped cream, hot fudge): $600 Are there other items you would like to add? Please estimate/research the cost. Advertising costs: 30-second TV ad to run throughout the month: $1050 Monthly website costs: $250 Local newspaper ad to run for a month: $100 for Ice Cream Store Budget You have inherited an ice cream store, which includes all furniture and equipment. You have $10,000 monthly to spend on running your store. Your job is to come up with a monthly budget plan. You will need to decide how to spend your money on employees, ice cream, supplies, and advertising. You may complete this project either by hand with a calculator or by using the sample spreadsheet. Create your monthly budget spreadsheet using the costs listed below. If you would like to add something that is not on the list, you may estimate or research its monthly cost. Consider: How many employees will you need? How many flavors of ice cream will you have and of what flavors? What supplies will you need? How will you advertise? Task: Create a budget for an average month. You should do the following: List your items. List the number of each item. List the cost of a single unit of each item. List the total cost of that item (number of items x cost). List the percentage of your total monthly funds ($10,000) that you will be spending on each item. You should be able to explain your budget choices and the benefits of your expenditures vs. possible limitations. Costs Employee costs: Skilled employee (40 hours/week) = $2250/month Unskilled employee (40 hours/week) = $1750/month Food and supply costs: Monthly supply of one plain ice cream flavor (vanilla, chocolate, strawberry) (12 gallons of a Costs Employee costs: Skilled employee (40 hours/week) = $2250/month Unskilled employee (40 hours/week) = $1750/month Food and supply costs: Monthly supply of one plain ice cream flavor (vanilla, chocolate, strawberry) (12 gallons of a single flavor): $120 Monthly supply of one fancy ice cream flavor (cookies and cream, cookie dough, others of your choice) (12 gallons of a single flavor): $140 Monthly supply of cups and containers: $100 Monthly supply of napkins and plastic spoons: $50 Monthly supply of cones: $250 Monthly supply of ice cream toppings (cherries, nuts, whipped cream, hot fudge): $600 Are there other items you would like to add? Please estimate/research the cost. Advertising costs: 30-second TV ad to run throughout the month: $1050 Monthly website costs: $250 Local newspaper ad to run for a month: $100