All I know is that I am to use an imaginary company that I make up other than that I don't know what to do. This is what I was given. This is all the information I was given. The company was not given nor were any numbers. I am trying to figure out what I need to do.

I just need an example with random number so I can get an idea of how to fill out the sheet.

The picture is a screenshot so all you have to do is zoom in.

Breakeven analysis (1) - Excel (Product Activation Failed) ? - . X PAGE LAYOUT FORMULAS DATA REVIEW VIEW mysweetmind Espitia X GS FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I Clipboard AutoSum : E Bad O General 9AA === U - A Font On Wrap Text Merge & Center - Alignment $ % 898 Normal Conditional Format as Good Formatting Table Styles Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Number Cells K12 B C D E F G H I J K L M N O P Q R S I A Breakeven Analysis Enter your company name here Notes on Preparation Using figures from your Profit and Loss Projection, enter expected annual fixed and variable costs. Fixed Costs ($) Variable Costs (%) Fixed costs are those that remain the same regardless of your sales volume. They are expressed in dollars. Rent, insurance and real estate taxes, for example, are usually fixed. 0.0% 0.0% 0.0% 0.0% Variable costs are those which change as your volume of business changes. They are expressed as a percent of sales. Inventory, raw materials and direct production labor, for example, are usually variable costs. A Under the variable expenses column, use whole numbers as a percentage, not decimal numbers. For example, use 45%, rather than .45%. A A A 5 Cost Description 6 Variable Costs 7 Cost of Goods Sold 8 Inventory Raw Materials 10 Direct Labor (Includes Payroll Taxes) 11 12 Fixed Costs 13 Salaries includes payroll taxes) 14 Supplies 15 Repairs & maintenance 16 Advertising 17 Car, delivery and travel 18 Accounting and legal 19 Rent 20 Telephone 21 Utilities 22 Insurance 23 Taxes (Real estate, etc.) 24 Interest 25 Depreciation 26 Other (specify) 27 Other (specify) 28 Miscellaneous expenses 29 Principal portion of debt payment 30 Owner's draw For your business, each category of expense may either be fixed or variable, but not both. A Page. A A Suggestions A A A A The categories of expense shown above are just suggestions Change the labels to reflect your own accounting systems and type of business. Breakeven is a "big picture" kind of tool, we recommend that you combine expense categories to stay within the 22 lines that this template allows. A A A A A A One of the best uses of breakeven analysis is to play with various scenarios. For instance, if you add another person to the payroll, how many extra sales dollars will be needed to recover the extra salary expense? If you borrow, how much will be needed to cover the increased principal and interest payments? Many owners, especially retailers, like to calculate a daily breakdown. This gives everyone a target to shoot at for the day. 32 Total Fixed Costs 34 Total Variable Costs 0% 37 Breakeven Sales level = 0 Breakeven Analysis + READY @ -- + 100% 11:39 PM 4 O Type here to search e M @ 9 wi x] ^ 4/5/2020 E