I need helps with numbers 1 thru 10 the overview is Select a product that you could make and can bring to class for presentation purpose. Examples of possible products could be cookies, birdhouse, or custom t-shirs. I chose Coffee Beans to make coffee. Please I need help with 1- 10 in Excel format

4. Make a list of all other expenses that would be needed to create your product. Examples of other expenses would be rent, utilites, and insurance. . Estimate the cost of each of these expenses each month.

5. Now classify all of the expenses you have listed as being either fixed or variable. For mixed expenses, serparate the expense into the fixed component and the variable component.

6. Calculate how many units of your product you will need to sell to break even in each of the four months you have projected.

7. Expect three independent changes that will incur in the second, third and fourth months, and assess how you break-even point will change due to that change. And think of the possible soultions maintain you break-even point

8 Calculate the margin of safety in units for each of the four months in your projection.

9. Now decide how much you would like to make in before-tax operating income ( target profit) in each of the upcoming four months. Calculate how many units you would need to sell in each of the upcoming months to meet these target profit levels.

10. how realisitic is your potential venture Do you think you would be able to break even in each of the projected four months? How risky is your venture ( use the margin of safety to help answer this question). Do you think your target profits are achievable?

Very Important

****I need to have excel table of the Coffee shop, **** 1. First I Need to get the sales budget of the coffee shop 2. Then I need the coffee companys production budget 3. I need the direct material budget*****Please do it in excel

***I need you to please do it like the picture of the nots. Over a 4 month period like the picture I put it in. I need the desired ending inventory , *** I need the beginning inventory

I need helps with numbers 1 thru 10 the overview is Select a product that you could make and can bring to class for presentation purpose. Examples of possible products could be cookies, birdhouse, or custom t-shirs. I chose Coffee Beans to make coffee. Please I need help with 1- 10 in Excel format I chose to make coffee

#1 First I have to describe my product. What market are you targeting this product for? What price will you sell product for? Make projections of your sales in units over each of the upcoming four monts.

#2 Make a detailed list of all the material need to make your product. Include quantities needed for each material on a per- unit basis.

#3 Make a list of all the equipment you will need to make your product. Estimate the cost of each piece of equipment that you will need.

4. Make a list of all other expenses that would be needed to create your product. Examples of other expenses would be rent, utilites, and insurance. . Estimate the cost of each of these expenses each month.

5. Now classify all of the expenses you have listed as being either fixed or variable. For mixed expenses, serparate the expense into the fixed component and the variable component.

6. Calculate how many units of your product you will need to sell to break even in each of the four months you have projected.

7. Expect three independent changes that will incur in the second, third and fourth months, and assess how you break-even point will change due to that change. And think of the possible soultions maintain you break-even point

8 Calculate the margin of safety in units for each of the four months in your projection.

9. Now decide how much you would like to make in before-tax operating income ( target profit) in each of the upcoming four months. Calculate how many units you would need to sell in each of the upcoming months to meet these target profit levels.

10. how realisitic is your potential venture Do you think you would be able to break even in each of the projected four months? How risky is your venture ( use the margin of safety to help answer this question). Do you think your target profits are achievable?

Very Important

****I need to have excel table of the Coffee shop, **** 1. First I Need to get the sales budget of the coffee shop 2. Then I need the coffee companys production budget 3. I need the direct material budget*****Please do it in excel

***I need you to please do it like the picture of the nots. Over a 4 month period like the picture I put it in. I need the desired ending inventory , *** I need the beginning inventory

I need to look like this my production budget, direct materials budget , and sales budget

PROJECT 2: BUSINESS PLAN Overview: Select a product that you could make and can bring to class for presentation purpose be finished by a group of students. Assume that you have decided to start a small business producing and selling this product. Part I: CVP analysis: You will be applying the concepts of cost-volume-profit analysis to this of possible products could be cookies, birdhouses, or custom t-shirts. This project is to potential venture. . Describe your product. What market are you targeting this product for? What price will you sell your product for? Make projections of your sales in units over each of the upcoming four months. 2. Make a detailed list of all the material needed to make your product. Include quantities needed for each material. Also include the cost of the material on a per-unit basis. 3. Make a list of all of the equipment you will need to make your product. Estimate the cost of each piece of equipment that you will need. 4. Make a list of all other expenses that would be needed to create your product. Examples of other expenses would be rent, utilities, and insurance. Estimate the cost of each of these expenses each month. 5. Now classify all of the expenses you have listed as being either fixed or variable. For mixed expenses, separate the expense into the fixed component and the variable component. 6. Calculate how many units of your product you will need to sell to break even in each of the four months you have projected. 7. Expect three independent changes that will incur in the second, third and fourth months, and assess how your break-even point will change due to that change. And think of the possible solutions to maintain your break-even point. 8. Calculate the margin of safety in units for each of the four months in your projection. Now decide how much you would like to make in before-tax operating income (target profit) in each of the upcoming four months. Calculate how many units you would need to sell in each of the upcoming months to meet these target profit levels. 9. 10. How realistic is your potential venture? Do you think you would be able to break even in each of the projected four months? How risky is your venture (use the margin of safety to help answer this question). Do you think your target profits are achievable? PROJECT 2: BUSINESS PLAN Overview: Select a product that you could make and can bring to class for presentation purpose be finished by a group of students. Assume that you have decided to start a small business producing and selling this product. Part I: CVP analysis: You will be applying the concepts of cost-volume-profit analysis to this of possible products could be cookies, birdhouses, or custom t-shirts. This project is to potential venture. . Describe your product. What market are you targeting this product for? What price will you sell your product for? Make projections of your sales in units over each of the upcoming four months. 2. Make a detailed list of all the material needed to make your product. Include quantities needed for each material. Also include the cost of the material on a per-unit basis. 3. Make a list of all of the equipment you will need to make your product. Estimate the cost of each piece of equipment that you will need. 4. Make a list of all other expenses that would be needed to create your product. Examples of other expenses would be rent, utilities, and insurance. Estimate the cost of each of these expenses each month. 5. Now classify all of the expenses you have listed as being either fixed or variable. For mixed expenses, separate the expense into the fixed component and the variable component. 6. Calculate how many units of your product you will need to sell to break even in each of the four months you have projected. 7. Expect three independent changes that will incur in the second, third and fourth months, and assess how your break-even point will change due to that change. And think of the possible solutions to maintain your break-even point. 8. Calculate the margin of safety in units for each of the four months in your projection. Now decide how much you would like to make in before-tax operating income (target profit) in each of the upcoming four months. Calculate how many units you would need to sell in each of the upcoming months to meet these target profit levels. 9. 10. How realistic is your potential venture? Do you think you would be able to break even in each of the projected four months? How risky is your venture (use the margin of safety to help answer this question). Do you think your target profits are achievable