Question
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
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.
#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 Calculatethe margin of safety in units foreach 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?
***I wrote which slides are important next to the slide
**** I have to first find the sales budget. 2. Production Budget 3. Then Direct Material budget in excel format
**** In one through ten I have to a CVP ( Cost Volume Profit) analysis: You will be applying the concepts of volume-profit anaylsis to this potential ventue. Chapter 22 notes so you know what's going on , please number which one your helping me with and if you can help guide to me excel format. Any assignments we work on must be in excel.
importnat slide
important slide
ments. Sales projections for the month to unit sales of the planters for the first five montns or tne upcoming year snows tne estimaueu each month to be as follows: the jections for the first to be so nventory at the start of the year was 350 planters. The desired inventory of planters at the end of each month should be equal to 10% of the following month's budgeted sales. Each planter requires two pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.25 per pound Requirements 1. Preparel a production hudget for each month in the first quarter of the year, including pro- duction in units for each month and for the quarterStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started