Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Breakeven Analysis (Use the Breakeven Process-Own Business document as a guide in completing this assignment. Using data compiled to compute the breakeven analysis for your

image text in transcribed
image text in transcribed
image text in transcribed
Breakeven Analysis (Use the Breakeven Process-Own Business document as a guide in completing this assignment. Using data compiled to compute the breakeven analysis for your own business, complete the following: 1. One paragraph description of your business. 2. Definition of a unit 3. Listing of variable costs 4. Listing of fixed costs 5. Enter the following data in to the Excel module. a. Sale price per unit b. A minimum of two variable costs c. A minimum of five fixed costs d. A minimum profit component of $15,000 6. Manipulate the data to arrive at a reasonable amount of units to be sold per year/month/week. 7. Summarize your findings in a two-three paragraph document. Submit the following, via Canvas: 1. Small Business breakeven analysis 2. Word document summarizing your findings 4. Variable costs a. Labor 1. (if manufacturing use cost per unit to produce, not per hour)use hourly rate to arrive at unit cost ii. If service, use hourly rate based on \# of hours to perform service b. Materials (cost to produce) c. Travel (primarily used for service business) d. Supplies e. Other 5. Fixed costs a. Rent b. Owner salary (full time vs part-time venture) c. Owner taxes (20% Owner salary) d. Advertising e. Equip lease f. Miscellaneous g. ???????? 6. Profit Component (full time vs part-time venture) 7. Review Income Statement for accuracy 8. Review unit sales for reasonableness 9. Change data to arrive at realistic most likely scenario Breakeven Analysis tyour campany nama) Nate: Data entry is tequirst in hiplighted Sields: Arnoumt per Unint on Annual Amosumt Armuer Arsoumt 15 5 Annual Amaven Nan 4 Inter oroti camporeat Prefie Cemponent Froal Sale price per unit Cantribution margin per unet \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Description } \\ \hline & \\ \hline mon & \\ \hline mos & \\ \hline & \\ \hline cos & \\ \hline & \\ \hline 000 & \\ \hline lom & \\ \hline mon & \\ \hline cos & \\ \hline fecal bie & end Couts \\ \hline \end{tabular} . Contribution Marvin Step 2 il trater saie price per unin Step 2 Enter varlatle cestu description and per unit cest

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions