60.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer