Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

business name food bar write all number and see the chart , 3 files here, i cant attach it Open the attached spreadsheet and replace

business name food bar image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
write all number and see the chart , 3 files here, i cant attach it
Open the attached spreadsheet and replace all the red text and numbers with those for your business venture Business Name AL + OC - OD+R-E Credits Debits Totals Item Operating Activities Sources of Sales (A) Describe Describe Describe Total Sales Business Expenses (E) Supplies Electricity Phone Internet Cable Water Sewer Garbage Advertising Insurance Licenses and Fees Legal (attorney retainer) Payroll Employee Benefits Payroll Tax Property Tax Repairs and Maintenance Total Expenses 0 Investment Activities Supplies Merchandise Inventory Total Current Assets Property, Plant, Equipment (A) Building Other Equipment Total Long Term Assets Financing Activities Loan (L) Business Loan Mortgage Property Mortgage Total Liabilities Loan Payments (E) Monthly Payment Total Finance Expense Total Income/Loss Cash Flow Expenses BreakEvenAnalysis Business Name Projection of Expenses Amount Explain how you arri Fixed Expenses Rent Utilities Insurance Total Fixed Expenses 0 Regardless of the nun Variable Cost Per Customer Amount Explain how you arri Materials Service & Sales Business: How much will it cost you to buy materials and/or services needed to serve cach customer? Sales Business: How much will it cost you to buy the raw materials or finished products that you wil manufacture or re-sell to cach customer? O Total Mateials Cost Labor How much would you like to be paid per hour? How many employees would you like to have working for you? How much would you like to pay your employees per hour? Service Business: How many customers do you expect to server per hour? Sales Business: How many units of the product do you expect to sell to with these materials or services per hour? Customer Served Per Hour 0 Total Labor 15 Total Variable Expenses or Cost Per Customer or Hour 15 The midpoint for your break-even point will be set at: 15 Cash Flow Expenses BreakEven Analysis Projection of Renee and Expenses Fixed Expenses Cost per Customer eller Selling price per Customer: How much do you plan to charge each customer for your product or service! Breakeven Anaisis Total Revenue Total Expenses Variable Expenses 200 3015 To determine how much money you need to start your business, you must estimate the costs of doing business for the first months. Some of these expenses will be one-time costs such as the fee for incorporating your business or the price of a sign for your building. Some will be ongoing costs, such as the cost of utilities, inventory, insurance, etc. While identifying these costs, decide whether they are essential or optional. A realistic startup budget should only include those things that are necessary to start a business. These essential expenses can be divided into two separate categories: fixed and variable. Fixed expenses include rent, utilities, administrative costs and insurance costs. Variable expenses include inventory, shipping and packaging costs, sales commissions, and other costs associated with the direct sale of a product or service. The most effective way to calculate your startup costs is to use a worksheet that lists both one-time and ongoing costs. If you use Excel, you can attach the file. Download attached spreadsheet file if you didn't in Assignment 9. Save it on your computer with your first and last name added on to the name. Open the file using Microsoft Excel 2010 or later. Replace all the red numbers and labels with your numbers and your information. Looking at the graph, tell me how many people your business needs to serve in order for it to start making a profit. Open the attached spreadsheet and replace all the red text and numbers with those for your business venture Business Name AL + OC - OD+R-E Credits Debits Totals Item Operating Activities Sources of Sales (A) Describe Describe Describe Total Sales Business Expenses (E) Supplies Electricity Phone Internet Cable Water Sewer Garbage Advertising Insurance Licenses and Fees Legal (attorney retainer) Payroll Employee Benefits Payroll Tax Property Tax Repairs and Maintenance Total Expenses 0 Investment Activities Supplies Merchandise Inventory Total Current Assets Property, Plant, Equipment (A) Building Other Equipment Total Long Term Assets Financing Activities Loan (L) Business Loan Mortgage Property Mortgage Total Liabilities Loan Payments (E) Monthly Payment Total Finance Expense Total Income/Loss Cash Flow Expenses BreakEvenAnalysis Business Name Projection of Expenses Amount Explain how you arri Fixed Expenses Rent Utilities Insurance Total Fixed Expenses 0 Regardless of the nun Variable Cost Per Customer Amount Explain how you arri Materials Service & Sales Business: How much will it cost you to buy materials and/or services needed to serve cach customer? Sales Business: How much will it cost you to buy the raw materials or finished products that you wil manufacture or re-sell to cach customer? O Total Mateials Cost Labor How much would you like to be paid per hour? How many employees would you like to have working for you? How much would you like to pay your employees per hour? Service Business: How many customers do you expect to server per hour? Sales Business: How many units of the product do you expect to sell to with these materials or services per hour? Customer Served Per Hour 0 Total Labor 15 Total Variable Expenses or Cost Per Customer or Hour 15 The midpoint for your break-even point will be set at: 15 Cash Flow Expenses BreakEven Analysis Projection of Renee and Expenses Fixed Expenses Cost per Customer eller Selling price per Customer: How much do you plan to charge each customer for your product or service! Breakeven Anaisis Total Revenue Total Expenses Variable Expenses 200 3015 To determine how much money you need to start your business, you must estimate the costs of doing business for the first months. Some of these expenses will be one-time costs such as the fee for incorporating your business or the price of a sign for your building. Some will be ongoing costs, such as the cost of utilities, inventory, insurance, etc. While identifying these costs, decide whether they are essential or optional. A realistic startup budget should only include those things that are necessary to start a business. These essential expenses can be divided into two separate categories: fixed and variable. Fixed expenses include rent, utilities, administrative costs and insurance costs. Variable expenses include inventory, shipping and packaging costs, sales commissions, and other costs associated with the direct sale of a product or service. The most effective way to calculate your startup costs is to use a worksheet that lists both one-time and ongoing costs. If you use Excel, you can attach the file. Download attached spreadsheet file if you didn't in Assignment 9. Save it on your computer with your first and last name added on to the name. Open the file using Microsoft Excel 2010 or later. Replace all the red numbers and labels with your numbers and your information. Looking at the graph, tell me how many people your business needs to serve in order for it to start making a profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

International Financial Reporting A Practical Guide

Authors: Alan Melville

6th edition

1292200743, 1292200766, 9781292200767, 978-1292200743

More Books

Students also viewed these Finance questions