User Account

All Pages

Identified the various factors

Assignment Help Basic Statistics
Reference no: EM133266339

You are in charge of a young and growing company. You have identified the various factors (sources of revenue and expenses) that influence the company business as shown below.

All the figures are in thousands of Kenya Shillings except the percentages.

ANNUAL INCOME AND EXPENSES PROJECTION

 

Revenue

 

Sales

Starts at 10,000 and grows by 8%

Expenses

 

Raw materials

15% of sales

Transport

7% of sales

Electricity

2.1% of sales + 10

Rent

Starts at 120 then grows by 2%

Salaries

Starts at 1,000 then grows by 10%

Commissions (Sales)

1.8% of sales

Loan repayment

170

Advertising and promotion

2.5% of sales

Depreciation

Fixed at 20

Miscellaneous

Starts at 10 and grows by a fixed amount of 10

Total (Expenses)

 

Profit

 
  1. Use the information provided in the table above to produce a financial projection model for the company for the next six years.
  2. Make a line graph of sales, total expenses and profit for the six-year period.      
  3. Find the average expenses, sales and profit for the six-year period.        
  4. Print the worksheet and the graph

Reference no: EM133266339

Questions Cloud

What is the most economical order quantity : A manufacturing company places a semi-annual order of 24,000 units at a price of $20 per unit. Its carrying cost is 15% and the order cost is $12 per order.
Service company to achieve global success : The first to set up an international air express business in 1969, DHL had the first-mover advantage over other companies. Is being a first mover as advantageou
Describe what primary health care is : Describe what primary health care is and how you understand the role of the nurse practitioner in primary health care
Explain the profit maximization problem : In the formal presentation of the Newsvendor problem, we have shown that the profit maximization problem is equivalent to the minimizing of the following cost f
Identified the various factors : You are in charge of a young and growing company. You have identified the various factors (sources of revenue and expenses) that influence the company business
Dickey-fuller and the augumented dickey-fuller : Describe in detail the Dickey-Fuller and the augumented Dickey-Fuller (ADF) procedure for testing for the order of integration of a time series variable.
What should she score in the final exam : Tina is getting ready to take the final exam for MAT 143. Her averages before the final exam are given. Test average= 68; Hand in assignment average = 75; MML a
What should she score in the final exam : Tina is getting ready to take the final exam for MAT 143. Her averages before the final exam are given. Test average= 68; Hand in assignment average = 75; MML a
How does walmart go green without going into red : How does Walmart go green without going into red (low)? Who are the stakeholder groups Walmart is serving in its renewal energy business

Reviews

Write a Review

Basic Statistics Questions & Answers

  An investigator wants to estimate chocolate consumption

an investigator wants to estimate chocolate consumption dichotomous-eat chocolate or do not in kindergarten students

  Draw a normal distribution pointing out the important

Draw a normal distribution pointing out the important values to the problem and insert a link to it into your answer.

  Would multicollinearity appear to be present

In the second analysis, the partial regression coefficient for x1 had a positive sign and the p-value associated with it was 0.39. Given these results, would multicollinearity appear to be present?

  What proportion of children classified as hyperlipidemic

What proportion of children 10 to 15 would be classified as hyperlipidemic (assume that hyperlipidemia is defined as a total cholesterol lelvel of 200)?

  Design an experiment that will effectively collect data

How might you design an experiment that will effectively collect data for this chosen hypothesis? How will you minimize threats to validity? Will it be a true experiment or a quasi-experiment?

  What critical value you should use to test

What critical value you should use to test Dr. Stat's claim that statistics students have a mean pulse rate greater than 60.0 bpm at a 0.01 significance level?

  Find the probability of getting

find the probability of getting one who made a correct dosage calculation or was given the bottle with a concentration label.

  Find the width and thickness of the belt

Assume that all the random variables follow normal distribution and the constraints have to be satisfied with a minimum probability of 0.95.

  Confidence interval for variance in amount of hidden cash

Suppose divorce lawyers always assume a spouse has hidden cash of approximately $10,000. Is there any evidence to suggest that the mean amount of stashed cash is more than $10,000?

  Expect a positive correlation

For each of the following pairs of variables, indicate whether you would expect a positive correlation, a negative correlation, or a correlation close to 0.

  Homeowners in the united states

In a recent poll of 760 homeowners in the United States, one in five homeowners reports having a home equity loan that he or she is currently paying off. Using a confidence coefficient of 0.90, derive an interval estimate for the proportion of all..

  Represents the mean score for the general population

What test is needed (select from above) to analyze the above scenario? Is the data qualitative or quantitative?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd