Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to create a sales projection analysis on a given spread sheet. I need managerial accounting expert to help me with this, I will
I need to create a sales projection analysis on a given spread sheet. I need managerial accounting expert to help me with this, I will not be uploading everything here because I DO NOT want the information I HAVE CHOSEN TO BE COPIED. here are the instructions attached. Please tell me how to do it and which information and/ or formulas I WILL NEED to complete this.
the whole purpose of the assignment is this: Selling a food item at a carnival for 4 hours a day for 6 days.
As operator of this booth, you will need to buy all the materials, hire all of your labor (if needed), and pay 12.5% of your sales revenue to N&A Amusement Company and 12.5% of your sales revenue to the church. Additionally, you are required to pay the church a $200 rental cost (which includes utilities expense) for the booth space Project Requirements A. Determine your financial goal for this one-week venture. B. Briefly describe the product that you will sell at the carnival as well as all of the costs that you will have to incur during the week. On the Excel file (provided), classify each cost as variable, fixed, or mixed. For mixed costs, be sure to identify the variable and fixed components. C. You will need to research all of your costs: direct materials, direct labor, and overhead involved in making your product. On the Excel file tell me your source for each of these costs (e.g. list websites where you found your information). D. Perform market research to determine the appropriate price to charge for your product. E. Before you begin any business venture, it is essential to perform a preliminary breakeven analysis. Your findings provide the basis for assessing the reasonableness of this business opportunity. An important part of this breakeven analysis is for you to determine the contribution margin per unit. From parts C and D, you will be able to determine your contribution margin per unit. After determining your contribution margin per unit, answer the following questions: 1. What is the contribution margin per unit of your product? 2. What is the contribution margin ratio? 3. What are the total fixed costs? 4. What is the sales volume at the breakeven point? 5. What is the sales revenue in dollars at the breakeven point? 6. What is the sales volume in units required to reach your financial goal? 7. What is the sales revenue in dollars required to reach your financial goalStep 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